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	54.34876032	56.46947995	43.64803459	63.8562685	44.85377979	53.17181704	51.77656678	57.79202856	53.19736229	51.70465848	47.74002181	42.71135333	51.77	6.231771598	0.4134056148	0.753713278	-1.303718571	1.939056552	-1.110235036	0.2245438662	0.0006508304892	0.9659400236	0.2286430608	-0.01088815103	-0.6470855171	-1.454025951
3	2	42.4619365	47.03878034	49.6360429	52.62513994	50.76660638	39.53134792	44.53572012	43.60511974	57.79735623	53.20461958	50.08171563	45.81262372	48.09	5.208778921	-1.080767874	-0.2020890297	0.2965427228	0.8704002598	0.5135923413	-1.643392747	-0.6826354792	-0.8612954676	1.863380835	0.9816508325	0.3821045678	-0.4374909609
4	3	59.73989039	53.54747771	53.81696247	33.18872787	57.75277411	45.01106186	51.01258736	40.31696875	50.56646298	49.81475268	58.81949316	30.3159044	48.66	9.669207153	1.14604037	0.5056142645	0.5334846742	-1.599909955	0.9405306269	-0.377231217	0.2434531267	-0.8626994709	0.1973144545	0.1195717512	1.05085188	-1.897020506
5	4	55.64425882	43.11604513	53.74342865	49.20860082	54.49196143	48.48576292	55.94120171	48.56332578	45.65021042	56.89752053	42.21767208	54.60107094	50.71	5.186011788	0.9507956058	-1.464974779	0.5842653598	-0.2901691784	0.728602244	-0.4295514108	1.008054035	-0.4145952439	-0.9763208014	1.192457553	-1.638204823	0.7496414384
6	5	44.74902054	31.09526439	52.79435947	44.29747029	47.57846521	59.47450363	44.75773162	50.65273631	60.73939613	78.15187054	49.19415639	62.16571899	52.14	11.87247888	-0.6223247334	-1.772358882	0.05532135968	-0.6603580919	-0.3840051118	0.6179792705	-0.6215910132	-0.1250641501	0.7245191528	2.191144158	-0.2479180156	0.8446560568
7	6	32.81724962	53.63256253	48.00961679	56.10180454	49.38616487	45.7405865	42.82052291	48.33479362	75.0865008	43.58517163	51.70235474	63.04009036	50.85	10.69039455	-1.687265629	0.259838644	-0.2661424798	0.4908162747	-0.1373775342	-0.4783919231	-0.7515402693	-0.2357248159	2.266681157	-0.6800135623	0.07928330718	1.139836831
8	7	55.25289631	73.60231234	39.5707376	54.64180677	55.80624948	22.66489377	50.10710348	50.13353481	50.22425772	49.76659176	29.02641125	48.13299388	48.24	13.1509197	0.532947305	1.928242573	-0.6595288916	0.4864798671	0.5750244512	-1.945054483	0.1416596271	0.1436694738	0.1505680721	0.1157670106	-1.461322727	-0.00845227725
9	8	32.89172128	44.94493668	70.54973292	45.80437669	55.16858407	32.24316927	39.9204719	50.909267	44.0353011	48.72289393	41.04132459	34.90671656	45.09	10.69891772	-1.140596993	-0.01401431336	2.379199365	0.06631530782	0.9415634053	-1.201215463	-0.4836379621	0.543456122	-0.09903558448	0.3391015207	-0.3788747778	-0.9522606276
10	9	48.31193574	38.01315214	40.76342284	44.70060884	66.05208916	28.00734724	26.96604899	58.91823559	57.32468687	57.42763026	54.61305678	46.6690198	47.31	12.30666242	0.08109424973	-0.7557519442	-0.5322737489	-0.2123506165	1.522602338	-1.568791626	-1.653404189	0.9429282287	0.8134415603	0.8218064109	0.5931031781	-0.05240384131
11	10	45.13869292	42.31597947	41.17208901	48.70548648	41.04916075	40.86710201	63.55594781	17.92912757	33.99196361	23.70222164	61.51183327	47.77668793	42.31	13.18994713	0.2144816694	0.0004767596265	-0.08624765636	0.4848992478	-0.09556750135	-0.1093703422	1.610791655	-1.848420106	-0.6306111274	-1.410731158	1.455816467	0.4144820926
12	11	51.03563733	42.23394955	45.55094175	64.17101595	55.46516851	52.88809895	46.86207685	57.00900178	47.91680375	52.08572708	53.92202407	48.4999395	51.47	5.874198073	-0.07394962718	-1.572313773	-1.007642281	2.162164725	0.6801160556	0.2414060333	-0.7844398819	0.9429320607	-0.60488739	0.1048134547	0.4174173145	-0.5056166908
13	Mean	47.35751884	49.05111236	50.28137092	49.38053381	53.5396305	41.59227668	45.31532832	49.91400113	54.95794828	54.36396771	47.15957849	47.59505466		Mean	-0.1151036402	-0.2121470184	-0.0006127405904	0.3397585811	0.3795314799	-0.6062790948	-0.1793308655	-0.07353394047	0.3576084899	0.3422436201	-0.03589355882	-0.1962413124
14	Median	48.31193574	47.03878034	49.6360429	49.20860082	54.49196143	45.01106186	44.75773162	50.13353481	53.19736229	51.70465848	49.19415639	46.6690198		Stdev of Means	0.3
15	Real Mean	50													Correction	33.03944979
16	Real Stdev	10													Results	46.2	43.0	50.0	61.2	62.5	30.0	44.1	47.6	61.8	61.3	48.8	43.5
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