Alert and action levels from your own results.
Paste a year of monitoring results and see the levels by percentile and by mean plus SD, with how many results exceed each.
Your results
Alert and action levels
200 results, from 0 to 15 CFU per plate. Mean 1.67 and SD 2.45.
| Level | 95th and 99th percentiles | Mean + 2 and 3 SD |
|---|---|---|
| Alert level | 7 CFU per plate7 of 200 above it (3.5%) | 6.6 CFU per plate11 of 200 above it (5.5%) |
| Action limit | 10 CFU per plate2 of 200 above it (1.0%) | 9.0 CFU per plate4 of 200 above it (2.0%) |
5.5% of the results are above the mean + 2 SD and 2.0% above the mean + 3 SD, against 2.3% and 0.135% for normal data. The results are skewed, so the sigma levels sit too low: the percentiles fit them better.
Where each number comes from.
The alert level is the 95th percentile, or the mean + 2 SD; the action limit is the 99th percentile, or the mean + 3 SD. Percentiles are by nearest rank, the smallest result with at least that share of the results at or below it, and the SD is the sample’s, with n − 1. Each count is of the results above the level as shown.
EU GMP Annex 1 caps action limits for each grade but sets no formula, and PIC/S PI 058-1 leaves the method to the manufacturer, to define and document. WHO TRS 1033 Annex 3 names the sigma method for water. Alert and action limits works the same room, and says which method suits which data.
Keep the levels with the data behind them.
In Seal limits and trend rules are versioned with their population, exclusions and approval, so a recalculated level takes effect from a known point.