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 0.05, determine whether differences among the treatment, block, and interactive effects are significant.

Demonstrate clearly and fully the ability to use Excel to do the ANOVA and correctly answer the problems.

Supports main points with references, exs, and full explanations of how they apply. Thoughtfully analyzes, evaluates, and describes major points of the criteria.