Excellency AcademyOpen the appFinanceTier 615 minintermediate
Forecast Next Quarter's Revenue
Project next quarter's revenue from six months of history using linear regression.
What you will learn
- Use FORECAST.LINEAR with known_ys and known_xs in the correct order
- Explain why swapping the two ranges fits an entirely different, wrong line
- Recognise a forecast as an extrapolation, not a guarantee
Excel skills
FORECAST.LINEAR · Statistical Functions
The task
Six months of revenue are listed. Forecast what month 9 will look like, in Summary!B3, by fitting a line through the trend so far.
You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.