TY - BOOK AU - Pomerant︠s︡ev,A.L. TI - Chemometrics in Excel SN - 9781118873298 (pdf) AV - QD75.4.C45 U1 - 543.0285/554 23 PY - 2014///] CY - Hoboken, New Jersey PB - John Wiley & Sons KW - Microsoft Excel (Computer file) KW - Microsoft Excel (Programes d'ordinador) KW - Chemometrics KW - Data processing KW - SCIENCE KW - Chemistry KW - Analytic KW - bisacsh KW - Química KW - Mesurament KW - Informàtica KW - Llibres electrònics KW - Electronic books N1 - 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; 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 UR - http://onlinelibrary.wiley.com/book/10.1002/9781118873212 ER -