Computing r-Square with Excel

Fundamentals of Social Statistics by Adam J. McKee

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

Section 4.2 important symbols

[ Back | Contents | Next ]

Last Modified:  06/03/2021

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.