Question

In testing a new drug, we obtained the following results:

Placebo	Drug A	Drug B	Drug C
3	5	6	7
0	4	3	6
2	2	4	5
0	2	3	4
0	2	4	3

Run the ANOVA and fill in the summary table with the results obtained:

	SS	df	MS	F-ratio	p-value
Between		3
Within		16
TOTAL		19

(Report P-value & F-ratio accurate to 3 decimal places and all other values accurate to 2 decimal places.)

What conclusion can be drawn at the 0.01 significance level?

• The various drugs have results that are statistically different.
• The various drugs do not have results that are statistically different.

Answer 1

The null and alternative hypothesis is

H1: At least one of the mean is different.

Level of significance = 0.01

By using excel we can solve this question easily.

First, enter all data into excel.

Click on Data -------> Data Analysis--------> Anova: Single-Factor-----> Input Data -------> Select all data -------> Output Range : Select any empty cell --------> ok
We get

P-value = 0.003

P-value < 0.01 we reject null hypothesis.

Conclusion:

• The various drugs have results that are statistically different.