7. Calculate Probability with Google Sheets Wrap-Up

Playback Speed:

Transcript

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

You: Used the SUM function to calculate the possiblecombinations 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 eventsby the number of possible outcomes -- a calculation you can make even withouta spreadsheet.

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

You might: Guess which baseball team will win the playoffsbased on batting averages, Plan whether to take a beach vacation duringhurricane season, Or determine the likelihood of an opponent’snext move in a board game.

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

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

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

However, you’ve probably gotten dressed expecting a 10 percent chance of rain, onlyto 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 whatwill happen in real life.

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

Enjoy recognizing probability in your own life!

1. Introduction to Calculate Probability with Google Sheets

2. Find Possible Outcomes with a Formula

3. Count Ways to Roll Dice with a Function

4. Calculate Probability with a Formula

5. Simulate Rolling Dice and Count the Numbers Rolled

6. Compare Probability Calculations to Actual Dice Rolls

7. Calculate Probability with Google Sheets Wrap-Up

8. Reflection

9. Extensions: Calculate Probability with Google Sheets