Talk:Documentation/Calc Functions/QUARTILE

    From The Document Foundation Wiki

    SF comments

    (1) Summary. Maybe include something obvious to describe what quartiles are? Perhaps add – “Quartiles describe the division of a data set into four intervals based on the values of the data. The lowest 25% of the values are smaller than the first or lower quartile (equivalent to the 25th percentile). The lowest 50% of the values are smaller than the second quartile and this is also known as the median (equivalent to the 50th percentile). The lowest 75% of the values are smaller than the third or upper quartile (equivalent to the 75th percentile).”.
    (2) Returns. Suggest the following alternative – “Returns a real number which is the requested quartile of the specified data set.”.
    (3) Arguments, bullet. Insert “or” before “equal”.
    (4) Examples, general. The Descriptions in this table appear unnecessarily verbose. For example, the first could simply read “Calculates the maximum value of the data in cells A1:A5.”. Similarly, the second could read “Calculates the third or upper quartile value of the data in cells A1:A5.”. And so on…
    (5) Examples, final example. Did you intend the formula to specify the cell range as A1:A6?
    (6) Related LibreOffice functions. Is there a particular reason why PERCENTILE.INC and PERCENTILE.EXC have been excluded?

    --Stevefanning (talk) 2020-11-03T20:43:38 (UTC)

    Ronnie

    all points addressed. About point 6, there doesn't seem any need for them PERCENTILE will link them.

    Laura comments

    Suggestion: In Additional Details in the pin, add that QUARTILE is also inclusive like QUARTILE.INC?

    --Stevefanning (talk) 2021-10-26T13:01:08 (UTC)

    Updated pin as suggested.