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	44.51017986	56.24134308	51.80209534	39.12603427	50.18754353	64.25751665	55.65277881	49.84980981	47.47534314	39.80978893	35.89491551	40.39429823	47.93	8.399471138	-0.4075602718	0.9890947114	0.4605795622	-1.048570342	0.2683589111	1.943461176	0.9190231252	0.2281499853	-0.05454241648	-0.9671658524	-1.433251557	-0.8975770311
3	2	48.9417702	42.25855665	48.40781048	40.42341996	39.38731899	41.64485011	37.65379279	58.23530693	44.8398935	49.89698569	54.17656956	39.19243286	45.42	6.517957531	0.5400788833	-0.485275074	0.4581575576	-0.7668259562	-0.9257869452	-0.5794313394	-1.191748512	1.965914613	-0.0892404518	0.686630235	1.343213811	-0.9556868221
4	3	54.84627367	50.68262128	54.50600228	54.41470071	63.0399884	54.66253849	49.1713974	50.76444815	52.71645353	57.19885065	34.07892663	38.69157187	51.23	7.857668531	0.4600761541	-0.06980778994	0.4167717828	0.4051523604	1.502842809	0.4366932402	-0.2621325074	-0.05939415773	0.18902627	0.7594750115	-2.18286392	-1.595839253
5	4	56.9095654	64.98615213	61.403791	59.6373558	45.23770272	58.7281455	54.92480222	50.14116027	49.97151362	39.05415426	54.1002379	49.40455569	53.71	7.325856787	0.4369869787	1.539463722	1.050461379	0.8093380203	-1.156255016	0.6852282628	0.1660612376	-0.4869193062	-0.5100765506	-2.000326725	0.05350589538	-0.5874678978
6	5	47.12463181	50.23744423	65.29725792	48.80975223	45.11832479	58.83195669	33.39634294	36.75754373	47.50846426	34.07063431	52.5496204	74.08413302	49.48	12.20992876	-0.1930841504	0.06185692925	1.295264101	-0.0550718448	-0.3574018185	0.7657523114	-1.317438694	-1.042154467	-0.1616480575	-1.262213853	0.2512254522	2.014914091
7	6	57.15269412	65.37301339	37.74941571	42.93298388	45.08020301	49.16887534	42.84993655	50.01823471	55.17888006	54.7463689	47.55235598	62.2156077	50.83	8.310593212	0.7602120788	1.749349564	-1.57455247	-0.9508222451	-0.6924509027	-0.2004676917	-0.9608151943	-0.0982656772	0.5227062821	0.4706629263	-0.3949808049	1.369424135
8	7	46.16429936	54.44953836	43.63664704	56.07779314	52.57118241	56.1258529	37.50292331	56.37606792	38.84451178	46.99702832	71.70116155	53.28158868	51.14	9.304822027	-0.5351795222	0.3552447095	-0.8068292447	0.5302351359	0.1533756198	0.5354001743	-1.466027637	0.562291073	-1.321845571	-0.4456851762	2.209296634	0.2297238044
9	8	30.03708569	58.28168711	71.2272772	37.94394342	59.01977663	31.65903999	60.7442637	59.78817914	57.30132723	44.71360204	57.13414993	40.27444909	50.68	13.18843066	-1.565006476	0.5766131092	1.558199958	-0.9654766364	0.6325780336	-1.442023361	0.7633355976	0.6908414103	0.5022782697	-0.4521738187	0.4896022121	-0.7887682983
10	9	52.51660607	67.71389059	55.4779722	57.05218506	56.14702325	68.75238243	43.36029907	55.47449956	41.74099327	41.38357689	53.74248959	42.34862056	52.98	9.40059861	-0.04885562761	1.567773819	0.2661632616	0.4336220505	0.3373343731	1.678244639	-1.022868813	0.2657938552	-1.195124417	-1.233145016	0.08154920902	-1.130487333
11	10	42.98651159	44.61882952	56.45831511	55.69771358	50.24158038	59.45079764	44.34480731	68.47827212	58.00562745	65.47287066	38.84585692	48.69940704	52.78	9.304539205	-1.05201744	-0.8765850102	0.3958568954	0.3141116827	-0.2722830943	0.7174722336	-0.9060353894	1.687694862	0.5621533988	1.364691069	-1.49703192	-0.4380272872
12	11	43.68857682	54.67287498	50.58821747	50.80946202	50.05218114	46.58564363	55.77488696	46.99146202	44.38601425	67.60768925	57.9197684	50.96710234	51.67	6.663728422	-1.197789877	0.4505813438	-0.162387441	-0.1291861247	-0.2428283438	-0.7630382452	0.6159560273	-0.7021386464	-1.093128135	2.391658989	0.9378301047	-0.105529651
13	Mean	48.68923402	56.69158298	54.38980768	48.49090761	50.6432293	53.75901757	46.1396152	51.93391669	48.39748671	45.31899889	51.21449189	48.87636197		Mean	-0.2547399337	0.5325736395	0.305244122	-0.1294085363	-0.06841057945	0.3433901273	-0.4238809781	0.2738012313	-0.2408583072	-0.06250838282	-0.01290044387	-0.2623019585
14	Median	48.9417702	56.24134308	54.50600228	48.80975223	50.18754353	56.1258529	43.36029907	50.76444815	47.50846426	44.71360204	53.74248959	42.34862056		Stdev of Means	0.3
15	Real Mean	50													Correction	33.73482586
16	Real Stdev	10													Results	41.4	68.0	60.3	45.6	47.7	61.6	35.7	59.2	41.9	47.9	49.6	41.2
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