Excel Tutorial: Using the Least-Squares Method To Calculate Unknown Concentrations and Error

J. J. Harynuk and J. Lam
Department of Chemistry, University of Alberta, Edmonton, AB T6G 2G2 Canada
J. Chem. Educ., 2009, 86 (7), p 879
DOI: 10.1021/ed086p879
Publication Date (Web): July 1, 2009

Abstract

This tutorial guides students through the construction of a spreadsheet that performs least-squares analysis to find the best-fit line through a series of data points.

Keywords (Audience):

Second-Year Undergraduate

Keywords (Domain):

Analytical Chemistry

Keywords (Feature):

JCE WebWare: Web-Based Learning Aids

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Calibration
View: Hi-Res PDF | PDF w/ Links

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