Microsoft Office Tutorials and References

In Depth Information

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

page

(e) Save the spreadsheet as: BIO3

Let’s call the Premed students Group A, the Biology majors Group B, the

Other Science majors Group C, and the General Ed requirement students

Group D.

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 four

types of students in their cumulative GPAs when entering the

Introductory Biology course, what is the null hypothesis and the research

hypothesis for the ANOVA t-test comparing Premed students (Group

A) versus Other Science majors (Group C)?

9. What is the mean (average) GPA for Premed students on your Excel

printout?

10. What is the mean (average) GPA for Other Science majors on your

Excel printout?

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

Premed students versus Other Science majors?

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 Excel for Premed students versus Other

Science majors.

14. Compute the ANOVA t-test value comparing Premed students versus

Other Science majors using Excel.

15. What is the result of the ANOVA t-test comparing Premed students

versus Other Science majors?

16. What is the conclusion of the ANOVA t-test comparing Premed students

versus Other Science majors in plain English?

═

3. Suppose that you wanted to study the effect of “crowding” on the weight of

brown trout (
Salmo trutta
) raised in a ﬁsh hatchery in the state of Colorado in the

U.S.A. Crowding is measured in terms of the number of trout raised in a

container (i.e., the density of the ﬁsh in the container) and the weight of the

ﬁsh is measured in grams. The trout have been raised in four containers (200,

350, 500, and 700 ﬁsh per container) for nine months. You decide to take a

Search JabSto ::

Custom Search