Regression Anaylysis

Question needs to be completed no later than 12 noon Eastern Standard time 10/22/2017.

Must be done in excel and show work.

Estimate the linear relation between the number of visits and the age of the patient. Examine the results of the analysis by

1. Interpreting the coefficient of determination

2. Interpreting the square root of the coefficient of determination

3. Interpreting findings presented in the ANOVA table

4. Determining whether the intercept and slope of the sample regression line are significant.

Visits: 3,5,4,2,1,3,6,7,4,5,10,1,2,3,8,

Ages: 28,45.50,19,16,27,54,63,32,42,68,19,23,30,61