Talk:Documentation/Calc Functions/PROB

    From The Document Foundation Wiki

    SF comments

    (1) Summary. Needs clarification and I suggest the following replacement text – “Given a specified probability for each possible value of a discrete random variable, calculates the probability of a sample value lying between two limits.”.
    (2) Returns. Suggest the following replacement text – “Returns a real number in the range [0, 1] which is the probability that for the specified probability mass function, a sample value will lie within the specified limits.”.
    (3) Arguments, Data. Suggest the following replacement text – “Data is an array or a reference to a range of cells containing the possible values of the discrete random variable.”.
    (4) Arguments, Probability. Suggest adding the following text - “for each value in Data.”.
    (5) Arguments, 1st bullet. I do not think that Calc’s implementation raises an error if a zero probability is found and so “equal to” should be deleted.
    (6) Arguments, 2nd bullet. Change “number” to “numbers”.
    (7) Arguments, general. What happens if one value appears twice in the data array, with different probabilities in each case?
    (8) Arguments, general. What happens if End < Start?
    (9) Additional details. The line of text underneath the formula makes little sense and needs re-writing. Similarly, the line beginning “satisfying…” does not make sense either.
    (10) Examples, general. Suggest two additional examples: (i) =PROB(A1:A6,B1:B6,151) to pick out the probability associated with the value 151 (0.03), and (ii) =PROB(A1:A6,B1:B6,170) to show a probability of zero for a value not contained in the data array.
    (11) Examples, table of example data. Suggest changing header cells to “Data” and “Probability”.
    (12) Examples. I would expect the example formula to return 0.2.

    --Stevefanning (talk) 2020-11-03T16:56:43 (UTC)

    Ronnie

    all points addressed. About point 9, the equation and context is mentioned in ODF section.

    --Ronnie rg8888 (talk) 2020-11-28T09:04:08 (UTC)