A user friendly spreadsheet program for calibration using weighted regression. User's Guide
Gort SM Hoogerbrugge R
Gort SM
Hoogerbrugge R
Citations
Altmetric:
Series / Report no.
Open Access
Type
Report
Language
en
Date of publication
1995-03-31
Year of publication
Research Projects
Organizational Units
Journal Issue
Title
A user friendly spreadsheet program for calibration using weighted regression. User's Guide
Translated Title
Een gebruiksvriendelijk rekenprogramma voor calibratie met behulp van gewogen regressie
Published in
Abstract
Een gebruiksvriendelijke computer spreadsheet voor calibratie doeleinden is beschreven. Deze spreadsheet (ontwikkeld met behulp van Microsoft Excel) stelt niet-statistici, zoals analytische chemici, in de gelegenheid om gewogen lineaire regressie toe te passen. Verschillende calibratiefuncties en variantiemodellen zijn beschikbaar. De berekende calibratiefunctie met betrouwbaarheidsintervallen en residuen worden tevens grafisch weergegeven. F-testen worden toegepast om keuzes te kunnen maken tussen "simpele" en meer "complexe" calibratiefuncties. Maximum likelihood kan worden gebruikt om twee variantiemodellen te vergelijken. De traceerbaarheid van de gevolgde calibratieprocedure kan worden verkregen door middel van een ingebouwde LOG-functie.<br>
An interactive user friendly computer spreadsheet for calibration is described. This spreadsheet application (developed in Excel from Microsoft) enables analytical chemists to apply linear regression analysis using weighted least squares. Several types of calibration functions - as well as various variance models - are available. The calculated calibration function with confidence intervals and standardized residuals are graphically displayed. F-tests are preformed in order to distinguish between "simple" and more "complex" calibration functions. Maximum likelihood can be used to select between variance models. Traceability of the calibration procedures is obtained by a built-in LOG-function.<br>
An interactive user friendly computer spreadsheet for calibration is described. This spreadsheet application (developed in Excel from Microsoft) enables analytical chemists to apply linear regression analysis using weighted least squares. Several types of calibration functions - as well as various variance models - are available. The calculated calibration function with confidence intervals and standardized residuals are graphically displayed. F-tests are preformed in order to distinguish between "simple" and more "complex" calibration functions. Maximum likelihood can be used to select between variance models. Traceability of the calibration procedures is obtained by a built-in LOG-function.<br>
Description
Publisher
Rijksinstituut voor Volksgezondheid en Milieu RIVM
Sponsors
RIVM