Use four percentages to get one number

73 Views Asked by At

Say in Alaska 37% of the people prefer Mountdew, 48% likes Fanta and 6% likes Cola and 9% likes something else.

In Alabama 1% of the people prefer Mountdew, 10% likes Fanta and 82% likes Cola and 7% likes something else.

So people in Alabama are more biased towards one kind of drink, than the people in Alaska, how can I use the four percentages to get one number that represents the biasedness? Is there a formula to calculate this?

I'm trying to make a Choropleth map that shows the biasedness, of each state. The Choropleth map will have ten levels.

enter image description here

I apologize in advance incase I'm using the wrong tag. I have no idea what tag to put on this question.

Edit

I got so far the following formula: ((A - B) / 10) + ((B - C) / 20) + (C - D) / 40.
A, B, C, D should be assigned in decending order respectively, A being the largest number, D being the smallest.

1

There are 1 best solutions below

0
On

Are you just looking for the standard deviation?

Or the Mean-Squares error for assuming a flat deviation.

In any case, I assume that the math works out to averaging, for Alaska: (37-25)^2 + (48-25)^2 + (6-25)^2 + (9-25)^2; for Alabama: (1-25)^2 + (10-25)^2 + (82-25)^2 + (7-25)^2

(Of courae, this is treating "other" as an equal choice to Fanta, Coke and Mountain Dew)