Syntax :

=GROWTH( known_y’s, [known_x’s], [new_x’s], [const] )

Parameters :

The following parameters are :

• Known y’s – A collection of known y-values.

• Known x’s – A collection of known x-values. This is an optional parameter of one or more x-value arrays. If supplied, the length of the [known x’s] should be the same as the length of the collection of known y’s. If not specified, the collection of [known x’s] assumes the value 1, 2, 3,…

• New x’s -A list of new x-values for which the function computes new y-values. If omitted, the function assumes that the set of [new x’s] is the same as the set of [known x’s], and returns the y-values that are on the estimated exponential growth curve.

• Const -An optional logical argument indicating whether the constant ‘b’ in the equation y = b * mx should be forced to equal 1.
  If [const] is TRUE (or omitted), the constant b is treated normally; if [const] is FALSE, the constant b is set to 1, and the equation becomes y = mx.