Talk:Documentation/Calc Functions/MODE.MULT

    From The Document Foundation Wiki

    SF comments

    (1) Summary. For consistency with the page for MODE(), suggest the following replacement text – “Finds the most common values in a data set. An error occurs when no value appears more than once. It is an array function, and the most common values are returned in a vertical array.”.
    (2) Syntax. Please update to match the syntax defined in the Help.
    (3) Returns. For consistency with the page for MODE(), suggest the following replacement text – “Returns a vertical array of real numbers which are the most common values in the list of arguments”. Probably also worth adding “The function will return more than one value when there are multiple modes sharing the same frequency of occurrence.”
    (4) Arguments, general. Please refer to relevant comments raised on same text for the MODE() function.
    (5) Additional details. Suggest a short description is provided stating that the number of values returned are dependent on (a) how many different values are considered to be the most common, and (b) how big the defined array is. Should also mention what the #N/A means when is appears in the output array area.
    (6) Examples. The example given is rather too like that on the corresponding Microsoft page for my liking; can we change the test data so that it is obviously different. Also, perhaps it would be worth laying out the test data in a two-dimensional array, to save space. Also, I would suggest that we do not need to show multiple output #N/A fields, the first one will do.

    --Stevefanning (talk) 2020-10-27T19:33:05 (UTC)

    Ronnie

    all points addressed.

    --Ronnie rg8888 (talk) 2020-11-27T13:49:48 (UTC)