Tools: Jupiter Notebook / Python /Pandas/ Tableau
Insight and Conclusion
Observations: n = 1,150
Miles Mean: 10.09 miles
Median (50th percentile): 6.00
Miles Range: min 0.0, max 310.0 miles
Spread: std dev ≈ 21.56 miles Q1–Q3: 2.0 miles (25th percentile) to 10.0 miles (75th percentile)
There is a wide range with a long tail toward higher mile values, and the mean is higher than the median, suggesting right-skewness.Duration_Time
Mean: 1,399.36 seconds (≈ 23.32 minutes)
Median: 990.0 seconds (≈ 16.5 minutes)
Range: min 60.0 s, max 20,160.0 s
Spread: std dev ≈ 1,640.59 seconds Q1–Q3: 600 s to 1,680
The mean is notably higher than the median, indicating substantial right skew and a few long-duration observations. The maximum duration is over 5.6 hours (20,160 s).
Potential interpretations:
The dataset likely contains trips or runs with varying lengths: Short trips cluster around a few minutes
(median ~16.5 minutes). A minority of trips are very long (max ~5.6 hours), pulling the mean up. If Miles and Duration_Time
are paired per observation (i.e., each row is a trip with its distance and duration), you might expect a positive relationship
