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
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
Search JabSto ::