Pro lesson · 6 exercises · first one free
Typical values: MEDIAN, MODE.SNGL and RANK.EQ
About this lesson
Find the middle and the most common value, rank results, and compare with the average.
Statistics, charts and tables · 6 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Finding the middle value
- Finding the most common value
- Ranking a value within a list
- Counting values above the average
- Seeing how ties affect ranks
- Choosing between average and median
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 6, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.