LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reversing growth curve YT Charts and Charting in Excel 1 January 10th 07 11:30 PM
How to make tangent line/slope on exponential curve? scientist Excel Discussion (Misc queries) 0 November 2nd 06 12:56 PM
How do you graph a logistic growth curve? Skip Excel Discussion (Misc queries) 0 October 4th 06 12:55 AM
Project exponential growth againt linear timeline [email protected] Excel Worksheet Functions 3 July 24th 06 02:11 PM
exponential numbers in cells dick Excel Discussion (Misc queries) 4 June 27th 06 11:06 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"