TCE
    
|
The Chemical Educator
ISSN: 1430-4171 (electronic version)
Abstract Volume 15
(2010) pp 103-107
Using Multiple Linear Regression to Analyze Mixtures: An Excel Spreadsheet Exercise for Undergraduates
Eugene T. Smith,* Eugene A. Belogay, and Terje Hơim
Harriet L. Wilkes Honors College, Florida Atlantic
University, Jupiter, FL 33458 esmith@fau.edu
Received November 20, 2008. Accepted September 9, 2009.
Published: 27 January 2010
Abstract. An exercise is described for the analysis of a mixture containing acetaminophen, aspirin, and caffeine using UV spectroscopy and HPLC. The concentrations of various components in a mixture are determined directly from the UV spectra using multiple linear regression, and then the concentrations of various components in a mixture are determined using HPLC data. The experiment is appropriate for undergraduate students in analytical chemistry.
Key Words: Laboratories and Demonstrations; analytical chemistry
(*) Corresponding author. (E-mail: esmith@fau.edu)
Article in PDF format (383 KB) HTML format
Supporting Materials:
Instructor notes, a student handout, and Excel workbooks are available online. The supplements were prepared with Microsoft Word (2003) and Excel (2003 and 2007). Laboratory instrumentation varies greatly among universities, so the customization of the Student Handout is left to the instructor. Answers to the sample questions in the Student Handout are provided at the end of the Instructor Notes. The Excel workbooks are explained in detail in the Instructor Notes. (190 KB)
© The Chemical Educator 1996-2024