Microsoft Office Tutorials and References
In Depth Information
Since we know that the correlation between the weight of the ﬁsh and the
number of eggs produced is +0.87, this tells us that it makes sense to use weight to
predict eggs produced based on past data.
We now need to ﬁnd that regression equation that is the equation of the ‘‘best-
ﬁtting straight line’’ through the data points.
between X and Y.
In order to ﬁnd this equation, we need to check to see if your version of Excel
contains the ‘‘Data Analysis ToolPak’’ necessary to run a regression analysis.
6.5.1 Installing the Data Analysis ToolPak into Excel
Objective: To install the Data Analysis ToolPak into Excel
Since there are currently three versions of Excel in the marketplace (2003,
2007, 2010), we will give a brief explanation of how to install the Data Analysis
ToolPak into each of these versions of Excel.
126.96.36.199 Installing the Data Analysis ToolPak into Excel 2010
Open a new Excel spreadsheet
Click on: Data (at the top of your screen)
Look at the top of your monitor screen. Do you see the words: ‘‘Data Analysis’’
at the far right of the screen? If you do, the Data Analysis ToolPak for Excel 2010
was correctly installed when you installed Ofﬁce 2010, and you should skip ahead
to Sect. 6.5.2 .
If the words: ‘‘Data Analysis’’ are not at the top right of your monitor screen,
then the ToolPak component of Excel 2010 was not installed when you installed
Ofﬁce 2010 onto your computer. If this happens, you need to follow these steps:
Excel options (creates a dialog box)
Manage: Excel Add-Ins (at the bottom of the dialog box)
Highlight: Analysis ToolPak (in the Add-Ins dialog box)
Data (You now should have the words: ‘‘Data Analysis’’ at the top right of your
Search JabSto ::