Microsoft Office Tutorials and References
In Depth Information
Fig. 6.26
dialogue box for creating the regression function in excel
OK
Input Y Range: eggs
Input X Range: weight
Click on the ‘‘button’’ to the left of Output Range to select this, and enter A50 in
the box as the place on your spreadsheet to insert the Regression analysis in cell
A50
OK
The SUMMARY OUTPUT should now be in cells: A50 : I67
Now, make the columns in the Regression Summary Output section of your
spreadsheet wider so that you can read all of the column headings clearly.
Now, change the data in the following two cells to Number format (2 decimal
places):
B53
B66
Next, change this cell to four decimal places: B67
Now, change the format for all other numbers that are in decimal format to
number format, three decimal places, and center all numbers within their cells.
Save the resulting file as: eggs36
Print the file so that it fits onto one page. (Hint: Change the scale under ‘‘Page
Layout’’ to 60 % to make it fit).. Your file should be like the file in Fig. 6.27 .
Search JabSto ::




Custom Search