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