Correlation Assignment

profileroelofsl
ObesityExample.xlsx

Sheet1

Category Type of Service/Source of Funds Date Expenditures Obesity Prevalence
Total Hospital Expenditures Department of Defense 12/31/80 $2,819,000,000 0.095
Total Hospital Expenditures Department of Veterans Affairs 12/31/80 $4,997,000,000 0.107
Total Hospital Expenditures Medicaid (Title XIX) 12/31/80 $9,214,000,000 0.151
Total Hospital Expenditures Medicare 12/31/80 $26,278,000,000 0.104
Total Hospital Expenditures Other Third Party Payers and Programs 12/31/80 $15,041,000,000 0.093
Total Hospital Expenditures Out of pocket 12/31/80 $5,381,000,000 0.144
Total Hospital Expenditures Private Health Insurance 12/31/80 $36,786,000,000 0.095
Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/80 $35,493,000,000 0.088
Total Hospital Expenditures Department of Defense 12/31/81 $3,275,000,000 0.143
Total Hospital Expenditures Department of Veterans Affairs 12/31/81 $5,436,000,000 0.112
Total Hospital Expenditures Medicaid (Title XIX) 12/31/81 $11,062,000,000 0.105
Total Hospital Expenditures Medicare 12/31/81 $31,521,000,000 0.127
Total Hospital Expenditures Other Third Party Payers and Programs 12/31/81 $17,300,000,000 0.11
Total Hospital Expenditures Out of pocket 12/31/81 $6,271,000,000 0.109
Total Hospital Expenditures Private Health Insurance 12/31/81 $42,615,000,000 0.096
Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/81 $42,583,000,000 0.072
Total Hospital Expenditures Department of Defense 12/31/82 $3,694,000,000 0.1
Total Hospital Expenditures Department of Veterans Affairs 12/31/82 $5,951,000,000 0.135
Total Hospital Expenditures Medicaid (Title XIX) 12/31/82 $11,782,000,000 0.158
Total Hospital Expenditures Medicare 12/31/82 $36,662,000,000 0.175
Total Hospital Expenditures Other Third Party Payers and Programs 12/31/82 $19,052,000,000 0.199
Total Hospital Expenditures Out of pocket 12/31/82 $7,210,000,000 0.162
Total Hospital Expenditures Private Health Insurance 12/31/82 $49,297,000,000 0.212
Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/82 $48,444,000,000 0.201
Total Hospital Expenditures Department of Defense 12/31/83 $3,887,000,000 0.164
Total Hospital Expenditures Department of Veterans Affairs 12/31/83 $6,290,000,000 0.188
Total Hospital Expenditures Medicaid (Title XIX) 12/31/83 $12,947,000,000 0.204
Total Hospital Expenditures Medicare 12/31/83 $40,989,000,000 0.143
Total Hospital Expenditures Other Third Party Payers and Programs 12/31/83 $19,725,000,000 0.148
Total Hospital Expenditures Out of pocket 12/31/83 $7,624,000,000 0.176
Total Hospital Expenditures Private Health Insurance 12/31/83 $53,282,000,000 0.141
Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/83 $53,936,000,000 0.18
Total Hospital Expenditures Department of Defense 12/31/84 $4,200,000,000 0.157
Total Hospital Expenditures Department of Veterans Affairs 12/31/84 $6,886,000,000 0.191
Total Hospital Expenditures Medicaid (Title XIX) 12/31/84 $13,961,000,000 0.159
Total Hospital Expenditures Medicare 12/31/84 $45,415,000,000 0.163
Total Hospital Expenditures Other Third Party Payers and Programs 12/31/84 $20,035,000,000 0.148
Total Hospital Expenditures Out of pocket 12/31/84 $8,093,000,000 0.176
Total Hospital Expenditures Private Health Insurance 12/31/84 $55,775,000,000 0.182
Total Hospital Expenditures Total CMS Programs (Medicaid, CHIP and Medicare) 12/31/84 $59,377,000,000 0.182
Total Hospital Expenditures Department of Defense 12/31/85 $4,917,000,000 0.193
Total Hospital Expenditures Department of Veterans Affairs 12/31/85 $7,100,000,000 0.196
Total Hospital Expenditures Medicaid (Title XIX) 12/31/85 $14,624,000,000 0.203
Total Hospital Expenditures Medicare 12/31/85 $48,644,000,000 0.198