PROB 
PROB(x_range, prob_range, lower_limit [,upper_limit]) 
Returns the probability that values in a range are between two limits. 
x_range  The range of numeric values of x with which there are associated probabilities. 
prob_range  The set of probabilities associated with values in x_range. 
lower_limit  The 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 

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