Mortality Expectation Calculation

[henhouse]

I have a mortality table for 100 people, and I'm trying to calculate the expected deaths each year for 20 years. This requires me to calculate the probability of one death and multiply by 1, then calculate the probability of two deaths and multiply by 2, and so on up to 100.

The setup of the table is as follows: I have the individuals indicator in the first column (simply 1-100 numbered), and then 20 years worth of cumulative probabilities of survival. So the second column is the probability of that individual surviving one year, and the third column is the probability of that individual surviving 2 years.

I'm not sure if I have a lack of statistical knowledge here, but I'm having trouble wrapping my head around where to begin and how to set it up. I thought about trying to create a loop through VBA, but the initial setup keeps puzzling me.

Any thoughts or ideas would be extremely helpful!

 

[ScatmanKyle]

Without your calculations I can't give you a full solution, but assuming you have a set calculation for survival, then you can do:

=[YOUR CALCULATION]*ROW()
Assuming your first person starts on row 1. If they start on row 2, then it's:
=[YOUR CALCULATION]*ROW()-1