linest function for curve

B

Baffeled

I want to obtain a formula for a curve for the equation (Mx)²+C. I need the
formula to return values for M and C and will have a number of points for the
formula to refference. I know Linest can return results for Mx+C formula, but
is there a way of returning results for (Mx)²+C? Or is there another function
to return results for a curve?
 
B

Bernard Liengme

Let the x-values be in A2:A6 and the y-values in B2:B6
Select two cells to receive the M and C values; type =LINEST(B2:B6,A2:A6^2);
press SHIFT+CTRL+ENTER as this is an array formula
Note that this fits the data to mx²+c so you will need to take the square
root of LINEST's slope to get your M if to are fitting to y=(Mx)²+c
See http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
best wishes
 

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

Top