1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I have averaged out the season so far

Discussion in 'Formula 1' started by Antony Snook, Aug 14, 2013.

Thread Status:
Not open for further replies.
  1. Antony Snook

    Antony Snook

    Messages:
    195
    Ratings:
    +14
    I have been on the internet looking for the average formula. I know i used it in school some 20 years ago but never applied it. Tried to do it in Excel but boxes and variables messed it up so i did it old school with pen and paper. I calculated 10 rounds so far and the highest score is 25 so that's 250 as the maximum score and divided it by the points of the driver making a decimal.
    The weird thing is the lower the number the better the average and the higher the worse. So when i put it into a chart "The values go backwards so its a mind bender" :O_o::thumbsdown::thumbsup:
     

    Attached Files:

  2. Mohamedou Ari

    Mohamedou Ari
    F1 Sim Racer & #1 St. Bernard Lover on RD Premium

    Messages:
    3,004
    Ratings:
    +605
    Not again, Antony!

    *facepalm*
     
  3. Bradley Vanian

    Bradley Vanian

    Messages:
    2,551
    Ratings:
    +1,160
    I have just injured myself by facepalming so hard.

    If you had a grasp of basic mathematics, you would know you should be dividing the Points by the Maximum.

    So for Vettel, (172/250)*100

    Also, I can see NO POINT in you doing this. This shows no relevant statistic that we didn't already know.

    Plus it doesn't actually work as a pie chart as you have over 100% of what you think is the maximum. 250 isn't the maximum overall, just the maximum for one person.
     
    • Like Like x 2
  4. Tony Holder

    Tony Holder

    Messages:
    1,624
    Ratings:
    +541
    Just when you thought it was safe.....

    [​IMG]
     
    • Like Like x 4
  5. Ho3n3r

    Ho3n3r

    Messages:
    5,022
    Ratings:
    +1,491
  6. Tony Holder

    Tony Holder

    Messages:
    1,624
    Ratings:
    +541
    • Like Like x 1
  7. Markus Neumann

    Markus Neumann

    Messages:
    1,109
    Ratings:
    +357
    You've encountered a common bug in Microsoft Excel which can occur when performing mathematical calculations beyond the user's capability. In my experience, pressing the shortcut "Alt+F4" can often solve the problem.
     
    • Like Like x 5
  8. Tom

    Tom
    Staff Emeritus Premium

    Messages:
    5,815
    Ratings:
    +3,200
    I...I....no...I don't even know what to say. But I'll close this thread for your own good, trust me. :D

    Tom
     
    • Like Like x 2
Thread Status:
Not open for further replies.