Microsoft Office Tutorials and References
In Depth Information
Let’s try a practice problem.
Suppose that you have been asked to analyze some data from the SAT Reasoning
Test (formerly called the Scholastic Aptitude Test) which is a standardized test for
college admissions in the U.S. This test is intended to measure a student’s readiness
for academic work in college, and about 1.4 million high school students take this
test every year. There are three subtest scores generated from this test: Critical
Reading, Writing, and Mathematics, and each of these subtests has a score range
between 200-800 with an average score of about 500.
Suppose that a nearby selective college in the northeast of the U.S. that is near to
you wants to determine the relationship between SAT Reading scores, SAT Writing
scores, and SAT Math scores in their ability to predict freshman grade-point
average (FROSH GPA) for Biology majors at the end of freshman year at this
college, and that this college has asked you to determine this relationship.
You have decided to use the three subtest scores as the predictors, X 1 ,X 2 , and X 3
and the freshman grade-point average (FROSH GPA) as the criterion, Y. To test
your Excel skills, you have selected 11 biology majors randomly from last year’s
freshmen class, and have recorded their scores on these variables.
Let’s use the following notation:
Y FROSH GPA
X 1 READING SCORE
X 2 WRITING SCORE
X 3 MATH SCORE
Suppose, further, that you have collected the following hypothetical data
summarizing these scores (see Fig. 7.1 ):
Create an Excel spreadsheet for these data using the following cell reference:
A2: SAT REASONING TEST
A4: Is there a relationship between SAT scores and Freshman GPA at a local
A6: FROSH GPA
B6: READING SCORE
C6: WRITING SCORE
Next, change the column width to match the above table, and change all GPA
ﬁgures to number format (two decimal places).
Now, ﬁll in the additional data in the chart such that:
Search JabSto ::