Microsoft Office Tutorials and References

In Depth Information

Fig. 7.10
Worksheet Data for Chapter 7: Practice Problem #1

General GRE test produces three subtest scores: (1) GRE Verbal Reasoning

(scale 200-800), (2) GRE Quantitative Reasoning (scale 200-800), and (3)

Analytical Writing (scale 0-6).

Suppose that you have been asked by the Chair of the Biology Department at a

selective graduate university to see how well the GRE predicts GPA at the end of

the ﬁrst year of graduate study for Biology majors. The Chair has asked you to

use the three subtest scores of the GRE as predictors, and, in addition, to use the

GRE Biology Test score (score range 200-990) as an additional predictor of this

GPA. The Chair would like your recommendation as to whether or not the

Biology Test should become an admissions requirement in addition to the

GRE for admission to the program in Biology. The GRE Biology Test includes

descriptions of laboratory and ﬁeld situations, diagrams, and experimental

results.

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

12 Biology students who have just ﬁnished their ﬁrst year of study at this

university. These hypothetical data appear in Fig.
7.10
:

(a) Create an Excel spreadsheet using FIRST-YEAR GPA as the criterion ( Y ),

and GRE VERBAL ( X
1
),
GRE QUANTITATIVE (X
2
), GRE WRITING

(X
3
), and GRE BIOLOGY( X
4
)
as the predictors.

(b) Use Excel’s
multiple regression
function to ﬁnd the relationship between

these ﬁve variables and place it below the table.

(c) Use number format (2 decimal places for the multiple correlation on the

SUMMARY OUTPUT, and use four decimal places for the coefﬁcients in

the SUMMARY OUTPUT).

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

page.

Search JabSto ::

Custom Search