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?
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.)
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.