Author Topic: Tied Points in Stats  (Read 2220 times)

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Tied Points in Stats
« on: February 21, 2014, 10:02:36 PM »
Hello, we have a league where some players are tied in points. What is the factor that determines how to stay ahead of the other? Can determine the grade point average will be the tiebreaker factor?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Tied Points in Stats
« Reply #1 on: February 22, 2014, 05:46:19 PM »
Are you trying to figure out a way to break the tie?

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: Tied Points in Stats
« Reply #2 on: February 22, 2014, 07:02:03 PM »
Yes, I would use the average score as a tiebreaker.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Tied Points in Stats
« Reply #3 on: February 24, 2014, 01:39:39 PM »
Well, there's no way to know, from a formula point of view, whether two players have "tied" in the Stats.  So you would have to do this "outside" of a formula.  But there might be a way to use an Overall Score formula to do this.  I guess it depends on how you're ranking players.  You've said "points" but also "score".  How are you ranking your players?

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: Tied Points in Stats
« Reply #4 on: February 24, 2014, 01:59:03 PM »
My rank is calculated according to the formula points for playing. In that case is n - r + 1.

See the ranking https://googledrive.com/host/0B2wKdFdgDnquZ0p4RF9MNGIxLWM/ranking.html

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Tied Points in Stats
« Reply #5 on: February 24, 2014, 03:19:51 PM »
OK, so when points are tied, how would you like to break the tie?  You said:

Quote
Yes, I would use the average score as a tiebreaker.

So, what do you mean by "average score"?

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: Tied Points in Stats
« Reply #6 on: February 24, 2014, 03:24:58 PM »
Sorry, the correct is "average points"

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Tied Points in Stats
« Reply #7 on: February 24, 2014, 03:32:42 PM »
Well, you could simply sort the stats by the Points column, and when there's a tie break it by looking at the Average Points column.  But if you want the players listed in their ranking order, I would set one of the Overall Score formulas to:

points + averagePoints

And then sort by that column.  Of course, this could still result in tied players.

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: Tied Points in Stats
« Reply #8 on: February 24, 2014, 04:56:54 PM »
It did not work, look https://googledrive.com/host/0B2wKdFdgDnquZ0p4RF9MNGIxLWM/test.html

See what I have labeled the column "Overall Score", according to the formula + points averagePoints. But if you see the "Points" column was out of order ranking.

Recalling that the first criterion would be the points and in case of a tie, the tiebreaker would be the average points.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Tied Points in Stats
« Reply #9 on: February 24, 2014, 09:36:46 PM »
That's a shame.  I guess I didn't think that someone with fewer points might have played in fewer tournaments and thus have a higher average number of points, ultimately putting him above someone with more points.

I guess you could try adding them as a fraction.  Like points + (averagePoints * .0001).  I don't know how large your players' points are likely to get, but that should work for values under 10,000.

rafatins

  • Newbie
  • *
  • Posts: 20
    • View Profile
Re: Tied Points in Stats
« Reply #10 on: February 25, 2014, 09:53:31 AM »
now it worked, thank you.