Calculate 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

`=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.

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.

The QUARTILE.EXC function is a statistical function in Sourcetable that returns the quartile of a data set.

The QUARTILE.EXC function returns the quartile of the data set, which is the value that divides the data set into four equal parts. It is useful for finding the median, lower quartile, and upper quartile.

The QUARTILE.EXC function takes an array of numbers as input.

The QUARTILE.EXC function produces a number as output, which is the quartile of the data set.

If the array argument is empty, the QUARTILE.EXC function produces a #NUM! error.

Drop CSV