Excel Functions


PROBReturns the probability that the values in a data set are greater than a lower limit and less than an upper limit.
PROB
Returns the probability that the values in a data set are greater than a lower limit and less than an upper limit.

Distribution Functions

To find probabilities when you just have the raw data or known patterns, you can use the Probability Distribution Functions.


BINOM.DIST is the Binomial Probability function.
You use it to find the probability of a "yes/no" outcome (like the probability of getting exactly 7 heads out of 10 coin flips).


NORM.DIST is the Normal Probability function.
You use it to find the probability of continuous data (like the probability that a package will weigh between 5kg and 10kg).


POISSON.DIST is the Poisson Probability function.
You use it to find the probability of a count over time (like the probability of receiving more than 20 customer service calls in an hour).



© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext