Microsoft Office Tutorials and References
In Depth Information
GROWTH
Figure 11.19
The GEOMEAN is not
the same as the
arithmetic mean
( AVERAGE .
GROWTH
GROWTH calculates predicted exponential growth by using existing data.
=GROWTH(known_y’s,known_x’s,new_x’s,const)
Using an existing data set of values and increments, and supplying a new set of increments,
the GROWTH function generates the predicted set of corresponding values (the new y values).
In Figure 11.20, the exponential growth values (the predicted y values) have been calculated.
The known_y and known_x values are based on the formula y=b*m^x . A set of new y values is
predicted for the entire time increment, not just for the additional time increments you specify.
Because these new y values are based on the growth equation (and not on the known y values),
the first three y values predicted do not match the known y values for the same increment.
The known values for the known data points; the dependent variable.
Each value must be a positive number.
KNOWN_Y’S
The known data points—typically increments of time (years, quarters,
months); the independent variable. An optional argument. If omitted
assumed to be the array {1,2,3…}, the same size as the known_y ’s.
KNOWN_X’S
The data points of those values you want to predict. An optional
argument. If omitted assumed to be the same as the known_x ’s.
NEW_X’S
TRUE or FALSE indicating whether the slope ( b) is = 1 (FALSE) or not
(TRUE).
CONST
Because this function returns an array:
The result range must be selected before you begin the function.
The formula must be array entered by using Ctrl+Shift+Enter, instead of just Enter.
Search JabSto ::




Custom Search