An analyst can vary inputs such as prices, costs or demand and compare the resulting outputs. The goal is to identify which assumptions have the greatest effect.
The analysis explores consequences under chosen inputs. The range should reflect plausible conditions, and the calculations still need verification.
ELI5
Think of turning one dial at a time to see how much it changes a machine's output. Some dials have a large effect and others make little difference.
For example, a planning spreadsheet can show how a total changes when an assumed quantity increases or decreases, without claiming either case will happen.
How does it differ from a forecast?
It compares results under stated assumptions. A forecast aims to estimate what is likely to happen.
Can it reveal a spreadsheet error?
Unexpected changes can point to a formula or assumption worth checking, though the analysis alone cannot verify every calculation.

