RSQ Function Explained
The RSQ function in Microsoft Excel calculates the coefficient of determination (R-squared) of a regression line based on the data points in two supplied arrays. It takes two arguments: the known_y's and the known_x's. The known_y's argument is an array or range of dependent data points, and the known_x's argument is an array or range of independent data points. The RSQ function returns the R-squared value, which is a number between 0 and 1 that indicates how closely the regression line fits the data points.
RSQ Function Syntax
RSQ(known_y's, known_x's)
- known_y’s – The set of dependent values (y-values) that are already known.
- known_x’s – The set of independent values (x-values) that are already known.