Contact-centre hourly calls
Hourly operations data for 90 days of the customer contact centre of a fictional utility, Brightwell Water Services, open 08:00–21:00. Each row is one day-hour: calls offered, answered and abandoned, agents on shift, average handle time and average wait. Built for the Poisson model of arrivals, exponential-like waiting times, and operational relationships such as staffing vs waiting and waiting vs abandonment.
- Rows
- 1,170
- Columns
- 9
- One row is
- one hour of one day
- Version
- v1
Data dictionary
| Column | Type | Unit | Summary | Description |
|---|---|---|---|---|
dateDate | date | Calendar date. | ||
weekdayWeekday | category | 7 levels: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday… | Day of the week. | |
hourHour | integer | hour | mean 14, median 14, SD 3.743, range 8–20 | Hour starting (8 = 08:00–08:59 … 20 = 20:00–20:59). |
agentsAgents on shift | integer | agents | mean 2.873, median 2, SD 1.292, range 2–9 | Agents logged in during the hour. |
calls_offeredCalls offered | integer | calls | mean 21.38, median 17, SD 13.87, range 0–69 | Calls arriving in the hour. |
calls_answeredCalls answered | integer | calls | mean 18.3, median 15, SD 11.6, range 0–65 | Calls answered by an agent. |
calls_abandonedCalls abandoned | integer | calls | mean 3.081, median 1, SD 5.481, range 0–41 | Callers who hung up before being answered (offered = answered + abandoned). |
avg_handle_minAverage handle time | number | minutes | mean 5.483, median 5.4, SD 1.014, range 3.1–9.1; 1 missing | Mean talk + wrap-up time of answered calls.Missing: Null in hours with no answered calls. |
avg_wait_secAverage wait | number | seconds | mean 146.9, median 55.1, SD 223.4, range 3.4–1355; 1 missing | Mean time callers waited before being answered or abandoning.Missing: Null in hours with no calls offered. |
What it is good for
- Check whether hourly arrivals within a given hour slot behave like a Poisson process (mean ≈ variance).
- Model the daily and weekly arrival pattern.
- Describe right-skewed waiting times and their relationship with staffing.
- Relate abandonment rate to average wait (scatter plot, logistic-style curve).
Methods: Poisson distribution, dispersion index, exponential distribution, scatter plot, correlation, regression, binomial proportions.
Data quality notes
- Arrivals across all hours are over-dispersed relative to a single Poisson because λ changes by hour and weekday; within an hour-weekday slot they are close to Poisson.
- avg_wait_sec is strongly right-skewed: a few understaffed hours have very long waits.
- avg_handle_min / avg_wait_sec are null only when there were no answered / offered calls (rare, early or late hours on quiet days).
Provenance and licence
Calls offered ~ Poisson(λ) where λ follows a two-peak daily profile (late morning and late afternoon, up to ≈55 calls/hour) times a day-of-week factor (Sunday highest, Friday/Saturday lowest). Agents are scheduled from the expected (not actual) load, so busy hours are sometimes understaffed. Average handle time is gamma-distributed around 5.5 minutes. Average wait is exponential-like and grows sharply as utilisation (offered work ÷ agent capacity) approaches 1. Abandoned calls ~ Binomial(calls offered, p) with p rising with the wait.
Synthetic data · CC0-1.0 (synthetic data generated by Statistics Quest) · generated deterministically (seed 20241013). It does not describe real people or organisations; any resemblance is coincidental.
Preview
Dataset
Contact-centre hourly calls
1,170 rows · one row = one hour of one day · synthetic data
| Date | Weekday | Hour (hour) | Agents on shift (agents) | Calls offered (calls) | Calls answered (calls) | Calls abandoned (calls) | Average handle time (minutes) | Average wait (seconds) |
|---|---|---|---|---|---|---|---|---|
| 2024-01-07 | Sunday | 8 | 2 | 11 | 11 | 0 | 4.8 | 48.3 |
| 2024-01-07 | Sunday | 9 | 3 | 16 | 14 | 2 | 6.2 | 81.2 |
| 2024-01-07 | Sunday | 10 | 4 | 38 | 36 | 2 | 5.2 | 186 |
| 2024-01-07 | Sunday | 11 | 7 | 65 | 58 | 7 | 5 | 103.9 |
| 2024-01-07 | Sunday | 12 | 6 | 59 | 58 | 1 | 4.9 | 92 |
| 2024-01-07 | Sunday | 13 | 3 | 20 | 19 | 1 | 6.1 | 35.6 |
| 2024-01-07 | Sunday | 14 | 2 | 9 | 8 | 1 | 5.8 | 45.9 |
| 2024-01-07 | Sunday | 15 | 2 | 22 | 14 | 8 | 4.9 | 317.4 |
| 2024-01-07 | Sunday | 16 | 3 | 31 | 25 | 6 | 6.3 | 388.3 |
| 2024-01-07 | Sunday | 17 | 5 | 50 | 15 | 35 | 6.6 | 874.7 |
| 2024-01-07 | Sunday | 18 | 4 | 37 | 32 | 5 | 5.1 | 183.1 |
| 2024-01-07 | Sunday | 19 | 2 | 14 | 13 | 1 | 6.3 | 57.6 |
Used in
- The Poisson distribution · Probability Distributions
- Uniform and exponential distributions · Probability Distributions
- Choosing and checking a distribution · Probability Distributions
- Time-indexed data · Time Series and Forecasting
- Autocorrelation · Time Series and Forecasting
- Staffing the contact centre · Case