Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Regression Using the Analysis ToolPak

MULTIPLE LINEAR REGRESSION USING THE ANALYSIS TOOLPAK [Pg.216]

Linear regression can also be performed using the Add-In package called the Analysis ToolPak. Choose Data Analysis... from the Tools menu if the Data Analysis... command is not present in the Tools menu, you must use the Add-Ins... command in the Tools menu to install it. [Pg.216]

The major limitation of the regression tool is that, unlike FINEST, it is not a function. With FINEST, the returned values are dynamically linked to the original data and are updated if the raw data is changed. With the Regression tool, the values are calculated from the raw data and entered into worksheet cells they do not change if you change the input data. [Pg.217]




SEARCH



Analysis ToolPak

Regression analysis

© 2024 chempedia.info