Computing r-Square with Excel

 

To compute the coefficient of determination, use the RSQ function.

Figure 24: r-Square in Excel.
Figure 24: r-Square in Excel.

Key Terms

Covariance, correlation, Correlation Coefficient, Pearson’s r, Scattergram, Scatterplot, x-axis, y-axis, linear relationship, positive relationship, negative relationship, Inverse Relationship, Direct Relationship, Regression Line, Trendline, Bivariate, Multiple Correlation, Coefficient of Determination

Important Symbols


[ Back | Contents | Next ]

Last Modified:  02/18/2019
[amazon_link asins=’1983091049′ template=’ProductCarousel’ store=’thereferencepage’ marketplace=’US’ link_id=’f6d2aba5-7e38-11e8-a89f-0f73c296ad50′]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Exit mobile version