jphachi_rokuThanks for the support AngelCreator
Right now, I'm working on how to display the results so that the it will be easier to understand.
If we display the standard deviation, most people will see a number with decimal places and ask themselves, so what does that mean?
We need some kind of "read me first" portion and sample data to display for people to undestand
Basically, the lower the number, the more consistent (which contradicts the example that I gave earlier) the closer your laptimes are to each other.
if by some fluke that you were able to do 10 laps with times the same to the 0.000 seconds then the Standard deviation is 0. The higher the number, the farther apart your laptimes are from each other.
If figured out the built in function to exel (try it yourself on your own laps, it gives you the feeling that your a formula one engineer)
-first convert the laps into seconds first (for example 1'24.456 will become 84.456)
-enter the laptimes in exel. for example 10 laps will occupy the boxes A1 to A10
-at box A11 type the following: =STDEVP(A1:A10) and press enter
-box A11 will give you the standard deviation (sometimes I get a negative answer, but I checked the math and graphs it seems that the farther you are from 0 the less consistent the samples)
I'm open for suggestion on how we can improve this.
This needs some more brainstorming to become an effective tool in finding the top drivers in GTP
for now, I'll try and make my own data table to serve as an example.
GAHHHHH!!! reminds me of friggin modern statistical analysis class i took last quarter.