Tech Report
Looking behind the Spreadsheet Trendline
Abstract
Presents a visual approach to linear least-squares curve fitting that drives home the idea of minimizing the sum of the squares of the deviations in order to find the best fit to a set of data that are being described by a linear relationship.
Keywords (Audience):
First-Year Undergraduate / GeneralKeywords (Feature):
JCE WebWare: Web-Based Learning AidsKeywords (Pedagogy):
Computer-Based LearningKeywords (Subject):
Computational ChemistryCiting Articles
Citation data is made available by participants in CrossRef's Cited-by Linking service. For a more comprehensive list of citations to this article, users are encouraged to perform a search in SciFinder.
This article has been cited by 2 ACS Journal articles (2 most recent appear below).

Reply to Visualizing Statistical Concepts: Response from the JCE WebWare Feature Editor
William F. ColemanJournal of Chemical Education2008 85 (5), 637Reply to Visualizing Statistical Concepts: Response from the JCE WebWare Feature Editor
William F. ColemanJournal of Chemical Education2008 85 (5), 637While certainly containing accurate descriptions of least-squares analysis, de Levie's letter misses the point of the visualization, which is to see how minimizing the sum of the squares of the deviations leads to the best least-squares line.

Visualizing Statistical Concepts
Robert de LevieJournal of Chemical Education2008 85 (5), 635Visualizing Statistical Concepts
Robert de LevieJournal of Chemical Education2008 85 (5), 635Because statistical concepts such as least-squares fitting are often experienced as abstract, their visualization can be a helpful didactic tool, provided that this is done correctly. Unfortunately, the example in Figure 1 on page 1884 of the December ...
Tools
-
Add to Favorites
-
Download Citation
-
Email a Colleague -
Permalink
Order Reprints
Rights & Permissions
Citation Alerts
History
- Received: August 03, 2009
Cart
ACS
Network






