Example 95th Percentile Calculation

Note: Excel spreadsheets are used for demonstration purposes, however, there is a slight difference in the opReports percentile() formula and the Excel percentile() formula:

See spreadsheet http://dl-omk.opmantek.com/jira/WAN-Utilisation-Distribution-Report-95th_percentile_calc_20210305-1.xlsx
which contains an opReports WAN Utilisation Distribution Report on first sheet and data and 95th percentile calculation on second sheet.

See newer example spreadsheet http://dl-omk.opmantek.com/jira/WAN-Utilisation-Distribution-Report-95th_percentile_calc_20210421-1.xlsx
which also contains an opReports WAN Utilisation Distribution Report on first sheet and data and 95th percentile calculation on second sheet.

Related Topics