KNOWLEDGE BASE

R Square Value Is Different in Tableau and Excel


Published: 10 Mar 2021
Last Modified Date: 10 Mar 2021

Issue

R square is different in Excel and Tableau.
(0.3562 and 0.4089)

User-added image        User-added image

Environment

  • Tableau Desktop

Resolution

Option
Check the box of  [Trend Lines Options] > [Force y-intercept to zero].
User-added image

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:
User-added image

While the normal R Square calculation is as follows:
User-added image
Did this article resolve the issue?