In this article, we will learn about how to use the PERCENTILE function in Excel.
The PERCENTILE is a statistical function. In statistics, when finding a value, below the given kth percentage or percentile. Value of k can be shown in the table below.
|Value of k||Percentage||Percentile|
|0||0 %||Min value|
|0.1||10 %||10th percentile|
|0.2||20 %||20th percentile|
|0.3||30 %||30th percentile|
|0.4||40 %||40th percentile|
|0.5||50 %||50th percentile|
|0.6||60 %||60th percentile|
|0.7||70 %||70th percentile|
|1||100 %||Max Value|
PERCENTILE function takes the range of values as array and value of k. And returns the interpolate value from the array.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.