Distribution analysis (box plots) in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a box plot used for in data analysis?

A box plot shows the distribution of data by displaying the median, quartiles, and potential outliers. It helps understand spread and skewness.

beginner

Name the five key components shown in a box plot.

Minimum, first quartile (Q1), median (Q2), third quartile (Q3), and maximum.

beginner

How does Tableau help create box plots?

Tableau can automatically generate box plots using built-in analytics features by dragging a measure and dimension, then selecting 'Box-and-Whisker Plot' from the Show Me panel.

intermediate

What does an outlier represent in a box plot?

An outlier is a data point that lies far outside the typical range, beyond the whiskers, indicating unusual or extreme values.

intermediate

Why is distribution analysis important in business intelligence?

It helps identify patterns, variability, and anomalies in data, enabling better decision-making and spotting trends or risks.

Which part of a box plot shows the median value?

A The top whisker

B The dots outside the box

C The bottom whisker

D The line inside the box

The median is represented by the line inside the box in a box plot.

In Tableau, how do you create a box plot?

A Use the Show Me panel and select 'Box-and-Whisker Plot'

B Manually draw shapes on the dashboard

C Use a pie chart and change colors

D Create a scatter plot and add trend lines

Tableau's Show Me panel includes a box-and-whisker plot option that automatically creates the visualization.

What does the length of the box in a box plot represent?

A Range between minimum and maximum

B Interquartile range (Q3 - Q1)

C Distance between outliers

D Total number of data points

The box length shows the interquartile range, which is the middle 50% of the data.

What is the purpose of whiskers in a box plot?

A Show the mean value

B Highlight the median

C Indicate the spread outside the quartiles up to a limit

D Display the total count of data points

Whiskers extend to show data spread outside the quartiles but within a defined range, excluding outliers.

Which of these is NOT typically shown in a box plot?

A Data labels for each point

B Quartiles

C Outliers

D Median

Box plots do not usually show labels for each data point; they summarize data distribution.

Explain how a box plot helps you understand data distribution.

Think about how the box and whiskers show where most data lies and what is unusual.

Describe the steps to create a box plot in Tableau and what insights it provides.

Focus on Tableau's interface and what the box plot reveals about data.