FORECAST.LINEAR Function in Excel: Syntax, Examples and Free Practice
FORECAST.LINEAR is an Excel Statistical function. Predicts a future value along a linear trend.
FORECAST.LINEAR syntax
Arguments
x: The value to evaluateknown_ys: The known y-valuesknown_xs: The known x-values (optional)
When to use FORECAST.LINEAR
FORECAST.LINEAR is used in data analysis work to summarize or test patterns across a data set.
Practice FORECAST.LINEAR online, free
Open the live Excel-style spreadsheet and try FORECAST.LINEAR yourself. No Excel install or sign-up needed to start.
Practice FORECAST.LINEAR now →More Statistical functions
Frequently asked questions
What does the FORECAST.LINEAR function do in Excel?
Predicts a future value along a linear trend.
What is the syntax of FORECAST.LINEAR in Excel?
The syntax is =FORECAST.LINEAR(x, known_ys, known_xs). x: The value to evaluate; known_ys: The known y-values; known_xs: The known x-values (optional).
Where can I practice FORECAST.LINEAR online for free?
Open the free live spreadsheet on Cellgrids and try FORECAST.LINEAR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts