Mortality Expectation Calculation

henhouse

New Member
Joined
Jun 18, 2019
Messages
1
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!
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
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
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top