Talk:Documentation/Calc Functions/PROB
Appearance
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)