Loading

R Square Value Is Different in Tableau and Excel

Publiseringsdato: Apr 29, 2025
Beskrivelse

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

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

 
Løsning
Option
Check the box of  [Trend Lines Options] > [Force y-intercept to zero].
User-added image
Flere ressurser
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
Knowledge-artikkelnummer

001471374

 
Laster
Salesforce Help | Article