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