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	30.40686915	45.82196789	59.97673703	52.10850662	44.72643599	32.65331649	54.42080331	37.52654621	68.64565822	55.54621239	42.71280875	33.52813957	46.51	11.92987163	-1.349494626	-0.05735174143	1.129146285	0.4696060442	-0.1491827298	-1.161190224	0.6634301484	-0.7527005211	1.855802988	0.7577655374	-0.3179714054	-1.087859755
3	2	57.11382362	48.31875377	29.72372383	32.51430904	44.00853655	57.51171418	58.21238517	50.37035086	37.93507866	48.85311872	52.36697234	54.0651966	47.58	9.672394104	0.9853809962	0.07608493599	-1.846399791	-1.557889502	-0.3695355758	1.026517716	1.098958001	0.2881934454	-0.9974522871	0.1313313363	0.4946181898	0.6701925348
4	3	49.05691838	59.64628112	32.23093923	41.87733669	49.08509932	39.21282175	54.62523003	54.33160136	32.85638929	49.4499366	53.46024855	56.54464849	47.70	9.137540132	0.1487049537	1.30759045	-1.692707386	-0.63701873	0.1517890375	-0.9286196315	0.7580934282	0.7259591051	-1.62425898	0.1917163339	0.6305994358	0.9681519824
5	4	37.6381125	51.00760465	68.01313728	61.62852414	45.6793295	44.50747953	25.77896667	53.36512785	32.79035447	47.842323	54.66666097	65.44466832	49.03	12.82824422	-0.888046567	0.1541453282	1.479777452	0.9820777641	-0.2612096547	-0.3525588644	-1.812502449	0.3379213118	-1.265943803	-0.09259784294	0.4393797103	1.279557615
6	5	61.1266666	47.28686589	62.00834852	53.07634536	56.69031789	49.13857449	51.52733469	62.69480932	55.83836549	60.46224123	65.03714684	46.52845096	55.95	6.399714794	0.8086887969	-1.353876435	0.9464577369	-0.4492299537	0.11547842	-1.064534071	-0.6912736568	1.053722016	-0.01764507586	0.7048677062	1.419728565	-1.472384049
7	6	49.9541118	66.57343269	49.66403224	53.09319259	42.23022851	53.51435646	57.87514044	55.81841571	53.5259537	70.03174961	46.92383461	50.54565316	54.15	7.805366236	-0.5370318145	1.592185494	-0.574195934	-0.1348622438	-1.526592466	-0.08090399714	0.4777865041	0.2142851297	-0.0794181945	2.035254636	-0.9252617957	-0.4612453179
8	7	40.95340641	55.00114975	58.87704098	34.31223344	63.21911554	60.69566441	40.69655532	46.53096195	65.22253174	62.6620598	50.5551463	52.99869504	52.64	10.16667343	-1.149865495	0.231878832	0.613113781	-1.803095189	1.040202798	0.7919946551	-1.17512952	-0.6012538396	1.237259997	0.9854104667	-0.2054326918	0.03491620483
9	8	43.11080649	56.83101934	57.5759309	61.42656059	43.68599369	66.62724659	58.97432591	45.50747384	30.58563696	30.06243776	43.77319042	42.6906183	48.40	11.81372853	-0.4480772992	0.7133014146	0.7763561527	1.102301487	-0.3993892666	1.542525416	0.8947264881	-0.2452059243	-1.508298845	-1.552586235	-0.3920083007	-0.4836450875
10	9	57.81700061	64.52932212	51.55109088	58.82919921	43.31915993	56.75089957	54.590302	56.29400374	48.52532182	46.45243198	50.05667695	42.63558194	52.61	6.677994351	0.7793384913	1.784478831	-0.1589536663	0.930910738	-1.39164877	0.6196945947	0.2961547037	0.5512764737	-0.6120491458	-0.9224551946	-0.3827355154	-1.49401154
11	10	56.68419214	42.1258867	60.54563128	57.20003477	44.6382832	51.26784803	59.93232949	40.05918164	48.45134568	42.24573993	39.60153041	65.7425884	50.71	9.095595207	0.6570553509	-0.9435331879	1.081594818	0.7137688062	-0.6673119569	0.06156445793	1.014166378	-1.170753618	-0.248091181	-0.930356125	-1.221069317	1.652965575
12	11	51.4836707	53.98219945	51.64274526	51.30037169	67.2168621	55.19603649	55.09444066	51.37367456	47.36848532	49.60876985	65.40951814	41.54038972	53.43	7.05970114	-0.2763704752	0.07754376229	-0.2538377143	-0.3023346071	1.95222123	0.2494826331	0.2350916799	-0.2919513248	-0.8592825994	-0.5419484114	1.696212664	-1.684826837
13	Mean	47.46419062	55.00182191	52.18010899	49.87402308	48.07157966	51.17911928	50.74456039	51.38214343	47.32503226	52.37361234	51.06140953	49.44240582		Mean	-0.1154288807	0.3256770621	0.1363956121	-0.06234230783	-0.1368344486	0.0639975168	0.1599547006	0.009953841304	-0.3744888296	0.06967292792	0.112369049	-0.1889262431
14	Median	49.05691838	55.00114975	57.5759309	53.07634536	44.72643599	53.51435646	54.590302	53.36512785	48.52532182	49.4499366	50.5551463	50.54565316		Stdev of Means	0.2
15	Real Mean	50													Correction	53.53576227
16	Real Stdev	10													Results	43.8	67.4	57.3	46.7	42.7	53.4	58.6	50.5	30.0	53.7	56.0	39.9
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