JCE Digital Library Journal of Chemical Education Division of Chemical Education, American Chemical SocietyAmerican Chemical Society
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print

JCE Digital Library

JCE Software

Only@JCE Online

About JCE


 Home > JCE DLib > Mathcad in Chemistry >
Linear Least-Squares Regression

Sidney H. Young and Andrzej Wierzbicki
Department of Chemistry, University of South Alabama, Mobile, AL 36688

Abstract

Linear least-squares regression is the workhorse mathematical tool of the physical chemistry laboratory. This Mathcad worksheet and its accompanying data files demonstrate various implicit and explicit methods for determination of slope and intercept of a regressed line. It also produces the correlation coefficient, 95% confidence ranges, standard deviation of fit, and standard deviations of slope and intercept. Residual analysis is used to demonstrate techniques of determining and removing questionable data points from the fit. Since this worksheet can import data from external files, one may use it as a general laboratory tool. Instructors can easily prepare simplified versions of the worksheet for students from this template. The worksheet also contains an introduction to weighted least-squares methods. It shows how a quadratic term can be included and tested during the fitting process for data that are poorly fit with a linear least-squares model. A second set of data is provided for this activity. The worksheet includes a discussion of how to determine whether the quadratic term is statistically significant. This testing method is general and can be used for all fitted parameters obtained by least-squares fitting. The worksheet is fully annotated and contains interactive exercises for student practice.
 

Mathcad documents (fully interactive with Mathcad)
*
PDF versions (non-interactive)
*
Commentary
*
Keywords
JCE Citation
*

* JCE Subscribers only: name and password or institutional IP number access required
 Home > JCE DLib > Mathcad in Chemistry > Linear Least-Squares Regression


JCE Digital Library
is a collection of
NSDL

JCE Digital Library
also includes the following collections
JCE DigiDemos
Tested Demonstrations
JCE WebWare
Web-Based Learning Aids
JCE QBank
Resources for Student Assessment