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	50.68656588	37.75071428	57.05138329	46.76695036	38.28976091	48.79077339	41.71766205	33.60457097	35.17332486	50.78111062	48.79095475	41.68068502	44.26	7.274013577	0.8839037457	-0.8944613147	1.75891138	0.3450519168	-0.8203555106	0.6232783742	-0.3491024528	-1.464455207	-1.248789691	0.8969013485	0.6233033074	-0.3541858956
3	2	31.46087143	43.92369188	60.52962727	59.14416123	45.61436836	62.48613368	56.45870571	50.50904799	63.09611148	29.24344514	37.24799194	51.3898702	49.26	11.88013676	-1.498113851	-0.4490669663	0.9487229515	0.8321025736	-0.3067557696	1.113410148	0.6060567308	0.1052495569	1.164754489	-1.684763747	-1.010988103	0.1793919869
4	3	54.84518141	66.90338308	48.38591699	42.79742324	52.40082169	32.32353976	59.14517153	46.40585317	50.57891743	56.52205147	55.11729922	59.77160366	52.10	8.995407768	0.3052021572	1.645686322	-0.4128602792	-1.034121026	0.0334679804	-2.19847997	0.7832227467	-0.6329796857	-0.1690691696	0.4916161701	0.3354529044	0.8528618498
5	4	59.1492813	51.03836855	43.86928588	62.98570397	53.05555137	54.0347398	60.05539276	68.82178423	49.34128573	57.67647779	41.53072636	39.67407299	53.44	8.883209619	0.6431487774	-0.2699122776	-1.076949709	1.07502226	-0.0428341268	0.06739499932	0.7451514879	1.732001044	-0.460956157	0.4773524521	-1.340205854	-1.549212896
6	5	39.1284252	54.60177603	40.8195883	43.54885286	43.71000876	48.82525575	32.93160101	44.26024497	50.09200035	68.48433132	55.2318037	53.47679141	47.93	9.341984476	-0.9417126301	0.7146111276	-0.7606843801	-0.4685339742	-0.4512832605	0.09627138425	-1.605043233	-0.3923839747	0.2318683345	2.200650344	0.7820515811	0.5941886811
7	6	51.20095797	37.88104583	35.19418925	45.75775893	49.16764525	55.25127873	54.5172021	57.46099247	28.55130956	50.90200474	57.36848461	44.33084001	47.30	9.291179302	0.4200021751	-1.013606166	-1.302789754	-0.1658436974	0.2011588341	0.8559340016	0.7769260943	1.093763201	-2.017756012	0.3878261486	1.083806676	-0.3194215018
8	7	41.55293634	48.40095692	67.3197535	56.66594425	39.46925962	48.6534167	57.1833749	56.00492759	58.52099181	46.20256049	56.32601526	42.67261019	51.58	8.363493019	-1.199035611	-0.3802365079	1.881832288	0.607985436	-1.448175141	-0.3500505818	0.6698532049	0.5289494815	0.8297884029	-0.6430927599	0.5673410565	-1.065159268
9	8	51.74725034	49.16339892	40.51635335	41.90324465	37.12219399	41.01304865	65.76331973	60.97783224	40.14898507	22.7788935	35.30866457	40.71733829	43.93	11.57092693	0.6755903636	0.4522848814	-0.2950230588	-0.1751630594	-0.5883581892	-0.2520969131	1.886908132	1.473329555	-0.3267723119	-1.827956415	-0.7450897485	-0.2776532369
10	9	52.14067891	64.05428177	45.58599512	40.83770223	45.08675866	46.62782904	67.68146785	52.71438552	45.94299446	58.61063721	42.81128902	56.53701702	51.55	8.618881933	0.06823303875	1.450500827	-0.6922697547	-1.243187255	-0.75019333	-0.5713916724	1.871342661	0.1347969645	-0.6508491459	0.8189056152	-1.014203171	0.5783152222
11	10	55.68616757	42.76200477	60.51345259	40.77582849	45.23096735	56.60075257	52.46330814	57.79484202	54.66152539	39.5590944	52.03947376	58.22130779	51.36	7.347277168	0.5889402386	-1.170100901	1.245957105	-1.440429111	-0.8340631384	0.7134196857	0.1502934641	0.8759410419	0.4494814755	-1.606032511	0.09260755277	0.9339850982
12	11	60.97414384	62.71266941	42.25709233	60.63390885	48.02347575	27.3357901	50.78817911	72.86579481	54.69712443	36.62116964	40.12616724	51.45050672	50.71	12.75919228	0.8046728267	0.9409295375	-0.6622735989	0.7780069541	-0.2103340644	-1.831728678	0.006349194638	1.736679391	0.3127122643	-1.103988291	-0.8292845694	0.05825903249
13	Mean	47.99023875	50.41306859	48.80801033	48.93419352	44.87959651	48.66733506	55.05043307	52.30662657	46.82732453	49.02239025	47.7481366	47.80564764		Mean	0.06825738468	0.09332986935	0.05750665349	-0.08082808934	-0.4743387015	-0.1576399293	0.5038143665	0.4718992154	-0.1714170474	-0.1447801496	-0.1322916697	-0.03351190257
14	Median	51.20095797	49.16339892	45.58599512	45.75775893	45.08675866	48.79077339	57.1833749	52.71438552	49.34128573	50.90200474	48.79095475	44.33084001		Stdev of Means	0.3
15	Real Mean	50													Correction	36.65854718
16	Real Stdev	10													Results	52.5	53.4	52.1	47.0	32.6	44.2	68.5	67.3	43.7	44.7	45.2	48.8
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