Microsoft Office Tutorials and References

In Depth Information

Fig. 6.23
Example of the Page Layout for Reducing the Scale of the Chart to 80% of Normal Size

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.

Search JabSto ::

Custom Search