6. Compare Probability Calculations to Actual Dice Rolls

attachment

Students can submit work

Playback Speed:

Transcript

In the previous video, you simulated rolling dice by using a spreadsheet function.

In this video, you will calculate the actual percentage of the time each possible outcome was rolled.

Then, you will compare the actual percentages to the probability percentages you calculated earlier.

To start, find the actual percentage of each outcome in your simulation by using the samedivision formula you used to calculate probability.

You simulated rolling the dice eleven times.

And calculated the number of times each number was rolled in column R.

So, in this example, the formula in column S is R3 divided by eleven.

Copy the formula to the rest of the column.

Then, convert the decimals to percentages rounded to the tenths place.

Nice work!

To make it easier to compare your actual results with the probability you calculated earlier,hide the columns you don’t need to see right now.

You can unhide the columns at any time.

In your calculations, you found that you had a 2.8 percent chance of rolling an outcomeof two.

Compare that to the percentage in your simulation.

Compare other outcomes as well.

You may find that your simulated outcomes differ significantly from the probable outcomes.

Remember that probability only tells you how likely it is that something may happen.

It’s not a perfect prediction.

Once again, recall the number you picked at the beginning of the lesson and find the percentageof its occurrence in your simulation.

And highlight that in your spreadsheet.

If your teacher rolled the dice eleven times, and everyone who chose the actual numbersrolled got the longer lunch period, would you have won the privilege?

Finally, look at the most probable outcome.

Was it a winner after all?

Great job calculating probability!

Move on to the next video to wrap up the lesson.

Now, it’s your turn: Calculate the Actual Percentage Rolled,Hide unnecessary columns, And compare the actual to the probable outcomes.

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

URL not accepted. Please paste a link to a Scratch project.URL not accepted. Please paste a link from google.com (such as a Google Doc).You don't appear to be signed in. Please refresh the page and try again.Something went wrong. Please refresh the page and try again.