engleski

Modelling of screen-printed sensor response parameters by use of Microsoft Excell Solver

Solver is a spreadsheet optimization modeling system that is incorporated into Microsoft Excel for Windows, which can be used for solving various linear, nonlinear or integer problems. When applied to analysis of a scientific data set, it can yield the same results as commercial analysis software packages. The investigations presented describe modelling of response parameters of a potentiometric surfactant screen-printed sensor by using potentiometric data set of some anionic surfactants. The theoretical models for the potentiometric titration curves were elaborated too. The experimental data were compared with appropriate theoretical curves in which the sensor response parameters and analyte properties (sensor slope, constant potential term, solubility product constant, analyte concentration) were estimated and optimized with Solver (Excel) using least-squares criterion to fit theoretical curves to an experimental data set. The initial parameter settings were defined, and no constraints on the variables were applied. The macro SolvStat provided the regression statistics of the Solver by calculation of the standard deviations of the parameters, correlation coefficients and standard errors of the y estimate SE(y). The theoretical models fit satisfactorily to the experimental values for the investigated surfactants.

screen-printed sensor; response parameters; potentiometric titration; anionic surfactants; Solver; macro SolvStat

nije evidentirano