Monday, October 12, 2015

Twin Cities Marathon 2014 vs 2015 Analysis

I'm back from running the Chicago Marathon and already wishing I wasn't back in San Diego (90 degrees by the coast... in mid Oct). I managed to compile Twin Cities last week but this weekend was busy (flying with a toddler in my lap, running a marathon, more flying with toddler).

Someone requested if I could break the margin of qualification by AG so I did that here.

Here is the breakdown of Twin Cities Marathon age group qualifiers, year over year.

AG Group2014 AG Total2014 QualifiersPercentage2015 AG Total2015 QualifiersPercentage
M183419261779.19%18001307.22%
M3539707709.90%776627.99%
M4044671608.94%678659.59%
M45495648114.36%5217013.44%
M50544656814.62%4426614.93%
M55592955317.97%2963311.15%
M60641403222.86%1483120.95%
M6569611422.95%621524.19%
M707424833.33%19210.53%
M75793133.33%8337.50%
M80+000.00%3133.33%
F183421191898.92%19771839.26%
F35396546610.09%6287011.15%
F40445376912.85%5026212.35%
F45493357221.49%3176520.50%
F50541983618.18%2033919.21%
F55591092623.85%1052422.86%
F6064331133.33%40717.50%
F656911654.55%15746.67%
F7074100.00%200.00%
F7579000.00%000.00%
F80+000.00%000.00%
Totals8853103916.85%854293515.92%

Finishers are down. Qualifiers are down, and the percentage of qualifiers are down. Let's look at the margins.

Margin2014Percentage2015Percentage
<1 minute706.74%525.56%
1-2 minutes585.58%444.71%
2-3 minutes535.10%404.28%
3-4 minutes444.23%485.13%
4-5 minutes716.83%394.17%
5-10 minutes21320.50%19721.07%
10-20 minutes25624.64%24325.99%
20> minutes27426.37%27229.09%
Totals1039935

Qualifiers in 2014 over 5 minutes were 71.5%. In 2015 they are 75.7%. So a significant shift towards qualifying with more margin (but... fewer qualifiers).

Alright folks, I really wanted to get the totals done today but I'm just not going to have the time. Will do it tomorrow though - the formatting into the block is the biggest time-suck. I think, though, that I may always separate individual race data with total data into different posts because there's a lot of tables and data for one race alone.

But you can see, just by looking at the totals of St George and Twin Cities, qualifier totals are down, with a shift towards more margin of qualification.

Bonus Data for Twin Cities:

Age group breakdown 2014:

AG< 1 min1-2 min2-3 min3-4 min4-5 min5-10 min10-20 min20> min
F18-343.70%6.88%3.70%2.65%7.94%21.16%25.93%28.04%
F35-394.55%3.03%10.61%7.58%9.09%18.18%24.24%22.73%
F40-445.80%5.80%8.70%7.25%4.35%26.09%21.74%20.29%
F45-496.94%5.56%6.94%4.17%6.94%13.89%26.39%29.17%
F50-542.78%5.56%8.33%2.78%5.56%13.89%33.33%27.78%
F55-593.85%0.00%0.00%3.85%0.00%15.38%38.46%38.46%
F60-6418.18%0.00%0.00%9.09%27.27%9.09%27.27%9.09%
F65-6916.67%0.00%0.00%0.00%16.67%16.67%33.33%16.67%
M18-345.65%5.65%3.39%3.39%7.34%20.34%23.16%31.07%
M35-3910.00%7.14%2.86%7.14%10.00%22.86%27.14%12.86%
M40-4418.33%6.67%5.00%5.00%10.00%18.33%20.00%16.67%
M45-4911.11%4.94%6.17%4.94%4.94%18.52%24.69%24.69%
M50-544.41%7.35%4.41%2.94%2.94%29.41%19.12%29.41%
M55-593.77%1.89%9.43%3.77%1.89%30.19%26.42%22.64%
M60-643.13%6.25%0.00%3.13%6.25%12.50%25.00%43.75%
M65-6921.43%14.29%7.14%0.00%7.14%14.29%14.29%21.43%
M70-740.00%0.00%0.00%0.00%0.00%12.50%12.50%75.00%
M75-790.00%0.00%0.00%0.00%0.00%100.00%0.00%0.00%

For 2015:

AG< 1 min1-2 min2-3 min3-4 min4-5 min5-10 min10-20 min20> min
F18-343.283.282.195.463.8321.3132.2428.42
F35-392.868.575.715.712.8628.5721.4324.29
F40-444.848.068.061.616.4519.3522.5829.03
F45-494.627.691.549.234.6227.6923.0821.54
F50-542.562.567.695.137.6915.3817.9541.03
F55-594.170.008.330.004.174.1737.5041.67
F60-640.000.0014.290.000.000.0014.2971.43
F65-690.000.000.000.000.0014.2942.8642.86
M18-346.156.153.857.693.0819.2328.4625.38
M35-399.683.233.233.233.2325.8132.2619.35
M40-4415.384.626.153.080.0026.1516.9227.69
M45-494.295.717.145.712.8621.4317.1435.71
M50-544.550.004.554.559.0921.2128.7927.27
M55-5912.126.063.030.003.0312.1227.2736.36
M60-646.453.230.009.689.6812.9025.8132.26
M65-690.006.670.006.676.6726.6720.0033.33
M70-740.000.000.000.000.000.0050.0050.00
M75-790.000.000.000.000.0033.330.0066.67
M80+0.000.000.000.000.000.000.00100.00





No comments:

Post a Comment