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.
