Regression Analysis (Question Solved)

Use the “Regression” function in Excel to estimate the linear relation between the number of visits and the age of the patient. 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 28 45 50 19 16 27 54 63 32 42 68 19 23 30 61

Use these data to find the covariance between age and the number of visits. Examine the results of the analysis and write 1 pages summary report in answering the under listed question and follow the rubric in attending to the question and also note that it will go thru the school turnitin for similarity and if it is more than 10%  will not be accepted.

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

In your evaluation, let   0.05.  Follow the rubric in answering this assignment

Use Excel to complete (Regression Analysis)