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.95980355	57.96825841	67.47790604	39.4875116	48.66329507	58.34853158	42.13953565	65.38404323	52.83835091	38.03816821	64.79370354	38.90363818	52.42	10.85880795	0.2341793005	0.5112313378	1.386985626	-1.190681699	-0.3456733417	0.5462511269	-0.9464537815	1.194159414	0.03881230919	-1.324153384	1.139794359	-1.244451267
3	2	60.44316345	35.41675026	64.40665994	69.30955988	59.10106873	49.01652943	38.81792596	54.96712152	27.51938672	37.88368466	52.7257385	50.43285716	50.00	12.77586319	0.8171497126	-1.141732659	1.127382879	1.511145594	0.7121004727	-0.07724261549	-0.8755138022	0.3885256853	-1.759879819	-0.948639296	0.2130868136	0.03361703527
4	3	47.34070813	59.71916946	52.00405794	50.66237806	48.82221169	52.51154212	70.05440755	61.69483011	58.30627557	56.94395737	52.19353657	61.94462654	56.02	6.626086306	-1.309335038	0.5588056348	-0.6055485803	-0.8080330965	-1.08574852	-0.528959752	2.118585816	0.8569696738	0.3455735962	0.1399743727	-0.57695272	0.8946686139
5	4	36.46162678	36.97077943	46.77011371	56.16628394	51.73928647	58.59215445	66.54318424	31.4200522	69.35196756	49.95134644	56.49636793	85.97729712	53.87	15.45841447	-1.126144703	-1.093207777	-0.4592919057	0.1485434088	-0.1378376733	0.3054722138	0.8198218455	-1.452282586	1.00152116	-0.2534989548	0.1698964392	2.077008532
6	5	57.34673265	57.46249484	41.51503882	56.30649963	38.5355358	38.24649234	54.2037704	52.82106655	41.42289143	52.55466976	62.54791989	35.43969106	49.03	9.317514796	0.8922084802	0.9046326289	-0.8069241936	0.7805657258	-1.126698627	-1.157720146	0.5548908252	0.4064924719	-0.8168138894	0.3779015009	1.450424631	-1.458959408
7	6	50.64246791	52.62984812	58.37990138	66.41307919	48.55410535	44.64783886	38.6504601	58.17513818	62.76427966	51.22726303	67.50825709	48.68736058	54.02	8.79964117	-0.3842049139	-0.1583570441	0.4950847435	1.407983083	-0.621528519	-1.065440538	-1.746988644	0.4718152497	0.9933298648	-0.3177482135	1.532440192	-0.6063852607
8	7	31.23131259	47.61332876	56.14614332	48.60545945	40.84663203	74.97756639	47.02893502	43.33801036	37.63287356	50.56137316	47.80761728	61.42172376	48.93	11.41548108	-1.550783121	-0.1157129696	0.6317644697	-0.02880198546	-0.7084778891	2.281403493	-0.1669060588	-0.4902323054	-0.9900042173	0.1425367158	-0.09869322976	1.093907098
9	8	45.34095539	62.64289028	65.34760285	57.97374095	53.52661744	37.96669701	52.65685738	42.51842842	45.22221476	40.70033849	58.68309241	47.83473927	50.87	8.950909093	-0.6174671695	1.315513572	1.6176854	0.7938738951	0.2970390518	-1.44132297	0.1998690269	-0.9328012806	-0.6307329308	-1.135919189	0.8731229915	-0.3388603975
10	9	32.62502401	64.38994036	44.60409436	52.13681641	40.64686347	61.54209619	57.24739542	47.91087551	40.38636827	57.72695471	36.50853323	50.17679904	48.83	10.17057968	-1.592841633	1.530374286	-0.4150257429	0.3256126755	-0.8041118144	1.250366237	0.8280991782	-0.08989371968	-0.8297244351	0.8752507962	-1.211004083	0.1328982552
11	10	46.82617044	45.66552769	26.44437485	47.99639895	49.48770193	41.33933842	63.72970063	46.50942774	53.2328407	37.88393763	43.76659876	37.9753344	45.07	9.109991455	0.1926153758	0.06521210072	-2.044685909	0.3210708762	0.4847705882	-0.409671909	2.048108905	0.1578466603	0.8958729249	-0.7889698273	-0.1432325435	-0.7789372415
12	11	48.61125007	50.72347553	52.71759634	46.13470239	44.10305681	59.5814815	46.60050288	48.40887378	52.68222608	44.09413295	44.71330454	53.96439572	49.36	4.731788562	-0.1585023931	0.2878881067	0.7093187731	-0.6818875035	-1.111248527	2.159908771	-0.5834468237	-0.2012719055	0.7018437429	-1.113134467	-0.9822808619	0.9728130873
13	Mean	46.26575494	52.7570511	55.18350204	55.22903657	47.82617956	52.87216093	51.9269413	50.91439623	48.38273427	48.39863954	55.47386294	53.42430364		Mean	-0.4184660092	0.242240656	0.148795051	0.2344900885	-0.4043104363	0.1693676283	0.2045514987	0.02812066885	-0.09547288126	-0.3951272678	0.2151456353	0.07066536791
14	Median	47.34070813	57.46249484	56.14614332	56.16628394	48.66329507	52.51154212	52.65685738	52.82106655	45.22221476	50.56137316	56.49636793	50.17679904		Stdev of Means	0.3
15	Real Mean	50													Correction	37.98869818
16	Real Stdev	10													Results	34.1	59.2	55.7	58.9	34.6	56.4	57.8	51.1	46.4	35.0	58.2	52.7
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