[EXT] America First Healthcare - The Best (and Worst) States for Healthy Aging in America - Data sources & Methodology.xlsm

	A	B	C	E
1	Healthy Aging Composite Score (computed from the provided workbook)
2
3	Weights			Methodology
4	Health care & outcomes	36%
5	Community engagement	27%		To identify the best metropolitan areas for healthy aging, a composite score was created based on the following metrics: -Health care & outcomes (36%): Percentage of adults in very good or excellent health; Level of physical activity; Health care facilities & workers per capita; Additional health care factors and lifestyle habits -Community engagement (27%): Density of arts, entertainment, & recreation facilities; Density of civic & religious organizations; Educational attainment (overall & adults 65+) -General livability (27%): Unemployment rates (overall & adults 65+); Poverty rates (overall & adults 65+); Commuters who walk; Commuters who bike; Mean commute time; Weather; Violent and property crime rates Only metropolitan areas with at least 500,000 people were included in the analysis. Data sources include: U.S. Census Bureau American Community Survey; U.S. Census Bureau County Business Patterns; U.S. Bureau of Labor Statistics Occupational Employment Statistics; National Centers for Environment Information; Federal Bureau of Investigation Uniform Crime Reporting Program; Centers for Disease Control and Prevention Behavioral Risk Factors. - Demand & search interest (10%): Proprietary internal data from America First Healthcare.
6	General livability	27%
7	Demand & search interest	10%
8
9	Metric mapping used
10	Health
11	Dedicated Health Care Provider	Higher is better	link
12	Physical inactivity (Age 65+)	Lower is better	link
13	Smoking prevalence (preferably 65+, otherwise adult overall)	Lower is better	link
14	Early Death - Ages 65-74	Lower is better	link
15	Nursing Home Quality	Higher is better	link
16
17	Community
18	Volunteerism	Higher is better	link
19	Risk of social isolation (Age 65+) index	Lower is better	link
20
21	Livability
22	65+ poverty rate (% of people 65+ below poverty)	Lower is better	link
23	Housing cost burden (Age 65+) (% 65+ spending >30% income on housing)	Lower is better	link
24	Food insecurity (state prevalence)	Lower is better	link
25	Affordability	Lower is better	link
26	Weather	Lower is better	link
27	Safety	Higher is better	link
28
29	Demand & search interest
30	Demand score	Higher is better
31
32	Normalization
33	Each metric is rescaled to 0–100 using min-max scaling across the 50 states; then category scores are simple averages of their metrics; composite is the weighted sum.