Question 30: Skipped Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view.
What is its R-squared value?
A . 0.783262
B . 0.739284
C . 0.759329
D . 0.748472
Answer: A
Explanation:
Explanation Trend lines have become popular questions in recent Tableau examinations. Follow along:
1) First drag Sales to the Rows shelf and Profit to the Columns shelf:
You will only see a single mark since the view is aggregated.
2) Now, break down this view by state. Drag State into Detail on the Marks shelf (or directly to the view):
3) Finally, move to the Analytics pane, and drag Trend line to the view.
When you drag it, select the Linear option!:
4) The following is our view. Hover over the trend line to see the R-squared value: