Chemometrics in Excel

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.

ConclusionChapter 10: Calibration; 10.1 The Basics; 10.2 Simulated Data; 10.3 Classic Calibration; 10.4 Inverse Calibration; 10.5 Latent Variables Calibration; 10.6 Methods Comparison; Conclusion; Chapter 11: Classification; 11.1 The Basics; 11.2 Data; 11.3 Supervised Classification; 11.4 Unsupervised Classification; Conclusion; Chapter 12: Multivariate Curve Resolution; 12.1 The Basics; 12.2 Simulated Data; 12.3 Factor Analysis; 12.4 Iterative Methods; Conclusion; Part IV: Supplements; Chapter 13: Extension of Chemometrics Add-In; 13.1 Using Virtual Arrays; 13.2 Using VBA Programming.

ConclusionChapter 14: Kinetic Modeling of Spectral Data; 14.1 The "Grey" Modeling Method; Conclusions; Chapter 15: Matlab®: Beginner'S Guide*; 15.1 The Basics; 15.2 Matrices; 15.3 Integrating Excel and Matlab®; 15.4 Programming; 15.5 Sample Programs; Conclusion; Afterword. The Fourth Paradigm; Index; End User License Agreement.

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.

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.

Includes index.

Includes bibliographical references (page 19) and index.