Scientific Results

Preliminary statistical tests in Microsoft Excel to quality control of chemical-physical measurements / Test statistici in Excel preliminari alla validazione e al controllo di qualità di misure chimico-fisiche

Year: 2015

Authors: Lanza C.

Autors Affiliation: CNR – Istituto Nazionale di Ottica (INO) Sede di Pisa

Abstract: As part of the research contract “Validation and quality control of chemical-physical analysis of compounds that affect the environment and health”
between Intertek Italy Spa and the National Research Council (CNR) Pisa 2015, we have developed some software procedures for automatic recognition
of large errors (outliers) in chemical-physical measures. Three different types of statistical tests1 were considered: IRQ, Grubb and Hampel test
which, together with the normality test, the Chi-square test of Pearson1, contribute synergistically to give more reliability to the subsequent
statistical predictions to be applied to numerical series. These preliminary tests, although not visible, have been implemented and made executable
in the same Microsoft Excel(r) spreadsheets which were stored algorithms responsible for the validation and quality control. An example of measures
of a compound of the family of phthalates is described and used to display the effectiveness of these preliminary tests.

Journal/Review:

More Information: Technical report 12/2015. CNR INO Pisa, p.30.-
Protocollo N. 10729 del 18.12.2015
KeyWords: Outlier; Normality; Median; Quartiles; Calculation programs

English