Use Excel; Use the "Regression" function in Excel and the following data:
visits 3,5,4,2,1,3,6,7,4,5,10,1,2,3,8
age 28,45,50,19,16,27,54,63,32,42,68,19,23,30,61
to estimate the number of visits and the age of the patient. Examine the results of the analysis by
1. Interpreting the coefficient2.
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
In your evaluation let x = 0.05