MEDIAN, MODE, STDEV, LARGE and RANK
Summaries of a list of numbers: MEDIAN (middle value), MODE (most common), STDEV.S (sample standard deviation), LARGE(range, k) and SMALL(range, k) (the k-th largest or smallest) and RANK(value, range) (position in the list, 1 = largest).
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
`RANK` gives 1 to which value by default?
Your turn: write the code
In D1 show the third smallest score.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.