Chemometrics in Excel

With an increasing need for using mathematical and statistical methods in their everyday practice it is essential for engineers and researchers to master chemometric approaches to multivariate data processing. Because chemometrics is a very practicable discipline it is important to not only explain the methods but to also provide a trainee with full access and an ability to perform all relevant calculations. This book presents the basic chemometric methods as worksheet functions in Excel. A specially designed Chemometrics Add In for Excel has been developed in conjunction with the book. The book is developed as a tutorial guide, which combines theoretical sections with the well explained examples presented in the accompanying Excel worksheets where the Chemometrics Add In is used. Topics in the book include an introduction to chemometrics. It also details the basics of chemometrics, topics in Chemometrics include Principal component analysis, Calibration, Classification, and Multivariate Curve Resolution. Supplements such as an Extension of the Chemometrics AddIn, Kinetic modeling of spectral data, and a MatLab Beginners Guide are also included.