Shell -

Why do I get different values for the same arrays when I run CORREL and ad
r-squared value to a scatter plot? <

First, CORREL is R, and R-squared from Add Trendline (or from worksheet
function RSQ) is R*R.

Second, as I recall, depending on the version of Excel, there may or may not
be an adjustment for the number of observations (degrees of freedom), but
maybe that was only for COVAR.

Third, adjusted R square, from the Regression tool of the Analysis ToolPak,
also adjusts for the number of explanatory X variables.

- Mike
www.mikemiddleton.com