Microsoft Office Tutorials and References
In Depth Information
Since we know that the correlation between the weight of the fish 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 find that regression equation that is the equation of the ‘‘best-
fitting straight line’’ through the data points.
Objective:
To
find
the
regression
equation
summarizing
the
relationship
between X and Y.
In order to find 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.
6.5.1.1 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 Office 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
Office 2010 onto your computer. If this happens, you need to follow these steps:
File
Options
Excel options (creates a dialog box)
Add-Ins
Manage: Excel Add-Ins (at the bottom of the dialog box)
Go
Highlight: Analysis ToolPak (in the Add-Ins dialog box)
OK
Data (You now should have the words: ‘‘Data Analysis’’ at the top right of your
screen)
Search JabSto ::




Custom Search