Estimating microbial population counts by 'most probable number' using Microsoft Excel
Related Experiment Video
Updated: Oct 23, 2026

Modified Most Probable Number Assay to Quantify Salmonella in Raw and Ready-to-Cook Chicken Products
Published on: January 31, 2025
1International Rice Research Institute, Manila, Philippines. abrjones@irri.cgiar.org
Abstract:
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.
Related Concept Videos
Microbial Growth Measurement: Direct Methods
Methods to Assess Microbial Populations
Microbial Growth Measurement: Indirect Methods
Exponential Growth
Exponential Equations for Modeling Growth