Share
Explore BrainMass

# Using the Regression Function in Excel

Question 1:

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

Question 2:

A large health maintenance organization is interested in the prescribing patterns of physicians.
Suppose that we selected a random sample of three patients treated for four diagnoses by
three physicians.

(See attachment for data table)

If alpha = 0.05, determine whether differences among the treatment, block, and interactive effects are
significant.

#### Solution Summary

The expert examines using the regression function in Excel.

\$2.19