linest function for curve

[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?

 

[Gary''s Student]

See:

http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/

 

[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