Excel functions / Statistics
PROB function
Adds up the probabilities of the outcomes that fall between two limits.
Syntax
=PROB(x_range, prob_range, lower_limit, [upper_limit])
Arguments
x_range: The outcomes: the values that can happen.prob_range: The probability of each outcome. They must add up to 1.lower_limit: The lowest outcome to count.upper_limit(optional): The highest outcome to count. Left out, only lower_limit itself counts.
When to use it
PROB adds up the probabilities of the outcomes that fall between two limits, given a list of outcomes and the chance of each.
Examples
Chance of 1 to 3
A B C D 1 Outcome Chance 2 0 0.2 0.8 3 1 0.3 4 2 0.1 5 3 0.4 In D2:
=PROB(A2:A5, B2:B5, 1, 3)→ 0.8
Common mistakes
- Chances that do not add to 1. The probabilities must add up to 1, or the result is #NUM!.
PROB in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PROB
- Danish: SANDSYNLIGHED
- Dutch: KANS
- Finnish: TODENNÄKÖISYYS
- French: PROBABILITE
- German: WAHRSCHBEREICH
- Hungarian: VALÓSZÍNŰSÉG
- Italian: PROBABILITÀ
- Norwegian: SANNSYNLIG
- Polish: PRAWDPD
- Portuguese (Brazil): PROB
- Portuguese (Portugal): PROB
- Russian: ВЕРОЯТНОСТЬ
- Spanish: PROBABILIDAD
- Swedish: SANNOLIKHET
- Turkish: OLASILIK
Related functions
- SUMIFS: Adds the cells that meet every one of several conditions.
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.