Statistics Quest

Delivery times under old and new routing (independent samples)

Individual parcel delivery times for a random sample of deliveries from the fictional Swiftdune Couriers: 80 deliveries routed by the old system and 76 by the new route-optimisation system, sampled on different days and routes. Each row is one delivery. Unlike delivery_process (paired by route), the two groups here are independent samples, and individual deliveries vary a lot, so the same true saving is much harder to detect.

Rows
156
Columns
5
One row is
one parcel delivery
Version
v1

Data dictionary

ColumnTypeUnitSummaryDescription
delivery_id
Delivery
idDelivery identifier.
system
Routing system
category2 levels: old, newWhich routing system planned the delivery.
date
Date
dateDelivery date.
distance_km
Route distance
numberkmmean 37.89, median 34.05, SD 16.33, range 8–101.8Length of the route the parcel was on.
delivery_min
Delivery time
numberminutesmean 43.06, median 39.95, SD 14.55, range 17.3–91.5Time from leaving the depot to hand-over.

What it is good for

  • Run a Welch two-sample t-test and a Mann–Whitney test and interpret them.
  • Explain why independent samples need more data than a paired design for the same effect.
  • Check skewness and unequal spread before choosing a test.

Methods: Welch t-test, pooled t-test, Mann–Whitney U test, confidence interval for a difference in means, power.

Data quality notes

  • Delivery times are right-skewed (log-normal variation).
  • The true saving is 3 minutes, but with this sample size the difference may not be statistically significant — a teachable contrast with the paired data.
  • No missing values.

Provenance and licence

Each delivery's time = route-level average (as in delivery_process: ≈ 18 + 0.25·distance + 0.6·stops) − 3 minutes under the new system, multiplied by log-normal delivery-to-delivery variation (sd 0.25 on the log scale), rounded to 0.1 minute. Old-system deliveries come from the four weeks before the change, new-system deliveries from the four weeks after.

Synthetic data · CC0-1.0 (synthetic data generated by Statistics Quest) · generated deterministically (seed 20241118). It does not describe real people or organisations; any resemblance is coincidental.

Preview

Dataset

Delivery times under old and new routing (independent samples)

156 rows · one row = one parcel delivery · synthetic data

DeliveryRouting systemDateRoute distance (km)Delivery time (minutes)
D001old2024-04-1339.647.3
D002old2024-04-1725.535.8
D003old2024-04-2818.638.2
D004old2024-04-2834.946.1
D005old2024-04-0737.429.1
D006old2024-04-161360.4
D007old2024-04-1531.138.9
D008old2024-04-3053.148.4
D009old2024-04-1616.549.2
D010old2024-04-2020.425.2
D011old2024-05-0435.129.5
D012old2024-04-1122.137.4

Used in