# Analysis of variance

See attached. I am using the ANOVA calculation from the data Analysis tool in Excel.

---

ANOVA

Source of

Variation Sum of Squares df Mean Square F value

Treatments 2

Error 20

Total 500 11

Assume a .05 level of significance.

a. What are the null and alternate hypotheses?

b. How many treatments are there?

c. What is the critical value of F at the 5% level of significance? Indicate in words when you would reject the null hypothesis.

d. What are the values for the Mean Square Treatment (MST) and the Mean Square Error (MSE)?

e. Compute the value of F. Do you Reject or Fail to Reject the Null Hypothesis? State you conclusion.

---

https://brainmass.com/statistics/analysis-of-variance/analysis-of-variance-65222

#### Solution Summary

Analysis of variance

$2.19