SolverStat is an
Excel add-in (xla) for Microsoft
Excel 97, 2000, XP, 2007, 2010, 2013, 2016 that performs advanced
statistical tests on
least
squares
regression data.
In Microsoft Excel, the built-in optimization package Solver yields
minimized
least squares regression parameters: the use of this utility in
association
with the worksheet functions makes Excel a flexible tool to solve
linear
and non linear regression problems. Nevertheless, Solver provides no
estimates
of the precision of the fitted parameters and an incomplete and
unprompted
analysis of fittings: the statistical analysis of the result is, on the
other
hand, a crucial step to evalutate the reliability of the models.
SolverStat overcomes that limits.
SolverStat is released as Open
Source under the Educational Community License version 2.0.
Citation: "SOLVERSTAT : a new utility for multipurpose analysis. An
application to the investigation of dioxygenated Co(II) complex
formation in dimethylsulfoxide solution."
C.Comuzzi, P.Polese, A.Melchior, R.Portanova, M.Tolazzi. Talanta
59 (2003)
67-80 (PDF)
[email protected]