NATURAL SCIENCE GURU ONLY

Use Excel to complete Exercise 7 on page 208 (ANOVA) in the textbook. Answer the questions at the end of the exercise.

While APA format is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines.

7. 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  a= 0.05, determine whether

differences among the treatment,

block, and interactive effects are

significant.