Microsoft Office Tutorials and References
In Depth Information
Figure 11.19
The GEOMEAN is not
the same as the
arithmetic mean
GROWTH calculates predicted exponential growth by using existing data.
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.
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.
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.
TRUE or FALSE indicating whether the slope ( b) is = 1 (FALSE) or not
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