Chemometrics in Excel /

Pomerant︠s︡ev, A. L. 1954-

Chemometrics in Excel / Alexey L. Pomerantsev. - 1 online resource.

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




Translated from the Russian.

9781118873298 (pdf) 1118873297 (pdf) 9781118873267 (epub) 1118873262 (epub) 9781118873229 ( mobi) 111887322X ( mobi) 9781118873212 1118873211 1118605357 9781118605356 9781306706230 1306706238

2013046560


Microsoft Excel (Computer file)
Microsoft Excel (Programes d'ordinador)


Chemometrics--Data processing.
SCIENCE--Chemistry--Analytic.
Química--Mesurament--Informàtica.


Llibres electrònics.
Electronic books.

QD75.4.C45

543.0285/554