Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 5/7

MEDIAN and MODE

Exercise 1 of 3

In F2, find the median: the middle score when they are sorted.

About this lesson

MEDIAN finds the middle value and MODE the most common one: two more ways to describe a typical value.

In this lesson

  1. In F2, find the median: the middle score when they are sorted.
  2. In F2, find the score that appears most often.
  3. Why is the median sometimes more useful than the average?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in F2 and press Enter to check.