Microsoft Office Tutorials and References
In Depth Information
dialogue box for creating the regression function in excel
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
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
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 ﬁle as: eggs36
Print the ﬁle so that it ﬁts onto one page. (Hint: Change the scale under ‘‘Page
Layout’’ to 60 % to make it ﬁt).. Your ﬁle should be like the ﬁle in Fig. 6.27 .
Search JabSto ::