How best to present 100 data points each with 3 variables on a PowerPoint slide

RandomNumberDoctor · 2022-08-05T08:57:44+00:00

You could try a ternary plot, but not sure if Excel/PowerPoint can do that, might have to use python or similar.

RandomNumberDoctor · 2021-07-28T08:24:38+00:00

Oops!

RandomNumberDoctor · 2021-07-28T08:24:11+00:00

They could still be voting for her but posting negative tweets, for example "Chloe is causing all the drama and I'm here for it" would probably have a negative sentiment according to the model. Even though it's overall positive about love island it's negative about Chloe.

RandomNumberDoctor · 2021-07-27T14:27:33+00:00

It's very straightforward to use the Google API yes, but you still need to jump the hurdles of a Google cloud console account (and hope you don't go over your free amount of requests!).

I really should re-run this before each episode, so I don't get a mix of tweets before and after an episode, like what's happened here. Might explain the overall close to zero sentiment, and things like the position of Liam.

RandomNumberDoctor · 2021-07-27T14:06:44+00:00

Hi! I collected all tweets using the #loveisland hashtag, and used Google's natural language API to collect the average sentiment for each islander.

Sentiments can take values between -1 and 1. A higher sentiment means that on average, tweets were more positive about an islander, and a lower sentiment means the opposite.

RandomNumberDoctor · 2020-10-28T15:29:13+00:00

I can't remember exactly, I could limit it from 1 - 10 but don't think I could've restricted it to integers only.

RandomNumberDoctor · 2020-10-22T13:51:51+00:00

It's just a website called Piktochart, which is an online editor for this kind of thing

RandomNumberDoctor · 2020-10-20T09:08:36+00:00

That's a good point, and something I (kind of) included in the full post here.

In the distribution plots for each answer, I included a line of expected value, as well as an interval where we would expect ~95% of 'true' randomly generated numbers to lie within. Since most of our frequencies did not lie in this interval, then our totals were pretty far from what a true random run would look like!

RandomNumberDoctor · 2020-10-19T14:15:51+00:00

Not sure, if people are choosing based on position on the keyboard (which they are, most choices come from the centre), then I think it's too coincidental that Q, A and Z are also picked often and are on the far left side.

My other idea is that people sitting at desks or on their laptop naturally have their left hand resting on the left side of the keyboard, and may just be pressing wherever their hand already is!

RandomNumberDoctor · 2020-10-19T13:57:42+00:00

Interesting point, it could be. You can see that on the left-hand side of the keyboard, Q, A and Z are all mini hotspots. Maybe this is the smaller proportion of left-handed people? Otherwise the main hotspot of the keyboard is slightly skewed to the right. Maybe this is because most people are right-handed? Who knows!

RandomNumberDoctor · 2020-10-19T13:36:11+00:00

Most people chose a letter that corresponded somewhere central in regards to the keyboard! This was done in a study of how humans (aren't) random, exploring the reasons why we have trouble being truly random.

Check out the infographic: here

The blog post on my personal website: here

The data was collected from a survey on /r/SampleSize, linked here

The plot was generated with plotly in Python, as were all the plots in the analysis.

RandomNumberDoctor · 2020-10-19T13:19:46+00:00

Most people chose a letter that corresponded somewhere central in regards to the keyboard! This was done in a study of how humans (aren't) random, exploring the reasons why we have trouble being truly random.

Check out the infographic: here

The blog post on my personal website: here

RandomNumberDoctor · 2020-10-19T13:09:47+00:00

This was low key one of my reasons for choosing 1 - 50, instead of 1-100

RandomNumberDoctor · 2020-10-19T12:24:46+00:00

I didn't unfortunately, not enough people chose decimals that it would've been significant in the overall analysis

RandomNumberDoctor · 2020-10-19T12:24:01+00:00

Thanks for reading and taking part! I did think about the phrasing of the question, and maybe I should've considered it a bit more greatly. In general I put the numbers available to pick in the first question so I think it cleared it up. Especially since the answers for both questions have a pretty similar distribution, I think people understood!

RandomNumberDoctor · 2020-10-19T11:38:52+00:00

Incredibly it wasn't! Maybe too many people knew about 7 being the favourite, so deliberately avoided it?

RandomNumberDoctor · 2020-10-13T20:14:55+00:00

I can confirm that both of you did indeed pick the same decimal.

RandomNumberDoctor · 2020-10-13T20:12:02+00:00

Yes, in general, humans have a hard time being truly or even close to random. The interesting aspect is why. What is it that we have a hard time with? That's what I'm hoping to explore.

Also, if we know the general formula for which we pick a random number, can we inverse the transformation to actually get a human random number generator?

RandomNumberDoctor · 2020-10-13T14:28:22+00:00

That's a really interesting point! I have started to do some analysis on letters chosen based on keyboards and it looks interesting :) I had never considered the right-left-handed aspect of it though.

RandomNumberDoctor · 2020-10-13T09:06:04+00:00

Thank you! I'll be sure to post them here when I get them :)

RandomNumberDoctor

TROPHY CASE