What is RSQ?
Returns the coefficient of determination (R²) for a regression. Measures how well the line fits the data.
Syntax
=RSQ(known_y's, known_x's)
Example
Formula: =RSQ(A1:A10, B1:B10)
Result: 0.92
How It Works
Returns R² value between 0 and 1. Higher values indicate better fit (1 = perfect fit).