Question

The data set below contains total Medicare enrollment data for the state of Texas for the years 2013 - 2017. Estimate a linear trend regression model and forecast Medicare enrollment in Texas for the year 2020.

HW 7 Data #10.xlsx

Please round intermediate results to one decimals and your final answer to the closest integer.

Data Set: Please explain the functions used in excel to obtain answer. Thank you

Year	Enrollment
2013	3,385,888
2014	3,513,102
2015	3,634,716
2016	3,757,335
2017	3,883,588

Answer 1

The linear regression model is,

Enrollment = slope * Year + intercept

Now,

Slope = 123963.3

Intercept = -246151123.7

Enrollment = 123963.3 * Year - 246151123.7

Now,

Forecast Medicare enrollment in Texas for the year 2020 is,

Enrollment = 123963.3 * 2020 - 246151123.7

Enrollment = 4254742