JCE Online Journal of Chemical Education
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print
   Current Issue
 Previous Issues
 Supplements
 Search JCE Index

JCE Digital Library
   DigiDemos
 QBank
 SymMath
 WebWare

JCE Software
   Latest Releases
 Software & Video
 Downloads
 Support

Only@JCE Online
   JCE Online Store
 JCE HS CLIC
 JCE Discussion Forums
   Biographical Snapshots
 ChemEd Resource Shelf
 Featured Molecules
 Hal's Picks
 Project Chemlab
 Reviewed WWW Sites
 "Web-Ed" Articles

About JCE
   Features
 Publications
 Operations
 Outreach
 Contact Us


  Home > JCE Print > Journal of Chemical Education > Issues > 2003  > September  >
In the Classroom
A Global Least-Squares Fit for Absolute Zero
Carl Salter
Department of Chemistry, Moravian College, Bethlehem, PA 18018
Cover
September 2003
Vol. 80 No. 9
p. 1033
Abstract
A simple, nonlinear least-squares method is described that permits gas thermometry data to be fitted directly to absolute zero. This nonlinear method can be implemented using Solver in Excel, and unlike other linear methods previously reported, it is statistically sound. The Excel macro SolverAid can be used to compute the error in absolute zero. The method can be applied simultaneously to multiple sets of data, permitting a global value of absolute zero to be computed from different gas samples. Constant volume thermometry data for helium are used to illustrate the global fit to absolute zero using Solver in an Excel spreadsheet. The relationship between the global value of absolute zero and the values from the individual fits is analyzed.
More Information
*  Citation
 Salter, Carl. J. Chem. Educ. 2003 80 1033.
*  Keywords
 Gases; General Chemistry; Laboratory Computing / Interfacing; Laboratory Instruction; Physical Chemistry; Statistics / Data Analysis
*  History
 Created:
Last Updated:		 August 4, 2003
February 28, 2005
<< Previous Article Table of Contents Next Article >>
  Home > JCE Print > Journal of Chemical Education > Issues > 2003 > September > Page 1033


Subscriptions
 Subscription Info
 Order Forms

JCE HS CLIC

Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.
 JCE HS CLIC

Contributions Welcome
JCE welcomes your submission
 Contributors' Corner

Advertisers
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.
 Recent Advertisers

Be An Ambassador
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.
 Outreach with JCE

Comments to
jceonline@chem.wisc.edu		 Copyright © Division of Chemical Education, Inc., American Chemical Society.
All rights reserved.