Trendline for a Hyperbola?

  • Thread starter Thread starter phil6666
  • Start date Start date
P

phil6666

I have a graph which should be an hyperbola.

Is there a simple way to add a trendline that will yield this shape?

thnx
 
On chart right-click mouse and select <Add Trendline...>

Then select Type. Maybe you need polynomial?

See how you go.

Alex
 
I've tried polynomial- 2nd order polynomial comes close, but I really
need an hyperbola.

(3rd or 4th order don't work either....)
 
Hi!

The simplest basic equation for a parabola is y=a*x^2.

It is always going to be a polynomial of order 2 even if you shift th
origin :
e.g. Y+c=a*(x+d)^2 or tilt the axes.

I would suggest that, if your explorations of trendlines usin
2nd-order polynomials or power of 2 don't give you the answers yo
want, either the data is incompatible with that or your hypothesis ma
need some more thought.

Al
 
Back
Top