Modal madness

In this exercise you'll work with a medical dataset to practice calculating modes. Remember that a mode is the most frequent value that occurs in a sample. If every value is unique, then there is no mode, and if there is a tie, then the sample can have 2+ modes.

Let's see how the mode compares to the median and mean here!

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • In cells F2 and G2, calculate the mean number of lab procedures and mean number of lab medications.
  • In cells F3 and G3, calculate the median number of lab procedures and median number of lab medications.
  • In cells F4 and F4, calculate the modes of the two columns.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise