V0 = numbers of film rating 0
V1 = numbers of film rating 1
V2 = numbers of film rating 2
V3 = numbers of film rating 3
V4 = numbers of film rating 4
V5 = numbers of film rating 5
V6 = numbers of film rating 6
T = Total votes
T = V0+V1+V2+V3+V4+V5+V6
M0 = Median of V0
M0 = (1+V0)/2
M1 = (1+V1)/2
M2 = (1+V2)/2
M3 = (1+V3)/2
M4 = (1+V4)/2
M5 = (1+V5)/2
M6 = (1+V6)/2
Mn = (1+Vn)/2
Cn = from 0 to Mn
C0 = M0 = (1+V0)/2
C1 = V0+M1 = V0+(1+V1)/2
C2 = V0+V1+M2 = V0+V1+(1+V2)/2
C3 = V0+V1+V2+M3 = V0+V1+V2+(1+V3)/2
C4 = V0+V1+V2+V3+M4 = V0+V1+V2+V3+(1+V4)/2
C5 = V0+V1+V2+V3+V4+M5 = V0+V1+V2+V3+V4+(1+V5)/2
C6 = V0+V1+V2+V3+V4+V5+M6 = V0+V1+V2+V3+V4+V5+(1+V6)/2
Cn = V0+V1+...+V(n-1)+Mn = V0+V1+...+V(n-1)+(1+Vn)/2
average rating overall of 2020 = 3.19
G = perfect film rating = 6.38
New Score[adjust] = N
N0 = C0*G/T = C0*6.38/T
N1 = C1*G/T = C1*6.38/T
N2 = C2*G/T = C2*6.38/T
N3 = C3*G/T = C3*6.38/T
N4 = C4*G/T = C4*6.38/T
N5 = C5*G/T = C5*6.38/T
N6 = C6*G/T = C6*6.38/T
i.e.
xianjiro
6 0 0%
5 7 1%
4 37 6%
3 190 31%
2 280 45%
1 96 15%
0 10 2%
V0 = 10
V1 = 96
V2 = 280
V3 = 190
V4 = 37
V5 = 7
V6 = 0
T = Total votes
T = V0+V1+V2+V3+V4+V5+V6 = 620
median
M0 = (1+V0)/2 = 5.5
M1 = (1+V1)/2 = 48.5
M2 = (1+V2)/2 = 140.5
M3 = (1+V3)/2 = 95.5
M4 = (1+V4)/2 = 19
M5 = (1+V5)/2 = 4
M6 = (1+V6)/2 = 0.5
from 0 to median
C0 = M0 = 5.5
C1 = V0+M1 = 58.5
C2 = V0+V1+M2 = 246.5
C3 = V0+V1+V2+M3 = 481.5
C4 = V0+V1+V2+V3+M4 = 595
C5 = V0+V1+V2+V3+V4+M5 = 617
C6 = V0+V1+V2+V3+V4+V5+M6 = 620.5
average rating overall of 2020 = 3.19
G = perfect film rating = 6.38
N = new score
N0 = C0*G/T = 5.5*6.38/620 = 0.06
N1 = C1*G/T = 58.5*6.38/620 = 0.60
N2 = C2*G/T = 246.5*6.38/620 = 2.54
N3 = C3*G/T = 481.5*6.38/620 = 4.95
N4 = C4*G/T = 595*6.38/620 = 6.12
N5 = C5*G/T = 617*6.38/620 = 6.35
N6 = C6*G/T = 620.5*6.38/620 = 6.39
score Vote adjust score
6 0 6.39
5 7 6.35
4 37 6.12
3 190 4.95
2 280 2.54
1 96 0.60
0 10 0.06
name | 0 | 1 | 2 | 3 | 4 | 5 | 6 | all scores | T=all votes | ave. score |
xianjiro | 10 | 96 | 280 | 190 | 37 | 7 | 0 | 1409 | 620 | 2.272580645 |
peacefulanarchy | 53 | 28 | 61 | 52 | 82 | 43 | 41 | 1095 | 360 | 3.041666667 |
mjf314 | 4 | 6 | 18 | 73 | 72 | 36 | 36 | 945 | 245 | 3.857142857 |
matthewscott8 | 15 | 45 | 37 | 13 | 20 | 28 | 43 | 636 | 201 | 3.164179104 |
oldale1 | 15 | 38 | 102 | 143 | 113 | 40 | 36 | 1539 | 487 | 3.160164271 |
frbrown | 2 | 14 | 45 | 52 | 62 | 34 | 28 | 846 | 237 | 3.569620253 |
ebbywebby | 21 | 70 | 103 | 106 | 71 | 40 | 11 | 1144 | 422 | 2.710900474 |
lineuphere | 6 | 11 | 28 | 55 | 49 | 49 | 20 | 793 | 218 | 3.637614679 |
sol | 15 | 28 | 83 | 108 | 89 | 59 | 48 | 1457 | 430 | 3.388372093 |
lonewolf2003 | 8 | 46 | 42 | 53 | 104 | 46 | 11 | 1001 | 310 | 3.229032258 |
jal90 | 3 | 7 | 17 | 39 | 32 | 42 | 30 | 676 | 170 | 3.976470588 |
opio | 0 | 8 | 20 | 19 | 32 | 25 | 18 | 466 | 122 | 3.819672131 |
fergenaprido | 31 | 28 | 41 | 17 | 40 | 53 | 34 | 790 | 244 | 3.237704918 |
hurluberlu | 17 | 36 | 71 | 139 | 95 | 52 | 8 | 1283 | 418 | 3.06937799 |
sortile9io | 6 | 37 | 66 | 86 | 58 | 63 | 30 | 1154 | 346 | 3.335260116 |
test 1 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 2100 | 700 | 3 |
test 2 | 200 | 0 | 200 | 0 | 200 | 0 | 200 | 2400 | 800 | 3 |
test 3 | 0 | 0 | 0 | 100 | 200 | 200 | 300 | 3900 | 800 | 4.875 |
test 4 | 300 | 100 | 50 | 25 | 12 | 6 | 3 | 371 | 496 | 0.747983871 |
adjust | 0 | 1 | 2 | 3 | 4 | 5 | 6 | all scores | ave. score |
xianjiro | 0.06 | 0.60 | 2.54 | 4.95 | 6.12 | 6.35 | 6.39 | 1980.99 | 3.195145161 |
peacefulanarchy | 0.48 | 1.20 | 1.98 | 2.99 | 4.17 | 5.28 | 6.03 | 1151.59 | 3.198861111 |
mjf314 | 0.07 | 0.20 | 0.51 | 1.69 | 3.58 | 4.99 | 5.92 | 784.74 | 3.203020408 |
matthewscott8 | 0.25 | 1.21 | 2.51 | 3.30 | 3.82 | 4.59 | 5.71 | 644.38 | 3.205870647 |
oldale1 | 0.10 | 0.45 | 1.37 | 2.97 | 4.65 | 5.65 | 6.15 | 1556.72 | 3.196550308 |
frbrown | 0.04 | 0.26 | 1.05 | 2.36 | 3.89 | 5.18 | 6.02 | 759.22 | 3.203459916 |
ebbywebby | 0.17 | 0.85 | 2.16 | 3.74 | 5.08 | 5.92 | 6.30 | 1349.37 | 3.197559242 |
lineuphere | 0.10 | 0.35 | 0.92 | 2.14 | 3.66 | 5.09 | 6.10 | 698.61 | 3.204633028 |
sol | 0.12 | 0.44 | 1.26 | 2.68 | 4.14 | 5.24 | 6.03 | 1374.89 | 3.197418605 |
lonewolf2003 | 0.09 | 0.65 | 1.55 | 2.53 | 4.15 | 5.69 | 6.28 | 992.09 | 3.200290323 |
jal90 | 0.08 | 0.26 | 0.71 | 1.76 | 3.10 | 4.48 | 5.84 | 545.49 | 3.208764706 |
opio | 0.03 | 0.24 | 0.97 | 1.99 | 3.32 | 4.81 | 5.94 | 392.37 | 3.216147541 |
fergenaprido | 0.42 | 1.19 | 2.09 | 2.85 | 3.60 | 4.81 | 5.95 | 781.55 | 3.20307377 |
hurluberlu | 0.14 | 0.54 | 1.36 | 2.96 | 4.75 | 5.87 | 6.33 | 1336.61 | 3.197631579 |
sortile9io | 0.06 | 0.46 | 1.41 | 2.81 | 4.14 | 5.26 | 6.11 | 1106.93 | 3.199219653 |
test 1 | 0.46 | 1.37 | 2.28 | 3.19 | 4.11 | 5.02 | 5.93 | 2236.19 | 3.194557143 |
test 2 | 0.80 | 1.60 | 2.40 | 3.19 | 3.99 | 4.79 | 5.59 | 2555.19 | 3.1939875 |
test 3 | 0.00 | 0.00 | 0.00 | 0.40 | 1.60 | 3.19 | 5.19 | 2555.19 | 3.1939875 |
test 4 | 1.94 | 4.51 | 5.47 | 5.96 | 6.19 | 6.31 | 6.37 | 1585.43 | 3.196431452 |