Description Given a set of numbers and a probability associated with each number, computes the probability corresponding to a specified number. Also computes all the probabilities corresponding to a specified range of numbers.
Syntax PROB (arrayX, probabilities, test [, upper])
| Argument | Description |
|---|---|
| arrayX | A range reference or array constant containing numeric values. There must be the same number of values in probabilities as in arrayX.The function will return the error value #NUM! if arrayX contains non-numeric data (text, logical values, or blank cells). |
| probabilities | A range reference or array constant containing the probabilities associated with the numbers in arrayX. Each probability must be a number between 0 and 1. All values in probabilities must add up to 1. There must be the same number of values in probabilities as in arrayX. The function will return the error value #NUM! if probabilities contains non-numeric data (text, logical values, or blank cells). |
| test | The value from arrayX whose probability you want to find. If test is not found in arrayX and no value is entered for upper, the function returns 0. |
| [upper] | Optional. Specifies the upper limit of a range of numbers from arrayX whose cumulative probabilities you want to know. Test is the lower limit, upper the upper limit, inclusive. PROB will return the sum of all values in probabilities that correspond to the numbers in arrayX that fall between or include test and upper. |
Remarks When arrayX and probabilities are range references, the function pairs up the numbers by moving left-to-right through each sequential row.
Examples This function returns 0.05:
This function returns 0.3:
This function returns 0.1:
