What is its R-squared value?

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

View Answer

Answer: A

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: