A USER-FRIENDLY SPREADSHEET PROGRAM FOR CALIBRATION USING WEIGHTED REGRESSION

被引：22

作者：

GORT, SM

HOOGERBRUGGE, R

机构：

来源：

CHEMOMETRICS AND INTELLIGENT LABORATORY SYSTEMS | 1995年 / 28卷 / 01期

关键词：

D O I：

10.1016/0169-7439(95)00013-M

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

An interactive user-friendly computer spreadsheet for calibration is described. This spreadsheet application (developed in Excel from Microsoft(R)) 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 performed 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. The performance of the application is illustrated by a calibration example.

引用

页码：193 / 199

页数：7

共 13 条

[1]

[Anonymous], 1987, ANALYST, V112, P199

[2]

BRANDT S, 1976, STATISTICAL COMPUTAT

[3] VARIANCE FUNCTION ESTIMATION [J].

DAVIDIAN, M ;

CARROLL, RJ .

JOURNAL OF THE AMERICAN STATISTICAL ASSOCIATION, 1987, 82 (400) :1079-1091

[4] REGRESSION AND CALIBRATION WITH NONCONSTANT ERROR VARIANCE [J].

DAVIDIAN, M ;

HAALAND, PD .

CHEMOMETRICS AND INTELLIGENT LABORATORY SYSTEMS, 1990, 9 (03) :231-248

[5]

DRAPER NR, 1981, APPLIED REGRESSION A

[6] NON-CONSTANT VARIANCE REGRESSION TECHNIQUES FOR CALIBRATION-CURVE-BASED ANALYSIS [J].

GARDEN, JS ;

MITCHELL, DG ;

MILLS, WN .

ANALYTICAL CHEMISTRY, 1980, 52 (14) :2310-2315

[7]

HORWITZ W, 1982, ANAL CHEM, V54, pA67, DOI 10.1021/ac00238a002

[8]

Massart D. L., 1988, CHEMOMETRICS TXB

[9]

1994, ISO9169 INT ORG STAN

[10]

1990, ISO IEC GUIDE 25 GEN

← 1 2 →