Call Topics.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Topic	Weekday?	Total Calls	Avg Calls per Day	Avg Rating	Avg Speed of Answer	Calls Answered	Calls Resolved	Call Resolved Ratio	Calls Abandoned	Avg Talk Duration
2	Admin Support	Weekday	701	11.0	3.475778547	67.33217993	578	529	92%	123	230.2076125
3	Admin Support	Weekend	275	10.6	3.294930876	67.03686636	217	194	89%	58	222.2949309
4	Contract related	Weekday	676	10.6	3.42	67.96545455	550	491	89%	126	225.8745455
5	Contract related	Weekend	300	11.5	3.280334728	65.29288703	239	218	91%	61	232.9330544
6	Payment related	Weekday	701	11.0	3.387323944	68.39084507	568	508	89%	133	213.0035211
7	Payment related	Weekend	306	11.8	3.416	67.78	250	221	88%	56	222.356
8	Streaming	Weekday	732	11.4	3.419568823	67.64510779	603	532	88%	129	225.9369818
9	Streaming	Weekend	290	11.2	3.360655738	65.03278689	244	217	89%	46	232.1639344
10	Technical Support	Weekday	706	11.0	3.410488246	68.77034358	553	511	92%	153	227.3924051
11	Technical Support	Weekend	313	12.0	3.424603175	66.66269841	252	225	89%	61	219.9444444
12
13	No filters applied
14
15
16
17
18
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