answersLogoWhite

0


Best Answer

= 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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you determine coefficient of determination in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is coefficient of determination?

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.


How is coefficient of determination and coefficient of correlation is related?

coefficient of determination


How would one explain the coefficient of determination?

The coefficient of determination, is when someone tries to predict the outcome of the testing of a hypothesis, or their guess at to what will happen. It helps determine how well outcomes are determined beforehand.


What is coefficient variation?

it is da same as coefficient of determination


What is the verb from determination?

The verb from 'determination' is 'determine'.


What is the noun form of a verb determine?

The noun form of the verb "determine" is "determination."


Multiple coefficient of determination and a regress ion table?

Adjusted R2


What is numerical range of regression coefficient?

ɪ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.


What does the coefficient of determination explain in regression?

The coefficient, also commonly known as R-square, is used as a guideline to measure the accuracy of the model.


What are the uses of emf measurements?

1- Determination of activity coefficient . 2-determination of of composition of complex ion. 3-Potentiometric titrations.


What factors determine the coefficient of friction?

quality of the Surface is affected to the Coefficient of friction


Cause and effect relationships cannot be determined using the coefficient of determination?

True