1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
Dismiss Notice
Like RaceDepartment on Facebook.

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. 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. Mohameddo-san

    Mohameddo-san
    F1 Sim Racer & #1 St. Bernard Lover on RD Premium Member

    Not again, Antony!

    *facepalm*
     
  3. 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. Just when you thought it was safe.....

    [​IMG]
     
    • Like Like x 4
    • Like Like x 1
  5. 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
  6. Tom

    Tom
    Staff Emeritus Staff

    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.