Hazen percentile calculator
The Hazen percentile calculator is an Excel file that uses macros to calculate the percentile of a data set using the Hazen formula.
As there is no one correct way to calculate percentiles, the Hazen method is a "middle-of-the-road" option. Other percentile methods include Blom, Tukey, Weibull and Excel (the standard formula used to calculate percentiles in Excel). The methods vary in the minimum number of data they require, the formula used to calculate the percentile and the actual result. For example, the Excel percentile method always gives the lowest percentile result, while the Weibull method always gives the highest.
The Hazen percentile method is the percentile used in the Microbiological Water Quality Guidelines for Marine and Freshwater Recreational Areas and associated Bathewatch software.
This Excel file calculator can calculate a Hazen percentile for up to 2000 data per site for multiple sites simultaneously and different percentiles eg, 5th percentile or 95th percentile.
Select ‘enable macros’ when opening the excel file.
Availability:
Hazen Percentile Calculator - version 2 (Excel spreadsheet 214 KB)
If you have any questions about the Hazen percentile calculator please send us an email, environmental.reporting@mfe.govt.nz
