Hello, nice to meet you all, I've been working on a spreadsheet 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. Thanks!
from asking other places this is probably not an exponential function, this image better describes what i am looking for:
can this be expressed mathematically to solve for x and y ?
wow thank you, that was amazing, so amazing that it shot right over my head
i have come to believe that it is not an exponential function that describes the second image but perhaps a parabola at a 45 degree angle? Is this possible and what would be the function derived from knowing just the area?
Hello cubew00t
Welcome to Math Help Forum!I have a solution for you that seems to satisfy all your requirements including symmetry about the line . It is:The area under the curve is:Here are a few sample values.; area = %The curve is not, of course, exponential. It's part of a rectangular hyperbola, with asymptotes and . The curve contains the points and and is symmetrical about the line . (You can check this by replacing by in the function: the same values of will be produced in the reverse order.)
; area = %
; area = %
I attach a screen shot of the graphs for and an Excel spreadsheet with the calculations that produced these graphs.
Grandad
Thank you this is exactly what i was looking for!
Edit: if all the information I have is Area, how can I deduce a function that works in excel? For example, I input Area and it on-the-fly changes the values that affect the shape hyperbola.
Thank you for your efforts again.
Hello cubew00tI attach a revised version of the spreadsheet. You'll see that cell H1 contains a value of k that can be varied to give the function values in column F, producing the % area in cell G24. You can use Tools -> Goal Seek to find the value of k for a given percentage area. In the spreadsheet attached, I've set this to 15%, giving a value of k as 8.513. I've also modified the chart so that just this single (variable) set of data is displayed.
Grandad
MrGrandad you are truly a godsend, and I will take this opportunity to impose upon you for the last time (lol).
I see the spreadsheet you have graciously created however it's like eating fish without having learned how to fish. It is too complicated for me to reverse engineer to get what I specifically need. Can you modify it slightly to allow me to input Area, that will affect k and not the other way around?
=(H1*(100+H1)*LN((100+H1)/H1)-100*H1)/100
This is beyond me to reverse engineer. While I await your response, I will keep trying!
Hello cubew00tIt's not possible to produce an explicit formula for an equation like this. (It's not merely difficult, it really isn't possible!) So you'll have to rely on a tool like Goal Seek in a spreadsheet to do the job for you. It seems from you last posting that you're not familiar with this superb spreadsheet tool. (It's worth finding out how to use it!)
I don't know which version of Excel you have, and whether the attached spreadsheet will work (I uninstalled Excel 2007 from my machine because I hated it so much, and went back to my ancient Excel 2000 which I love!), but I have now added some VBA code to do the Goal Seek for you, if you have a compatible version. Just press <Ctrl>+g to run the code; enter the area required (no percentage sign, just a number between 1 and 49), and the value of will appear in cell D1.
If the code doesn't work, you'll have to find out how to use Goal Seek and do it manually. It's worth the effort - it's the only way to solve a problem like this.
I have also simplified the spreadsheet, and the function to the equivalent
Grandad