1. Departmental Performance Comparison
Data AnalystBackground
A manager needs to compare the response times of three different customer support teams to identify performance gaps.
Problem
Raw data is too dense to interpret, making it difficult to see which team has the most consistent performance versus those with extreme outliers.
How to use
Input the response time data for each team into the Box Plot Data field and enable 'Show Statistics' to get a summary table alongside the chart.
{"Support Team A": [12, 15, 18, 20, 22, 25, 30], "Support Team B": [10, 11, 12, 13, 14, 15, 45], "Support Team C": [15, 16, 17, 18, 19, 20, 21]}Outcome
The box plot clearly highlights that Team B has a significant outlier (45 minutes), prompting a deeper investigation into that specific shift.