SOLVERSTAT: a new utility for multipurpose analysis. An application to the investigation of dioxygenated Co(II) complex formation in dimethylsulfoxide solution
SOLVERSTAT: a new utility for multipurpose analysis. An application to the investigation of dioxygenated Co(II) complex formation in dimethylsulfoxide solution
复制标题
DOI：
10.1016/s0039-9140(02)00457-5
复制
发表时间：
2003-01-02
期刊：
影响因子：
6.1
通讯作者：
Tolazzi, M
中科院分区：
文献类型：
--
作者：
Comuzzi, C;Polese, P;Tolazzi, M
一个新的多用途分析工具，SOLVERSTAT，利用电子表格的多功能性在这里描述。借助该工具，在Microsoft Excel Solver中引入了先进的统计测试，从而允许回归诊断和不同模型之间的区分。本实用程序用于通过紫外可见光谱法测定Co（II）与N，N'-二甲基乙二胺（dmen）在298 K的非质子溶剂二甲基亚砜（dmso）和以Et4NClO4调节至0.1 mol dm（-3）的介质中1:2配合物吸收分子二氧的稳定常数。讨论了模型和参数的可靠性，并与Dynafit（不同的软件包）和独立伏安测量的结果进行了比较。SOLVERSTAT的有效性也进行了检验，将其应用于文献中已经讨论的不同模型之间的区分。(C) 2002 Elsevier Science B.V.版权所有
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. (C) 2002 Elsevier Science B.V. All rights reserved.