An Additional Benefit from Using the SolvStat Macro

AN ADDITIONAL BENEFIT FROM USING THE SOLVSTAT MACRO 

There is an additional major advantage in using the Solver Add-in and the SolvStat.xls macro, even for functions that are linear or can be rearranged to a linear form. For example, if the function is 

Plotting 1/y vs /x will yield a straight line with slope X/ab and intercept X/a. LINEST can be used to provide the regression coefficients X/ab and 1/fl, and their associated standard deviations. The coefficients a and b can be obtained from the regression coefficients a = 1/intercept, b = intercept/slope). However, relationships dealing with the propagation of error must be used to calculate the 

---