Makeover Monday: Results Voided

7/11/2017 Matt Chambers 0 Comments

For this week's Makeover Monday, I wanted to do something a bit more analytical.  I wanted to see if you could statistically detect when a cyclist may be using performance enhancing drugs.  Using Z score calculations in Tableau, I was able to see which years out of the last 20 were potential outliers. A good test for an outlier is +-2 Standard Deviations.  Once I built the Z score calculations and applied it, you can see that in 2005 there was a fairly strong outlier.  This is the only occurrence in 20 years where the average speed was 2 standard deviations faster than the mean and also the fastest speed in Le Tour de France history.  This record was set by Lance Armstrong, who later confessed to using performance-enhancing drugs in 2013.