Projection Methods in Excel
Alexey L. Pomerantsev · 2014
This chapter describes the Chemometrics Add-In, which is an add-in designed especially for Microsoft Excel. The Chemometrics Add-In enables data analysis based on the following projection methods: Principal Component Analysis (PCA), Projection on Latent Structures (PLS1 and PLS2). This add-in includes user-defined functions, which can be used as standard worksheet functions. WE provide detailed descriptions of all these functions. Excel file Projection.xls is used to illustrate the Chemometrics Add-In facilities.