Microsoft Office Tutorials and References
In Depth Information
(a) Enter these data on an Excel spreadsheet.
(b) Perform a one-way ANOVA test on these data, and show the resulting
ANOVA table underneath the input data for the three levels of Nitrogen.
(c) If the F-value in the ANOVA table is signiﬁcant, create an Excel formula to
compute the ANOVA t-test comparing the average for Low Nitrogen against
High Nitrogen and show the results below the ANOVA table on the
spreadsheet (put the standard error and the ANOVA t-test value on separate lines of
(d) Print out the resulting spreadsheet so that all of the information ﬁts onto one
page
(e) Save the spreadsheet as: Weed5
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 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 between the
three amounts of Nitrogen in the weight of the ﬂowers grown in the
greenhouse during a growing season, what is the null hypothesis and the
research hypothesis for the ANOVA t-test comparing Low Nitrogen
versus High Nitrogen?
9. What is the mean (average) for Low Nitrogen on your Excel printout?
10. What is the mean (average) for High Nitrogen on your Excel printout?
11. What are the degrees of freedom (df) for the ANOVA t-test comparing
Low Nitrogen versus High Nitrogen?
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.
14. Compute the ANOVA t-test value comparing Low Nitrogen versus High
15. What is the result of the ANOVA t-test comparing Low Nitrogen versus
High Nitrogen?
16. What is the conclusion of the ANOVA t-test comparing Low Nitrogen
versus High Nitrogen in plain English?
Note that since there are three treatments, you need to do three ANOVA
t-tests to determine what the signiﬁcant differences are between the
three treatments. Since you have just completed the ANOVA t-test
comparing Low Nitrogen versus High Nitrogen, you would also need
to do the ANOVA t-test comparing Low Nitrogen versus No Nitrogen,
and also the ANOVA t-test comparing No Nitrogen versus High
Search JabSto ::

Custom Search