Applications of Microsoft Excel in Analytical Chemistry, 2nd Edition

Applications of Microsoft Excel in Analytical Chemistry, 2nd Edition
Author: F. James Holler
Pages: 474 pages
Edition: 2
Language: English
Publisher: Cengage Learning
Publication Date: 2013-01-17
ISBN-10: 128508795X
ISBN-13: 9781285087955
Book Description
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.15－Applications of Microsoft Excel in Analytical Chemistry, 2nd Edition 9781285087955.pdf