Microsoft Office Tutorials and References

In Depth Information

1. What are the null hypothesis and the research hypothesis for the

ANOVA F-test?

2. What is MS
b
on your Excel printout?

3. What is MS
w
on your Excel printout?

4. Compute F

═

MS
b
/MS
w
using your calculator.

5. What is the critical value of F on your Excel printout?

6. What is the result of the ANOVA F-test?

7. What is the conclusion of the ANOVA F-test in plain English?

8. If the ANOVA F-test produced a signiﬁcant difference in the average

weight of the ﬁsh between the four types of crowding, what is the null

hypothesis and the research hypothesis for the ANOVA t-test comparing

350 ﬁsh per container versus 500 ﬁsh per container?

9. What is the mean (average) weight for 350 ﬁsh on your Excel printout?

10. What is the mean (average) weight for 500 ﬁsh on your Excel printout?

11. What are the degrees of freedom (df) for the ANOVA t-test comparing

350 ﬁsh versus 500 ﬁsh?

12. What is the critical t value for this ANOVA t-test in Appendix E for

these degrees of freedom?

13. Compute the s.e.
ANOVA
using your calculator for 350 ﬁsh versus 500

ﬁsh.

14. Compute the ANOVA t-test value comparing 350 ﬁsh versus 500 ﬁsh

using your calculator.

15. What is the result of the ANOVA t-test comparing 350 ﬁsh versus 500

ﬁsh?

16. What is the conclusion of the ANOVA t-test comparing 350 ﬁsh versus

500 ﬁsh in plain English?

References

Black, K. Business Statistics: For Contemporary Decision Making (6
th
ed.). Hoboken, NJ: John

Wiley & Sons, Inc., 2010.

Gould, J.L. and Gould, G.F. Biostats Basics: A Student Handbook. New York, NY: W.H. Freeman

and Company, 2002.

Weiers, R.M. Introduction to Business Statistics (7
th
ed.). Mason, OH: South-Western Cengage

Learning, 2011.