linest function for curve
 

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?

linest function for curve
 

See:

http://spreadsheetpage.com/index.php...line_formulas/
--
Gary''s Student - gsnu200831


"Baffeled" wrote:

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?

linest function for curve
 

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Baffeled" wrote in message
...
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?