The coefficient, also commonly known as R-square, is used as a guideline to measure the accuracy of the model.
Chat with our AI personalities
ɪ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.
That is not true. It is possible for a data set to have a coefficient of determination to be 0.5 and none of the points to lies on the regression line.
= 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.
It's not quite possible for the coefficient of determination to be negative at all, because of its definition as r2 (coefficient of correlation squared). The coefficient of determination is useful since tells us how accurate the regression line's predictions will be but it cannot tell us which direction the line is going since it will always be a positive quantity even if the correlation is negative. On the other hand, r (the coefficient of correlation) gives the strength and direction of the correlation but says nothing about the regression line equation. Both r and r2 are found similarly but they are typically used to tell us different things.
coefficient of determination