Skip to content
Playback Speed:
Transcript

In the main lesson, you learned that probability tells you the likelihood that an event will happen.

You simulated rolling the dice eleven times.

In this extension, you will see how the probability changes when you work with a larger sample size, such as 500 rolls.

You will learn the law of large numbers and use Google Sheets to test it out.

The law of large numbers says that the more times you perform the same experiment, the closer the actual results get to the predicted results.

Think about the main lesson.

The law of large numbers implies that the more times you roll the dice, the closer the actual results will come to the probability, or predicted results.

To start, open your probability spreadsheet and make a copy.

Update the title.

Your sheet shows the results for 11 rolls.

Compare the Probability column with the Actual Percentage rolled column.

Notice the differences between the predicted outcomes and the actual outcomes.

Now, see what happens when you roll the dice 500 times.

Hold down shift and select the bottom row of cells in the dice simulation columns.

Then, drag the cell handle to copy the RANDBETWEEN formulas to at least 500 more rows.

Scroll back up to the top of your sheet.

Copy the new values in the roll simulation columns.

And paste only the values in the number rolled columns.

Next, add the orange and purple dice together for the new rolls.

Copy the sum formula to at least row 502.

Now that you have simulated rolling each die 500 times and added the dice together, count how many times each outcome appeared.

First, change the title of the Number of Times column to indicate the new number of rolls.

Then, use the COUNTIF formula to calculate how many times each outcome appeared in the 500 rolls.

Update the range of the COUNTIF formula to include the new dice rolls.

The first two rows are headings, so the last row in the range is 502.

Copy the formula to the rest of the column.

Finally, change the percentage formula, since you rolled the dice 500 times instead of 11.

Change the number of rolls in the formula in the Actual Percentage Rolled column from 11 to 500.

Copy the formula to the rest of the column.

Compare the actual outcomes with the probable outcomes.

To make it easier to compare your results, hide the columns you don’t need.

After 500 rolls, the percentages of each actual outcome are closer to the probability you calculated than they were after 11 rolls.

You just demonstrated the Law of Large Numbers using Google Sheets!

Now, it’s your turn: Make a new copy of your spreadsheet.

Add 500 more dice rolls in the simulation columns, Copy and paste the new values to freeze the data, Copy the SUM formula to add the new dice rolls.

Update the range in the COUNTIF formula and the total number of dice rolls in the Actual Percentage formula.

And compare the actual outcomes to the probable outcomes.

Choose an Extension
Illustrate Probability with Conditional Formatting
In this extension lesson, students illustrate probability data using conditional formatting in Google Sheets.
Create an Event Based on the Weather Forecast
Students use Google Search to find the weather forecast and then they create an event in Google Calendar.
Make a Table to Visualize Probability
Students visualize and solve a probability problem using a table in Google Sheets.
Learn the Law of Large Numbers
Students learn the law of large numbers and demonstrate the law using Google Sheets.
Format Titles and Tables with Google Sheets
Students learn how to enhance a spreadsheet by formatting titles and tables in Google Sheets.
Create a Batting Order Using Probability
Students create a batting order by analyzing and sorting probability data in Google Sheets.
See more extensions
Next Lessons Dashboard
Instructions
Choose an extension from the list to continue learning ways to use Google Sheets to perform calculations.
Shared work attachment
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.

This project will be shared with your teachers

Students can submit their work on this page. View their submitted work on the student progress page of My Classes.

Students can submit their work on this page.

Students: sign in to submit your work.
Teachers: sign in to view submitted work.