Excel Function : QUARTILE.EXC

Download now!

Excel Function : QUARTILE.EXC

Category

Statistical

Description

Returns the quartile of the data set, based on percentile values from 0..1, exclusive

Microsoft Excel Reference Page

https://support.office.com/en-us/article/QUARTILEEXC-function-5a355b7a-840b-4a01-b0f1-f538c2864cad

Syntax and Description of the QUARTILE.EXC Excel Function

The QUARTILE.EXC function in Excel returns the quartile of a data set, based on a percentile value that you specify. The quartiles of a data set are the values that divide the data set into four equal parts. The QUARTILE.EXC function takes two arguments: array - The array or range of data that you want to quartile. quart - The quartile value that you want to return. This value must be between 0 and 1. For example, the following formula returns the first quartile of the data in cells A1-A5: =QUARTILE.EXC(A1:A5,0.25)

About QUARTILE.EXC Excel Function

=QUARTILE.EXC(array,k) Returns the k-th quartile of values in a data set. k is an integer between 1 and 4 that specifies the quartile to return. Quartiles divide a data set into four equal parts.