I have averaged out the season so far

Antony Snook · Aug 14, 2013

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"

Jax Humanhater · Aug 14, 2013

Not again, Antony!

*facepalm*

Bradley Vanian · Aug 14, 2013

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.

Tony Holder · Aug 14, 2013

Just when you thought it was safe.....

Ho3n3r · Aug 14, 2013

There we go.

Tony Holder · Aug 14, 2013

Dewald Nel said:
There we go.

And http://www.online-calculator.com/

Markus Neumann · Aug 14, 2013

Antony Snook said:
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"

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.