Thank you for the steps. Sorry, I may have worded it differently since I wasn't expecting decimal numbers. I want to know the years of potential life lost due to premature deaths per 100,000 people. Here is a sample of what I'm looking for. Numbers are not exact but should be in thousands.

Thank you so much G. What I did is follow all your steps but without the calculation in the end.

Here's what I found.

Premature Death is the years of potential life lost before age 75 (YPLL-75). Every death occurring before the age of 75 contributes to the total number of years of potential life lost. For example, a person dying at age 25 contributes 50 years of life lost, whereas a person who dies at age 65 contributes 10 years of life lost to a county's YPLL. The YPLL measure is presented as a rate per 100,000 population and is age-adjusted to the 2000 US population.