PROB function - The function returns the probability that values in a range are between two limits in Excel

BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
F.INV function - The function returns the inverse of the probability distribution F in Excel

The following article introduces you to the PROB function - one of the functions in the statistical function group is very popular in Excel.

PROB function - The function returns the probability that values in a range are between two limits in Excel Picture 1

Description: The function returns the probability that values in a range are between two limits.

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

Inside:

- x_range: the range of numerical values of x with probability associated with it, which is a required parameter .

- prob_range: A set of probabilities associated with the values in x_range, is a required parameter.

- lower_limit: The lower bound of the value you want to calculate probability.

- upper_limit: Close on the option of the value you want to calculate probability.

Attention:

- If any value in Prob_name is not equal to 1 or has a value greater than 1 or less than or equal to 0 -> the function returns the #NUM! Error value !

- If upper_limit parameter is omitted -> function returns with probability lower_limit

- If x_range and prob_range have different data points -> the function returns the # N / A error value

For example:

Calculate Prob probability with the data described in the table below:

PROB function - The function returns the probability that values in a range are between two limits in Excel Picture 2

- In the cell to calculate the probability of entering the formula : = PROB ($ B $ 6: $ B $ 9, $ C $ 6: $ C $ 9, D6) (Here use the absolute address)

PROB function - The function returns the probability that values in a range are between two limits in Excel Picture 3

- Press Enter -> copy the formula for the remaining values:

PROB function - The function returns the probability that values in a range are between two limits in Excel Picture 4

- Case 1 of the values in prob_range is greater than 1 or less than 0 => The function returns the #NUM! Error value

PROB function - The function returns the probability that values in a range are between two limits in Excel Picture 5

Above are instructions and some specific examples when using the Prob function - the function returns the probability of values in a range between two limits in Excel.

Good luck!

Jessica Tanner

Update 19 May 2020

You should read it

May be interested

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
the following article introduces the chidist function - the function returns the right end probability of a distribution when the distribution helps you have a basis to determine the correctness of the expected with the original hypothesis.
F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
GUSSE function - The function returns the probability that an element of the population is normalized in Excel
gusse function: the function returns the probability that an element of the normalized population will fall into the mean and the standard deviation. support functions from excel 2013 onwards. syntax: gauss (z)
PERCENTILE.INC function - Function returns the kth percentile of values in the range with k in the range from 0 to 1 in Excel
percentile.inc function: the function returns the kth percentile of values in the range with k in the range from 0 to 1. syntax: percentile.inc (array, k)
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
quartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
MODE.SNGL function - Function that returns the most frequently occurring, or the most repeated values in an array or data range in Excel
mode.sngl function: the function returns the most frequently occurring, or the most repeated value in an array or range of data. support functions from excel 2010 onwards. syntax: mode.sngl (number1, [number2], ...)
CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
chisq.inv.rt function: the function returns the inverse of the right end probability of the distribution when squared. support function from excel 2010 version. syntax: chisq.inv.rt (probability, deg_freedom)
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
f.dist.rt function: the function returns the right probability distribution f for 2 data sets. support functions from the excel 2010 version. syntax: f.dist (x, deg_freedom1, deg_freedom2)
CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
chisq.inv function: the function returns the inverse of the probability of the left end of the distribution when squared. support functions from the excel 2010 version. syntax: chisq.inv (probability, deg_freedom)
BINOM.DIST function - Function returns the probability of binomial distribution of individual terms in Excel
binom.dist function: the function returns the binomial distribution probability of an individual term. support functions from the excel 2010 version. syntax: binom.dist (number_s, trials, probability_s, cumulative)