Big Chemical Encyclopedia

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

Articles Figures Tables About

A Macro to Provide Regression Statistics for the Solver

The preceding example illustrates the steps in the application of the method. The procedure is cumbersome to apply in practice. The macro SolvStat.xls on the diskette that accompanies this book was written to perform the calculations. It returns the standard deviations of the coefficients, the correlation coefficient and the SE(y) or RMSD it can be applied to linear or non-linear regression. [Pg.235]

To calculate the standard deviations of regression coefficients obtained by using the Solver, the macro uses the same approach outlined in the preceding example. The SSresiduals/ SSregression arid SE y) are calculated from the known [Pg.235]


See other pages where A Macro to Provide Regression Statistics for the Solver is mentioned: [Pg.235]    [Pg.235]   


SEARCH



Solver

Statistical regression

Statistics for

© 2024 chempedia.info