• "Bite off more than you can chew and then chew like hell." - Peter Brock

# I have averaged out the season so far

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

Not open for further replies.
1. ### 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"

File size:
13.5 KB
Views:
137
2. ### Mohamedou AriF1 Sim Racer & #1 St. Bernard Lover on RDPremium

Messages:
2,999
Ratings:
+603
Not again, Antony!

*facepalm*

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 x 2
4. ### Tony Holder

Messages:
1,622
Ratings:
+540
Just when you thought it was safe.....

• Like x 4

Messages:
4,996
Ratings:
+1,491

Messages:
1,622
Ratings:
+540
• Like x 1
7. ### 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 x 5