Trend lines in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a linear trend line to the scatter plot.

Tableau

Add Trend Line: Model Type = [1]

Drag options to blanks, or click blank then click option'

ALinear

BExponential

CPolynomial

DLogarithmic

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a polynomial or exponential model when a linear trend is needed.

Confusing logarithmic with linear trend lines.

The linear model fits a straight line to the data points, showing a simple trend.

2fill in blank

medium

Complete the code to display the R-squared value on the trend line.

Tableau

Show Trend Line Summary: Display [1]

Drag options to blanks, or click blank then click option'

AP-value

BStandard Deviation

CMean

DR-squared

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting P-value instead of R-squared for fit quality.

Confusing standard deviation with trend line statistics.

R-squared shows how well the trend line fits the data, with values closer to 1 indicating a better fit.

3fill in blank

hard

Fix the error in the calculation of the trend line equation.

Tableau

Trend Line Equation: y = [1] * x + b

Drag options to blanks, or click blank then click option'

Amean

Bintercept

Cslope

Dresidual

Attempts:

3 left

💡 Hint

Common Mistakes

Using intercept instead of slope as the multiplier of x.

Confusing residual with slope.

The slope represents the rate of change of y with respect to x in the trend line equation.

4fill in blank

hard

Fill both blanks to create a calculated field for the predicted value using the trend line.

Tableau

Predicted Value = [1] * [Sales] + [2]

Drag options to blanks, or click blank then click option'

ASlope

BIntercept

CAverage

DMedian

Attempts:

3 left

💡 Hint

Common Mistakes

Using average or median instead of slope or intercept.

Swapping slope and intercept positions.

The predicted value is calculated by multiplying the slope by the sales value and adding the intercept.

5fill in blank

hard

Fill all three blanks to write a Tableau LOD expression that calculates the average sales per category for trend analysis.

Tableau

{ FIXED [1] : AVG([2]) } + [3]

Drag options to blanks, or click blank then click option'

A[Category]

B[Sales]

C0

D[Region]

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong dimension like region instead of category.

Forgetting to use AVG aggregation on sales.

Adding a non-numeric value at the end.

The expression fixes the calculation by category, averages sales, and adds zero to keep numeric type consistent.