Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

1. Introduction to Calculate Probability with Google Sheets

Playback Speed:

There are many methods you can use to make a decision about the future, such as making a pros and cons list or having a discussion with a friend.

You can also calculate the probability of a certain outcome.

Probability tells you the likelihood that an event will happen.

For example, you could use weather data that forecasts a 65 percent chance of rain to decide whether to bring an umbrella to school.

Or, you could calculate the probability that your favorite band's new song will be a hit based on how their songs ranked in the past.

Calculating the probability doesn't guarantee a specific outcome, but it helps you determine if a particular outcome is likely.

In this lesson, you will calculate the probability of an event using formulas and a spreadsheet.

You will imagine that you and your classmates have the opportunity to earn an extra thirty minutes for your lunch period.

Each student will choose a number, and then your teacher will roll two, six-sided dice.

Those who choose the sum that’s rolled will get the privilege.

You could choose a number at random, but some numbers have a higher probability of being rolled.

To give yourself a better chance of receiving the longer lunch period, you can use probability to choose the most likely number.

As you complete this project, you will: Use spreadsheet formulas and functions, Change number formats, Round large numbers, And copy formulas into multiple cells.

This lesson uses Google Sheets, but you could use these skills in any spreadsheet application.

A spreadsheet is a useful way to organize data.

Plus, anything you create in Google Sheets is automatically saved to your Google account, so you can access it anywhere from any device connected to the internet.

To complete this lesson, you must be signed in to your Google account.

Open a new tab in your browser, and sign in now.

If you don’t have a Google account, pause the video and create one now.

To begin, open the starter project linked on this page.

Make a copy, and give it a title.

With this spreadsheet, you will: Determine the possible combinations of dice rolls, Calculate the probability that each combination is rolled, Simulate rolling two dice, Calculate how often each number was rolled, And compare the outcome to your prediction.

Spreadsheets are made up of many rows and columns.

And each block in the spreadsheet is called a cell.

As you complete this project, you will select various rows and columns, and you will type into the cells.

Choose a number between 2 and 12, including those numbers, to earn your chance at a longer lunch.

Type it in the cell beside My Pick.

You will use this number later in the lesson.

Then, move on to the next video to start building your project!

Now, it’s your turn: Open the starter project, and make a copy.

Add a title.

Choose a number between 2 and 12, and add it to the sheet.

Then, move on to the next video where you will build your project spreadsheet.


  1. Open the starter project, and make a copy.
  2. Add a title
  3. Choose a number between 2 and 12, and add it to the sheet.
  4. Move on to the next video.