a random statistics question
-
a random statistics question
let's say HYPOTHETICALLY that your group chat watches movies and there's three of you, and maybe you recently compiled a spreadsheet of everybody's movie rankings
stdev seems like the right tool to find most contentious/most agreed on movies for three people or pairwise between two people
is there a method to figure out which movies are ones where two people agreed and the other person disagreed?
-
undefined oblomov@sociale.network shared this topic
-
a random statistics question
let's say HYPOTHETICALLY that your group chat watches movies and there's three of you, and maybe you recently compiled a spreadsheet of everybody's movie rankings
stdev seems like the right tool to find most contentious/most agreed on movies for three people or pairwise between two people
is there a method to figure out which movies are ones where two people agreed and the other person disagreed?
@picklish variance?
When all three disagree, will be highest. When all three agree, variance will be lowest, and with only one disagreeing, variance will be intermediate.
-
@picklish variance?
When all three disagree, will be highest. When all three agree, variance will be lowest, and with only one disagreeing, variance will be intermediate.
@oblomov Yeah this all makes sense to me, and I can sort by variance to find the most/least agreement.
However, an intermediate variance could be either two people agreeing and one really disagreeing OR everybody slightly disagreeing? It feels harder to "find" those values, if that makes sense.
I guess I'm looking for some formula/function where a maximum value of the formula is one where two people agree and one disagrees. I'd even be fine if this was a specific per-person formula, like person A disagrees and people B and C agree and I just replicate that formula.
Like one hypothetical to find one where A disagrees is:
sqrt((B-A)^2 + (C-A)^2) - stdev(B, C)
essentially the stdev with A as the mean (how much B and C disagree with A) and then counteract that value by subtracting the stdev of B and C (how much B and C agree)
and this ~sort of works but also still has very high values in ways that don't make sense
mostly curious if I'm just making stuff up or there's something obvious I should consider