Alexey L. Pomerantsev

Chemometrics in Excel

• Gebundenes Buch

Produktbeschreibung

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(r) for chemometrics training
Online downloads includes workbooks with examples

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: Wiley & Sons
• 1. Auflage
• Seitenzahl: 336
• Erscheinungstermin: 19. Mai 2014
• Englisch
• Abmessung: 260mm x 183mm x 22mm
• Gewicht: 197g
• ISBN-13: 9781118605356
• ISBN-10: 1118605357
• Artikelnr.: 40189874

Autorenporträt

Alexey L Pomerantsev is a Leading Researcher at The Russian Academy of Science. He is a founding member and Chair of the Russian Chemometrics Society, being instrumental in organizing the annual Winter Symposium on Chemometrics. He is a peer reviewer and member of Editorial Board of the Journal 'Chemometrics and Intelligent Laboratory Systems.' Dr. Pomerantsev has over 100 publications, many of them dealing with Chemometric Investigations.

Inhaltsangabe

Preface xvii
PART I INTRODUCTION 1
1 What is Chemometrics? 3
1.1 Subject of Chemometrics, 3
1.2 Historical Digression, 5
2 What the Book Is About? 8
2.1 Useful Hints, 8
2.2 Book Syllabus, 9
2.3 Notations, 10
3 Installation of Chemometrics Add-In 11
3.1 Installation, 11
3.2 General Information, 14
4 Further Reading on Chemometrics 15
4.1 Books, 15
4.1.1 The Basics, 15
4.1.2 Chemometrics, 16
4.1.3 Supplements, 16
4.2 The Internet, 17
4.2.1 Tutorials, 17
4.3 Journals, 17
4.3.1 Chemometrics, 17
4.3.2 Analytical, 18
4.3.3 Mathematical, 18
4.4 Software, 18
4.4.1 Specialized Packages, 18
4.4.2 General Statistic Packages, 19
4.4.3 Free Ware, 19
PART II THE BASICS 21
5 Matrices and Vectors 23
5.1 The Basics, 23
5.1.1 Matrix, 23
5.1.2 Simple Matrix Operations, 24
5.1.3 Matrices Multiplication, 25
5.1.4 Square Matrix, 26
5.1.5 Trace and Determinant, 27
5.1.6 Vectors, 28
5.1.7 Simple Vector Operations, 29
5.1.8 Vector Products, 29
5.1.9 Vector Norm, 30
5.1.10 Angle Between Vectors, 30
5.1.11 Vector Representation of a Matrix, 30
5.1.12 Linearly Dependent Vectors, 31
5.1.13 Matrix Rank, 31
5.1.14 Inverse Matrix, 31
5.1.15 Pseudoinverse, 32
5.1.16 Matrix-Vector Product, 33
5.2 Advanced Information, 33
5.2.1 Systems of Linear Equations, 33
5.2.2 Bilinear and Quadratic Forms, 34
5.2.3 Positive Definite Matrix, 34
5.2.4 Cholesky Decomposition, 34
5.2.5 Polar Decomposition, 34
5.2.6 Eigenvalues and Eigenvectors, 35
5.2.7 Eigenvalues, 35
5.2.8 Eigenvectors, 35
5.2.9 Equivalence and Similarity, 36
5.2.10 Diagonalization, 37
5.2.11 Singular Value Decomposition (SVD), 37
5.2.12 Vector Space, 38
5.2.13 Space Basis, 39
5.2.14 Geometric Interpretation, 39
5.2.15 Nonuniqueness of Basis, 39
5.2.16 Subspace, 40
5.2.17 Projection, 40
6 Statistics 42
6.1 The Basics, 42
6.1.1 Probability, 42
6.1.2 Random Value, 43
6.1.3 Distribution Function, 43
6.1.4 Mathematical Expectation, 44
6.1.5 Variance and Standard Deviation, 44
6.1.6 Moments, 44
6.1.7 Quantiles, 45
6.1.8 Multivariate Distributions, 45
6.1.9 Covariance and Correlation, 45
6.1.10 Function, 46
6.1.11 Standardization, 46
6.2 Main Distributions, 46
6.2.1 Binomial Distribution, 46
6.2.2 Uniform Distribution, 47
6.2.3 Normal Distribution, 48
6.2.4 Chi-Squared Distribution, 50
6.2.5 Student's Distribution, 52
6.2.6 F-Distribution, 53
6.2.7 Multivariate Normal Distribution, 54
6.2.8 Pseudorandom Numbers, 55
6.3 Parameter Estimation, 56
6.3.1 Sample, 56
6.3.2 Outliers and Extremes, 56
6.3.3 Statistical Population, 56
6.3.4 Statistics, 57
6.3.5 Sample Mean and Variance, 57
6.3.6 Sample Covariance and Correlation, 58
6.3.7 Order Statistics, 59
6.3.8 Empirical Distribution and Histogram, 60
6.3.9 Method of Moments, 61
6.3.10 The Maximum Likelihood Method, 62
6.4 Properties of the Estimators, 62
6.4.1 Consistency, 62
6.4.2 Bias, 63
6.4.3 Effectiveness, 63
6.4.4 Robustness, 63
6.4.5 Normal Sample, 64
6.5 Confidence Estimation, 64
6.5.1 Confidence Region, 64
6.5.2 Confidence Interval, 65
6.5.3 Example of a Confidence Interval, 65
6.5.4 Confidence Intervals for the Normal Distribution, 65
6.6 Hypothesis Testing, 66
6.6.1 Hypothesis, 66
6.6.2 Hypothesis Testing, 66
6.6.3 Type I and Type II Errors, 67
6.6.4 Example, 67
6.6.5 Pearson's Chi-Squared Test, 67
6.6.6 F-Test, 69
6.7 Regression, 70
6.7.1 Simple Regression, 70
6.7.2 The Least Squares Method, 71
6.7.3 Multiple Regression, 72
Conclusion, 73
7 Matrix Calculations in Excel 74
7.1 Basic Information, 74
7.1.1 Region and Language, 74
7.1.2 Workbook, Worksheet, and Cell, 76
7.1.3 Addressing, 77
7.1.4 Range, 78
7.1.5 Simple Calculations, 78
7.1.6 Functions, 78
7.1.7 Important Functions, 81
7.1.8 Errors in Formulas, 85
7.1.9 Formula Dragging, 86
7.1.10 Create a Chart, 87
7.2 Matrix Operations, 88
7.2.1 Array Formulas, 88
7.2.2 Creating and Editing an Array Formula, 90
7.2.3 Simplest Matrix Operations, 91
7.2.4 Access to the Part of a Matrix, 91
7.2.5 Unary Operations, 93
7.2.6 Binary Operations, 95
7.2.7 Regression, 95
7.2.8 Critical Bug in Excel 2003, 99
7.2.9 Virtual Array, 99
7.3 Extension of Excel Possibilities, 100
7.3.1 VBA Programming, 100
7.3.2 Example, 101
7.3.3 Macro Example, 103
7.3.4 User-Defined Function Example, 104
7.3.5 Add-Ins, 105
7.3.6 Add-In Installation, 106
Conclusion, 107
8 Projection Methods in Excel 108
8.1 Projection Methods, 108
8.1.1 Concept and Notation, 108
8.1.2 PCA, 109
8.1.3 PLS, 110
8.1.4 Data Preprocessing, 111
8.1.5 Didactic Example, 112
8.2 Application of Chemometrics Add-In, 113
8.2.1 Installation, 113
8.2.2 General, 113
8.3 PCA, 114
8.3.1 ScoresPCA, 114
8.3.2 LoadingsPCA, 114
8.4 PLS, 116
8.4.1 ScoresPLS, 116
8.4.2 UScoresPLS, 117
8.4.3 LoadingsPLS, 118
8.4.4 WLoadingsPLS, 119
8.4.5 QLoadingsPLS, 120
8.5 PLS2, 121
8.5.1 ScoresPLS2, 121
8.5.2 UScoresPLS2, 122
8.5.3 LoadingsPLS2, 124
8.5.4 WLoadingsPLS2, 125
8.5.5 QLoadingsPLS2, 126
8.6 Additional Functions, 127
8.6.1 MIdent, 127
8.6.2 MIdentD2, 127
8.6.3 MCutRows, 129
8.6.4 MTrace, 129
Conclusion, 130
PART IIICHEMOMETRICS 131
9 Principal Component Analysis (PCA) 133
9.1 The Basics, 133
9.1.1 Data, 133
9.1.2 Intuitive Approach, 134
9.1.3 Dimensionality Reduction, 136
9.2 Principal Component Analysis, 136
9.2.1 Formal Specifications, 136
9.2.2 Algorithm, 137
9.2.3 PCA and SVD, 137
9.2.4 Scores, 138
9.2.5 Loadings, 139
9.2.6 Data of Special Kind, 140
9.2.7 Errors, 140
9.2.8 Validation, 143
9.2.9 Decomposition "Quality", 143
9.2.10 Number of Principal Components, 144
9.2.11 The Ambiguity of PCA, 145
9.2.12 Data Preprocessing, 146
9.2.13 Leverage and Deviation, 146
9.3 People and Countries, 146
9.3.1 Example, 146
9.3.2 Data, 147
9.3.3 Data Exploration, 147
9.3.4 Data Pretreatment, 148
9.3.5 Scores and Loadings Calculation, 149
9.3.6 Scores Plots, 151
9.3.7 Loadings Plot, 152
9.3.8 Analysis of Residuals, 153
Conclusion, 153
10 Calibration 156
10.1 The Basics, 156
10.1.1 Problem Statement, 156
10.1.2 Linear and Nonlinear Calibration, 157
10.1.3 Calibration and Validation, 158
10.1.4 Calibration "Quality", 160
10.1.5 Uncertainty, Precision, and Accuracy, 162
10.1.6 Underfitting and Overfitting, 163
10.1.7 Multicollinearity, 164
10.1.8 Data Preprocessing, 166
10.2 Simulated Data, 166
10.2.1 The Principle of Linearity, 166
10.2.2 "Pure" Spectra, 166
10.2.3 "Standard" Samples, 166
10.2.4 X Data Creation, 167
10.2.5 Data Centering, 168
10.2.6 Data Overview, 168
10.3 Classic Calibration, 169
10.3.1 Univariate (Single Channel) Calibration, 169
10.3.2 The Vierordt Method, 172
10.3.3 Indirect Calibration, 174
10.4 Inverse Calibration, 176
10.4.1 Multiple Linear Calibration, 177
10.4.2 Stepwise Calibration, 178
10.5 Latent Variables Calibration, 180
10.5.1 Projection Methods, 180
10.5.2 Latent Variables Regression, 184
10.5.3 Implementation of Latent Variable Calibration, 185
10.5.4 Principal Component Regression (PCR), 186
10.5.5 Projection on the Latent Structures-1 (PLS1), 188
10.5.6 Projection on the Latent Structures-2 (PLS2), 191
10.6 Methods Comparison, 193
Conclusion, 197
11 Classification 198
11.1 The Basics, 198
11.1.1 Problem Statement, 198
11.1.2 Types of Classes, 199
11.1.3 Hypothesis Testing, 199
11.1.4 Errors in Classification, 200
11.1.5 One-Class Classification, 200
11.1.6 Training and Validation, 201
11.1.7 Supervised and Unsupervised Training, 201
11.1.8 The Curse of Dimensionality, 201
11.1.9 Data Preprocessing, 201
11.2 Data, 202
11.2.1 Example, 202
11.2.2 Data Subsets, 203
11.2.3 Workbook Iris.xls, 204
11.2.4 Principal Component Analysis, 205
11.3 Supervised Classification, 205
11.3.1 Linear Discriminant Analysis (LDA), 205
11.3.2 Quadratic Discriminant Analysis (QDA), 210
11.3.3 PLS Discriminant Analysis (PLSDA), 214
11.3.4 SIMCA, 217
11.3.5 k-Nearest Neighbors (kNN), 223
11.4 Unsupervised Classification, 225
11.4.1 PCA Again (Revisited), 225
11.4.2 Clustering by K-Means, 225
Conclusion, 229
12 Multivariate Curve Resolution 230
12.1 The Basics, 230
12.1.1 Problem Statement, 230
12.1.2 Solution Ambiguity, 232
12.1.3 Solvability Conditions, 234
12.1.4 Two Types of Data, 235
12.1.5 Known Spectrum or Profile, 236
12.1.6 Principal Component Analysis (PCA), 236
12.1.7 PCA and MCR, 237
12.2 Simulated Data, 237
12.2.1 Example, 237
12.2.2 Data, 238
12.2.3 PCA, 238
12.2.4 The HELP Plot, 240
12.3 Factor Analysis, 241
12.3.1 Procrustes Analysis, 241
12.3.2 Evolving Factor Analysis (EFA), 244
12.3.3 Windows Factor Analysis (WFA), 246
12.4 Iterative Methods, 249
12.4.1 Iterative Target Transform Factor Analysis (ITTFA), 249
12.4.2 Alternating Least Squares (ALS), 250
Conclusion, 252
PART IV SUPPLEMENTS 255
13 Extension Of Chemometrics Add-In 257
13.1 Using Virtual Arrays, 257
13.1.1 Simulated Data, 257
13.1.2 Virtual Array, 259
13.1.3 Data Preprocessing, 259
13.1.4 Decomposition, 260
13.1.5 Residuals Calculation, 260
13.1.6 Eigenvalues Calculation, 262
13.1.7 Orthogonal Distances Calculation, 263
13.1.8 Leverages Calculation, 264
13.2 Using VBA Programming, 265
13.2.1 VBA Advantages, 265
13.2.2 Virtualization of Real Arrays, 265
13.2.3 Data Preprocessing, 266
13.2.4 Residuals Calculation, 267
13.2.5 Eigenvalues Calculation, 268
13.2.6 Orthogonal Distances Calculation, 269
13.2.7 Leverages Calculation, 270
Conclusion, 271
14 Kinetic Modeling of Spectral Data 272
14.1 The "Grey" Modeling Method, 272
14.1.1 Problem Statement, 272
14.1.2 Example, 274
14.1.3 Data, 274
14.1.4 Soft Method of Alternating Least Squares (Soft-ALS), 275
14.1.5 Hard Method of Alternating Least Squares (Hard-ALS), 277
14.1.6 Using Solver Add-In, 279
Conclusions, 282
15 MATLAB®: Beginner's Guide 283
15.1 The Basics, 283
15.1.1 Workspace, 283
15.1.2 Basic Calculations, 285
15.1.3 Echo, 285
15.1.4 Workspace Saving: MAT-Files, 286
15.1.5 Diary, 286
15.1.6 Help, 287
15.2 Matrices, 287
15.2.1 Scalars, Vectors, and Matrices, 287
15.2.2 Accessing Matrix Elements, 289
15.2.3 Basic Matrix Operations, 289
15.2.4 Special Matrices, 290
15.2.5 Matrix Calculations, 292
15.3 Integrating Excel and MATLAB®, 294
15.3.1 Configuring Excel, 294
15.3.2 Data Exchange, 294
15.4 Programming, 295
15.4.1 M-Files, 295
15.4.2 Script File, 296
15.4.3 Function File, 297
15.4.4 Plotting, 298
15.4.5 Plot Printing, 300
15.5 Sample Programs, 301
15.5.1 Centering and Scaling, 301
15.5.2 SVD/PCA, 301
15.5.3 PCA/NIPALS, 302
15.5.4 PLS1, 303
15.5.5 PLS2, 304
Conclusion, 306
Afterword. The Fourth Paradigm 307
Index 311