Published: 10 Mar 2021 Last Modified Date: 08 Jul 2022
Issue
R square is different in Excel and Tableau. (0.3562 and 0.4089)
Environment
Tableau Desktop
Resolution
Option Check 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.