After the data sort excel data from big to small to take 80% of what functions were calculated

PERCENTILE returns the values in the region's first K-point value.You can use this function to establish acceptable thresholds.For example, determine the top scoring 90 points in the first test on candidates.Grammar PERCENTILE (array, k) Array to define the relative position of the array or data area.K 0 to 1 percentage points of value, including 0 and 1.Note ? If the array is empty or more than 8,191 data points were, the function PERCENTILE returns the error value # NUM! .? If k a non-numeric, function PERCENTILE returns the error value # VALUE!.? If k 1, the function PERCENTILE returns the error value # NUM!.? If k is not 1 / (n-1) multiple, function PERCENTILE use interpolation to determine the value of k-points.

Leave a Reply