Excel is the most popular spreadsheet system in the world.
Excel is especially popular with corporate workers.
One of the tools you should look into is the ability to calculate the probability of an event.
Vladimir Sereda / Tab-Tv
What formulas can you use to calculate probability in Excel?
If specifically interested in the PROB formula, scroll to the next heading.
Lets first understand how probability works in general.
Probability is how much chance there is of this or that event happening.
it’s possible for you to use a more straightforward method if you have a table with two columns.
As you could see, this is pretty simple.
The probability of such a number falling out would be about 25%.
The PROB function helps you to calculate the probability of having between 10 and 20 people attend.
It is helpful in quite a few situations.
An example of probability functions in Excel
Lets look at a simple example with two cubes.
Ill show you how to calculate theprobability that you will roll one specific number from 2 to 12.
For example, we have only one chance of getting two or only two chances of getting three.
You do this with the simple formula.=COUNTIF([Table_Range], [digit you want]).
We can use thePROB functionto determine which number has a better chance than 5. it’s possible for you to use this method to calculate probabilities from any table you need.
Try experimenting with this or other simple examples to see exactly how it works.
