Limit search to available items
Book Cover
E-book
Author Pomerant︠s︡ev, A. L. (Alekseĭ Leonidovich), 1954-

Title Chemometrics in Excel / Alexey L. Pomerantsev
Published Hoboken, New Jersey : John Wiley & Sons, [2014]

Copies

Description 1 online resource
Contents 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
Summary 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
Notes Includes index
Bibliography Includes bibliographical references (page 19) and index
Notes Translated from the Russian
Print version record and CIP data provided by publisher
SUBJECT Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
Microsoft Excel (Computer file) fast
Subject Chemometrics -- Data processing
SCIENCE -- Chemistry -- Analytic.
Form Electronic book
LC no. 2013046560
ISBN 9781118873298
1118873297
9781118873267
1118873262
9781118873229
111887322X
9781118873212
1118873211
1118605357
9781118605356
9781306706230
1306706238
Other Titles Khemometrika v Excel. English