Calculating R-squared value

M

Metin

I want to calculate the R-squared value on chart with an Excel formula. But the R-squared value has to be a 2nd order polynomial.
 
T

Tom Ogilvy

I think R-squared has already been defined. It is a single number.
Perhaps you could restate your question. Do you mean you want to calculate
the R-squared value for a second order polynomical fit to the data?

Look at the LINEST function.

--
Regards,
Tom Ogilvy

Metin said:
I want to calculate the R-squared value on chart with an Excel formula.
But the R-squared value has to be a 2nd order polynomial.
 
T

Tom Ogilvy

Also, for a chart, you can add a trendline and in that dialog specify the
fit to be a polynomial of order 2 and have it display the R-squared value
(second tab in the dialog).

--
Regards,
Tom Ogilvy

Metin said:
I want to calculate the R-squared value on chart with an Excel formula.
But the R-squared value has to be a 2nd order polynomial.
 
T

Tom Ogilvy

I'm afraid the function LINEST is not the function I'm looking for.

You are mistaken about LINEST. It can be used to fit a second degree
polynomial (or higher).

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST.

http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm


--
Regards,
Tom Ogilvy


Metin said:
Yes, I mean that I want to calculate the R-squared value for a second
order polynimical fit of the data.
I'm afraid the function LINEST is not the function I'm looking for. LINEST
calculates for a straigt line. The equation for the LINEST line is y = mx +
b. The equation of the line I'm looking for has to be y = m1x^2 + m2x + b.
 

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