Rahul5077

A. Use the “Regression” function in Excel and the data presented in Exercise 2 of Chapter 9 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

In your evaluation, let α = 0.05.

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

1) Use Excel to complete "Exercise 1" on page 247 (Regression Analysis) in the textbook.

2) Answer the questions at the end of the exercise.

3) APA format is not required, but solid academic writing is expected.

B. 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.

Physician

Diagnosis A B C

1 11,7,9 8,6,7 5,4,7

2 14,10,11 10,9,8 6,8,7

3 4,5,3 5,5,6 3,4,2

4 10,9,7 6,7,4 5,6,3

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

1) Use Excel to complete "Exercise 7" on page 208 (ANOVA) in the textbook.

2) Answer the questions at the end of the exercise.

3) APA format is not required, but solid academic writing is expected.