Chemometrics in Excel / Alexey L. Pomerantsev.
Material type: TextLanguage: English Original language: Russian Publisher: Hoboken, New Jersey : John Wiley & Sons, [2014]Description: 1 online resourceContent type:- text
- computer
- online resource
- 9781118873298 (pdf)
- 1118873297 (pdf)
- 9781118873267 (epub)
- 1118873262 (epub)
- 9781118873229 ( mobi)
- 111887322X ( mobi)
- 9781118873212
- 1118873211
- 1118605357
- 9781118605356
- 9781306706230
- 1306706238
- Khemometrika v Excel. English
- 543.0285/554 23
- QD75.4.C45
Includes index.
Description based on print version record and CIP data provided by publisher.
Translated from the Russian.
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
Computer Science and Engineering