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 figures to two decimal places, and center all figures
within their cells.
Save the file as: GPA16
Now, print the file so that it fits 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-fit 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