Statistics in Microsoft Excel

Program download

If you use 32 bit Windows OS and Excel 2007/2010, please download the macro file, example file, and manual: Statistical analysis tool for 32 bit and Excel 2007_2010.
If you use 64 bit Windows OS and Excel 2010, please download Statistical analysis tool for 64 bit and Excel 2010.


Principal component analysis (PCA), projection to latent structure regression (PLS-R), and projection to latent structure based discriminant analysis (PLS-DA) are the commonly-used multivariate analysis method in metabolomics study. Of course, there are many platforms for these analyses not only by the commercially available software such as SIMCA-P, but also by freely available software such as statistical language R, MetaboAnalyst. I also use them very much! However, I think that excel based platform should be also required for the approachability and the easily adjustment of Figures. In addition to multivariate analysis, I think that the easy-to-use platform for the graph making and the multiple comparison method is also required although I also know these tasks are possible by some tools like VANTED. I would like to offer the platform such that many researchers can easily do the statistical analysis.

Please cite one of the following papers

  • Integrated strategy for unknown EI–MS identification using quality control calibration curve, multivariate analysis, EI–MS spectral database, and retention index prediction. Analytical Chemistry, 89, 6766-6773, 2017 [ACS link]
  • MS-DIAL: data independent MS/MS deconvolution for comprehensive metabolome analysis. Nature Methods, 12, 523-526, 2015 [PubMed]

Format (Please see the example file)

- Data file must be saved as comma separated values (CSV) file format.
- First column must include the labels such as the retention time, peak number, and compound name in addition to two first rows, i.e. "Class", "Row: Label:: Column: Sample" index.
- First row must include the "Class" index. The order of class number is flexible. But users must use the class number from 1 without skip number.
- Second row must include the sample information.
- Others must include variables.

Available methods

1. Normalization method by internal standard
2. Bar graph making
3. Line chart making
4. Multi T-test
5. Principal component analysis (PCA)
6. Projection to latent structure regression (PLS-R)
7. Projection to latent structure based discriminant analysis (PLS-DA)

Back to Top