Microsoft Office Tutorials and References

In Depth Information

Answer the following questions using your Excel printout. Be sure to

include the plus or minus sign for each correlation:

7. What is the correlation between precipitation and productivity?

8. What is the correlation between temperature and productivity?

9. What is the correlation between temperature and precipitation?

10. Discuss which of

the two predictors is the better predictor of

productivity.

11. Explain in words how much better the two predictor variables combined

predict productivity than the better single predictor by itself.

3. The Advanced Placement (AP) Tests are standardized tests that allow high

school students to “test out” of college courses, either by receiving credit for

these courses or by allowing the students to waive courses in which their AP

scores are very high. The AP Exams are scored on a 5-point scale in which a

score of “1” means “No recommendation” and a score of “5” means “Extremely

well qualiﬁed.” There are 34 AP courses for which these exams are available.

The Biology Test is intended to measure the equivalent of a college introductory

biology course taken by Biology Majors during their ﬁrst 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)

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

coefﬁcients in the summary output and for all other decimal ﬁgures in the

SUMMARY OUTPUT.

(d) Save the ﬁle as: APbiology

(e) Print the table and regression results below the table so that they ﬁt onto one

page.

Answer the following questions using your Excel printout:

Search JabSto ::

Custom Search