Microsoft Office Tutorials and References

In Depth Information

6.5.1.3

Installing the Data Analysis ToolPak into Excel 2003

Open a new Excel spreadsheet

Click on: Tools (at the top of your screen)

If the bottom of this Tools box says “Data Analysis,” the ToolPak has already been

installed in your version of Excel and you are ready to ﬁnd the regression equation.

If the bottom of the Tools box does not say “Data Analysis,” you need to install the

ToolPak as follows:

Click on:

File

Options (bottom left of screen)

Add-ins

Analysis Tool Pak (it is directly underneath Inactive Application

Add-ins near the top of the box)

Go

Click to add a check-mark to the left of analysis Toolpak

OK

Note:
If these steps do not work, try these steps instead: Tools / Add-ins / Click to

the left of analysis ToolPak to add a check mark to the left / OK

You are now ready to skip ahead to Sect. 6.5.2.

6.5.2 Using Excel to Find the SUMMARY OUTPUT

of Regression

You have now installed
ToolPak
, and you are ready to ﬁnd the regression equation

for the “best-ﬁtting straight line” through the data points by using the following

steps:

Open the Excel ﬁle:
eggs35
(if it is not already open on your screen)

Note:
If this ﬁle is already open, and there is a gray border around the chart, you

need to click on any empty cell outside of the chart to deselect the chart.

Now that you have installed
Toolpak
, you are ready to ﬁnd the regression

equation summarizing the relationship between weight and eggs produced in your

data set.

Remember that you gave the name:
weight
to the X data (the predictor), and the

name:
eggs
to the Y data (the criterion) in a previous section of this chapter (see

Sect. 6.2)

Data (top of screen)

Data analysis (far right at top of screen; see Fig.
6.25
)

Search JabSto ::

Custom Search