Microsoft Office Tutorials and References
In Depth Information
Click on the Labels box to add a check mark to it (because you have included
the column labels in row 6)
Output Range (click on the button to its left, and enter): A20 (see Fig. 7.3 )
Fig. 7.3 Dialogue Box for
SAT vs. FROSH GPA Data
Important note:
Excel automatically assigns a dollar sign $ in front of each
column letter and each row number so that you can keep these
ranges of data constant for the regression analysis.
OK (see Fig. 7.4 to see the resulting summary output)
Next, format cell B23 in number format (2 decimal places)
Search JabSto ::




Custom Search