QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
The following article introduces you to the QUARTILE.INC function - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the quartile of a dataset, with percentile values from 0 to 1 including 0 and 1. Functions supported from Execl 2010 onwards.
Syntax: QUARTILE.INC (array, quart)
Inside:
- array: An array or range containing values that want to find quartiles, a required parameter .
- quart: The position of the quartile to be returned, is the required parameter including the following values:
+ quart = 0 -> function returns the minimum value.
+ quart = 1 -> function returns the first quartile (25th percentile).
+ quart = 2 -> function returns the median value (50th percentile).
+ quart = 3 -> function returns the 3rd quartile (75th percentile).
+ quart = 4 -> function returns the maximum value.
Attention:
- If quart is not an integer -> it is truncated to an integer.
- If array is empty -> the function returns the #NUM! Error value .
- If quart > 4 or quart <0 -> the function returns the #NUM! Error value
- The MIN and MAX, MEDIAN functions return the same value as the QUARTILE.INC function with corresponding values quart = 0, quart = 4, quart = 2.
For example:
Locate the units as described in the following data table:
- Determine the position of the 1st percentile. In the cell to calculate enter the formula : = QUARTILE.INC (D6: J6, D7)
- Press Enter -> 1st percentile is:
- The fourth percentile. In the cell to calculate enter the formula: = QUARTILE.INC (D6: J6, D8). Press Enter -> return value is:
- In case the value of quart = 0 -> the function still calculates normally.
- Where the quart value = 6> 4 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using QUARTILE.INC function in Excel.
Good luck!
You should read it
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- QUARTILE function - The function returns the quartile of a dataset in Excel
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
- How to Calculate Quartiles in Excel
- LARGE function - The function returns the kth largest value in a dataset in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- KURT function - The function returns the sharp coefficient of a dataset in Excel
- MAXA function - The function returns the largest value in a set of values including text and logical values in Excel
- MODE.MULT function - The function returns a vertical array of the most common values in Excel
- MINA function - The function returns the smallest value in the given numbers including text and logical values in Excel
- SMALL function - The function returns the kth smallest value in a dataset in Excel
Maybe you are interested
The reason Elon Musk plans to move headquarters X, SpaceX to Texas
Intel Lunar Lake processors will be available in the third quarter of 2024
Ethereum tripled in the first quarter of 2024 – what will the second quarter look like?
Nearly a quarter of Windows users are using Windows 11, Microsoft is disappointed
Research shows that a quarter of children's apps on the Google Play Store violate privacy rules
How to Calculate Quartiles in Excel