Chemometrics in Excel

Providing an easy explanation of the fundamentals, methods, and applications of chemometrics Acts as a practical guide to multivariate data analysis techniques Explains the methods used in Chemometrics and teaches the reader to perform all relevant calculations Presents the basic chemometric methods as worksheet functions in Excel Includes Chemometrics Add In for download which uses Microsoft Excel® for chemometrics training Online downloads includes workbooks with examples.

Includes index.

Title Page; Copyright; Dedication; Preface; Part I : Introduction; Chapter 1: What is Chemometrics?; 1.1 Subject of Chemometrics; 1.2 Historical Digression; Chapter 2: What the Book Is About?; 2.1 Useful Hints; 2.2 Book Syllabus; 2.3 Notations; Chapter 3: Installation of Chemometrics Add-In*; 3.1 Installation; 3.2 General Information; Chapter 4: Further Reading on Chemometrics*; 4.1 Books; 4.2 The Internet; 4.3 Journals; 4.4 Software; Part II : The Basics; Chapter 5: Matrices and Vectors; 5.1 The Basics; 5.2 Advanced Information; Chapter 6: Statistics; 6.1 The Basics; 6.2 Main Distributions.

6.3 Parameter Estimation6.4 Properties of the Estimators; 6.5 Confidence Estimation; 6.6 Hypothesis Testing; 6.7 Regression; Conclusion; Chapter 7: Matrix Calculations in Excel; 7.1 Basic Information; 7.2 Matrix Operations; 7.3 Extension of Excel Possibilities; Conclusion; Chapter 8: Projection Methods in Excel*; 8.1 Projection Methods; 8.2 Application of Chemometrics Add-In; 8.3 PCA; 8.4 PLS; 8.5 PLS2; 8.6 Additional Functions; Conclusion; Part III: Chemometrics; Chapter 9: Principal Component Analysis (PCA); 9.1 The Basics; 9.2 Principal Component Analysis; 9.3 People and Countries.

Conclu…