Applications of Microsoft Excel in Analytical Chemistry

Applications of Microsoft Excel in Analytical Chemistry

4.11 - 1251 ratings - Source

This supplement can be used in any analytical chemistry course. The exercises teaches you how to use Microsoft Excel using applications from statistics, data analysis equilibrium calculations, curve fitting, and more. Operations include everything from basic arithmetic and cell formatting to Solver, Goal Seek, and the Data Analysis Toolpak. The authors show you how to use a spreadsheet to construct log diagrams and to plot the results. Statistical data treatment includes descriptive statistics, linear regression, hypothesis testing, and analysis of variance. Tutorial exercises include nonlinear regression such as fitting the Van Deemter equation, fitting kinetics data, determining error coefficients in spectrophotometry, and calculating titration curves. Additional features include solving complex systems of equilibrium equations and advanced graphical methods: error bars, charts with insets, matrices and determinants, and much more. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.This worksheet should be useful for solving any problem involving a quadratic equation. As practice, use the solver to find the hydronium ion concentration in Example 9-7 of FAC9 or Example 4-7 of AC7. Compare the results you obtain from the exact solution to the result of 9.2 X 1073 M obtained by assuming the H3O+ concentration is small compared to the ... 134 Copyright 2013 Cengage Learning.

Title:Applications of Microsoft Excel in Analytical Chemistry
Author:F. Holler, Stanley Crouch
Publisher:Cengage Learning - 2013-01-17


You Must CONTINUE and create a free account to access unlimited downloads & streaming