Issue
R square is different in Excel and Tableau.
(0.3562 and 0.4089)
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
Resolution
OptionCheck the box of [Trend Lines Options] > [Force y-intercept to zero].
Cause
By default, the linear trend line y-intercept is not set to zero in Tableau.So when the y-intercept is set to zero in Excel, the R Square values are different.
Additional Information
When setting the y-intercept to zero, the R Square calculation for the linear trend line is shown below:While the normal R Square calculation is as follows:
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials