Microsoft Office Tutorials and References

In Depth Information

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
)

Fig. 6.25

Example of using the data/data analysis function of excel

Scroll down the dialog box using the down arrow and click on: Regression (see

Fig.
6.26
)

Search JabSto ::

Custom Search