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

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

Nitrogen using your calculator.

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