Microsoft Office Tutorials and References
In Depth Information
Using GROWTH to Predict Many Data Points from an Exponential Regression
for each independent variable, just as known_x'sdoes. So, if
known_y'sis in a single column, known_x'sand new_x'smust have the
same number of columns. If known_y'sis in a single row, known_x's
and new_x'smust have the same number of rows. If new_x'sis omitted,
it is assumed to be the same as known_x's. If both known_x'sand
new_x'sare omitted, they are assumed to be the array {1,2,3,...} that is
the same size as known_y's.
const
const This is a logical value that specifies whether to force the
constant b to equal 1. If constis TRUE or omitted, b is calculated nor-
mally. If constis FALSE, b is set equal to 1, and the m values are ad-
justed so that y = m^x.
In Figure 14.20 , the original data is the population for the first 10 genera-
tions in A2:B11.
Figure 14.20.
Figure 14.20. GROWTH
GROWTH performs an exponential regression and extrapolates
performs an exponential regression and extrapolates
the results in one step.
the results in one step.
Search JabSto ::




Custom Search