I. Intro
The PERCENTILE function returns the value at the specified percentile of the data set.
II. About the function
- Formula: =PERCENTILE(data, percentile)
- Parameters:
- data (required): The array or range you want to evaluate.
- percentile (required): A percentile value between 0 and 1, including 0 and 1.
- Example: =PERCENTILE(A2:A100,0.95)
- Note:
- If percentile is not a number, then it returns the error value #VALUE!.
- If percentile < 0 or percentile > 1, then it returns the error value #NUM!.
- If percentile is not a multiple of 1/(n-1), then PERCENTILE will use interpolation to determine the value.
III. Steps
Use the PERCENTILE function
- Select a cell and click Formulas on the toolbar, then select Statistical > PERCENTILE. You can also directly enter =PERCENTILE in a cell.
- Enter the parameters in the cell. For example: =PERCENTILE(A3:A9,0.28).
- Press Enter to display the result, which is 41.04 in this example.
250px|700px|reset
Delete the PERCENTILE function
Select the cell with the PERCENTILE function, and press Delete.