Hi all,
I'm reading about exponential growth, and finding it very interesting.
However, I'm a bit confused. I wanted to have some spreadsheed fun and do some calculation in practice.
Given n=ekx, I want to calculate some values for n, with k=0.07. Alright no problem.
I than wanted to check the increase in % for each x. I thought to myself, 'duh, this is given by k! I already know this is 0.07!'. But I got surprised! When I calculate the %-growth I get a %-growth that is > k. In the case of K=0.07, I get an %-increase by 0.072508181254217 for each term. Why is this!? Why is it not 0.07?
I'm calculating the %-growth with the formula: [n(x)-n(x-1)]/n(x-1) (i.e. [current-previous]/previous).
Please see attached a picture of my spreadsheed.
Thank you for any guidance!
Best,
Andreas
I'm reading about exponential growth, and finding it very interesting.
However, I'm a bit confused. I wanted to have some spreadsheed fun and do some calculation in practice.
Given n=ekx, I want to calculate some values for n, with k=0.07. Alright no problem.
I than wanted to check the increase in % for each x. I thought to myself, 'duh, this is given by k! I already know this is 0.07!'. But I got surprised! When I calculate the %-growth I get a %-growth that is > k. In the case of K=0.07, I get an %-increase by 0.072508181254217 for each term. Why is this!? Why is it not 0.07?
I'm calculating the %-growth with the formula: [n(x)-n(x-1)]/n(x-1) (i.e. [current-previous]/previous).
Please see attached a picture of my spreadsheed.
Thank you for any guidance!
Best,
Andreas