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 find 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 find the regression equation
for the “best-fitting straight line” through the data points by using the following
steps:
Open the Excel file: eggs35 (if it is not already open on your screen)
Note: If this file 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 find 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