Excel PERCENTILE Function

The PERCENTILE function is an integrated operation in Excel which can be classified as a Statistical operation. The Excel PERCENTILE function determines the nth percentile from a collection of value ranges. You should utilize this function to calculate a guideline of validation. Simply stated, it is easy to go ahead and compare applicants who rate above the 90th percentile, 80th percentile, and so on.

Syntax

=PERCENTILE(array,k)

How to use the PERCENTILE Function in Excel.

A percentile is a value below which a specific ratio of values in a data array (or range) fall.

  • The array is the collection of some information values that define an appropriate ranking.
  • K is the percentile value in the range 0….1, inclusive

Figure 1. EXAMPLE 1. of the PERCENTILE Function
(Note; in the example above, scores=B2:B11)

  • Insert a table in your Excel sheet and adjust to suit your needs and enter the array of corresponding values.
  • To make any sense of the utilization of PERCENTILE function, you are required to make available various sorts of values along with a figure between 0 and 1 for the “k” argument, which represents percent.
    e.g =PERCENTILE(range,.3) // 30th percentile.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar