Talk:Documentation/Calc Functions/MEDIAN

    From The Document Foundation Wiki

    SF comments

    (1) Summary. The second sentence needs to be clarified. The median will be either the number in the middle of the set or the average of the two numbers in the middle of the set (as appropriate) ONLY after the function has sorted the values into numerical order.
    (2) Returns. Suggest delete “(middle)” and “Number 1, Number 2, …, Number 255.
    (3) Arguments, 1st bullet. This statement is a bit complex and I do not understand it fully. I am happy that if you write =MEDIAN(“fred”) then you get an error 504. What is the other condition that you are trying to capture? I tried =MEDIAN(2,A21) when A21 held a text string and no error was generated (the result was 2, which presumably means that A21 was simply ignored).
    (4) Arguments, 2nd bullet. Should the text “name/array/reference to a” be deleted? Also, please check how logical values are handled; I think they might be given the value 0 or 1 as appropriate.
    (5) Arguments, 3rd bullet. Suggest change to “If a cell contains 0 then the function includes it.”
    (6) Examples, general. Suggest including example(s) where the numbers are not ordered. We do not want to give the impression that the user must order the values before presenting them to the function.
    (7) Examples, 2nd example. Suggest delete “mean/”.

    --Stevefanning (talk) 2020-10-26T20:47:03 (UTC)

    Ronnie

    All points addressed.

    --Ronnie rg8888 (talk) 2020-11-27T12:18:16 (UTC)