Settings

Theme

Actuarial Life Table

ssa.gov

153 points by j765 4 years ago · 61 comments (60 loaded)

Reader

siddboots 4 years ago

One fun thing to do is to take these death probabilities and throw them into a Leslie matrix [1], along with assumptions for the age-specific birth rates. From there you can simulate the projected population growth (ignoring migration) with no more than a couple of lines of Python/R/whathaveyou.

It's also a great study case for understanding some basic principles of linear algebra: The dominant eigenvalue is the stable population growth rate, and the corresponding eigenvector is the stable age distribution.

[1] https://en.wikipedia.org/wiki/Leslie_matrix

rrjjww 4 years ago

Shameless self plug - I'm an Actuary, and as a way to learn React I put together a website that teaches you the basic concepts and math behind these actuarial table.

https://www.lifecontingencies.com

  • fludlight 4 years ago

    Is there a site where one can add more data points like BMI, smoking, booze & other drugs, family history of horrible diseases, current medical conditions, etc?

  • gaudat 4 years ago

    Damn this looks good. Going to check it out in depth.

    I know a guy back in college who majored in actuarial science but he's also doing computer science. These 2 subjects have good synergy.

  • francisofascii 4 years ago

    I like the visuals on the "How will I Die?" page. It is interesting to scroll up and down through various ages to see how the causes of death change.

  • justinbaker84 4 years ago

    Great job! Your site did a fantastic job of putting this into context for me.

klelatti 4 years ago

If anyone is interested in more life tables the Society of Actuaries has thousands to download and there is some simple code to read them in Python here:

https://www.joveactuarial.com/blog/mortality-tables/

chomp 4 years ago

I graphed the difference in years amongst men and women using good ol' fashioned awk and free graphing software:

https://imgur.com/a/3b1KrD7

It looks like at around age 18 - 30ish, the numbers start catching up, with a sharper reduction in expectancy differences happening around age 35.

From the PRB:

"Men are three times as likely as women to die from injuries (unintentional injuries, suicide, or homicide), and progress against those causes of death has been much slower than against other causes in the last 50 years. There is also evidence that men at all ages are less likely to seek medical care and less likely to comply with medical instructions than are women."

  • spookylettuce 4 years ago

    I'm very interested in this workflow of data -> awk -> graph. What graphing software did you use?

    • chomp 4 years ago

      Well, I spat out the list of numbers and just googled "graph values" and took the first result, but if you love to stay in command line, you can do something like so...

      # awk '{print $7-$4}' chart | gnuplot -p -e 'plot "/dev/stdin"'

      Where `chart` is just what I copy and pasted from the site :)

    • aidenn0 4 years ago

      I used a data -> awk -> graph with the NYT covid numbers, which had both state and county granularity. I used gnuplot to graph.

  • readthenotes1 4 years ago

    "There is also evidence that men at all ages are less likely to seek medical care and less likely to comply with medical instructions than are women."

    Especially on the 0-1 year old group. Toxic masculinity starts in utero.

    • chomp 4 years ago

      Men's health is complicated. Yes, there's some "strength in silence" confounding issues in doctor training and patients, but if you pry back the social media buzzwords, you'll see that there's complex economic and societal forces that push men's health downward.

      https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1121551/

      Also, I think you are trolling, but I'll bite. The expectancy in the 0-1 age group takes into account all life events that will affect the child over time, including what I had quoted. If you look at the probabilities in early life for both sexes, they have similar death probabilities.

      • TheSoftwareGuy 4 years ago

        > The expectancy in the 0-1 age group takes into account all life events that will affect the child over time

        But this is not taken into account in the Death Probability column, is it? Because we also see in that column, consistently better outcomes for women, even for the very youngest age groups

        • Retric 4 years ago

          10 and 11 year old boys have very similar rates of death as 10 and 11 year old girls, and it swaps some years ex: 2013.

          Click on 2006 for example and men have noticeably lower rates of death in that age range, but 14 year old boys where still twice as likely to die.

    • 21723 4 years ago

      Toxic masculinity starts in utero.

      I was going to reply but then decided, no, nevermind.

      • yellowstuff 4 years ago

        Most people will miss this reference and the rest will feel old. You owe us all apologies.

      • kristopolous 4 years ago

        The internet can be extremely hostile to empirical evidence. I actually just expect to be brigaded whenever I reference things like The Lancet. People are aggressively anti-intellectual.

        People don't logon to learn, they're here to be tribal and do social cues

      • pards 4 years ago

        Nevermind was the better album, for sure.

hardtke 4 years ago

This data, unfortunately, is missing an important confounding variable besides male/female. In the US lifespan his highly correlated with income, and the trend is getting worse. "The gap in life expectancy between the richest 1% and poorest 1% of individuals was 14.6 years (95% CI, 14.4 to 14.8 years) for men and 10.1 years (95% CI, 9.9 to 10.3 years) for women. Second, inequality in life expectancy increased over time. Between 2001 and 2014, life expectancy increased by 2.34 years for men and 2.91 years for women in the top 5% of the income distribution, but increased by only 0.32 years for men and 0.04 years for women in the bottom 5% (P < .001 for the difference for both sexes)." [1]

[1] https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4866586/

  • anamax 4 years ago

    From the article: "The differences in life expectancy were correlated with health behaviors and local area characteristics."

    "Health behaviors (rates of current smoking, obesity [defined as body mass index {calculated as weight in kilograms divided by height in meters squared} ≥30], and exercise during the past month)"

  • zeroonetwothree 4 years ago

    Hard to say in which direction the causation lies.

    • layer8 4 years ago

      That’s actually a good point: People who die earlier due to genetics accumulate less wealth in their lifetime, and their children therefore inherit less. With that causality, people are poorer literally because they die earlier, rather than the other way around. ;)

treespace8 4 years ago

Wow, as a guy I have a 1/5 chance of not even making it to retirement. (65) 1/3 chance of not living past 75. These are not good odds.

  • Teknoman117 4 years ago

    And coin toss of making to 80 (1/2). And if you make it to 90, every year is a round of russian roulette.

    Great. I didn't need an existential crisis today :)

    I really wonder about the quality of life as I age though. There is such a wide spread in my family. One of my grandfathers died of COVID early in the pandemic - he made it to 83.

    I had always considered him too stubborn to die. He survived two congestive heart failures, two bouts with cancer, and a heart attack. He had never taken care of himself (obese all of his life, heavy smoker from teenager to age 50, emphysema (from smoking), etc.). He caught COVID while recovering in a physical rehab from his heart attack and that's what ended up doing him in.

    His body was pretty much trashed by age 50 though. His ability to do things was pretty restricted from that point forward. As a child, he couldn't go on roller coasters with us, he had to be really careful with his diet, etc. He spent the last 3 years of his life in bed or wherever he could get on a walker.

    Meanwhile, my other three grandparents are enjoying their late 70's and early 80's - they travel, go hiking, play golf, play with the grand children and great-grandchildren, etc.

    I wonder how old I'll be when I get to the point where dying doesn't sound any worse than living.

    • npsimons 4 years ago

      > Meanwhile, my other three grandparents are enjoying their late 70's and early 80's - they travel, go hiking, play golf, play with the grand children and great-grandchildren, etc.

      It's okay to slow down, but don't stop moving.

    • scotty79 4 years ago

      > Great. I didn't need an existential crisis today :)

      Don't check what are the odds of you dying this year. You won't like them either.

  • cdf 4 years ago

    To be fair, if you are reading this or wrote this, you are far from a "typical" male in this study. The typical includes a lot of low income and/or blue collar workers who cannot or will not take good care of their health and are engaged in high risk activities at work and after work. In all likelihood, the typical HackerNews user alarmed by a subject like "Actuarial Life Table" will have much better odds at living a long life... if only because you are paid tech wages.

  • npsimons 4 years ago

    This is why I "soft retired" early. People haven't said it to my face, but I get the definite impression many think I'm crazy for "abandoning" work. I'm through hiking the PCT this year, something I never thought I would do until much older.

    I'm not really a brave guy, I fear change, but you got to take your chances while you're still alive.

    • kqr 4 years ago

      What does soft retire mean? I've always liked the idea of interspersing retirement years with active work, and increasing the relative frequency of retirement years as I get older.

      However, I understand the job market might not always be appreciative of gaps in employment.

      • cfn 4 years ago

        If you are a contractor it is not that bad. You can also use that time to do a small side project and put it in your CV.

  • lotsofpulp 4 years ago

    I wonder how those odds change if you narrow down to your occupation/socioeconomic status/location.

    I have always wondered what the income volatilities as you age are for the purposes of calculating how much I should be saving. My current strategy is to assume I will be unable to earn income and/or need to spend a lot on healthcare with increasing material odds starting at age 50 (since I might not have access to subsidized health insurance that comes with a job).

Spivakov 4 years ago

The death probability has a turning point from decreasing to increasing around age 10 for both male and female. Wonder why this specific age.

morepork 4 years ago

Based on this, by the time you're 30, around 2% of your male high school peers have passed away, but only 1% of your female ones. Puts an interesting perspective on things.

  • Teknoman117 4 years ago

    I don't keep in regular contact with people from high school these days, but from what I've heard, I wouldn't be surprised if 1 to 2% of my graduating class has already died from suicide or accidents alone.

    • kqr 4 years ago

      I hadn't thought about that but yeah, of the 100-ish people I've known a bit closer in childhood and adolescence, I know two are dead now.

      Both were female, though.

BenFranklin100 4 years ago

This is exactly the table I turned to in April 2020 to put my risk of dying from COVID-19 into perspective. In short, I had much bigger things to worry about over the next 10 years.

torstenvl 4 years ago

Great resource. I use this all the time for military clients near or past retirement eligibility, to estimate the lifetime financial penalty of discharging them before retirement, or of retiring them in a lower grade.

adamzerner 4 years ago

There is something I've never understood about this. Actually, I suspect that it is just plain old wrong.

It looks at what ages people died in the year 2019. If you die at age 80 in 2019, that means you were born in 1939. But if people born in the year 1939 are living to age 80... how do I put this... wouldn't you expect people born in, say, 1989 to live longer? Wouldn't people born 50 years later have longer life expectancies? Especially if you believe the stuff about accelerating rates of technogical growth.

  • dasil003 4 years ago

    IANAA, but my assumption is that that is why they update the tables every year— we always have young cohorts with incomplete data, so the best we can do is extrapolate from the past. Given a fixed cohort, over time as new tables are generated and the cohort ages, the accuracy will converge to reality. You could then look at past tables retroactively to see the error in the original extrapolations (which could be large due to black swan events).

  • mrtnmcc 4 years ago

    By choosing someone who died in 2019, you've implicitly chosen from the lucky group of survivors. This is not representative of everyone born in 1939. That is the discrepancy.

    If you add the current age to the remaining years of life, the total lifespan is monotonically increasing. This is reflecting the fact you are only looking at the expected age of an increasingly dwindling group of lucky survivors.

  • hugh-avherald 4 years ago

    Think of life expectancy as the expected age of death if you lived every year of your life in 2019.

amyjess 4 years ago

I wish I was good enough at math to use these tables to figure out what percentage of the population is within a particular age range in any given year.

In particular, I'm curious to see what years the population of particular generations peaked.

Edit: Actually what I'm really looking to do is to correlate certain marketing demographics with generations. For example, "in what years did Generation X comprise the majority of living people in the 18-34 demographic?" (where Generation X is defined as people born 1961-1981).

  • tfehring 4 years ago

    There’s not enough data to answer those questions from these tables, the “number of lives” fields are just illustrative.

  • vharuck 4 years ago

    Why not just go to the Census Bureau for annual tables of populations by age?

karakfa2 4 years ago

obesity and smoking status are more important than sex differences.

aidenn0 4 years ago

Does this mean that until your 113th birthday you can expect to, on average, live to your next birthday?

  • LodeOfCode 4 years ago

    For that you'd want to look at when the death probability exceeds 50% (108 for men, 109 for women). By 112 there's only a 40% chance you'll live to your next birthday

    • aidenn0 4 years ago

      Actually I realized my original question was ill-specified, "average" being ambiguous. The median woman will live at least one more year as late as 108 but the mean will live at least one more year as late as 113

verisimi 4 years ago

I would love to see the same data for the last 2 years

Kaius 4 years ago

Roughly 50% make it to age 80.

Roughly 20% make it to 90.

And around 1% make it to 100.

The road curves steeply at the end!

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection