Microsoft Office Tutorials and References
In Depth Information
Fig. 6.25 Example of Using the Data / Data Analysis Function of Excel
Fig. 6.26 Dialogue Box for Creating the Regression Function in Excel
Scroll down the dialog box using the down arrow and click on: Regression (see
Fig. 6.26 )
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
Search JabSto ::




Custom Search