Calculates the correlation coefficient of two datasets.
Computes the Pearson product-moment correlation coefficient, denoted as r, for a dataset.
Computes the Pearson product-moment correlation coefficient for a set of data.
The RSQ function in Excel calculates the square of the Pearson product-moment correlation coefficient, providing a statistical measure that indicates how well a regression model fits a dataset. It is essential for evaluating the strength of a linear relationship between two variables, making it invaluable in data analysis and predictive modeling.