Suppose that we are interested in the relationship between the age of the individuals who are members or our managed-cared organization and the use or physician care, as measured by visits. Suppose also that after selecting 15 members at random we obtained the following paired observations:
Age: 28,45,50,19,16,27,54,63,32,42,68,19,23,30,61
Visits: 3,5,4,2,1,3,6,7,4,5,10,1,2,3,8
Use these data to find the covariance between age and the number of visits.
Use the "Regression" function in Excel and the data presented above to estimate the linear relation between the number of visits and the age of the patients. 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 intercepts and slope of the sample regression line are significant