QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel

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

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!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

AVERAGEA function - The function returns the average of the arguments including numeric, text, and logical values in Excel
averagea function: the function returns the average of the arguments including numeric, text, and logical values. syntax: averagea (value1, [value2], ...)
SMALL function - The function returns the kth smallest value in a dataset in Excel
small function: the function returns the kth smallest value in a dataset. syntax: small (array, k)
RANK.EQ function - Function returns the rank of a number in a list of numbers, returns the highest rank when multiple values with the same rank in Excel
rank.eq function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the highest rank. support functions from execl 2010 version onwards.
MAX function - The function returns the largest value in a set of values in Excel
max function: the function returns the largest value in the set of values. syntax: max (number1, [number2], ...)
STDEV.P function - The function returns the standard deviation based on the whole in Excel
stdev.p: the function returns the standard deviation based on the whole population, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.p (number1, [number2] ,.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
frequency function: function that calculates and returns the frequency of occurrences of values within a certain range and returns a vertical number array. syntax: frequency (data_array, bins_array)
STDEV.S function - The function returns the standard deviation based on a sample in Excel
stdev.s function: the function returns the standard deviation based on a sample, ignoring logical values and text. standard deviation is a measure of the dispersion of values against the mean. support functions from excel 2010 onwards. syntax: stdev.s (number1, [number2], ...)
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])