Skip to content

Illustrate Probability with Conditional Formatting

Playback Speed:
Transcript

In this extension, you will make your probability data easier to understand by using conditional formatting.

Conditional formatting changes the background color of cells in a spreadsheet that contains certain words or numbers.

This helps your viewer see the most important parts of your data without having to read through the entire sheet.

You can apply conditional formatting to your Probability column to make it easy to see which outcomes are most likely and which are least likely.

To start, open your probability spreadsheet.

Select all of the results in the Probability column.

Then, use the toolbar to open the conditional formatting menu.

The data in the Probability column shows the likelihood of rolling each possible outcome.

To visualize this data, create a color scale that assigns each number a particular shade of color.

Change the minpoint -- or lowest value -- dropdown from min value to number.

The lowest number in your column is two point eight percent.

This appears as a decimal.

Next, update the other dropdowns to numbers as well.

Your middle and highest numbers will appear in the menu next to the midpoint and maxpoint.

Choose a color to represent the least likely outcome.

Then, choose another color to represent the most likely outcome.

The midpoint color automatically blends the minpoint color and the maxpoint color.

Now, when you look at your table, it’s easy to see which outcomes are the most likely...

And which are the least likely.

Great work!

Now, it’s your turn: Apply conditional formatting to your probability calculations Select a color scale, Choose colors for the minpoint and maxpoint, And look at your data to see which outcomes are most likely and which are least likely.

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.