The infrared spectrum of a heteronuclear diatomic molecule is acquired and analyzed in almost every undergraduate physical chemistry laboratory. Traditional data analyses can be frustrating to students because of the repetitive calculations, the graph production, and indirect method of obtaining molecular constants. This paper describes an improved data analysis method using the multiple linear regression feature of a spreadsheet program. This method dramatically simplifies the effort of data reduction, provides a more direct connection between experimental data and molecular constants, and yields results that are more accurate and precise than traditional methods.
Supplement
Supplementary materials provided are in the form of three files:
Spreadsheet comparing analysis methods in Excel 5.0/95 format (requires Analysis ToolPak Add-In)
Mathcad document with multiple linear regression analysis method in Mathcad 6.0 format
Data file for Mathcad document
They have been compressed as zip (for Windows) and sit (for Macintosh) files. It is also available as a pdf, accessible with Acrobat Reader.
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.
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.
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.