How do I solve for x in a second-order polynomial trend?

D

DianeD

I have instrument calibration data that is best characterized as quadratic- I
need to back-calculate for an adjusted point, using the basic formula y= ax^2
+ bx + c.

I'm horrible at formulae in excel!
 
D

David Biddulph

You could use Goal Seek to find X, given Y, or you could use the standard
quadratic equation solution (-B +/- SQRT(B^2-4*A*C))/(2*A)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Estimating values in 2, 3 order polynomial curves 3
Determining the apex of a order 2 polynomial 3
Extracting Constant from Non-linear Trend line 1
Polynomial Eq Parameters 4
Determining error associated with polynomial trend lines. 1
Polynomial Formula Incorrect? 1
Trend Line 5 or 6th order polynomial not working 1
Trend Line constants as Excel Cell Values 7

Top