Returns the probability that values in a range are between two limits.
PROB(Data; Probability; Start; End)
Data is the array or range of data in the sample.
Probability is the array or range of the corresponding probabilities.
Start is the start value of the interval whose probabilities are to be summed.
End (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the Start value is calculated.
If there is no End value, this function calculates the probability based on the principle that the Data values are equal to the value of Start.
=PROB(A1:A50;B1:B50;50;60) returns the probability with which a value within the range of A1:A50 is also within the limits between 50 and 60. Every value within the range of A1:A50 has a probability within the range of B1:B50.