Chemometrics Calculations with Microsoft Excel (4) - Principal Component Regression -

  • YOSHIMURA Norio
    Graduate School of Agriculture, Tokyo University of Agriculture and Technology
  • FUKUHARA Koji
    Graduate School of Agriculture, Tokyo University of Agriculture and Technology
  • MITSUKI Kenichiro
    Graduate School of Agriculture, Tokyo University of Agriculture and Technology
  • TAKAYANAGI Masao
    Graduate School of Agriculture, Tokyo University of Agriculture and Technology

Bibliographic Information

Other Title
  • Microsoft Excelを用いたケモメトリクス計算(4) -主成分回帰-
  • Microsoft Excel オ モチイタ ケモメトリクス ケイサン(4)シュセイブン カイキ

Search this article

Description

Although chemometrics has become widely used recently for analyzing experimental chemical data, there exist only a few instructions for the proper usage of chemometrics other than those in some introductory books. As the fourth step of chemometrics calculations with Microsoft Excel (Excel), the principal component regression is performed on worksheets. Three worksheets were constructed for generating the spectra of model calibration samples and unknown samples, solving principal component analysis by NIPALS algorithm and calculating principal component regression. The quantitative performance of principal component regression was compared with that of multiple linear regression or the analysis based on Lambert-Beer law. Principal component regression was found to be superior to the other two methods.

Journal

Citations (1)*help

See more

References(20)*help

See more

Related Projects

See more

Details 詳細情報について

Report a problem

Back to top