MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperbolas


Posted by Brian on March 22, 2001 3:49 PM

How do you get Excel to graph hyperbolas and return coefficients to particular cells? The Linest function does this for polynomials. Is there an equivalent for polynomials?


Posted by Mark W. on March 22, 2001 4:07 PM

Did you checkout the Help topic for
"hyperbolic functions"?

Posted by GregA on March 22, 2001 5:38 PM

Brian,

What exactly are you trying to do? Are you looking for a function that will give you a "best fit" hyperbola, i.e., take data that you supply and give the coefficients for the hyperbola that best fits the data? Or are you just trying to create a graph of a hyperbola (in which case Mark W's comment will be of some use).

If you want the former, I do not believe there is a function in Excel that will do this directly -- however, if my memory serves me after 20+ years, I believe the approach you want to use would be to transform the data you have to make it fit a linear model, then use LINEST to do linear regression. Let me know what application you have and I will ry to be more specific.

Greg