How to use the QUARTILE.INC function
What is the QUARTILE.INC function?
The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0..1, inclusive. Use the Quartiles.inc function to divide numerical values into groups.
This function has replaced the old QUARTILE function
What is QUARTILE.INC an abbreviation from?
QUARTILE.EXC is an abbreviation of QUARTILE INCLUSIVE.
What is a quartile?
A quartile is a type of quantile which splits a dataset into four equal parts. The quartiles divide a rank-ordered dataset into four quarters.
There are three quartile values - Q1, Q2, and Q3:
Q1 (first quartile) - 25th percentile
Q2 (second quartile) - 50th percentile (median)
Q3 (third quartile) - 75th percentile
What is the interquartile range (IQR)?
The interquartile range (IQR) is the difference between Q3 and Q1. It indicates the middle 50% spread of the data.
When is it useful to calculate the quartiles?
Quartiles provide quantile-based partitioning of data that reveals distribution, spread, skewness, and outliers. They serve as an important basic statistical summary.
Symmetrical distribution: Q2- Q1 =Q3- Q2
Positively skewed: Q2- Q1 < Q3- Q2
Negatively skewed: Q2- Q1 > Q3- Q2
Learn more about skewness: SKEW function
What is quantile?
Quantiles are a statistical technique for dividing a dataset into equal-sized groups for analysis. Quantiles split data into equal-sized subsets when ordered from smallest to largest.
The quartiles, percentiles, quintiles, deciles, etc. are examples of quantiles.
- Quartiles split data into 4 equal groups
- Percentiles into 100 groups,
- Quintiles into 5.
Quantiles can show aspects of shape, spread, and concentration.
How to graph quartiles?
The Box and Whisker chart display quartiles.
QUARTILE.INC function Syntax
QUARTILE.INC(array, quart)
QUARTILE.INC function Arguments
array | Required.The cell values for which you want to calculate the quartile value. |
quart | Required. Indicates which value to return. |
Quart parameters | |
---|---|
0 | Minimum value. |
1 | First quartile (25th percentile). |
2 | Median quartile (50th percentile). |
3 | Third quartile (75th percentile). |
4 | Maximum value. |
QUARTILE.INC function example
Formula in cell E3:
The QUARTILE.INC function returns
- the same value as the MIN function if quart is 0.
- the same value as the MEDIAN function if quart is 2.
- the same value as the MAX function if quart is 4.
QUARTILE.INC function not working
QUARTILE.INC returns #NUM! error value
- Â if array is empty.
- If quart < 0 or if quart > 5
How is the QUARTILE.EXC function calculated?
QUARTILE.EXC calculates quartiles using the inclusive method:
Data is sorted lowest to highest. The quartile boundaries include the quartile values themselves.
For example, for the data {1, 2, 3, 4, 5}:
Q0 = 1
Q1 = 2
Q2 = 3
Q3 = 4
The median of data {1, 2, 3, 4, 5} is 3. The first half contains 1 , 2, and 3. The median of 1,2, and 3 is 2 = Q1
Q2 is the median: 3
The second half contains 3, 4 and 5, The median of 3, 4 and 5 is 4 = Q3
Functions in 'Statistical' category
The QUARTILE.INC function function is one of many functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form