Microsoft Office Tutorials and References

In Depth Information

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 Nitrogen in

order to write a conclusion summarizing all three of these three types of ANOVA t-tests.

2. College students take Introductory Biology for a variety of reasons. Some

students take it because it is a required Premed course, others take it because they are

Biology majors, some take it because they are Science majors other than Biology,

and some students take it as a General Education all-college required course.

Suppose that you wanted to compare the cumulative GPAs of students who are

taking an Introductory Biology course this semester in terms of their reasons for

taking this course. Also, you have decided to exclude students who scored a 5 on

the Advancement Placement Biology Exam from your research study since these

students receive academic credit for this course without having to take this course.

You decide to take a random sample of students taking Introductory Biology this

semester to test your Excel skills, and the hypothetical data are given in Fig.
8.7
.

(a) Enter these data on an Excel spreadsheet.

Fig. 8.7

Worksheet Data for Chap. 8: Practice Problem #2

Search JabSto ::

Custom Search