Skip to content

Forecast¤

Excel FORECAST(value; data_Y; data_X): Extrapolates future values based on existing x and y values. Value is the x value, for which the y value of the linear regression is to be returned. Data_Y is the array or range of known y’s. Data_X is the array or range of known x’s. Does not work for exponential functions.

Parameter¤

Function name¤

The name of the Excel function

  • Datatype: string
  • Default Value: FORECAST

Comments