Excel Function Translator Logo
    The Excel Translator

    QUARTILE.INC

    Statistical

    Returns the quartile of a dataset based on percentile values from 0 to 1 inclusive. Modern replacement for the legacy QUARTILE function.

    Translations
    EnglishQUARTILE.INC
    FrenchQUARTILE.INCLURE
    SpanishCUARTIL.INC
    GermanQUARTILE.INKL
    ItalianQUARTILE.INC
    PortugueseQUARTIL.INC
    DutchKWARTIEL.INC
    PolishKWARTYL.PRZEDZ.ZAMK
    RussianКВАРТИЛЬ.ВКЛ
    TurkishDÖRTTEBİRLİK.DHL
    CzechQUARTIL.INC
    HungarianKVARTILIS.TARTALMAZ
    SwedishKVARTIL.INK
    DanishKVARTIL.MEDTAG
    FinnishNELJÄNNES.MUKAAN.LUKIEN
    Syntax
    QUARTILE.INC(array, quart)

    Arguments

    • arrayThe array or range of numeric data.
    • quart0 = min, 1 = Q1 (25%), 2 = median, 3 = Q3 (75%), 4 = max.
    Examples
    =QUARTILE.INC({1,2,3,4,5}, 1)
    2

    First quartile (25th percentile)

    =QUARTILE.INC({1,2,3,4,5}, 3)
    4

    Third quartile (75th percentile)

    Tips & Best Practices
    • •Available since Excel 2010 — same result as the legacy QUARTILE
    • •Returns #NUM! if quart is not 0, 1, 2, 3, or 4
    • •Use QUARTILE.EXC for the exclusive variant
    Common Mistakes
    • •Passing a quart value outside the valid 0-4 range, which returns a #NUM! error since only those five specific positions (min, Q1, median, Q3, max) are defined
    • •Confusing QUARTILE.INC with PERCENTILE.INC - QUARTILE.INC is really just a convenient shortcut for the five specific percentiles that quartiles represent (0, 0.25, 0.5, 0.75, 1)
    • •Using QUARTILE.INC when QUARTILE.EXC would better match a specific statistical convention - the two can give different results, especially for small datasets
    Related Functions
    QUARTILE.EXCCalculates quartiles using an exclusive method that treats the dataset's endpoints differently, a stricter alternative to QUARTILE.INC.
    PERCENTILE.INCQUARTILE.INC is essentially a convenient shortcut for PERCENTILE.INC at the specific values 0, 0.25, 0.5, 0.75, and 1.
    MEDIANEquivalent to QUARTILE.INC with quart set to 2, a more direct way to get specifically the middle value.
    Frequently Asked Questions

    Why does QUARTILE.INC return a #NUM! error?

    The quart argument must be 0, 1, 2, 3, or 4, corresponding to the minimum, first quartile, median, third quartile, and maximum - any other value isn't defined.

    What's the difference between QUARTILE.INC and QUARTILE.EXC?

    QUARTILE.INC includes the dataset's minimum and maximum as valid quart values (0 and 4) and matches the legacy QUARTILE function. QUARTILE.EXC only supports quart values 1, 2, and 3, using a stricter calculation method that excludes the endpoints.

    Is QUARTILE.INC just a special case of PERCENTILE.INC?

    Yes, essentially - QUARTILE.INC(array,1) gives the same result as PERCENTILE.INC(array,0.25), just with more convenient, memorable argument values.

    Need to translate a formula using QUARTILE.INC?

    Use our translator to convert your complete formula