Skip to content

7. Calculate Probability with Google Sheets Wrap-Up

Playback Speed:

In this lesson, you learned how to use formulas in Google Sheets to calculate the probability of an event.

You: Used the SUM function to calculate the possible combinations of rolling two dice.

Used the COUNTIF function to represent outcomes.

Calculated probability with a formula.

Simulated rolling two dice using the RANDBETWEEN function.

And compared probable outcomes to actual outcomes using percentages.

You also learned that, to calculate probability, you divide the number of possible events by the number of possible outcomes -- a calculation you can make even without a spreadsheet.

Almost every decision we make about the future involves some form of probability.

You might: Guess which baseball team will win the playoffs based on batting averages, Plan whether to take a beach vacation during hurricane season, Or determine the likelihood of an opponent’s next move in a board game.

In each of these situations, you make a decision based on the likelihood that an event will happen.

Probability is a valuable tool to help you make decisions, but it is not a guaranteed outcome.

For example, meteorologists use math to make predictions about the weather for the upcoming week.

However, you’ve probably gotten dressed expecting a 10 percent chance of rain, only to find yourself in the middle of a thunderstorm.

In the lesson, seven was the most likely outcome of rolling the dice, but you never know what will happen in real life.

Still, probability tells us that picking seven would have given you the best chance of winning your lunch privilege.

Enjoy recognizing probability in your own life!