Examples of Analytical Data Treatment Using Microsoft Excel Outliers, Significance Testing/ANOVA, Regression, Matrices, and Solver

by Stauffer, Mark T

• ISBN13: 9781119535881
• ISBN10: 1119535883
• Edition: 1st
• Format: Hardcover
• Copyright: 2022-06-15
• Publisher: Wiley
• More Book Details

Summary

This book deals with the use of Microsoft^® Excel™ for treatment of outlier data and results, significance testing in data analysis. The focus of this book centers on applications of Excel™’s math and statistical functions and analysis tools to problems and questions in analytical chemistry.  This book is intended as a practical, hands-on guide to the use of Excel™ for calculation and assessment of quantitative data and results from analytical determinations.  A basic operational knowledge of Microsoft^® Excel™ is assumed on the part of the reader.

Methods covered in the book include Treatment of outlier data/results in the Excel™ worksheet environment (Dixon Q test, Grubbs (G) test, etc.); Two-sample significance testing in the Excel™ worksheet environment; Analysis of variance (ANOVA) in the Excel™ worksheet environment for more than two samples; Regression; and Matrix functions for multianalyte determination and multivariate calibration.