Mortality Expectation Calculation
Results 1 to 2 of 2

Thread: Mortality Expectation Calculation
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Mortality Expectation Calculation

    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!

  2. #2
    New Member
    Join Date
    Oct 2015
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Mortality Expectation Calculation

    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •