Talk:Documentation/Calc Functions/PERCENTILE.EXC

    From The Document Foundation Wiki

    SF comments

    (1) Summary. Suggest re-word as follows – “Calculates the alpha-percentile of data values in an array of numbers. Percentiles can be used to understand the significance of particular values within a data set. The nth percentile of a data set is the value below which n% of the data set lies. This function uses an alpha argument lying in the range 0 to 1 (exclusive), which corresponds to a percentage in the range 0% to 100% (exclusive). For example, an alpha of 0.5 gives the 50th percentile, also known as the median.”
    (2) Returns. In the light of the proposed improvement to the Summary section, suggest simplifying this statement to read – “Returns a real number which is the scale value for the specified data set and alpha.”.
    (3) Arguments, 1st bullet. Insert “or” before “equal” (two occurrences).
    (4) Arguments, 2nd bullet. Would it be worth adding an example of this in action? Perhaps assume a data set with four values, then alpha values of 0.2, 0.4, 0.6, 0.8 will pick out the values in the data set in ascending order? Also, should “Alpha” be in bold?
    (5) Additional details, 1st paragraph. Maybe re-word slightly as – “alpha = 0.25 gives the first quartile, alpha = 0.5 gives the median, and alpha = 0.75 gives the third quartile.”.
    (6) Additional details, procedure. I am not sure that this is necessary, and do we know for sure that it reflects exactly what our software does? Suggest deletion.
    (7) Additional details, last bullet. Suggest changing “PERCENTILE” to “percentiles”.
    (8) Additional details, note box. This box appears for both PERCENTILE.EXC and PERCENTILE.INC. Should it also mention (and appear on) PERCENTILE’s page?
    (9) Examples, 3rd example. Insert “the” before “range”.
    (10) Examples, general. Suggest including an example for which no interpolation is carried out. Maybe combine this with specifying the data set as an array in {} brackets?

    --Stevefanning (talk) 2020-10-31T13:12:02 (UTC)

    Ronnie

    all points addressed.

    --Ronnie rg8888 (talk) 2020-11-28T05:24:43 (UTC)