2017 Bike Stats

2017 Cycling Stats

By Bike

Data were recorded from 1/1/17 to 12/31/17

Bike names were truncated for ease of visualization:
1. Masi FG = Masi Speciale Fixed FG Road
2. Masi LTD = Masi Speciale Fixed LTD FG Road
3. Lang FG = Specialized Langster FG Road
4. Roub EXP = Specialized Roubaix EXPERT Road
5. Tri COMP = Specialized Tricross COMP CX Road
6. Tri EXP = Specialized Tricross EXPERT CX Road
7. Tri SING = Specialized TriCross SINGLE CX Road

90.3% of rides are covered by only 4 bikes.

90.6% of distance is coverd by only 3 bikes.

By Day of the Week

Speed doesn’t vary day to day, but Distance definitely does: longer rides on the weekends, shorter rides on weekdays. Monday has slightly longer rides, likely because Monday is sometimes part of a 3 day weekend.

Over Time

Altitude Gain and Distance

Call:
lm(formula = Altitude.Gain..ft. ~ Distance..miles., data = bikes)

Residuals:
    Min      1Q  Median      3Q     Max 
-656.05 -185.36  -47.61  143.65 1268.33 

Coefficients:
                 Estimate Std. Error t value Pr(>|t|)    
(Intercept)      -198.335     70.816  -2.801  0.00586 ** 
Distance..miles.   44.786      1.827  24.510  < 2e-16 ***
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 325.1 on 133 degrees of freedom
Multiple R-squared:  0.8187,    Adjusted R-squared:  0.8174 
F-statistic: 600.7 on 1 and 133 DF,  p-value: < 2.2e-16

Year-by-year Comparison

Year-by-year Overview

Seems like he’s going on longer rides (the number of rides used to outpace the distance, but that hasn’t been the case over the past 3 years). Let’s see if this is true based on average distance.

Average ride distance was almost identitical over the first 3 years and has definitely decreased in recent years.

Here’s an alternative barplot visualization of Ride Frequency and Distance.

The highest total distance occurred in 2012, while the lowest total distance occurred in 2014. 2017 was about par for the case, with total distance around 4800 miles in 2013, 2015, and 2017.

Altitude gained follows a similar trend to the distance gained. Let’s take a closer look at the highest distance year, lowest distance year, and last year.

He was on an even slower pace than he was in 2014 headed into the summer months, but made up a lot of ground and finished around the average mileage total. The mileage gain in 2012 was consistently paced throughout.

Although 2012 was by far the best year in terms of distance gained, the average speeds were a lot more erratic. Much more consistent riding in 2017.

2016 consisted of much longer rides than any other year (shown by the higher median and longer upper whisker than other years). The individual points show outliers (greater than 1.5*IQR higher than the 75th percentile). The plot shows that the large total distance in 2016 is explained by longer rides, while the large total distance in 2012 is explained by a greater volume of bike rides.

An alternative representation that proves the hypothesis above. The violin plots show the relative density of points. In 2012, there’s a greater density of shorter-distance rides, while in 2016, the density is higher around the median.

Ride Type by Year

An overwhelming majority of the rides are Rolling Road rides over the past 6 years. Last year, no off-road rides were recorded and only one Hills Road ride has been recorded in the past 4 years.

Bike Type

Finally, we’ll look at the bikes used for the road rides over the past 6 years.

The 10 bikes used over the past 6 years are shown in the table below. Values for altitude gain, distance, and speed are average values for each bike.

Bike	Rides	Alt. Gain (ft)	Distance (mi)	Speed (mph)
Masi Speciale Fixed FG Road	33	560.3636	20.68303	13.311976
Specialized Langster FG Road	102	923.1275	29.45637	14.854365
Specialized Rockhopper EXPERT 29er	2	441.5000	12.65000	8.899292
Specialized Roubaix EXPERT Road	310	2117.2774	47.41097	15.208614
Specialized Tricross COMP CX Road	241	1274.5643	33.17975	14.394964
Specialized Tricross SPORT CX Road	18	678.6667	16.50889	13.841827
Centurion Super Le Mans FG Road	63	665.6349	20.63762	13.897439
Masi Speciale Fixed LTD FG Road	28	564.6429	19.96429	13.514350
Specialized Tricross EXPERT CX Road	41	1437.4390	35.49049	14.458006
Specialized TriCross SINGLE CX Road	8	346.3750	21.51250	12.514158

Rides by Day

A lot more weekday rides in 2012 and 2017 than there were in other years. Pretty consistent Sunday and Saturday riding, with a couple of years exhibiting more than 52 rides on those days.

As expected, a lot more distance is accumulated on the weekends while weekdays are usually shorter rides.