Use formulas and compare options
Want more background?
The idea in everyday life
Build a transparent calculation that compares options without hiding assumptions or changing the answer through formatting.
A formula is a reusable explanation; another person should be able to inspect the inputs and reproduce it.
One step at a time.
Use the sample or information you have permission to use. Keep your work as you go. You can pause between steps.
- 1
Write the question, inputs, units, formula, and decision threshold in plain language before entering values.
- 2
Calculate two or three options, preserve the original inputs, and test a high and low assumption.
- 3
Check totals, units, rounding, and whether the comparison is fair across the same time and scope.
See how it works.
Jordan compares two training commutes using weekly travel time and cost, then tests a winter delay assumption before choosing.
Did you cover these?
- Your work includes a comparison table showing formulas or written arithmetic, assumptions, and your recommendation. Include a sensitivity check: show what changes when an assumption is higher or lower.
- Check this common mistake: Changing the inputs to make a preferred option win or comparing totals from different timeframes.
- A reviewer can change one assumption and understand why the recommendation changes or stays the same.
What to finish
A comparison table showing formulas or written arithmetic, assumptions, and your recommendation. Include a sensitivity check: show what changes when an assumption is higher or lower.
Watch for this
Changing the inputs to make a preferred option win or comparing totals from different timeframes.
How can I tell I understand it?
A reviewer can change one assumption and understand why the recommendation changes or stays the same.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
Pass the check. We’ll save the progress.
Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.
Go to the knowledge checkOptional course overview video · same video as Lesson 1
Calculating Wages: The Pay-Rate-Hour Triangle
From TabletClass Math. Watch here or open it on YouTube .
Watch for an idea you can use in the practice below. You can pause or skip this optional overview.Tools, templates, and lesson sources
Tools and templates
Tools open in a new tab so you can keep your place here.
Sources and further reading
Explore the references behind this lesson.
Report a problem with this lesson
Tell us what went wrong. Please leave out personal information and private project contents.