...
Specifies the interpolation method used to compute the percentiles: nearest_neighbour or linear. The default value is: nearest_neighbour.
Nearest Neighbour or Linear. Given a list of numbers V, the algorithm used to compute a percentile is the following.:
Compute the rank (R) of a Pth P-th percentile. This is done using the following formula:
R = P/100 x (N + 1)
where P is the desired percentile and N is the number of input fields.Compute the percentile:
If R is an integer, the Pth P-th percentile will be the number with rank R.
If R is not an integer, the Pth P-th percentile is computed by interpolation as follows:
If the interpolation method is Nearest Neighbour, the following equation is used:
Pth P-th = V[int(R + 0.5)]If the interpolation method is Linear, the following steps are used:
Define IR as the integer portion of R
Define FR as the fractional portion or R
Find the scores with Rank IR and with Rank IR + 1, e.g. V[IR] and vV[IR+1]
Interpolate by multiplying the difference between the scores by FR and add the result to the lower score, e.g.
Pth = FR * (vV[IR+1] - V[IR]) + V[IR]