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	56.82503653	61.39646583	55.24566536	52.01689496	48.34281808	62.07370965	41.81302711	60.37602622	35.37531804	43.58016238	41.20041851	63.18552607	51.79	9.531606435	0.5286741711	1.008281605	0.3629758522	0.02423228113	-0.361230223	1.079334038	-1.046297427	0.9012230918	-1.721703941	-0.8609000035	-1.110568712	1.195979267
3	2	51.21830348	68.94230842	50.94910225	61.26113317	54.67584279	35.42673339	56.03489754	48.02560454	50.75547578	46.77596792	53.1666753	54.52960521	52.65	8.09047967	-0.1765656339	2.01415799	-0.2098394613	1.064748862	0.2507933673	-2.128436318	0.418775342	-0.5711898172	-0.2337720928	-0.725647486	0.06425714809	0.2327181002
4	3	32.36428843	50.6283904	26.2684777	48.0923908	53.65811089	54.97574842	66.63062237	44.29821659	50.40882976	51.8975842	48.58425519	56.21789228	48.67	10.65420257	-1.530329969	0.1839327223	-2.102480789	-0.05409537855	0.4683013052	0.5919743367	1.685897029	-0.4102153401	0.163324832	0.303058841	-0.007929146074	0.708561557
5	4	47.52047903	44.50992332	48.7487596	46.51036396	47.26251344	46.81674031	49.7242548	59.94651068	53.65304292	60.23072825	48.78841545	72.8917522	52.22	8.263843552	-0.5683164179	-0.9326209566	-0.4196833316	-0.6905495004	-0.5995325937	-0.6534751846	-0.3016395679	0.9353460818	0.1737794181	0.9697389846	-0.4148846148	2.501837683
6	5	50.62120144	44.17718564	50.56586515	61.34646334	42.3198941	51.88200108	38.37357976	50.03204198	42.35519767	57.28771701	23.36582391	61.9962854	47.86	10.74902481	0.2568540045	-0.342643709	0.2517059755	1.2546433	-0.5154306898	0.374148332	-0.8825630022	0.2020435007	-0.5121463386	0.8770512487	-2.27875997	1.315097348
7	6	59.37006551	60.13019836	38.28685654	36.86106577	52.03248744	76.36359244	75.66054018	51.53036684	39.32088299	52.70433067	30.67776548	58.59825382	52.63	14.60379977	0.46166284	0.5137131874	-0.98201684	-1.079648333	-0.04078023564	1.625300195	1.57715846	-0.07516310939	-0.9112115383	0.005224451035	-1.503051857	0.4088127803
8	7	33.37518262	61.36187363	43.79958247	58.85243816	45.1162845	44.91034137	35.07267712	45.58921553	63.10209347	42.74386928	38.9984851	43.52771176	46.37	9.739847858	-1.334274466	1.539147318	-0.263990823	1.281501049	-0.1288036978	-0.1499480861	-1.159990994	-0.08024739148	1.717817444	-0.3723819604	-0.7569243301	-0.2919040623
9	8	45.15783504	55.73278798	49.19429165	62.51182369	41.27286498	58.92393964	55.26509775	47.62444458	52.47707337	46.0233155	67.03640325	64.05724329	53.77	8.211027238	-1.049230273	0.2386661895	-0.5576405497	1.064267606	-1.522370837	0.6273083862	0.181707393	-0.7488282079	-0.1578389625	-0.9438256223	1.615304575	1.252480304
10	9	63.54188978	63.96779395	44.67642232	48.73354894	41.56526121	51.90994484	53.78257094	45.41448645	34.37759006	56.72009384	65.31158336	45.89416941	51.32	9.714190651	1.25767316	1.301516666	-0.6843792596	-0.2667297847	-1.004648978	0.06025534531	0.2530275656	-0.6084013264	-1.744563544	0.5554225888	1.439849282	-0.5590217147
11	10	43.43312084	38.95878682	63.41576852	53.03896203	54.45845182	48.5398085	47.33239715	64.55661534	49.45451852	29.30625545	58.31244096	21.43877687	47.69	12.94902405	-0.3285218803	-0.6740563394	1.214656015	0.4132978239	0.5229191969	0.06584665564	-0.02739676904	1.302758935	0.1364859576	-1.419481735	0.8205469659	-2.027054827
12	11	55.8441332	50.01503236	38.44947802	51.49524269	52.11890951	47.33840729	56.22350823	59.61753568	58.97253933	68.66984522	55.47278983	44.13245857	53.20	7.882644577	0.3359671808	-0.4035182531	-1.870735787	-0.215737323	-0.1366183394	-0.7430775273	0.3840950684	0.8146647095	0.732839841	1.96304955	0.2888581972	-1.149787317
13	Mean	48.88825354	56.76076972	45.30389145	52.9095692	47.36067527	53.69808346	52.48414084	50.3152126	46.86950045	50.88486323	46.3477584	57.87760438		Mean	-0.195127935	0.40423422	-0.4783117272	0.2541755093	-0.2788547023	0.0681118338	0.09843391798	0.1510901024	-0.2142717204	0.03193716888	-0.1675729511	0.3261562835
14	Median	50.62120144	60.13019836	48.7487596	52.01689496	47.26251344	51.90994484	53.78257094	48.02560454	50.40882976	51.8975842	48.58425519	58.59825382		Stdev of Means	0.3
15	Real Mean	50													Correction	37.28722267
16	Real Stdev	10													Results	42.7	65.1	32.2	59.5	39.6	52.5	53.7	55.6	42.0	51.2	43.8	62.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