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	60.12676369	56.28975128	57.95599448	40.56888563	56.29339906	42.37043765	69.6862043	32.07165554	35.65781181	67.59283594	51.28866433	60.92203199	52.57	12.27756345	0.6155994022	0.3030770981	0.4387915835	-0.9773777506	0.3033742077	-0.8306424456	1.394209967	-1.669471921	-1.377381696	1.2237064	-0.1042583614	0.6803735163
3	2	47.81078834	52.91056428	50.44045963	52.30984003	46.73152335	35.79720197	57.8273441	53.35871912	58.33525425	58.25722492	57.95409914	45.06915816	51.40	6.778690832	-0.5295112569	0.2228133536	-0.141579227	0.1341938456	-0.6887256271	-2.30176886	0.9481421736	0.2889256535	1.023069643	1.011558669	0.9668412181	-0.9339595854
4	3	53.21407318	42.97024392	57.53452908	54.65140595	44.53291995	50.52391262	54.81523082	49.68316667	29.22066336	49.79577399	43.88200119	54.91605902	48.81	7.793220401	0.5649023095	-0.7495516308	1.119288773	0.749336047	-0.5490342638	0.2197098952	0.7703575074	0.1118281849	-2.513851863	0.12627758	-0.6325579847	0.7832954445
5	4	56.01035926	52.53297846	69.45054522	45.66227881	35.30942358	57.92255712	34.096051	45.14816426	50.86142431	62.20669043	71.80564942	61.56988945	53.55	12.07088942	0.2039914568	-0.08408845877	1.317429372	-0.6532842652	-1.510955549	0.362405455	-1.611476111	-0.6958755385	-0.2225665844	0.7173199239	1.512535476	0.664564824
6	5	42.93177651	46.93115123	54.48114397	66.40633697	39.74186189	31.77957331	57.78292215	65.28439433	54.88716127	52.57754267	62.91158976	49.2969102	52.08	10.55557925	-0.8670852598	-0.4881979787	0.2270628854	1.356815476	-1.169287019	-1.923607402	0.5398622213	1.250526411	0.2655275954	0.04672211448	1.025734904	-0.2640739479
7	6	50.7897662	63.43969981	45.77396686	48.80038487	43.75121348	52.69747387	48.2714561	49.3571517	57.5539493	52.45346328	53.8463066	45.95467942	51.06	5.486298585	-0.04879302313	2.256938869	-0.963034065	-0.411402039	-1.331725881	0.2989291514	-0.5078110764	-0.3099188941	1.184129866	0.2544527922	0.5083294799	-0.9300951797
8	7	36.75864674	65.17423379	48.63695176	65.17348098	42.00039458	63.77275164	44.41611314	29.11367019	44.52555917	49.57426749	54.55743216	42.5874216	48.86	11.47721008	-1.054169969	1.42165707	-0.0192228923	1.421591478	-0.5974607339	1.299547067	-0.3869811359	-1.720270571	-0.3774451926	0.06244466619	0.4966237594	-0.5463135455
9	8	66.46794232	48.08980063	54.39105819	27.32953568	34.32823696	52.99360928	57.9448769	55.51967248	34.74820971	61.04353311	50.41072541	46.65769451	49.16	11.73063003	1.475413881	-0.09126596743	0.4458967888	-1.861014472	-1.264396791	0.3267685824	0.7488488631	0.5421076731	-1.22859541	1.01299974	0.1065857052	-0.2133485942
10	9	68.77294482	35.71981312	44.78046417	56.33402649	48.14164814	37.87020455	50.61178401	47.24580598	49.08361043	51.8161854	42.85594669	39.74078483	47.75	8.953478912	2.348268958	-1.343383417	-0.3314135296	0.9589857037	0.04399182954	-1.103209576	0.3198774264	-0.05606337428	0.1491981189	0.4543951267	-0.5463598648	-0.8942874015
11	10	57.81115003	50.94008279	57.57314216	59.04654714	42.6099675	34.41953055	52.16509262	55.83835076	45.10398685	51.04660133	57.43747187	45.33646209	50.78	7.580520611	0.9278761865	0.02146519039	0.8964788881	1.090846143	-1.077419137	-2.157877508	0.1830648864	0.6676303047	-0.7484154343	0.03551680271	0.8785816616	-0.7177479842
12	11	60.48022343	46.66129314	56.96400181	58.28393109	61.75394868	45.78875357	66.60236924	43.2004903	42.3834701	58.72160618	43.26648462	54.10444551	53.18	8.47700601	0.8606779267	-0.7694884642	0.4458827008	0.6015897132	1.010934427	-0.8724186224	1.582884069	-1.177746147	-1.274126898	0.6532205718	-1.16996105	0.1085517736
13	Mean	53.65367345	51.56202628	53.71612371	50.80401949	43.42562455	47.30308022	52.82799806	47.4202667	46.09707151	56.1463908	54.3902683	49.6349588		Mean	0.4088336921	0.0636341512	0.3123255707	0.2191163527	-0.6209731398	-0.6074694784	0.3619071628	-0.2516662017	-0.4654961686	0.5089649443	0.2765540857	-0.2057309709
14	Median	53.21407318	52.53297846	54.39105819	52.30984003	43.75121348	50.52391262	54.81523082	49.3571517	49.08361043	52.57754267	53.8463066	46.65769451		Stdev of Means	0.4
15	Real Mean	50													Correction	24.31715372
16	Real Stdev	10													Results	59.9	51.5	57.6	55.3	34.9	35.2	58.8	43.9	38.7	62.4	56.7	45.0
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