Affordable Access

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

Authors
Type
Published Article
Journal
Journal of Microbiological Methods
0167-7012
Publisher
Elsevier
Publication Date
Volume
35
Issue
2
Pages
157–161
Identifiers
PMID: 10192048
Source
Medline
License
Unknown

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.

Statistics

Seen <100 times