R Square Value Is Different in Tableau and Excel
10 Mar 2021
Last Modified Date:
10 Mar 2021
R square is different in Excel and Tableau.
(0.3562 and 0.4089)
Check the box of [Trend Lines Options] > [Force y-intercept to zero].
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.
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:
Did this article resolve the issue?
Thank you for providing your feedback on the effectiveness of the article.
Click here to return to our Support page.
Open new Case
Open a new case
Click here to go to our Support page.
Get detailed answers and how-to step-by-step instructions for your issues and technical questions.
Find and share solutions with our active community through forums, user groups and ideas.
Browse a complete list of product manuals and guides. Available online, offline and PDF formats.
Training and Tutorials
Learn how to master Tableau’s products with our on-demand, live or class room training.
PRINT THIS PAGE
SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
Download Tableau Desktop & Server
Tableau Online & Public Status
Send Large Files
All Tech Specs
Elite Account Management