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):
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 ::