Final data.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M
1	Team	Count of positive comments/posts	Count of negative comments/posts	% of comments/posts that are -ve (excluding neutral)	Average of Sentiment (exc neutral)	Count of total comments/posts	Total swear words	Positive swear words	Negative Swear Words	Avg +ve swears per 100 positive comments/posts	Avg -ve swears per 100 negative comments/posts	Final Score (/10, higher is more negative)
2	Newcastle United	9033	4577	33.63%	1.354438688	35347	4994	645	1959	7.140484889	43	9.44
3	West Ham United	8597	4202	32.83%	1.46703054	32295	3873	427	1581	4.966848901	38	8.335
4	Nottingham Forest	4866	2307	32.16%	1.527214813	18921	2364	258	922	5.302096178	40	8.055
5	Everton	7926	3767	32.22%	1.496866135	30571	3856	485	1350	6.119101691	36	7.5
6	Manchester United	16280	7476	31.47%	1.521603606	61242	7908	936	2610	5.749385749	35	6.665
7	Wolverhampton Wanderers	4300	1886	30.49%	1.577888928	16268	1938	255	705	5.930232558	37	6.39
8	Manchester City	7567	2767	26.78%	2.03529213	25289	3007	477	1123	6.303687062	41	6.39
9	Tottenham Hotspur	13222	5819	30.56%	1.641597939	48129	5478	720	1881	5.445469672	32	5.555
10	Aston Villa	7330	2887	28.26%	1.815488403	26236	2744	364	973	4.965893588	34	5
11	Crystal Palace	2904	1300	30.92%	1.6478507	11299	995	118	402	4.063360882	31	4.725
12	Arsenal	12324	5341	30.23%	1.712192436	44704	5630	895	1698	7.262252515	32	4.72
13	Brighton and Hove Albion	4032	1440	26.32%	2.025651657	14148	1353	201	450	4.985119048	31	3.335
14	Chelsea	10626	3844	26.57%	1.989194848	36838	3865	546	978	5.138339921	25	2.775
15	Liverpool	12984	4417	25.38%	2.010126917	44784	4577	620	1370	4.775107825	31	2.5
16	Fulham	1736	614	26.13%	2.008536646	6378	371	54	137	3.110599078	22	1.945
17	Brentford	1504	496	24.80%	2.032345726	5244	414	62	105	4.122340426	21	0.835
18	Bournemouth	433	143	24.83%	2.228238166	1565	112	15	30	3.464203233	21	0.835
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