FinanceTier 615 minintermediate

Commission Tier by Sales Quartile

Find the lower and upper sales quartiles to set commission tier boundaries.

What you will learn

• Use QUARTILE.INC with the correct argument for each quartile
• Explain why QUARTILE.INC's second argument is easy to get backwards
• Use a quartile boundary to define a commission tier

Excel skills

QUARTILE.INC · Statistical Functions

The task

Find the lower quartile (Q1) and upper quartile (Q3) of the sales figures, to use as commission tier boundaries. In Summary!B2, calculate Q1; in Summary!B3, calculate Q3.

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