JCE Online Journal of Chemical EducationDivision of Chemical Education, American Chemical SocietyAmerican Chemical Society
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print
   Current Issue
 Previous Issues
 Supplements
 Search JCE Index

JCE Digital Library
   ChemInfo
 DigiDemos
 Featured Molecules
 LivTexts
 LrnCom
 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 > 2006  > August  >
In the Laboratory
Using a Spreadsheet to Fit Experimental pH Titration Data to a Theoretical Expression: Estimation of Analyte Concentration and Ka
John Burnett and William A. Burns
Department of Chemistry, Arkansas State University, State University, AR 72467
Cover
August 2006
Vol. 83 No. 8
p. 1190
Abstract
A method of determining analyte concentration and Ka by least-squares fitting experimental acid–base pH titration data to a single theoretical expression is presented. The fitting is carried out using the Solver Add-in of the ubiquitous Excel spreadsheet program. The theoretical expressions used in this article are easily derived using the systematic treatment of equilibrium and alpha fractions, and therefore this method of analysis is appropriate for the typical undergraduate analytical chemistry laboratory–lecture sequence.
Supplement
A derivation of theoretical monoprotic acid–monoprotic base and diprotic acid–monoprotic base pH titration expressions, a description of least-squares fitting of data using the Excel Solver Add-in, Excel spreadsheets that can be used to determine Ka and Fa for monoprotic acid–monoprotic base and diprotic acid–monoprotic base pH titrations, and experimental acid–base pH titration data for the acids listed in Table 1 are available.
*  Contents Folder JCE2006p1190W containing JCE2006p1190W.doc (Microsoft Word) and JCE2006p1190W.xls (Microsoft Excel)
*  Download
JCE2006p1190W.pdf

JCE2006p1190W.zip
More Information
*  Citation
 Burnett, John; Burns, William A. J. Chem. Educ. 2006 83 1190.
*  Keywords
 Analytical Chemistry; Bronsted-Lowry Acids / Bases; Computational Chemistry; Computer-Based Learning; Hands-On Learning / Manipulatives; Laboratory Instruction; pH; Titration / Volumetric Analysis; Upper-Division Undergraduate
*  History
 Created:
Last Updated:		 6/21/2006
6/30/2006
<< Previous Article Table of Contents Next Article >>
  Home > JCE Print > Journal of Chemical Education > Issues > 2006  > August  > Page 1190


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.