I have been requested to analyse how consistent the drivers were over a whole race and compare average lap times, with standard deviations included. I start by copying all the lap times into a spreadsheet and taking all the laps (minus any safety car periods) and calculating the mean and Standard Deviation.
Then I make a graph with the calculated data. From the graph made, the dots represent the mean average lap times and the vertical bars cover one standard deviation from the mean. Laps driven under the safety car are also not considered because these were not set competitively.
I was also requested by Maverick to look at the lap times without the in-laps and out-laps for the pit stops included… and the results are, well, interesting to say the least. A lot of drivers change position and it really shows how important strategy is in deciding the outcome of a race – For example in some races, Barrichello has been slower than Button but if you take away the pit stops (as he was on a different strategy), he was often very close!
Pingback: Belgium – Driver Consistency « Making Up The Numbers
Pingback: Driver Consistency – Japan « Making Up The Numbers
Pingback: Driver Consistency – Brazil « Making Up The Numbers
Pingback: Driver Consistency – Abu Dhabi « Making Up The Numbers
Pingback: 2009 In Review – Driver Classification « Making Up The Numbers
Pingback: 2009 In Review – Driver Consistency « Making Up The Numbers
Pingback: F1 Testing – Barcelona Day 1 « Making Up The Numbers
Pingback: F1 Testing 2010 – Barcelona Day 2 « Making Up The Numbers
Pingback: F1 Testing 2010 – Barcelona Day 3 « Making Up The Numbers
Pingback: F1 Testing 2010 – Barcelona Day 4 « Making Up The Numbers
Pingback: Barcelona Testing Summary 2010 « Making Up The Numbers
Pingback: Fantasy Racers 2010 – Bahrain « Making Up The Numbers
Pingback: Driver Consistency – Bahrain 2010 « Making Up The Numbers
Pingback: Fantasy Racers 2010 – Melbourne « Making Up The Numbers
Pingback: Driver Consistency – Australia « Making Up The Numbers
Pingback: Fantasy Racers 2010 – Sepang « Making Up The Numbers
Pingback: Driver Consistency Malaysia « Making Up The Numbers
Pingback: Shanghai – Driver Consistency « Making Up The Numbers
Pingback: Barcelona – Driver Consistency « Making Up The Numbers
Pingback: Monaco Qualifying Analysis « Making Up The Numbers
Pingback: A Little Housekeeping… « Making Up The Numbers
Pingback: Monaco – Driver Consistency « Making Up The Numbers