Microsoft Office Tutorials and References
In Depth Information
year of college; the test has three general areas: (1) Molecules and Cells, (2)
Heredity and Evolution, and (3) Organisms and Populations.
Suppose that you have been asked by the Chair of the Biology Department at a
selective university to see how well the AP Biology Test, along with other
predictors, predicts GPA at the end of the ﬁrst-year of study for Biology majors. This
Chair has asked you to use as predictors: (1) SAT-Verbal scores, (2) SAT-Math
scores, and (3) high school GPA, and, in addition, to use the AP Biology Test score
as an additional predictor of this GPA. The Chair would like your recommendation
as to whether or not the AP Biology Test should become an admissions
requirement in addition to the SAT for admission to the undergraduate major in Biology.
You have decided to use a multiple correlation and multiple regression analysis,
and to test your Excel skills, you have collected the data of a random sample of 10
Worksheet Data for Chap. 7: Practice Problem #3
Biology students who have just ﬁnished their ﬁrst-year of study at this university.
These hypothetical data appear in Fig. 7.12 .
(a) Create an Excel spreadsheet using FROSH GPA as the criterion and the
other four variables as the predictors.
(b) Use Excel’s multiple regression function to ﬁnd the relationship between
these ﬁve variables and place the SUMMARY OUTPUT below the
(c) Use number format (2 decimal places) for the multiple correlation on the
Summary Output, and use number format (3 decimal places) for the
coefﬁcients in the summary output and for all other decimal ﬁgures in the
(d) Save the ﬁle as: AP biology
(e) Print the table and regression results below the table so that they ﬁt onto
Answer the following questions using your Excel printout:
Search JabSto ::