Home › Functions › Statistical › =PERCENTILE.INC()
Statistical Excel 2010 ◉ 35 views

=PERCENTILE.INC()

PERCENTILE.INC returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. You can use this function to establish a threshold of acceptance.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=PERCENTILE.INC(array,k)
Hover argument names in the table for details.
Output typeNumber
Popularity40 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =PERCENTILE.INC() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
Download PERCENTILE.INC.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
array Array Required The array or range of data that defines relative standing.
k Number Required The percentile value in the range 0 to 1, inclusive.

▣ Examples

▦ Data
CellValue
A2 1
A3 3
A4 2
A5 4
A6 1
A7 3
A8 2
A9 4
30th percentile of the list in the range A2:A5. =PERCENTILE.INC(A2:A5,0.3)
Result: 1.9

§ Remarks

  • If array is empty, PERCENTILE.INC returns the #NUM! error value.
  • If k is nonnumeric, PERCENTILE.INC returns the #VALUE! error value.
  • If k is < 0 or if k > 1, PERCENTILE.INC returns the #NUM! error value.
  • If k is not a multiple of 1/(n - 1), PERCENTILE.INC interpolates to determine the value at the k-th percentile.

✦ Tips

  • If k is not a multiple of 1/(n - 1), PERCENTILE.INC interpolates to determine the value at the k-th percentile.

⚠ Common Errors

#NUM! If array is empty, PERCENTILE.INC returns the #NUM! error value. If k is < 0 or if k > 1, PERCENTILE.INC returns the #NUM! error value.
Fix: Enter k as a number between 0 and 1
#VALUE! If k is nonnumeric, PERCENTILE.INC returns the #VALUE! error value.
Fix: برای k یک مقدار عددی وارد کنید.

⇄ Related Functions

=LARGE() Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. =MEDIAN() Returns the median of the given numbers. The median is the number in the middle of a set of numbers. =PERCENTILE() Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile. If k is non-numeric, PERCENTILE returns the #VALUE! error value. This function has been replaced with one or more new functions that may provide improved accuracy. Although this function is still available for backward compatibility, this function may not be available in future versions of Excel. =PERCENTILE.EXC() The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. =PERCENTRANK.INC() Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. =QUARTILE.INC() QUARTLE.INC returns the quartile of a data set, based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.