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