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?
Welcome to Math Help Forum!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.
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.
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?
This is beyond me to reverse engineer. While I await your response, I will keep trying!
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