Probability is a measure of the likelihood of an event to occur. Many events cannot be predicted with total certainty. We can only predict the chance of an event to occur.
Formula to calculate probability in excel.
Here we will use the PROB Function, that requires the lower limit, upper limit and the probability range in the argument section.
Example:
Calculate the probability of the students scores in a certain test below if the lower limit is 50 and the upper limit is 90.
| Name of the student | Score | Probability of getting each score. |
| Joy | 60 | 0.09 |
| Brian | 30 | 0.2 |
| Esther | 80 | 0.3 |
| Alice | 90 | 0.4 |
| Ken | 94 | 0.01 |
We will begin by transferring the data onto an excel worksheet.
Then use the PROB Function, fill the argument section, press enter to find the probability.
Therefore, the probability is 0.79.
