= CORREL(x values,y values)
***clarification****
CORREL gives you the correlation coefficient (r), which is different than the coefficient of determination (R2) outside of simple linear regression situations.
Chat with our AI personalities
The coefficient of determination R2 is the square of the correlation coefficient. It is used generally to determine the goodness of fit of a model. See: http://en.wikipedia.org/wiki/Coefficient_of_determination for more details.
coefficient of determination
it is da same as coefficient of determination
ɪf the regresion coefficient is the coefficient of determination, then it's range is between 0 or 1. ɪf the regression coefficient is the correaltion coefficient (which i think it is) the it must lie between -1 or 1.
The coefficient, also commonly known as R-square, is used as a guideline to measure the accuracy of the model.