Use the "Regression" function in Excel and the data presented in Exercise 3 (below) to estimate the linear relation between the number of visits and the distance to the nearest source of care. 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

Exercise 3.

The results of a sample survey of 20 patients yielded the following paired observations:

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

Miles: 3 4 6 9 1 1 3 2 5 6 2 5 1 2 9 8 4 3 2 2

4 . During an evaluation of internal operations, the administrator is concerned that the use of labor and consumable supplies fail to vary directly with the volume of service. To examine the situation, the following data were assembled:

Use multiple regression analysis to examine the relationship between volume and the use of labor and consumable supplies. Assess your results from a statistical and administrative perspective. Let α = 0.05.

Price: $8.07

Solution: The downloadable solution consists of 4 pages, 407 words and 2 charts.
Deliverable: Word Document