Publication Date
| In 2026 | 0 |
| Since 2025 | 0 |
| Since 2022 (last 5 years) | 0 |
| Since 2017 (last 10 years) | 1 |
| Since 2007 (last 20 years) | 1 |
Descriptor
| Chemistry | 1 |
| Computation | 1 |
| Data Analysis | 1 |
| Equations (Mathematics) | 1 |
| Graphs | 1 |
| Least Squares Statistics | 1 |
| Monte Carlo Methods | 1 |
| Problem Solving | 1 |
| Spreadsheets | 1 |
Author
| Tellinghuisen, Joel | 1 |
Publication Type
| Journal Articles | 1 |
| Reports - Descriptive | 1 |
Education Level
Audience
Location
Laws, Policies, & Programs
Assessments and Surveys
What Works Clearinghouse Rating
Least-Squares Analysis of Data with Uncertainty in "y" and "x": Algorithms in Excel and KaleidaGraph
Peer reviewed
Direct linkTellinghuisen, Joel – Journal of Chemical Education, 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…
Descriptors: Chemistry, Least Squares Statistics, Data Analysis, Spreadsheets
