FORECAST (PQL - xl)

This function calculates a future value using existing values

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

FORECAST(x, known ys, known xs)

Function Arguments

Name

Description

Type

Optional

x

Value for which to predict the future dependent value

Number

known ys

An array of known dependent values (y’s)

StringOrNumber

known xs

An array of known independent values (x’s)

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'FORECAST' function - using the same inputs, logic and outputs.