This function returns the probability that values in a range are between two limits.
PROB(array,probs,lower,upper)
This function has these arguments:
| Argument | Description |
|---|---|
| array | Array of numeric values, which has corresponding probs |
| probs | Probabilities associated with the numeric values in array |
| lower | Lower limit on the numeric value for which you want a probability |
| upper | [Optional] Upper limit on the numeric value for which you want a probability; if omitted, returns the probability of result equal to lower limit |
If the upper argument is not provided, the function uses the value for the lower argument only, and returns the probability that the values are equal to the lower argument.
Accepts numeric data for all arguments. Returns numeric data.
PROB({B1:B6},{E1:E6},10,100)
PROB({B2,B4,B5,B7},{0.4,0.25,0.1,.025),10,100)
PROB({R1C2:R6C2},{R1C5:R6C5},1,50)
PROB({0,1,2,3},{0.2,0.3,0.1,0.4},2) gives the result 0.1