On Aug 19, 2:54 am, "Dana DeLouis" wrote:
Using "Forecast" excel function, I get 38.76

I believe you are estimating the straight line linear growth at time period
10 to get 38.76.

Next, I use "Growth" excel function and I get: 16.65

You are calculating an exponential growth at time period "1" to get 16.65.
If you change the time to 10, you will get as est. of 41.74.

Put your data, Growth, and Forecast data in 3 columns together, and select
an x-y scatter chart to get a nice view of the differences.

--
HTH :)
Dana DeLouis

"Jo" wrote in message

oups.com...



Hi,
Say, I have the following 9 data points:

1 2 3 4 5 6 7 8 9
15.53 19.99 20.43 21.18 25.93 30.00 30.00 34.01 36.47

Using "Forecast" excel function, I get 38.76

Next, I use "Growth" excel function and I get: 16.65

Can someone please apply the meaning of the last value, i.e. growth,
to the above 9 data points?

Thanks,
Jo- Hide quoted text -

- Show quoted text -

Dana,

Here is how I am writing FORECAST & GROWTH functions:

Forecast(10,D8:L8,$D$7:$L$7) = 38.76
Growth(GROWTH(D8:L8,$D$7:$L$7) = 16.65

Look at Growth function please, what do you mean by saying "If you
change.......you will get as est of 41.74?"

Also, to plot the xy scatter graph describing above, how would the
format look like (I have 9 points, one value for Forcast, and one for
Growth)?

Please elaborate, THANKS

Jo