Simple Regression Analysis

Suppose that we are interested in the relationship between the age of the individuals who are members of our managed care organization and the use of physician care, as measured by visits. Suppose also that after selecting 15 members at random we obtained the following paired observations:

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

Age:  20 45 50 19 16 27 54 63 3242 68 19 23 30 61

Use these data to find the covariance between age and the number of visits

Use the "Regression" function in Excel to 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 the whether the intercept and slope of the sample regression line are significant.

In the evaluation, let α = 0.005