论文信息 - A spreadsheet for linear least-squares fitting with errors in both coordinates - 字舞流文

A spreadsheet for linear least-squares fitting with errors in both coordinates

A freely available, easy-to-use Excel spreadsheet for performing linear least-squares fits for (x, y) data with errors in both coordinates is described.

B. Cameron Reed

[1] B. Cameron Reed,et al. Linear least‐squares fits with errors in both coordinates. II: Comments on parameter variances , 1992 .

[2] P. R. Bevington,et al. Data Reduction and Error Analysis for the Physical Sciences , 1969 .

[3] B. Cameron Reed,et al. Linear least‐squares fits with errors in both coordinates , 1989 .

[4] B. Cameron Reed. Erratum: ‘‘Linear least‐squares fits with errors in both coordinates’’ [Am. J. Phys. 57, 642–646 (1989)] , 1990 .

[5] D. York. Least-squares fitting of a straight line. , 1966 .

[6] D. Chong. Comment on ``Linear least-squares fits with errors in both coordinates,'' by B. C. Reed [Am. J. Phys. 57, 642-646 (1989)] , 1991 .

[7] Margarita López Martínez,et al. Unified equations for the slope, intercept, and standard errors of the best straight line , 2004 .

[8] J. Hulst,et al. The physical structure of Magellanic Cloud HII regions - II. Elemental abundances , 2002 .