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 first-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
Fig. 7.12
Worksheet Data for Chap. 7: Practice Problem #3
Biology students who have just finished their first-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 find the relationship between
these five variables and place the SUMMARY OUTPUT below the
table.
(c) Use number format (2 decimal places) for the multiple correlation on the
Summary Output, and use number format (3 decimal places) for the
coefficients in the summary output and for all other decimal figures in the
SUMMARY OUTPUT.
(d) Save the file as: AP biology
(e) Print the table and regression results below the table so that they fit onto
one page.
Answer the following questions using your Excel printout:
Search JabSto ::




Custom Search