The `QUARTILE.INC` function in Excel is used to return the quartile of a given data set, which is a measure of the spread of values. This function includes the minimum and maximum values in its calculations (thus “inclusive”), which is why it’s denoted as `.INC`.
Here’s how to use the `QUARTILE.INC` function:
Syntax:
QUARTILE.INC(array, quart)
- array: This is the range of cells or the array of numeric data for which you want to find the quartile.
- quart: This specifies which quartile you want to return. The quartile is an integer value between 0 and 4:
- `0` for the minimum value (0th quartile)
- `1` for the first quartile (25th percentile)
- `2` for the median (50th percentile or second quartile)
- `3` for the third quartile (75th percentile)
- `4` for the maximum value (100th percentile or fourth quartile)
Example:
Suppose you have a dataset in cells A1 to A10 and want to find the first quartile.
=QUARTILE.INC(A1:A10, 1)
- Click on the cell where you want the result to appear.
- Enter the formula:
- Press `Enter`.
This will return the first quartile of your dataset within the range A1:A10.
Important Notes:
- Make sure that the `array` you specify contains numeric data only; otherwise, you might encounter errors.
- The `quart` value should strictly be an integer between 0 and 4. Using a value outside this range will result in an error.
- Since Excel 2010, `QUARTILE.INC` has been the preferred function over the earlier `QUARTILE` function for inclusivity in calculations.
By understanding how to use `QUARTILE.INC`, you can efficiently divide your data into quartiles, making it easier to analyze data distributions in your spreadsheets.
Unlock Your Potential
Excel
Access
Power BI
