A user-friendly MS-Excel spreadsheet is developed for evaluation of global consumer's and producer's risks in conformity assessment of chemical composition of a multicomponent material or object, when up to four component concentrations are under control. These risks are probabilities of incorrect conformity decisions related to a material batch (lot or similar) randomly drawn from a statistical population of such batches. The probabilities characterize the material quality globally, allowing the prediction of false decisions on conformity of a future batch, based on the future measurement results. The spreadsheet program evaluates risks using Monte Carlo simulations. As input data, the following need to be provided to the software: parameters of normal or lognormal distribution of actual (‘true’) values of the component concentrations (prior distribution); parameters of the distribution of measurements results at the actual value of the component concentration (likelihood function); and correlation matrices for couples of the actual components' concentrations under control and also for corresponding measurement results. The spreadsheet is validated by comparison of the risk estimates with those calculated in R programing environment by numerical integration of the relevant analytical formulae. The developed Excel file and a demonstration videos of its use are available as electronic supplementary material.

Spreadsheet for evaluation of global risks in conformity assessment of a multicomponent material or object / Bettencourt da Silva, Ricardo J. N.; Lourenço, Felipe R.; Pennecchi, Francesca R.; Hibbert, D. Brynn; Kuselman, Ilya. - In: CHEMOMETRICS AND INTELLIGENT LABORATORY SYSTEMS. - ISSN 0169-7439. - 188:(2019), pp. 1-5. [10.1016/j.chemolab.2019.02.010]

Spreadsheet for evaluation of global risks in conformity assessment of a multicomponent material or object

Pennecchi, Francesca R.;
2019

Abstract

A user-friendly MS-Excel spreadsheet is developed for evaluation of global consumer's and producer's risks in conformity assessment of chemical composition of a multicomponent material or object, when up to four component concentrations are under control. These risks are probabilities of incorrect conformity decisions related to a material batch (lot or similar) randomly drawn from a statistical population of such batches. The probabilities characterize the material quality globally, allowing the prediction of false decisions on conformity of a future batch, based on the future measurement results. The spreadsheet program evaluates risks using Monte Carlo simulations. As input data, the following need to be provided to the software: parameters of normal or lognormal distribution of actual (‘true’) values of the component concentrations (prior distribution); parameters of the distribution of measurements results at the actual value of the component concentration (likelihood function); and correlation matrices for couples of the actual components' concentrations under control and also for corresponding measurement results. The spreadsheet is validated by comparison of the risk estimates with those calculated in R programing environment by numerical integration of the relevant analytical formulae. The developed Excel file and a demonstration videos of its use are available as electronic supplementary material.
File in questo prodotto:
File Dimensione Formato  
Kuselman_2019_Chemometrics_188.pdf

non disponibili

Descrizione: Articolo principale
Tipologia: Versione editoriale
Licenza: Non Pubblico - Accesso privato/ristretto
Dimensione 735.73 kB
Formato Adobe PDF
735.73 kB Adobe PDF   Visualizza/Apri   Richiedi una copia
Accepted manuscript 10.1016@j.chemolab.2019.02.010.pdf

embargo fino al 03/03/2021

Descrizione: Articolo principale
Tipologia: Documento in Post-print
Licenza: Creative Commons
Dimensione 1.51 MB
Formato Adobe PDF
1.51 MB Adobe PDF Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11696/63153
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 13
  • ???jsp.display-item.citation.isi??? 13
social impact