SOLUTION: I have two numbers (2,310 and 4,290), what I need is to calculate 10 numbers between them based on a fixed percentage increase.
Many thanks in advanced. Wonderful site.
Question 1059551: I have two numbers (2,310 and 4,290), what I need is to calculate 10 numbers between them based on a fixed percentage increase.
Many thanks in advanced. Wonderful site. Answer by Theo(13342) (Show Source):
You can put this solution on YOUR website! first number is 2310.
10 numbers in between.
12th number is 4290.
f = p * (1+x)^11
f = 4290
p = 2310
formula becomes 4290 = 2310 * (1+x)^22
divide both sides by 2310 to get 4290 / 2310 = (1+x)^11
solve for (1+x) to get (1+x) = (4290/2310)^(1/11)
solution is (1+x) = 1.0578899295410038.
subtract 1 from both sides to get x = .0578899295410038.
multiply by 100% to get x = 5.78899295410038 percent.
the following excel spreadsheet gives you the numbers in between.
each number have been arrived at by multiplying the previous number by 1.0578899295410038.
the calculator will not give you as many decimal places accuracy in the disploay.
these numbers were derived from excel as shown below:
