SheetFX
≡
<< Go back to all functions

FORECAST.LINEAR

The FORECAST.LINEAR function in Google Sheets is a statistical tool used to predict a future value of a dependent variable based on historical data of the independent variable. It is commonly used in financial forecasting, sales projections, and trend analysis. Explore our comprehensive guide to understand how to apply the FORECAST.LINEAR function effectively.

Function Syntax and Parameters

Syntax: FORECAST.LINEAR(x, data_y, data_x)

Parameters:

  • x: The x-value that you want to forecast.
  • data_y: The array or range containing dependent variables.
  • data_x: The array or range containing independent variables.

Step-by-Step Tutorial

  1. Using FORECAST.LINEAR with numerical data:

    • Example: =FORECAST.LINEAR(5, B2:B10, A2:A10)
    • Result: This formula will forecast the y-value corresponding to x=5 using the given dataset.

  2. Using FORECAST.LINEAR with named ranges:

    • Example: If you have named the ranges data_y and data_x for the respective data arrays, then you can use the formula =FORECAST.LINEAR(10, data_y, data_x) to forecast the value for x=10.

Use Cases and Scenarios

  1. Financial Projections: Forecast future stock prices based on historical market data.
  2. Sales Forecasting: Predict sales figures based on historical data and market trends.
  3. Demand Estimation: Estimate future demand for a product or service based on historical sales data.

Related Functions

  • FORECAST: See also the non-linear forecast function.

Related Articles