Excel/Statistics

Need question completed by 12 noon Eastern Standard time.

A large health maintenance organization is interested in the prescribing patterns of physicians. Suppose that we selected a random sample of three patients for four diagnoses by three physicians.  If a - 0.5, determine whether differences among the treatment, block and interactive effects are significant.

                                                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