Excel's GROWTH function?
 

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,

Can you please explain how the growth for the 1st time period was
16.65 and, for the 10th period, it became 41.74? I mean how can this
be validated?

Thanks,
Jo