Note

Determination of Dissociation Constants and Concentration by Microsoft Excel Solver

Norio YOSHIMURA^a*, Masanori OKAZAKI^a and Naoya NAKAGAWA^b

(Received: September 29, 2000; Accepted for publication: January 9, 2001; Published on Web: February 14, 2001)

The dissociation constants and concentration of an acid were determined from a titration curve by Microsoft Excel Solver. It is standard attachment of Microsoft Excel Package and a tool for solving optimization problems. A sample titration curve was obtained by the titration of citric acid solution with sodium hydroxide solution. Despite the fact that a titration curve equation is represented as a complicated non-linear equation, Solver was easily able to find a solution. As a result, the first, second and third step dissociation constants and concentration of citric acid were 1.44×10^-3, 5.15×10^-5, 2.29×10^-6M and 5.14×10^-3M, respectively. These values were sufficiently close to those in the literature and to experimental values. Calculation time for solving the problem was 8.60 second by even a personal computer with Pentium 90MHz. Since CPU is rapidly developed, Solver may become a powerful tool for problems with more variables in the near future.

Keywords: Excel, Solver, Titration Curve, Dissociation Constant, Citric Acid

Text in Japanese

PDF file(66kB)