Statistical
GROWTH Function
Excel's GROWTH function fits an exponential curve to your data and returns the yvalues
along that curve for the array of new x values that you specify.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
GROWTH(known_y's,
known_x's, new_x's, const)

known_y's
Required. The range or array of y values you already know in
the relationship y = b*m^x. (From another perspective, a
chart typically displays the same "y" values in the vertical
axis.)

known_x's
Optional. The range or array of x values you typically know
in the relationship y = b*m^x. (From another perspective,
"x" values are frequently date serial numbers, counters, or
other numeric categories.) If known_x's is omitted, it is
assumed to be the array {1,2,3,...} that is the same size as
known_y's.

new_x's Optional.
The new xvalues for which you want GROWTH to return
corresponding yvalues.

New_x's must include a column
(or row) for each independent variable, just as
known_x's does. So, if known_y's is in a single column,
known_x's and new_x's must have the same number of
columns. If known_y's is in a single row, known_x's and
new_x's must have the same number of rows.

If new_x's is omitted, it is
assumed to be the same as known_x's.

If both known_x's and new_x's
are omitted, they are assumed to be the array
{1,2,3,...} that is the same size as known_y's.

const
Optional. A logical value that specifies whether to force
the constant b to equal 1.

If const is TRUE or omitted,
then b is calculated normally.

If const is FALSE, b is set
equal to 1, and the mvalues are fitted to y = m^x
Applies To
Excel 2003 and above
Examples
The following examples show the use of GROWTH only when the
'const' value is omitted. This is because it's likely that
you'll never use the other setting.
Other ExcelUser Information
Other Help






ExcelUser, Inc. Copyright © 2004  2017 by Charles W. Kyd, all rights reserved. Content, graphics, and HTML code are protected by
US and International Copyright Laws, and may not be copied,
reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission.
Terms of Use 
Privacy Policy 
Disclaimer 
Earnings Policy.

Ref:
901 048

