My Math Forum  

Go Back   My Math Forum > High School Math Forum > Algebra

Algebra Pre-Algebra and Basic Algebra Math Forum

LinkBack Thread Tools Display Modes
February 26th, 2010, 06:07 PM   #1
Joined: Feb 2010

Posts: 2
Thanks: 0

Help on comparing differing sets of data

Hi guys, I'm hoping you can help me figure something out. I'm running a video game website, and on this website we have a scoreboard that tracks scores that players submit, ranking them from best to worst.

It currently tracks two different types of events - racing (time submissions like 2:03.22) and tricking events (score submissions like 3,227,896). The scoreboard then ranks them from best to worst accordingly - highest score on top, lowest time on top. None of this is surprising I'm sure.

But now we come to my hangup, and that's why I'm asking for some advice from people who know about mathematical terminology and formulas. I'm trying to build a "ranking system" that lists who are the best players based on certain criteria. For example, who is the best racer or likewise, and who is the best overall across many different tables of scores.

One of the things I'd like to do is weight the scores to an independent figure, say something like 1000. For score submissions, that's easy, you simply divide the score submitted by the highest score:

say the score is 100,000, and the top score is 125,000 this makes the formula (100,000 / 125,000) * 10000 = 800. So the top score would have an integer of 1000, the scores below would all be below that. Easy, right?

Now here's the kicker: how do you do this for TIMED rankings since the fastest time is the best? For example, if Bob has a time of 1:00 and Tom has a time of 1:05, what's the mathematical formula to equate these scores so that Bob's score ranks to 1000 and Tom's score is some figure below that?

1. Bob: 1:00 --- 1000
2. Tom: 1:05 --- 995 (or whatever the formula says it is)

I KNOW this is not that hard, but I can't wrap my head around it, nor can I find a formula online that tells me how to do this. Can you think of anything off the top of your head?
carter22 is offline  
February 26th, 2010, 06:24 PM   #2
Senior Member
Joined: May 2008
From: York, UK

Posts: 1,300
Thanks: 0

Re: Help on comparing differing sets of data

You could use something like where is the time in seconds, is the best time and is a scaling factor. This formula would basically take points off for each second past the best time. This has the disadvantage that if is greater than 1000, you get a negative point score - you could just let it be zero in this case, or if you wanted a non-zero score for any time you could use something like which reduces the score by a factor of for each second past the best time - e.g. for

t --- Score
60 | 1000
65 | 951
70 | 904
75 | 860
120 | 547
180 | 299
mattpi is offline  
March 1st, 2010, 05:49 PM   #3
Joined: Feb 2010

Posts: 2
Thanks: 0

Re: Help on comparing differing sets of data

Yes, that seems like it might do the trick. Thank you!

The only concern I see is that there are many different levels of "time ceilings" we could use on these tracks - some tracks take 5 minutes, other tracks take 30 minutes. We would want a spread of scores on the same curve as those that the score events have, to be sure that there is an equivalent relationship between the two events.
carter22 is offline  

  My Math Forum > High School Math Forum > Algebra

comparing, data, differing, sets

Search tags for this page
Click on a term to search for related topics.
Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Two data sets fitting Simon39 Abstract Algebra 4 November 29th, 2013 09:41 PM
Interpolation of larga data sets godric Real Analysis 1 August 31st, 2012 05:53 AM
Combining 2 data sets Shakarii Advanced Statistics 1 August 10th, 2012 02:32 AM
Goodness of fit metrics for comparing non-linear data series willf Advanced Statistics 0 January 24th, 2012 04:22 AM
Comparing multiple data sets with different n values cboldon Advanced Statistics 2 April 7th, 2008 03:01 PM

Copyright © 2019 My Math Forum. All rights reserved.