COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

How to score random rankings

• Email
• Follow

```This is more of a mathematical question than a FileMaker one, but I
thought maybe someone in this group might have come across it in their
programming:

I have an FM11 database designed to distribute ranked items to four
participants using random assignment in rounds of four.  I want to be
able to grade how well each player did in getting to pick first,
second, third and fourth when all the rounds are completed.

Specifically, there are 100 items, each of which constitutes a
record.  There are four players interested in the items, so there are
four number fields in each record -- one for each of player.  Each
player uses his number field to rank his interest in an item from 1 to
100.  Taken as a whole, players will rank the items differently and
there may be some items for which no rank is given if the player isn't
interested at all.  Each round, the database randomly decides who gets
to pick first, second, third and fourth, then assigns the top ranked
item in that player's list to them, removing the item from contention.

I'd like to build some tolerances into the system so that if the
random distribution ends up favoring one player too much -- say with a
lot of first-choice picks -- or another player too little -- say with
a lot of last-choice picks, the players can decide ahead of time that
the distribution should be done over.  However, in order to grade how
well each player did in an overall distribution, I have to be able to
weight how much each position is worth relative to the others in the
round.  For example, here are two sample distributions:

Sample A
Pick Number:	1	2	3	4
Sam         	4	8	5	8
Raphael     	8	5	6	6
Peter        	5	5	9	6
Herb         	8	7	5	5

Sample B
Pick Number:	1	2	3	4
Sam         	4	7	7	7
Raphael     	9	5	9	2
Peter        	7	6	5	7
Herb         	5	7	4	9

In Sample A, Sam only gets 4 first-choice picks, which isn't that
great compared to Raphael's 8, but he gets 8 second-choice picks,
which is better than Raphael's 5.  Taking into account their third-
and fourth-place picks, what would the overall grade be for how well
they did in the lineup?  Is Sam's result in Sample B -- 4 first, 7
second, 7 third and 7 fourth -- better than Herb's, since Herb got one
more first-place pick but 3 fewer third-place picks?

How would I score this?  There must be a standard statistical model
that's been developed over the years so that I wouldn't have to make
something up that wasn't accurate.  And further complicating the issue
is that not everyone participates in every round, since not everyone
is interested in all 100 items.  So it wouldn't be a matter of just
saying how many first-place picks to each player get relative to each
other:  a player that participates in every round is much more likely
to get more first-place picks than a player that's only interested in
half the items.

Makes sense?  What do you think.

Thanks for your help,
-J.
```
 0
Reply jahnbigbooty (106) 4/9/2011 9:14:57 PM

See related articles to this posting

```On 2011-04-09 14:14:57 -0700, jahn <jahnbigbooty@yahoo.com> said:

> Each round, the database randomly decides who gets
> to pick first, second, third and fourth, then assigns the top ranked
> item in that player's list to them, removing the item from contention.
>
> I'd like to build some tolerances into the system so that if the
> random distribution ends up favoring one player too much --

I have no idea how to score your game. Sounds like you want some kind
of weighted total.  I'm only going to respond to the section quoted
above.

This is where you're going to get into trouble, mathematically speaking.

If it's random, don't mess with it.

What people have a hard time understanding is that truly random results
can include sequences that LOOK like they're non-random, or biased.  A
truly random result is not going to be equitable, or reasonable or "not
really favoring one player over another."  Sometimes random numbers
come up all ones, or twos. Randomly. Low probability sequences do
happen.

"Tolerances," to me, is just one more way of saying "the house always
wins." Not that you're intending to win anything from these players,
but you know what I'm talking about. Vegas casinos build in
"tolerances" to make sure a certain percentage of bets fall their way,
and that's enough to make them profitable.

If in the effort to make it seem that equitable choices are being made,
you bias the results, then it's not random and you should acknowledge
that to your players right up front, along with an explanation of the
rules or algorithms you're using.

First, though, you have to make up some rules as to what's allowed.
What's going to make it *seem* fair?  If one person has too many first
picks, or too many last picks, they get a bump in the opposite
direction?

The game would tend to even out all results toward the middle because
of the rules. Is that what you want?

It sounds really complicated and likely to get more so as you develop
your scoring system. Some people love that kind of complexity. Some,
not so much. ;)
--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

```
 0
Reply lynn711 (255) 4/9/2011 11:55:22 PM

```Hi, Lynn -

Thanks as always for weighing for in.  I agree with your assessment of
the problems with randomness.  I think RadioLab did a show on this
recently -- great podcast.  The difference between casino tolerances
and the tolerances I'm looking for is that the casino is aiming to
bias the results in their favor, whereas I'm looking for a solution in
which results that are too biased (as a result of the problems of
randomness) are excluded.  If there's a way to weight numbers so that
an overall score can be assigned to a given distribution, then there's
a way to create a system in which only equal scores are accepted (or
relatively equal scores within a given tolerance).  So when you say
"first you have to make up some rules as to what's allowed" -- that
actually _is_ the question I'm asking; the rest is just programming.
What I'm looking for is to know whether there are established criteria
for grading these kinds of distributions.  But perhaps I need to find
a statisticians user group for that!

Thanks for your help.

Best,
-J.
```
 0
Reply jahnbigbooty (106) 4/13/2011 7:18:59 PM

2 Replies
62 Views

Similar Articles

12/6/2013 8:57:44 AM
[PageSpeed]

 Reply:

Similar Artilces:

uniform random variable
Given 2 independent uniform random variables X,Y = U [0,1], consider the random variables Z = g (X,Y) for g (x,y) = sqrt (-2ln(x) ). cos(2piy)..This is the condition.So I need to go for matlab program as the analytic method is tough 1 - 10,000 uniformly distributed random samples for X and Y 2 - For each sample of X and Y, compute Z= g(X,Y) 3 - Draw a histogram over the resulting samples in Z 4 - Estimate the moments mZ for n = 1,2....6. DSPtree <paulscot45@yahoo.com> wrote in message <2024364947.79076.1273099076053.JavaMail.root@gallium.mathforum.org>... > Given 2 independent uniform random variables X,Y = U [0,1], consider the random variables Z = g (X,Y) for g (x,y) = sqrt (-2ln(x) ). cos(2piy)..This is the condition.So I need to go for matlab program as the analytic method is tough > > 1 - 10,000 uniformly distributed random samples for X and Y > 2 - For each sample of X and Y, compute Z= g(X,Y) > 3 - Draw a histogram over the resulting samples in Z > 4 - Estimate the moments mZ for n = 1,2....6. Surely you have tried something? If not, why not? John DSPtree wrote: > Given 2 independent uniform random variables X,Y = U

[OT] Random links
Just for fun: http://www.crapville.com/funnypics/urinal.asp http://www.crapville.com/media_videos12/gemsweater.wmv http://z.wimp.com/a/rubberjohnny.swf -- Tux rox! Lin=F8nutlin=F8nut@bone.com wrote: > Just for fun: > > http://www.crapville.com/funnypics/urinal.asp > > http://www.crapville.com/media_videos12/gemsweater.wmv > > http://z.wimp.com/a/rubberjohnny.swf > Random letters... Just for fun: zcxvnasdfpoiapewrafsdfl I can do random numbers too! 2409872350987120498124 In comp.os.linux.advocacy, lqualig@uku.co.uk <lqualig@uku.co.uk> wrote on 21 Jul 2005 09:30:32 -0700 <1121963432.363503.46760@g14g2000cwa.googlegroups.com>: > > > Lin�nutlin�nut@bone.com wrote: >> Just for fun: >> >> http://www.crapville.com/funnypics/urinal.asp >> >> http://www.crapville.com/media_videos12/gemsweater.wmv >> >> http://z.wimp.com/a/rubberjohnny.swf >> > > > > Random letters... Just for fun: > zcxvnasdfpoiapewrafsdfl > > > I can do random numbers too! > 2409872350987120498124 > If you're going to do that at least

bug in j2me implementation of Random?
bug in j2me Random implementation? From: tom arnall <kloro2006@gmail.com> To: Date: Sunday 05:17:49 pm the following: public class Test1 extends MIDlet implements CommandListener { public void startApp() { Random rand = new Random(); System.out.println(rand.nextInt(5)); } . . . from the J2me compiler gets: home/kloro/cell/WTK2.2/apps/Test1/src/Test1.java:11: nextInt() in java.util.Random cannot be applied to (int) System.out.println(rand.nextInt(5)); yet the doc' for Random states in the methods section: nextInt(int n) - Returns a pseudorandom, uniformly distributed int value between 0 (inclusive) and the specified value (exclusive), drawn from this random number generator's sequence. same type of result for long, double, short. kloro wrote: > bug in j2me Random implementation? > From: > tom arnall <kloro2006@gmail.com> > To: > Date: > Sunday 05:17:49 pm > the following: > > public class Test1 extends MIDlet implements

Random number generation #2 383126
hello everybody can anyone tell that if we have a random number in a particular range and a key(seed), can we know which procedure is used to generate this no. using MATLAB seed is 100111 and randonm number is 1066104 range is 106*10^ 4 - 107*10^4 thank u

Random Oblivion thoughts .. and bug(let)s
;>up - has anyone? In MW it was fairly trivial to get +5 on all 3 >>attributes every time, if you wanted to train too much. > >I'm not sure how much you have to level a minor skill to get +5 but its not >hard to do. I levelled to 15 and found that light armour had only got +3. I >was deliberately trying to raise my Speed so I went to a trainer in Bravil and >trained 3 times. This got me +5. OK, It's hard to do =without training=. And early on training is pretty expensive compared to the loot you find, unless you go training random stuff you don't really

genrate uniform random variable from a set
Is there away to genrate random number from a set of numbers for example random number from the set {1,3,4,6,9} "Namo " <namo1983@hotmail.com> wrote in message news:hq7br0\$mll\$1@fred.mathworks.com... > Is there away to genrate random number from a set of numbers > > for example random number from the set {1,3,4,6,9} > Use RANDI to generate a random integer between 1 and NUMEL of the set, then use that random integer as an index. myset = [1 3 4 6 9]; indices = randi([1 numel(myset)], 10, 10); values = myset(indices) -- Steve Lord slord@mathworks.com comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ "Namo " <namo1983@hotmail.com> wrote in message <hq7br0\$mll\$1@fred.mathworks.com>... > Is there away to genrate random number from a set of numbers > > for example > random number from the set {1,3,4,6,9} one of the many solutions s={1,3,4,6,9}; % <- set n=5; % <- # of randomly chosen elements of S ix=ceil(5*rand(1,n)); r=[s{ix}] % r = 9 6 3 6 6 % <- current state of RAND... us

(X-post) SID-to-(random audio format) conversion
Greetings and apologies for the cross-posting, the question seemed fitting for both newsgroups. Apart from the usual conversion of SIDs to a WAV format through either SidPlay/W or the SidAMP-DiskWriter combo, is there any other conversion program or method? To be specific, I'm looking for a converter that would transcribe it into MIDI, or better yet, any tracker format (s3m/it/xt/mod) for easier resampling. I'm interested in how exactly SIDs tick, so using a mod-format woul help me track the melodies on all channels. Thanks in advance. In comp.emulators.cbm Stealth <protostealt

SQL syntax to update records with diff'rent function generated random PINS
I use a function, myrandomPIN (), to generate random PIN numbers. The following sql query updates records with the SAME PIN number but. I want to generate DIFFERENT pin numbers for every record. The function is ok but I can't figure out how to run it individually for each record. In other words I do not know the correct syntax to use UPDATE in a loop (if necessary) so that a different call to the function is done every time or ecah record ends up with a different PIN. Or may be this can be done with a single mysql_query(\$sql2)??? ---------------------------------------------------------------------------- \$qr = @mysql_query(\$sqlb1) or die("ERROR"); \$rs1 = mysql_fetch_array(\$qr); \$thepin=myrandomPIN(); \$sql2="UPDATE clients SET pin='\$thepin' WHERE code='".\$thecode."'"; \$qr = @mysql_query(\$sql2) or die("ERROR""); -------------------------------------------------------------------------- Thanks "John Pastrovick" <pastrovic2k@hotmail.com> wrote in message news:a21852f1.0404121212.21899286@posting.google.com... > I use a function, myrandomPIN (), to generate random PIN numbers. > >