GROWTH (PQL - xl)

This function calculates predicted exponential growth. This function returns the y values for a series of new x values that are specified by using existing x and y values

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

Syntax

GROWTH(known ys, OPTIONAL known xs, new xs, const)

Function Arguments

Name

Description

Type

Optional

known ys

Set of y values that are known in the relationship y=b*m^x

StringOrNumber

known xs

X is an optional set of x values that may be known in the relationship y=b*m^x

StringOrNumber

Y

new xs

New x values for which this functions returns the corresponding y values

StringOrNumber

const

Logical value that specifies whether to force the constant b to equal 1

StringOrNumber

Comments

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