Go to the original dataset “ problem solving 3-MM” and answer the questions 1 SEPERATE
1)
• Calculate the AVERAGE number of individuals enrolled in each of the four NYC Medicaid services (i.e., Cash Assistance–Medical Assistance, Social Security Income–Medical Assistance, Nursing Home-Medical Assistance, and Medical Assistance Only) for each year from 2007–2016. Also, calculate the AVERAGE number of “Total HRA-Enrolled Medical Assistance Individuals” for each year during the same period. You should use an appropriate function in Excel.
• ALSO, Calculate the MAXIMUM number of individuals enrolled in each of the four NYC Medicaid services (i.e., Cash Assistance–Medical Assistance, Social Security Income–Medical Assistance, Nursing Home-Medical Assistance, and Medical Assistance Only) for each year from 2007–2016. Also, calculate the MXIMUM number of “Total HRA-Enrolled Medical Assistance Individuals” for each year during the same period. You should use an appropriate function in Excel.
• Calculate the MINIMUM number of individuals enrolled in each of the four NYC Medicaid services (i.e., Cash Assistance–Medical Assistance, Social Security Income–Medical Assistance, Nursing Home-Medical Assistance, and Medical Assistance Only) for each year from 2007–2016. Also, calculate the MINIMUM number of “Total HRA-Enrolled Medical Assistance Individuals” for each year during the same period. You should use an appropriate function in Excel.
• Calculate the RANGE of individuals enrolled in each of the four NYC Medicaid services (i.e., Cash Assistance–Medical Assistance, Social Security Income–Medical Assistance, Nursing Home-Medical Assistance, and Medical Assistance Only) for each year from 2007–2016. Also, calculate the RANGE of “Total HRA-Enrolled Medical Assistance Individuals” for each year during the same period. You should build a formula in Excel.
Sample Solution
