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.

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





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s