How do I calculate Annual Average Growth Rate over more than one year?

Question

And how do I apply the formula to Excel Spread Sheet to get the result. thanks a lot for the answer

Answer 1

Average growth follows this model: X(n)=X(o)*(1+g)^n

there g - growth rate (%).

Growth rate= (Xn/Xo)^(1/n)

Growth rate - growth rate as resudual

n - number of periods

Xn - value at period 'n'

Xo - value at period 'o' (at beginning)

Growth rate(%)= (((Xn/Xo)^(1/n)) - 1)/100

Growth rate(%) - growth rate in percents