Microsoft Office Tutorials and References

In Depth Information

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

college?

A6: FROSH GPA

A7: 2.55

B6: READING SCORE

C6: WRITING SCORE

D6: MATH SCORE

D17: 660

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:

A17:

3.65

B17:

440

C17:

570

Then, center all numbers in your table

Important note:

Be sure to double-check all of your numbers in your table to be

sure

that

they

are

correct,

or

your

spreadsheets

will

be

incorrect.

Save this ﬁle as: GPA15

Before we do the multiple regression analysis, we need to try to make one

important point very clear:

Important:

When we used one predictor, X, to predict one criterion, Y, we said

that you need to make sure that the X variable is ON THE LEFT in

your table, and the Y variable is ON THE RIGHT in your table so

However, in multiple regression, you need to follow this rule which is exactly

the opposite:

When you use several predictors in multiple regression, it is

essential that the criterion you are trying to predict, Y, be ON THE

FAR LEFT, and all of the predictors are TO THE RIGHT of the

criterion, Y, in your table so that you know which variable is the

criterion, Y, and which variables are the predictors. If you make this

a habit, you will save yourself a lot of grief.

Notice in the table above, that the criterion Y (FROSH GPA) is on the far left of

the table, and the three predictors (READING SCORE, WRITING SCORE, and

Search JabSto ::

Custom Search