Talk:Documentation/Calc Functions/LOGNORM.DIST

    From The Document Foundation Wiki

    SF Comments

    (1) Returns. Suggest the following alternative – “Returns a non-negative real number representing the requested value for the log-normal distribution with the specified mean and standard deviation”.
    (2) Arguments, Number. Delete “probability” and change “standard logarithmic” to “log-normal”.
    (3) Arguments, Mean. Change “standard logarithmic” to “log-normal”.
    (4) Arguments, StDev. Change “standard logarithmic” to “log-normal”.
    (5) Arguments, 1st bullet. Suggest change to “If Number is negative or zero then the function returns a zero value for the cumulative distribution function. However, it returns an error for the probability distribution function for these values.”.
    (6) Additional details. Probably clearer if we change “If Cumulative is FALSE()” to “For the probability mass function”, and “otherwise If Cumulative is TRUE()” to “For the cumulative distribution function”.
    (7) Examples, 1st example. Formula gives an Err:511 because the Cumulative argument is required. Also insert “the” before “log-normal”.
    (8) Examples, examples 2-4. Insert “the” before “log-normal” (three occurrences).
    (9) Examples, 5th example. Insert “the” before “probability”.
    (10) Examples, examples 6 & 7. Insert “the” before “cumulative”.
    (11) Examples, 7th example. Formula gives an Err:511 because the Cumulative argument is required. You will need to remove the text “(default)”.

    --Stevefanning (talk) 2020-10-25T21:14:27 (UTC)

    Ronnie

    All points addressed. --Ronnie rg8888 (talk) 2020-11-21T15:26:25 (UTC)