Geometric Mean Calculator for Wastewater
- Open the Geometric Mean Calculator spreadsheet.
- Determine the frequency of bacterial sampling required in your permit.
- Enter lab data (bacteria sampling results) in the appropriate cells on the sheet.
- If a sample result is zero, enter a 1 in that cell.
- The geometric mean will be calculated automatically.
- Enter the geometric mean result onto your DMR.
Note: For permits requiring once-per-month sampling, the lab data IS the geometric mean to enter in the DMR.
The formula for calculating geometric mean is the nth root of the product of all monitoring data.
(N1 * N2 * N3...)(1/Count)
Please call the Small Business and Local Government Assistance (SBLGA) section of the TCEQ at 800-447-2827 if you need help using this tool.
Download the Geometric Mean Calculator Spreadsheet
- CFU—colony forming units per 100 milliliters
- DMR—discharge monitoring report
- MPN—most probable number per 100 milliliters
Where can I find more information and assistance?
The TCEQ's Small Business and Local Government Assistance Section offers free, confidential help to small businesses and local governments working to comply with state environmental regulations. Call us at 800-447-2827 or visit our Web page at TexasEnviroHelp.org.