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.

Objective:

To

ﬁnd

the

regression

equation

summarizing

the

relationship

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.

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 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:

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