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

JCE Print

JCE Digital Library

JCE Software

Only@JCE Online

About JCE


  Home > JCE Print > Journal of Chemical Education > Issues > 1998  > September  >
Information • Textbooks • Media • Resources
Computer Bulletin Board
Using Excel Solver: An Addendum to the HCl Infrared Spectrum Experiment
Mark Iannone
Millersville University, Department of Chemistry, Millersville, PA 17551

Cover
September 1998
Vol. 75 No. 9
p. 1188

Abstract
Solver, a flexible and convenient add-in provided with Excel, is useful for fitting of a nonlinear model to experimental data. Solver is introduced to physical chemistry students in the context of the analysis of the fundamental band of the infrared spectrum of gaseous HCl. All peak positions in the P and R branches are used to find least-squares values for the pure vibrational transition, the rotational constants in v = 0 and v = 1 states, and the centrifugal distortion constant.
More Information
*  Citation
Iannone, Mark. J. Chem. Educ. 1998 75 1188.
*  Keywords
laboratory instruction, physical chem, IR spectroscopy, laboratory computing, interfacing
*  History
Created:
Last Updated:
June 21, 1999
June 24, 2005
  Home > JCE Print > Journal of Chemical Education > Issues > 1998 > September > Page 1188


Subscriptions

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.


Contributions Welcome
JCE welcomes your submission

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.

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.