🧮

Data Analysis Beginner

Forecast Next Value

⏱ 7 min ⭐ 250 XP 🔁 3 attempts allowed

What you'll do

Use FORECAST.

Scenario

Months are in A2:A13 and sales in B2:B13. In D3 use FORECAST to predict sales at x = 13: FORECAST(13,B2:B13,A2:A13).

Ready to try it?

Create a free account and try "Forecast Next Value" free for 7 days, no card required. Earn 250 XP and track your internship progress.

Already have an account? Sign in