Prev. Article Next Article Table of Contents

Article

Using a Spreadsheet to Fit Experimental pH Titration Data to a Theoretical Expression: Estimation of Analyte Concentration and Ka

Supporting Info

Your current credentials do not allow retrieval of the full text.

Purchase the full-text

PDF/HTML,
figures/images,
references and tables,
(where available)

John Burnett and William A. Burns

Department of Chemistry, Arkansas State University, State University, AR 72467

J. Chem. Educ., 2006, 83 (8), p 1190

DOI: 10.1021/ed083p1190

Publication Date (Web): August 1, 2006

Section:

History, Education, and Documentation

Abstract

A method of determining analyte concentration and K_a 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.

Keywords (Audience):

Upper-Division Undergraduate

Keywords (Domain):

Analytical Chemistry

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Bronsted-Lowry Acids / Bases

View: Hi-Res PDF | PDF w/ Links

Tools

SciFinder Links

Explore by:

Author of this Article Any Author Research Topic

History

Received: August 03, 2009

Recommend & Share

Related Content

The Determination of the pKa of Multiprotic, Weak Acids by Analyzing Potentiometric Acid-Base Titration Data with Difference PlotsJournal of Chemical Education
- The Determination of the pKa of Multiprotic, Weak Acids by Analyzing Potentiometric Acid-Base Titration Data with Difference Plots
  Arno Kraft
  Journal of Chemical Education 2003 80 (5), p 554
  Abstract:
  This paper discusses the pK_a determination of mono-, di-, and triprotic weak acids with the help of difference (Bjerrum) plots, and the effect of strong acid–base concentration errors, ligand weight errors, and nonlinear electrode response. Experimental ...
  Abstract | PDF w/ Links | Hi-Res PDF
Predicting Acid-Base Titration Curves without CalculationsJournal of Chemical Education
- Predicting Acid-Base Titration Curves without Calculations
  Dennis W. Barnum
  Journal of Chemical Education 1999 76 (7), p 938
  Abstract:
  A common approach to teaching acid-base chemistry is to have students calculate titration curves. Students often concentrate on setting up the equations or the spreadsheet and either lose sight of or fail to recognize the general principles that the ...
  Abstract | PDF w/ Links | Hi-Res PDF
Curve-Fitting Approach to Potentiometric Titration Using SpreadsheetJournal of Chemical Education
- Curve-Fitting Approach to Potentiometric Titration Using Spreadsheet
  Ngai Ling Ma and C. W. Tsang
  Journal of Chemical Education 1998 75 (1), p 122
  Abstract:
  A curve fitting approach has been used to determine the endpoint of a potentiometric titration. Here, the titration curve is assumed to be an arctangent function with four adjustable parameters. By systematically adjusting these parameters, the titration ...
  Abstract | PDF w/ Links | Hi-Res PDF

#qs-wrap {display: none !important;}

Because you do not have JavaScript enabled, the Quick Search functionality is not displayed here. Please enable JavaScript or use the Advanced Search Page.

Select a CAS section from the 5 main topical divisions below:

Article

Using a Spreadsheet to Fit Experimental pH Titration Data to a Theoretical Expression: Estimation of Analyte Concentration and Ka

Abstract

Keywords (Audience):

Keywords (Domain):

Keywords (Pedagogy):

Keywords (Subject):

Tools

SciFinder Links

History

Recommend & Share

Related Content

The Determination of the pKa of Multiprotic, Weak Acids by Analyzing Potentiometric Acid-Base Titration Data with Difference Plots

Predicting Acid-Base Titration Curves without Calculations

Curve-Fitting Approach to Potentiometric Titration Using Spreadsheet

JOURNALS

BOOKS

C&EN

TOOLS

COMMUNITIES

DIRECTORIES & DATABASES

LEGACY MAGAZINES

Products

User Resources

Support

Partners

Search ACS Publications