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. What is new:
-Open Source
-Monte Carlo search of global minimum of the sum of squares in
nonlinear regressions
-LOO and MC cross validation
-Beale confidence region
-Significance and Power Analysis via MC Simulation
-Correlation tests
-Lin's Concordance Test
-Univariate outliers
-Resampling and histogram tools
-Principal Component Analysis
-Support for simple Logistic Regression
EST (Equilibrium Speciation Tool) is a Excel add-in for the
simulation of chemical equilibria in solution. The program calculates
the thermodynamic equilibrium concentrations of species in aqueous and
non aqueous chemical systems. It handles homogeneous (complexation,
acid-base, redox) and heterogeneous equilibria (solubility and
distribution with other solvent or gas phase). Corrections for ionic
strength can be made and activities calculated. It allows the users to
simulate, or to obtain from experimental data, desired
chemical-physical parameters as well as to interact with other
available or freely created Excel tools. It is based onclassical
Newton-Raphson method applied to mass balance and improved by
using a robust Genetic Algorithm.
What is new:
-Open Source
-Bugs fix
solverstat@gmail.com
