Looking behind the Spreadsheet Trendline

William F. Coleman
Chemistry Department, Wellesley College, Wellesley, MA 02481
Edward W. Fedosky
University of Wisconsin–Madison, Madison, WI 53715
J. Chem. Educ., 2006, 83 (12), p 1884
DOI: 10.1021/ed083p1884.1
Publication Date (Web): December 1, 2006

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 / General

Keywords (Feature):

JCE WebWare: Web-Based Learning Aids

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Computational Chemistry

Citing 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).

  • Cover Image

    Reply to Visualizing Statistical Concepts: Response from the JCE WebWare Feature Editor

    William F. Coleman
    Journal of Chemical Education2008 85 (5), 637
    • Reply to Visualizing Statistical Concepts: Response from the JCE WebWare Feature Editor

      William F. Coleman
      Journal of Chemical Education2008 85 (5), 637

      While 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.

  • Cover Image

    Visualizing Statistical Concepts

    Robert de Levie
    Journal of Chemical Education2008 85 (5), 635
    • Visualizing Statistical Concepts

      Robert de Levie
      Journal of Chemical Education2008 85 (5), 635

      Because 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

SciFinder Links

SciFinder subscribers:  Click to sign in | Not a SciFinder subscriber? Learn more at www.cas.org

Explore by:


History

  • Received: August 03, 2009

Recommend & Share

  • Share on ACS NetworkACS Network
  • Add to FacebookFacebook
  • Tweet ThisTweet This
  • Add to CiteULikeCiteULike
  • Add to NewsvineNewsvine
  • Digg ThisDigg This
  • Add to DeliciousDelicious

Related Content

See also: