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.
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.
AWESOME! A very special thanks for that tip to Tom and especially to
Bernard.
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.