View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Babymech Babymech is offline
external usenet poster
 
Posts: 49
Default Creating numbers for an exponential growth curve

I have a question which might be possible to solve entirely through clever
math, but I'm not seeing it yet.

I want to define a LOW number, and a HIGH Number and then, for a given
number of steps, generate numbers in between LOW and HIGH, rising
exponentially from LOW to HIGH. One example would be the following

LOW = 5
HIGH = 100
# of steps: 12

Generated Numbers: 5 5 5 5,5 6 7 8 10 13 18 30 50 100

This, when put into a chart, gives an exponentially rising curve. I know
that I could do this by asking Excel to draw a trend line between a limited
number of points, but I want to generate actual numbers.

My problem so far is that the equations I use to generate the numbers have
to be manually adjusted if I want them to end at up HIGH by, say, the 10th
number. By just inputting LOW, HIGH, and a number representing the
'exponentiality' of the progression, I want the list of numbers to cover the
range between LOW and HIGH in, say, 10 steps, no matter what I input as low
or high values.

Hopefully this makes sense, but I can try to clarify if my meaning doesn't
come across.

Thanks,
Babymech