Send to

Choose Destination
J Microbiol Methods. 1999 Mar;35(2):157-61.

Estimating microbial population counts by 'most probable number' using Microsoft Excel.

Author information

International Rice Research Institute, Manila, Philippines.


A computer-assisted method for determining population counts using the 'most probable number' (MPN) was developed. The Microsoft Excel spreadsheet and its Solver tool were used to generate MPNs, error estimates and confidence limits. Our method was flexible, allowing the use of unbalanced replication schemes and varying replication numbers and inoculation volumes. Furthermore, it required no programming skills and generated fast results, which were comparable to those of standard MPN tables and MPN software.

[Indexed for MEDLINE]

Supplemental Content

Full text links

Icon for Elsevier Science
Loading ...
Support Center