Announcement The Coop Page / Article Rating & Review Project!

[Nifty-Chicken]

View attachment 1456028
You guys missed out on some giant turkey legs today at the fair!

Is that the Alameda County Fair!?!?!

Chickens from that fair about 16 years ago lead to me owning BYC!

(my brother got three straggly hens the day it closed, then talked me into getting chickens, then the rest is history!)

 

[Nifty-Chicken]

Today's stats:

Coop pages with ratings:

#Coops - Ratings
1687 - 1 ratings
955 - 2 ratings
195 - 3 ratings
48 - 4 ratings
22 - 5 ratings
18 - 6 ratings
3 - 7 ratings
5 - 8 ratings
6 - 9 ratings
4 - 10 ratings
1 - 11 ratings
2 - 12 ratings
2 - 13 ratings
1 - 14 ratings
1 - 19 ratings

Highest Raters:
920 - SavKel&RynKel
452 - BlackHackle
376 - KikisGirls
375 - Hope Hughes
368 - PNW_Peepers
291 - 21hens-incharge
209 - sumi
144 - Nardo
137 - Cyprus
102 - Tesumph
97 - casportpony
84 - Thyme4Chickens
79 - ronott1
74 - Yorkshire Coop
71 - OhZark Biddies
55 - Cryss
47 - Rose Quartz
40 - karenerwin
40 - littleprairieheartsfarm
32 - MROO
30 - Ms Biddy
26 - Nifty-Chicken
21 - ECSandCCFS
21 - rjohns39

 

[Tesumph]

Out of curiosity, is there a way to see how many articles have 5 stars, how many have 4, etc.?

 

[Nifty-Chicken]

Out of curiosity, is there a way to see how many articles have 5 stars, how many have 4, etc.?

Great question!!!

The query on the database to filter the data to only coops is a little beyond me, but here are the ratings across all articles in our system... most of which are coop articles:

Star Rating - #
5 3389
4 1128
3 1576
2 1175
1 505

 

[Tesumph]

Great question!!!

The query on the database to filter the data to only coops is a little beyond me, but here are the ratings across all articles in our system... most of which are coop articles:

Star Rating - #
5 3389
4 1128
3 1576
2 1175
1 505

Whoa, that’s a lot of 5 stars!

I wonder if that’s because people avoid rating lower quality articles (lots of 5 star ratings on a good featured article), or if raters are too generous.

Maybe most articles are just that good.

 

[Nifty-Chicken]

Sorry, I should clarify! That's the NUMBER of ratings submitted, not the number of articles with those ratings! So, there are 3,389 5-star ratings, not 3389 articles with 5-stars.

But, the reason there are so many more 5-star ratings (not 5-star articles) is a combo of both of those factors you mentioned, but also that we tend to FEATURE and promote the best articles, so those get the most views / exposure, and then get the most # of ratings.

You asked

how many articles have 5 stars, how many have 4, etc.?

Well, that's a tricky question depending on how we round the numbers... but if I use the sql query:

"SELECT rating_avg, COUNT(rating_avg) AS average_count FROM `xf_nflj_ams_article` WHERE category_id IN (17,18,19,20) group by ROUND(rating_avg,1) ORDER BY `rating_avg` DESC"

we get:

... but if we change the "round" decimal_places to "0", we get:

 

[Nifty-Chicken]

Oh, and to make things more confusing, if I use the "Rating Weighted" data instead of the "Rating Average" data, we get:

@Cyprus can put it into better English than me!

 

[Nifty-Chicken]

(oh, and those last two posts were JUST coop articles... not all articles)

 

[Nifty-Chicken]

Ok, and since I'm running data... here are the members doing the most REVIEWS vs. just doing ratings:

(To be clear, we don't have any requirements on ratings vs. reviews. In some cases having peeps spend more time on reviews is better, but in other cases it's better to just quickly go through and give just a rating).

 

[Tesumph]

Ah, that makes more sense. Just keeping your data analysis skills sharp.

So in a nutshell, the average rating that is given is 5 stars because good articles get more exposure.
But the average coop article rating is 2.5, yes?

What is the weight calculation based on?