Microsoft Office Tutorials and References

In Depth Information

Fig. 7.3
Dialogue Box for SAT vs. FROSH GPA Data

OK (see Fig.
7.4
to see the resulting SUMMARY OUTPUT)

Next, format cell B23 in number format (2 decimal places)

Next, format the following four cells in Number format (4 decimal places):

B36

B37

B38

B39

Change all other decimal ﬁgures to two decimal places, and center all ﬁgures

within their cells.

Save the ﬁle as: GPA16

Now, print the ﬁle so that it ﬁts onto one page by changing the scale to 60% size.

The resulting regression analysis is given in Fig.
7.5

Once you have the SUMMARY OUTPUT, you can determine the multiple

correlation and the regression equation that is the best-ﬁt line through the data

points using READING SCORE, WRITING SCORE, AND MATH SCORE as the

three predictors, and FROSH GPA as the criterion.

Note on the SUMMARY OUTPUT where it says: “Multiple R.” This term is

correct since this is the term Excel uses for the multiple correlation, which is +0.80.

This means, that from these data, that the combination of READING SCORES,

Search JabSto ::

Custom Search