Microsoft Office Tutorials and References

In Depth Information

the results below the ANOVA table on the spreadsheet (put the standard

error and the ANOVA t-test value on separate lines of your spreadsheet,

and use two decimal places for each value)

(d) Print out the resulting spreadsheet so that all of the information ﬁts onto

one page

(e) Save the spreadsheet as: TROUT3

Now, write the answers to the following questions using your Excel printout:

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 = 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

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 versus 500 ﬁsh.

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

calculator.

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

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

plain English?

References

Black, K. Business Statistics: For Contemporary Decision Making (6th 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 (7th ed.). Mason, OH: South-Western Cengage

Learning, 2011.