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.