# 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:
141
2. ### Mohamedou AriF1 Sim Racer & #1 St. Bernard Lover on RDPremium

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

*facepalm*

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

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

• Like x 4

Messages:
5,022
Ratings:
+1,491

Messages:
1,624
Ratings:
+541
• 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
8. ### TomStaff EmeritusPremium

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.

Tom

• Like x 2