SOLVERSTAT: a new utility for multipurpose analysis. An application to the investigation of dioxygenated Co(II) complex formation in dimethylsulfoxide solution

A new utility for multipurpose analysis, SOLVERSTAT, taking advantage of the versatility of spreadsheets is here described. By means of this tool advanced statistical tests have introduced in Microsoft Excel Solver thus allowing regression diagnostic and discrimination between different models. The utility is here applied to the determination, by UV-Vis spectroscopy, of the stability constant for the uptake of molecular dioxygen by the 1:2 complex of Co(II) with N,N′-dimethylethylenediamine (dmen) in the aprotic solvent dimethylsulfoxide (dmso) at 298 K and in a medium adjusted to 0.1 mol dm−3 with Et4NClO4. The reliability of the model and parameters obtained are discussed and the results compared with those obtained by Dynafit, a different software package, and by independent voltammetric measurements. The validity of SOLVERSTAT has been also examined applying it to the discrimination between different models already discussed in the literature.