Nonlinear regression using spreadsheets

被引:149
作者
Bowen, WP
Jerman, JC
机构
[1] Department of Neuroscience, SmithKline Beecham Pharmaceuticals, Harlow, CM19 5AW, New Frontiers Science Park, Third Ave.
关键词
D O I
10.1016/S0165-6147(00)89091-4
中图分类号
R9 [药学];
学科分类号
1007 [药学];
摘要
Pharmacologists are often required to analyse nonlinear experimental effects by fitting the data to defined theoretical models, This may require a specialized computer program capable of performing nonlinear regression analysis, which can prove costly given the variety of pharmacological research. Here, Wayne Bowen and Jeff Jerman describe a generic method of performing nonlinear regression using spreadsheet applications, and demonstrate how this approach can be used to create automated systems of data analysis.
引用
收藏
页码:413 / 417
页数:5
相关论文
共 6 条
[1]
OPERATIONAL MODELS OF PHARMACOLOGICAL AGONISM [J].
BLACK, JW ;
LEFF, P .
PROCEEDINGS OF THE ROYAL SOCIETY SERIES B-BIOLOGICAL SCIENCES, 1983, 220 (1219) :141-162
[2]
Bowen W. P., 1994, British Journal of Pharmacology, V112, p440P
[3]
Bowen W. P., 1994, British Journal of Pharmacology, V112, p659P
[4]
WHY, WHEN, AND HOW BIOCHEMISTS SHOULD USE LEAST-SQUARES [J].
JOHNSON, ML .
ANALYTICAL BIOCHEMISTRY, 1992, 206 (02) :215-225
[5]
AN ALGORITHM FOR LEAST-SQUARES ESTIMATION OF NONLINEAR PARAMETERS [J].
MARQUARDT, DW .
JOURNAL OF THE SOCIETY FOR INDUSTRIAL AND APPLIED MATHEMATICS, 1963, 11 (02) :431-441
[6]
FITTING CURVES TO DATA USING NONLINEAR-REGRESSION - A PRACTICAL AND NONMATHEMATICAL REVIEW [J].
MOTULSKY, HJ ;
RANSNAS, LA .
FASEB JOURNAL, 1987, 1 (05) :365-374