QUARTILE.EXC
Formulas / QUARTILE.EXCCalculate the quartile for a set of data.
QUARTILE.EXC(array,quart)
- array - required range of numerical values to get the quartile value from
- quart - required argument to specify which quartile to calculate
Examples
=QUARTILE.EXC(A2, 2)To calculate the second quartile value for a range of data in cell A2, use the preceding formula. This will return the value at the 50th percentile of the data range.
=QUARTILE.EXC(A2, 1)To calculate the first quartile value for a range of data in cell A2, use the preceding formula. This will return the value at the 25th percentile of the data range.
=QUARTILE.EXC(A2, 3)To calculate the third quartile value for a range of data in cell A2, use the formula above. This will return the value at the 75th percentile of the data range.
The function is used to calculate the quartiles of a set of data. Quartiles divide the data into four equal parts. The first quartile is the value that is at the 25th percentile, the second quartile is at the 50th percentile, and the third quartile is at the 75th percentile.
Summary
The QUARTILE.EXC function is used to calculate the quartile of a given data set. It requires an array and a quart argument, and determines the quartile based on percentile values.
- The QUARTILE.EXC function takes two arguments, the first being the quartile value and the second being the percentile value.
- The arguments for the QUARTILE.EXC function are the array containing numeric data to analyze and quart.
- The quartile argument indicates which quartile value to return and accepts 3 values.
Frequently Asked Questions
What is the QUARTILE.EXC function?
What does the QUARTILE.EXC function do?
What type of data does the QUARTILE.EXC function take as input?
What type of output does the QUARTILE.EXC function produce?
What happens if the array argument is empty?
