Home : MPN Spread Function
Q13093 - INFO: MPN Spread Function

MPN returns the MPN value for the three counts given for the 5 tube Fecal Coliform MPN Procedure (Standard Methods 9221 C) .  Count1 is the 10mL reading, Count2 is the 1mL reading, and Count3 is the 0.1mL reading.  If different sample volumes are used, the MPN value should be adjusted by multipling the result. 

Syntax:

MPN(10mL Count, 1mL count, 0.1mL count)

Example:

MPN(3,0,1) - returns 11

MPN(C4,D4,E4) - returns 6.1 where cells C4,D4, and E4 equal 1.

NOTE:

Table 9221.IV. MPN Index for Various Combinations of Positive Results When Five Tubes Are Used per Dilution (10 mL, 1.0 mL, 0.1 mL).  Readings not in Standard Methods (such as 434) were taken from Metcalf and Eddy Wastewater Engineering, 3rd Edition Table F-1.

READING   MPNVALUE
000          1
001          1.8
002          3.6
003          5.4
004          7.2
005          9
010          1.8
011          3.6
012          5.5
013          7.3
014          9.1
015          11
020          3.7
021          5.5
022          7.4
023          9.2
024          11
025          13
030          5.6
031          7.4
032          9.3
033          11
034          13
035          15
040          7.5
041          9.4
042          11
043          13
044          15
045          17
050          9.4
051          11
052          13
053          15
054          17
055          19
100          2
101          4
102          6
103          8
104          10
105          12
110          4
111          6.1
112          8.1
113          10
114          12
115          14
120          6.1
121          8.2
122          10
123          12
124          15
125          17
130          8.3
131          10
132          13
133          15
134          17
135          19
140          11
141          13
142          15
143          17
144          19
145          22
150          13
151          15
152          17
153          19
154          22
155          24
200          4.5
201          6.8
202          9.1
203          12
204          14
205          16
210          6.8
211          9.2
212          12
213          14
214          17
215          19
220          9.3
221          12
222          14
223          17
224          19
225          22
230          12
231          14
232          17
233          20
234          22
235          25
240          15
241          17
242          20
243          23
244          25
245          28
250          17
251          20
252          23
253          26
254          29
255          32
300          7.8
301          11
302          13
303          16
304          20
305          23
310          11
311          14
312          17
313          20
314          23
315          27
320          14
321          17
322          20
323          24
324          27
325          31
330          17
331          21
332          24
333          28
334          31
335          35
340          21
341          24
342          28
343          32
344          36
345          40
350          25
351          29
352          32
353          37
354          41
355          45
400          13
401          17
402          21
403          25
404          30
405          36
410          17
411          21
412          26
413          31
414          36
415          42
420          22
421          26
422          32
423          38
424          44
425          50
430          27
431          33
432          39
433          45
434          52
435          59
440          34
441          40
442          47
443          54
444          62
445          69
450          41
451          48
452          56
453          64
454          72
455          81
500          23
501          31
502          43
503          58
504          76
505          95
510          33
511          46
512          64
513          84
514          110
515          130
520          49
521          70
522          95
523          120
524          150
525          180
530          79
531          110
532          140
533          180
534          210
535          250
540          130
541          170
542          220
543          280
544          350
545          430
550          240
551          350
552          540
553          920
554          1600

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 7/12/2010 4:45 PM.
Last Modified on 3/15/2017 8:09 AM.
Last Modified by Scott Dorner.
Article has been viewed 3135 times.
Rated 9 out of 10 based on 2 votes.
Print Article
Email Article