Administration and Executive AssistantTier 625 minintermediate

Quartiles with QUARTILE.INC

Find the lower and upper quartiles of a dataset, without mixing up which argument means which end.

What you will learn

• Use QUARTILE.INC with argument 1 to find the lower quartile (Q1)
• Use QUARTILE.INC with argument 3 to find the upper quartile (Q3)
• Explain why transposing the two arguments silently swaps which quartile comes back

Excel skills

QUARTILE.INC · Descriptive Statistics

The task

Fourteen students' scores are listed. Report the lower quartile (Q1) in Summary!B3 and the upper quartile (Q3) in Summary!B4 - the two values that mark off the middle half of the class from the bottom and top quarters.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free