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. 

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 

---