This array goes into the PERCENTILE function with the k value from F5, 90%.
PERCENTILE automatically ignores FALSE values and returns a result of 86.8.
The reference to Gender in G$4 is locked to prevent the row from changing.
The reference to k values, $F5 is locked to prevent the column from changing.
As a result, the formula can be copied across the range G5:H7.
A percentile is a value below which a given percentage of values in a data set fall.
you’re able to use PERCENTILE to determine the 90th percentile, the 80th percentile, etc.
