Affordable Access

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

Authors
  • Briones, A M Jr
  • Reichardt, W
Type
Published Article
Journal
Journal of Microbiological Methods
Publisher
Elsevier
Publication Date
Mar 01, 1999
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.

Report this publication

Statistics

Seen <100 times