PROB

PROB(x_range, prob_range, lower_limit [,upper_limit])

Returns the probability that the values in a data set are greater than a lower limit and less than an upper limit.

x_rangeThe range of numeric values of x with which there are associated probabilities.
prob_rangeThe set of probabilities associated with values in x_range.
lower_limitThe lower bound on the value for which you want a probability.
upper_limit(Optional) The upper bound on the value for which you want a probability.

REMARKS
* If "upper_limit" is not supplied, returns the probability that values in "x_range" are equal to "lower_limit".
* If any value in "prob_range" = 0 or if any value in "prob_range" > 1, then #NUM! is returned.
* If the sum of the values in "prob_range" = 1, then #NUM! is returned.
* If "upper_limit" is left blank, then the probability of being equal to "lower_limit" is returned.
* If "x_range" and "prob_range" contain a different number of data points, then #N/A is returned.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=PROB({0, 1, 2, 3}, {0.2, 0.3, 0.1, 0.4}, 2) = 0.1
2=PROB({0, 1, 2, 3}, {0.2, 0.3, 0.1, 0.4}, 1, 3) = 0.8


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top