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 find that regression equation that is the equation of the
“best-fitting straight line” through the data points.
Objective : To find the regression equation summarizing the
relationship between X and Y.
In order to find 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