Chemometrics Calculations with Microsoft Excel (2) - Iterative Calculation -

DOI Web Site Web Site 2 Citations 13 References
  • YOSHIMURA Norio
    Graduate School of Agriculture, Tokyo University of Agriculture and Technology
  • SHIGETANI Akihiro
    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を用いたケモメトリクス計算(2)反復計算
  • Microsoft Excel オ モチイタ ケモメトリクス ケイサン 2 ハンプク ケイサン

Search this article

Description

Although chemometrics has become widely used recently for analyzing experimental chemical data, there exist in Japan only a few instructions for the proper usage of chemometrics except for some introductory books. We have found that Microsoft Excel (Excel) is convenient, inexpensive, and popular software for chemometrics calculations especially for educational purposes. In this paper, as the second report for chemometrics calculations with Excel, the procedure of iterative calculation is explained using an example of solving an eigenvalue problem, which is necessary for a principal component analysis (PCA). The power method is applied to solve the eigenvalue problem. Excel has peculiar action, the copied range is still valid after the paste operation. Iterative calculation is executed on Excel worksheet by using this action and redo command.

Journal

Citations (2)*help

See more

References(13)*help

See more

Keywords

Details 詳細情報について

Report a problem

Back to top