MEDIAN practice

MEDIAN returns the middle value of a set of numbers. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

MEDIAN(number1, [number2], ...)

What people get wrong

For house prices and salaries the median is the typical value; a few very large numbers move the average but not the median.

Excel exercise that use MEDIAN

• Typical house priceLevel 1Pro