Test Rank.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Survey Entry	Film 1	Film 2	Film 3	Film 4	Film 5	Film 6	Film 7	Film 8	Film 9	Film 10	Film 11	Film 12	Mean	Standard Deviation	Film 1	Film 2	Film 3	Film 4	Film 5	Film 6	Film 7	Film 8	Film 9	Film 10	Film 11	Film 12
2	1	52.025305	41.02528908	42.67003705	62.9378382	42.37934912	49.39610209	38.75221529	50.24328785	42.68130762	52.7843589	55.99631659	61.3849476	49.36	8.049233194	0.331577191	-1.035014589	-0.8306786071	1.687300518	-0.866792349	0.004937019982	-1.317410904	0.1101875126	-0.829278403	0.4258785846	0.8249175503	1.494376476
3	2	56.18376407	50.73570317	40.75826985	49.7629963	61.79498556	49.4622637	57.83071158	33.2773188	40.90528109	50.70964583	42.62077987	35.5835383	47.47	8.909873248	0.9781275582	0.3666642126	-0.7531534372	0.2574924162	1.607903239	0.22373968	1.162972781	-1.592778294	-0.7366536239	0.363739666	-0.5441145467	-1.333939651
4	3	49.36628178	58.52170061	52.21381736	51.1686091	48.25371294	55.01760981	50.18477611	41.18664778	59.50416855	53.83674446	70.5624396	61.38084596	54.27	7.532834253	-0.6505073951	0.564894208	-0.2724909039	-0.4112445551	-0.79820331	0.09971859378	-0.5418505071	-1.736371458	0.6953189465	-0.05704382961	2.163328288	0.9444519221
5	4	55.37428154	37.78982709	40.47206963	54.61287795	47.71955812	43.96219598	57.30599515	43.81664581	54.49966331	40.75342922	45.40084854	44.20267747	47.16	6.653514611	1.234702189	-1.408179878	-1.005048195	1.120265889	0.08422400375	-0.4804943984	1.525031996	-0.5023700814	1.103250125	-0.9627608319	-0.264269946	-0.4443508719
6	5	41.93517466	38.44535223	62.06450141	61.74523381	64.93399419	46.3228623	47.52357015	50.44206281	55.53650459	42.24847299	43.24991669	31.08178178	48.79	10.45196599	-0.6562348478	-0.9901263309	1.269654193	1.239108016	1.544195153	-0.2364394095	-0.1215607496	0.1576683125	0.6450830048	-0.6262597858	-0.5304458778	-1.694641678
7	6	40.64698958	59.70060092	66.22249625	47.21104953	47.90596879	63.92693567	36.29943094	58.28524888	37.80181755	53.40747357	34.58811891	55.25133442	50.10	11.00662189	-0.8592069332	0.8718974449	1.464440316	-0.2628332215	-0.1996967503	1.255878542	-1.254201755	0.743306488	-1.117703323	0.3001391514	-1.409681977	0.467662018
8	7	39.32563475	65.35095577	47.13291579	53.01616879	52.53008627	52.76196138	39.38286997	61.39211308	45.62999521	53.91151925	49.25039345	44.92856624	50.38	7.87602601	-1.404108734	1.900263418	-0.4128371167	0.3341453063	0.2724285829	0.3018692063	-1.396841716	1.397618724	-0.6036593134	0.4478257917	-0.143986093	-0.6927180554
9	8	48.64383829	55.834721	42.65206106	55.30043673	52.49713721	45.72537308	66.92585456	58.90498959	45.19193937	53.56300097	44.9268774	58.99717374	52.43	7.260630409	-0.5215036543	0.4688900587	-1.346745664	0.3953035739	0.009207688861	-0.9234612041	1.996461761	0.8917553494	-0.9969305429	0.1560081321	-1.033437286	0.904451788
10	9	43.13060373	39.46371718	55.77501138	59.85252069	40.9754902	51.22983376	49.97834525	55.19224048	60.07093588	53.37999195	38.78378653	56.91823929	50.40	7.880768759	-0.9219010881	-1.387196628	0.6825626431	1.199962586	-1.195365974	0.1058197183	-0.05298312771	0.6086141596	1.227677546	0.3786558159	-1.473473826	0.827628175
11	10	30.71808897	63.92606934	62.96704471	38.72932699	50.01851057	64.46655896	48.13829154	44.54369599	50.58236379	68.25024098	53.12303375	64.60912152	53.34	11.77899839	-1.920475116	0.8987782096	0.8173600279	-1.240346147	-0.2819298873	0.9446640819	-0.441554583	-0.7467244655	-0.2340605182	1.265886813	-0.0183656114	0.9567671965
12	11	35.36794165	55.94217663	45.28263869	45.82949588	34.81866124	53.67223982	41.12971124	49.32144764	48.81978035	58.67949432	42.60274253	39.69877814	45.93	7.69284173	-1.373027601	1.301437272	-0.08420646243	-0.01311996302	-1.444429097	1.006365972	-0.6240495524	0.4408022521	0.3755900317	1.657263869	-0.4325687785	-0.8100579411
13	Mean	47.40354149	49.65198523	49.99568664	55.06752568	50.99892027	50.86723753	49.35375211	50.30450612	49.09129035	50.51051524	47.2643864	49.96990053		Mean	-0.5238689483	0.1411188542	-0.04283120062	0.3914576744	-0.1153144273	0.2093270729	-0.09690785054	-0.02075377279	-0.04285146103	0.3044848523	-0.2601907368	0.05632994347
14	Median	48.64383829	50.73570317	47.13291579	54.61287795	48.25371294	49.4622637	49.97834525	50.44206281	45.62999521	53.37999195	44.9268774	55.25133442		Stdev of Means	0.2
15	Real Mean	50													Correction	40.16734323
16	Real Stdev	10													Results	29.0	55.7	48.3	65.7	45.4	58.4	46.1	49.2	48.3	62.2	39.5	52.3
17															Mean of Results	50.0
18															Stdev of Results	10
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100