StatisticsLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
RSQ returns R², between 0 and 1. Near 1 means a straight line explains the data well; near 0 means your trend forecast is mostly a guess.
Syntax
=RSQ(known_ys, known_xs)
| Argument |
What it means |
known_ys |
Values. |
Examples
Example 1
=RSQ(C2:C25, A2:A25)
Check this before trusting a linear forecast.
CORREL · SLOPE
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong