Applied Digital Skills lessons are moving to a new platform! This website will no longer be available after 30 June 2025. Learn more

Calculate Probability with Google Sheets

Calculate probability using formulas and functions in a spreadsheet.

Example outcome

Lesson details

Learning objectives

By the end of this lesson, students should be able to:
  • Calculate the probability of rolling different numbers when using two dice
  • Compare the probability of an actual (simulated) dice roll

Time to complete

45—90 minutes

Audience

  • Key Stage 3
  • Key Stage 4
  • Post-16

Digital tools

  • Icon representing the Sheets toolSheets

Skills

  • Advanced formulas
namespaces/google.engedu.apski/contents/Unit-61590423953153596387311938995205352661en-uk