+ Reply to Thread
Results 1 to 17 of 17

derive exponential function from limited information

Hybrid View

  1. #1
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Lightbulb derive exponential function from limited information

    I've been working on a ss that requires me to create a function to determine a value from a exponential curve where the area of the curve is variable . The terminal points, 0,0 and 100,100 remain constant and the curve is symmetrical at the 45degree angle. How can I derive a function knowing only these things.

    Here is an image to crudely illustrate what i mean http://i.imgur.com/N2ehO.png

    The area can be 10, 20, 35% it doesn't matter, I need a way to determine the function from just the area! Thank you!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,102

    Re: derive exponential function from limited information

    Can you upload example?

    Where we can see input data?
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: derive exponential function from limited information

    The only thing I'm inputting is the area under the curve. What I need is a way to generate the function.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: derive exponential function from limited information

    The terminal points, 0,0 and 100,100 remain constant
    The value of the exponential function y = m * b ^ x has a value of m at x = 0, not 0.

    EDIT: And an exponential is not symmetric in that fashion.
    Last edited by shg; 12-05-2009 at 03:51 PM.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: derive exponential function from limited information

    i can see you are correct in that it is not an exponential function, http://i.imgur.com/dcSw0.png this is more of what i was going for.. is there a way to express this in excel?

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: derive exponential function from limited information

    There would be if you knew what the type of the function is.

  7. #7
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,102

    Re: derive exponential function from limited information

    This more looks like shifted y=a/x to me

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,102

    Re: derive exponential function from limited information

    How about instead of function make aproximation with two lines?

    First one will go from 0 to (1-p)*100
    And second from (1-p)*100 to 100

    Formula for first part is a*X
    And second 100+(x-100)/a

    Where a is p/(1-p) and p is needed percentage (i.e. 0,15)

  9. #9
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: derive exponential function from limited information

    could they be parabola tilted at a 45 degree angle?

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: derive exponential function from limited information

    What's the genesis of the problem?

  11. #11
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: derive exponential function from limited information

    edit: see below
    Last edited by cubew00t; 12-05-2009 at 06:52 PM.

  12. #12
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Exclamation Re: derive exponential function from limited information

    Ok, it seems as though I need more information.

    http://i.imgur.com/qCnFL.jpg

    I need to create a function in excel for a hyperbola and the only information I have is the area. If I input a certain area, it would ideally generate a new function that covers more or less area but still goes through 0,0 and 100,100.

    Thank you!

  13. #13
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: derive exponential function from limited information

    I'm happy to help if you're done with the other forum, otherwise please continue there.

  14. #14
    Registered User
    Join Date
    12-05-2009
    Location
    cubew00t
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: derive exponential function from limited information

    Yes, I'm done. Thank you.

  15. #15
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: derive exponential function from limited information

    It would be very messy to solve for k as a function of area in closed form. You could use Solver:
           -A-- --B--- ----------------------C----------------------
       1   Area    15% << set this to the desired value (here, 0.15)
       2      k  8.513 << by changing this                          
       3                                                            
       4    x     y                                                 
       5      0   0.00                                              
       6      5   0.41                                              
       7     10   0.86                                              
       8     15   1.37                                              
       9     20   1.92                                              
      10     25   2.55                                              
      11     30   3.25                                              
      12     35   4.05                                              
      13     40   4.97                                              
      14     45   6.03                                              
      15     50   7.27                                              
      16     55   8.75                                              
      17     60  10.53                                              
      18     65  12.72                                              
      19     70  15.47                                              
      20     75  19.05                                              
      21     80  23.89                                              
      22     85  30.78                                              
      23     90  41.39                                              
      24     95  59.85                                              
      25    100 100.00
    The formula in B1 is =(k * (100+k) * LN((100+k) / k) - 100*k) / (100 * 100)

    The formula in B5 and copied down is =k * x / (100 - x + k)
    Last edited by shg; 12-05-2009 at 08:22 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1