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.
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 1
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:
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 2
- Determine the position of the 1st percentile. In the cell to calculate enter the formula : = QUARTILE.INC (D6: J6, D7)
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 3
- Press Enter -> 1st percentile is:
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 4
- The fourth percentile. In the cell to calculate enter the formula: = QUARTILE.INC (D6: J6, D8). Press Enter -> return value is:
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 5
- In case the value of quart = 0 -> the function still calculates normally.
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 6
- Where the quart value = 6> 4 -> the function returns the #NUM! Error value
QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel Picture 7
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
May be interested
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
RSQ - The function returns the square of the Pearson torque correlation coefficient in Excel
SKEW function - The function returns the deviation of the distribution in Excel
SLOPE function - The function returns the slope of a linear regression line through data points in Excel
SMALL function - The function returns the kth smallest value in a dataset in Excel
STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel