NotesFAQContact Us
Collection
Advanced
Search Tips
Back to results
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1182229
Record Type: Journal
Publication Date: 2018-Jun
Pages: 8
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-0021-9584
EISSN: N/A
Least-Squares Analysis of Data with Uncertainty in "y" and "x": Algorithms in Excel and KaleidaGraph
Tellinghuisen, Joel
Journal of Chemical Education, v95 n6 p970-977 Jun 2018
For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication in this method, here called "total variance" (TV), is the need to calculate residuals [delta][subscript i] in every uncertain variable. In "x-y" problems, that means adjustments must be obtained for "x" as well as for the customary "y." However, for the straight-line fit model, there is a simpler procedure, a version of effective variance (EV) methods, that requires only the residuals in y and agrees exactly with the TV method. Furthermore, Monte Carlo calculations have shown that this EV[subscript 2] method is statistically comparable to the TV method for many common nonlinear fit models. This method is easy to code for computation in Excel and programs like KaleidaGraph, as is illustrated here for several examples, including implicit nonlinear models. The algorithms yield estimates of both the parameters and their standard errors and can be used as well for more traditional problems requiring weighting in "y" only.
Division of Chemical Education, Inc and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail: eic@jce.acs.org; Web site: http://pubs.acs.org/jchemeduc
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A