how do you find the value that cuts off the top 13 of a data

how do you find the value that cuts off the top 1/3 of a data set using the excel LARGE function

Solution

The =LARGE(array,k) function can be used to return the largest, second largest, third largest and kth largest values from a range.

Let n be the number of data points.

Then Large (array, [n/3]) will return the top 1/3 of the data values and take the complement of this set .