coefficient of determination

J

Jene

In the EXCEL curve fit function for a single dependant variable should the
coefficient of determination be upper case R-squared or lower case r-squared?
 
M

Mike Middleton

Jene -

Excel output (Trendline and Regression tool) uses upper case R for curve
fitting with either a single X variable or multiple X variables.

Many statistics authors use lower case r for the single-X-variable
situation.

Excel's Help uses lower case r in descriptions of the RSQ and PEARSON
functions. The description of the CORREL function doesn't mention either r
or R. (PEARSON and CORREL are numerically identical.)

- Mike
http://www.MikeMiddleton.com
 

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

Similar Threads

Curve fit coefficient 1
Goodness of fit test 3
Excel --> Word 4
Runtime Error on Linest 3
Polynomial Treandline Coefficients 6
Determine if previous "character" is a section break 3
Lower-Case Characters 2
How does Excel calculate Multiple R when doing multiple regression 1

Top