Loading

R Square Value Is Different in Tableau and Excel

게시 일자: Apr 29, 2025
상세 설명

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. 

 
솔루션
Option
Check the box of  [Trend Lines Options] > [Force y-intercept to zero].
User-added image
추가 자원
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 기사 번호

001471374

 
로드 중
Salesforce Help | Article