Sophistic Posted October 10, 2015 Posted October 10, 2015 Alright, folks. For those curious, I added a new tab to the sheet: "Ratings graphs". Can't link to it directly, but you can see it if you reload the spreadsheet page. You can hover over the various bars and wedges to see the specific values in the graphs. Most commonly used buckets for each reviewer: UPDATED (several updates, including some re-binning) Rob: 90-91 (27% of cases) followed by 91-92 (22%) Ken: Both 90-91 and 91-92 top his frequency chart with 19% each. Smithy: Like Rob, the Wookie likes 90-91 the best (29% of reviews), followed by 88-89 (21%). I have not yet determined if there's a correlation of scores to time-of-year, though that might be interesting. best post ever
JamesNYC Posted October 10, 2015 Posted October 10, 2015 That was an awesome job! Withe the baseball playoffs underway, stats hold an unusually strong interest for me. Thanks for your contribution
planetary Posted October 10, 2015 Author Posted October 10, 2015 Ok, one more update today. I summarized a bunch of flavor profile and other data into a single "Brand Profile" tab, with entries for every brand which has made an appearance on the review decks. It shows the top flavors mentioned (I have a rough weighting system which emphasizes strongly called out flavors, and de-emphasizes hints and aromas), and shows the number of times a human gave it a score, with the average score listed. I also added a brand average body rating, where 1 = most mild, 3 = medium, and 5 = full. Example:
Maxismoke Posted October 10, 2015 Posted October 10, 2015 This should be put into a proper tool like Qlik Sense
planetary Posted October 10, 2015 Author Posted October 10, 2015 This should be put into a proper tool like Qlik Sense I agree. For example - I would like to tease apart ratings and flavor data for regular production vs. EL/ER cigars. Chocolate is appearing in too many brand profiles because it's such a strong factor in many ELs.
planetary Posted October 10, 2015 Author Posted October 10, 2015 I miss the old Czar deck. Also miss the guest reviewers. Ken and Rob is a staple. I also liked Smith of course as well as Bster and Artie. And who was the young kid that Rob said had a good palate? Minismithy! He worked at Czars for a while, from what I could tell from the videos. No idea beyond that. BTW, I'd also added review location to the data. (Ken's deck has been the site for 51% of reviews. I did not count the number of leaf blower appearances.)
LeafLover Posted October 11, 2015 Posted October 11, 2015 How bout drink pairing? Or how many times they drank the same wine in different reviews. I'm guessing none. Also, the amount of times they drank non alcoholic beverages in their reviews. I'm guessing none on that as well.
planetary Posted October 11, 2015 Author Posted October 11, 2015 Sigh. Alright. On the list for the next 33 hour playthrough of the reviews: * List of songs played in the background * Drink pairings * Ken's footwear selection
Ken Gargett Posted October 11, 2015 Posted October 11, 2015 i'm stunned. i knew rob gave out good marks like candy.
planetary Posted October 11, 2015 Author Posted October 11, 2015 i'm stunned. i knew rob gave out good marks like candy. On the contrary! Rob has awarded 94+ points 12% of the time, whereas you have done so 20% of the time. Smithy's the real scrooge, only awarding that kind of score 3% of the time.
planetary Posted October 11, 2015 Author Posted October 11, 2015 Perhaps a more revealing answer to Ken's question is to show the reviewers' score quartiles. If you count up all the views, what's the score after you've counted 25% of them, then 50%, then 75%, then all of them? Created this graph and added it to the "Ratings Graphs" section. As you can see, Rob's a touch more generous than Ken at the half-way point, but in the third and fourth point, Ken's a full point more generous. In other news, I added two more graphs which may be of passing interest. First, locations... Secondly, and more sadly, review frequency over the years... Pick up the pace, you lot! We like the video reviews. 1
Fumadoro Posted October 11, 2015 Posted October 11, 2015 Wow! Thank you for this great learning devise! Beautiful work!
planetary Posted October 13, 2015 Author Posted October 13, 2015 Do the guys favor aged cigars? Answer: only a little. Most cigars smoked are young, and many of the young cigars score quite well, despite their youth. But age does seem to increase scores by a couple points, with diminishing returns around 10 years.
Ken Gargett Posted October 13, 2015 Posted October 13, 2015 Perhaps a more revealing answer to Ken's question is to show the reviewers' score quartiles. If you count up all the views, what's the score after you've counted 25% of them, then 50%, then 75%, then all of them? Created this graph and added it to the "Ratings Graphs" section. image.png As you can see, Rob's a touch more generous than Ken at the half-way point, but in the third and fourth point, Ken's a full point more generous. In other news, I added two more graphs which may be of passing interest. First, locations... image (1).png Secondly, and more sadly, review frequency over the years... image (2).png Pick up the pace, you lot! We like the video reviews. my yard? when on earth did we do that?
CaptainQuintero Posted October 13, 2015 Posted October 13, 2015 my yard? when on earth did we do that? Off the top of my head I think you, rob and smithy (possibly Warren?) did a Churchill taste off. Also I think I remember you and rob testing the Tampa blends at something like 9am?
planetary Posted October 13, 2015 Author Posted October 13, 2015 my yard? when on earth did we do that? I think I remember you and rob testing the Tampa blends at something like 9am? Exactly! This one, from June, 2010.
airtrade Posted October 13, 2015 Posted October 13, 2015 Amateur, if at all. I just like data.Just a amateur? Well excellent and extensive work! Thanks for all your efforts.Is there much mention of aging in the reviews? It would be a great spread sheet recommended aging of individual vitolas...
Fuzz Posted October 13, 2015 Posted October 13, 2015 Yes, yes, yes. The stats are all great, but how does it all correlate to the length of women's skirts, the length of men's beards and the price of gold?
planetary Posted October 13, 2015 Author Posted October 13, 2015 Is there much mention of aging in the reviews? It would be a great spread sheet recommended aging of individual vitolas... Yes, sometimes. I endeavored to make note of such predictions in the text summaries.
Ken Gargett Posted October 13, 2015 Posted October 13, 2015 Exactly! This one, from June, 2010. completely forgotten that.
planetary Posted October 24, 2015 Author Posted October 24, 2015 Stats have been updated with this week's review. Sorry, Ken, I don't yet have stats on the number of times you've made a plea for individual roller codes. I'll get that into the next update. As recompense, I'll offer this graph of footwear choices over the years:
Ken Gargett Posted October 24, 2015 Posted October 24, 2015 Stats have been updated with this week's review. Sorry, Ken, I don't yet have stats on the number of times you've made a plea for individual roller codes. I'll get that into the next update. As recompense, I'll offer this graph of footwear choices over the years: image.png truly scary. in every respect. i would suggest that slippers and booties (i've not worn booties since i was 3 months old) etc etc are all the same. just to stuff these next time, i am going to start wearing something different on each foot. 1
.png.15b5f6bc4159a73805a9f118f79a68ca.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now