Star Rating Breakdowns

[Bramblethorn]

We're actually talking about different things.

I am saying that the back calculation of votes has a significant probability of error with more than 50 votes.

Can you clarify what you mean by "back calculation" vs. "forward calculation"? I'm not familiar with that terminology.

What you have said is that you can use forward calculations to determine the exact number of votes. I won't dispute that, but I might suggest that doing so isn't very practical--especially if you don't start by doing the back-calculation first.

I think you're rather overstating the difficulty. It just takes a couple of simple spreadsheet formulas and once it's set up, it can be used over and over. The slowest part is the data entry, which you'd have to do for any method. I'm willing to go to the trouble of typing an extra formula, once, for a method that gives perfect certainty up to 100 votes and doesn't estimate 6s.

This is a screenshot of voting results on one of my stories on the morning it posted.

The columns from left to right are the # of votes, score, estimated # of *s, the change in *s, the change in votes, then the estimated # of votes from one to five. If the number of votes cast (5th column) is one, then the change in the *s (4th column) is the estimated vote.

The screenshot shows obvious errors at 64 votes and 72 votes. The errors are only obvious because you can't get 6 *s from one vote. Any of the other estimated votes could also be in error.

Nice scores!

For comparison, here's what I get when I do it my way, using the same inputs as your example. It took literally two minutes to set up this spreadsheet, and it gives exact numbers with no uncertainty and no 6s. From that table, I can figure out that you got exactly 24 five-star votes and 4 four-star votes during that period, with no 1s, 2s, or 3s... which is the answer to the OP's question. All that for far less effort than either of us have spent discussing the issue here.

For vote counts over 100, "unrounded score" and "change in stars" would be ranges based on min and max # of stars, but in this example there's no space between them so I've just left one column.

 

[sr71plt]

Think of the actual writing you folks could be doing.

 

[NotWise]

Can you clarify what you mean by "back calculation" vs. "forward calculation"? I'm not familiar with that terminology.

"back" calculate mean deriving the unknown # of *'s voted through a formula like:

T=round(N1*S1-N0*S0)

N1 and N0 are the current and previous number of votes
S1 and S0 are the current and previous ratings.
T is then the change in the total number of stars voted, which translates to the value of the vote if there's only one vote.

"forward" calculate means to derive the number of stars by finding out what is necessary to achieve the reported score, given the change in votes and the number of stars in the previous vote.

 

[Bramblethorn]

Think of the actual writing you folks could be doing.

It's a good thought, but Saturday morning isn't great for writing for me; for some reason I find stories flow better at night.

Arguing mathematics, that I can do 24/7 ;-)

 

[SimonDoom]

Think of the actual writing you folks could be doing.

LOL. I say this to myself sometimes, especially when I've been complaining to myself about not getting a story done and instead am brainstorming a reply to something someone said on these threads.

 

[ChloeTzang]

Think of the actual writing you folks could be doing.

I tell myself that too, yet here I am, reading all the new posts in my writing time.....

 

[OnceHotNowNot]

I found this thread and figured it was a good one to bump.

I'm so glad there are other people as neurotic as me when it comes to tracking the rating trend. I track the numbers out of the gate, in part to see how much the Asch study results hold true in voting.

Here is what I got for my latest few postings:

A Year in the Ghetto (Interracial Love) 4.33 on 30 votes (Without 1s: 4.57 on 28 votes)
Hour 1 : four votes 5, 5, 4, 5
Hours 2-4: eight votes 5, 5, 4, 5, 4, 5, 5, 5
Hours 5-12: eight votes 4, 5, 5, 5, 4, 5, 3, 4
Hours 13-24: five votes 1, 1, 5, 4, 5
Day 2: two votes 4, 5
Day 3: one vote 4
Day 4: nothing
Day 5: two votes 5, 4

Challenges of a Double Life (Interracial Love) 3.91 on 11 votes (Without 1s: 4.55 on 9 votes)
Hour 1: one vote 5
Hours 2-4: two votes 4, 4
Hours 5-10: three votes 5, 5, 5
Hours 11-12: two votes 1, 1
Hours 13-16: three votes 4, 5, 4

All Grown Up and Legal Now (Erotic Couplings) 4.73 on 37 votes
Hour 1 : three votes 5, 4, 5
Hours 2-4: seven votes 5, 5, 5, 4, 5, 5, 5
Hours 5-12: seven votes 4, 3, 5, 4, 5, 5, 5
Hours 13-24: eight votes 5, 4, 5, 5, 4, 5, 5, 5
Day 2: three votes 5, 5, 4
Day 3: three votes 5, 5, 5
Day 4: two votes 5, 4
Day 5: two votes 5, 5
Day 6: two votes 5, 5
Day 7: turned off voting

Cupid's Therapy (Humor and Satire) 4.37 on 14 votes
Hour 1 : no votes
Hours 2-4: one vote 5
Hours 5-12: six votes 4, 5, 5, 5, 5, 4, 5
Hours 13-24: eight votes 1, 4
Day 2: two votes 5, 4
Day 3: one vote 4
Day 4: no votes
Day 5: no votes
Day 6: one votes 5
Day 7: turned off voting


Biding Time (Loving Wives) 3.79 on 157 votes
Hour 1 : seven votes 5, 4, 5, 4, 5, 5, 5
Hours 2-4: eighteen votes 5, 5, 5, 4, 5, 3, 5, 5, 3, 5, 4, 5, 5, 5, 1, 5
Hours 5-9: thirty-seven votes 148 total voting points (average vote of 4.00)
Hour 10: six votes 1, 1, 1, 1, 1, 4 (dropped overall average from 4.18 to 3.94)
Hours 11-24: forty-two votes 164 total voting points (average vote of 3.90)
Day 2: twenty-one votes 86 total voting points (average vote of 4.10)
Day 3: twelve votes 30 total voting points (average vote of 2.50)
Day 4: fourteen votes 58 total voting points (average vote of 4.10)
Day 5: stopped counting


Why Didn't You Say Something (Lesbian Sex) 4.66 on 35 votes
Hour 1 : two votes 5, 5
Hours 2-4: six votes 5, 4, 5, 5, 5, 5
Hours 5-12: nine votes 5, 5, 4, 4, 5, 5, 5, 4, 5
Hours 13-24: eight votes 2, 5, 5, 5, 4, 5, 5, 5
Day 2: four votes 5, 5, 5, 5
Day 3: three votes 5, 5, 5
Day 4: three votes 5, 1, 5
Day 5: turned off voting