TCE ForumWhats NewSearchOrders


The Chemical Educator

ISSN: 1430-4171 (electronic version)

Table of Contents

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
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:

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-2017