Excel Assignment

profilewyh967r0
WANG_e03ch05_grader_h1_CallCenter.xlsx
Home>Business & Finance homework help>Marketing homework help>Excel Assignment

CallData

Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold Issue Grade Weekday
Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold
8 2 Accounting 6 4.5 4 Y
16 1 Public_Affairs 6.7 3.7 5 Y
15 2 Accounting 5.5 5.9 1 N
3 1 Public_Affairs 3.7 9.2 2 N
21 1 Admissions 6.5 5.9 1 N
15 3 Public_Affairs 8.8 6 3 N
22 1 Human_Resources 6.3 6.4 4 N
12 2 Admissions 2 7.2 2 Y
19 3 Accounting 5.4 7.6 6 N
15 1 Financial_Aid 5.9 4.2 5 Y
19 1 Public_Affairs 3.3 9.2 3 N
14 2 Accounting 4.9 5.1 3 N
12 4 Public_Affairs 4 5.9 5 N
20 2 Public_Affairs 4.3 8.2 2 N
14 2 Public_Affairs 5.3 6.7 5 N
11 2 Public_Affairs 5.1 6.8 5 N
15 1 Admissions 3.5 6.5 2 Y
16 1 Admissions 5.4 8.4 6 N
10 2 Public_Affairs 3.6 6.8 5 Y
15 2 Admissions 7.2 4.2 7 Y
1 2 Public_Affairs 3.3 9.9 7 N
9 3 Admissions 6.3 8.3 6 N
13 2 Public_Affairs 2.6 6.5 4 Y
20 3 Admissions 7.2 6.6 5 N
17 2 Admissions 1.8 7.5 2 N
11 1 Admissions 2.5 8.3 1 N
14 2 Admissions 4.7 6.6 2 N
17 3 Public_Affairs 7.6 5.3 3 N
21 1 Financial_Aid 5.7 5.4 7 Y
16 1 Public_Affairs 3 6.7 5 Y
2 1 Admissions 3.7 9.4 4 N
13 1 Accounting 1.5 7.8 1 N
11 3 Public_Affairs 3.3 9.3 1 N
18 3 Admissions 4.4 5.4 5 Y
20 2 Accounting 5 4 1 Y
23 2 Public_Affairs 3.2 8 3 Y
8 1 Public_Affairs 4.5 4.9 5 Y
8 2 Admissions 8.1 4.1 4 Y
5 1 Human_Resources 6.5 6.2 4 N
21 1 Public_Affairs 5.7 8.5 6 N
20 2 Admissions 4.5 5.6 7 N
19 3 Admissions 4.8 9 2 N
4 1 Admissions 5.9 8.2 4 N
22 2 Admissions 4.4 4.5 7 Y
20 1 Public_Affairs 3.2 9.4 7 N
20 3 Admissions 4 3.8 3 Y
16 4 Financial_Aid 4.9 6.5 2 N
11 1 Public_Affairs 5.7 6.2 5 Y
7 2 Public_Affairs 5 9.9 5 N
12 2 Public_Affairs 4.6 8.8 4 N
16 1 Financial_Aid 3.5 8.3 1 N
20 2 Public_Affairs 5.7 7.1 1 N
14 4 Admissions 4 6.1 2 N
12 1 Admissions 3.1 9.6 5 N
6 2 Admissions 3.5 10 7 N
17 2 Admissions 2.7 8.1 1 N
21 2 Human_Resources 5 5 7 Y
6 4 Admissions 2.7 7.7 3 N
20 2 Public_Affairs 6.1 6.7 6 N
20 1 Admissions 6 4.4 1 Y
22 2 Public_Affairs 4.7 8.1 3 N
3 1 Public_Affairs 5.3 5 4 Y
9 1 Admissions 3.4 8.9 6 N
13 2 Accounting 4.9 6.3 2 Y
23 1 Accounting 5.5 7.2 3 N
24 2 Admissions 4.5 7.1 3 N
10 3 Admissions 7.3 3.8 6 Y
20 4 Human_Resources 4.5 6.5 1 N
9 3 Human_Resources 5.8 4.9 2 Y
14 2 Accounting 4.2 7.6 3 N
11 1 Human_Resources 3.8 10 5 N
18 2 Public_Affairs 4.5 8.1 2 N
20 2 Admissions 3.5 10 2 N
6 2 Accounting 1.4 9.5 4 N
6 2 Admissions 3.8 10 2 N
13 1 Accounting 4.5 6.1 2 N
21 1 Accounting 4.6 6.8 3 N
23 1 Admissions 4.5 6.6 5 Y
10 1 Admissions 2.6 7.3 4 Y
19 1 Public_Affairs 6.3 7.7 1 N
13 3 Admissions 1.3 8.8 4 N
18 2 Human_Resources 4.9 5.5 2 N
18 2 Human_Resources 4.8 5.4 6 Y
12 2 Accounting 3.9 8 1 N
19 2 Accounting 6.8 6.6 4 Y
11 1 Public_Affairs 6.2 8.7 7 N
4 4 Human_Resources 5 6.2 2 N
24 3 Human_Resources 2.4 8.1 6 N
21 2 Accounting 6.8 6 4 N
12 3 Human_Resources 3.1 8.3 6 N
14 2 Human_Resources 3.2 7.4 1 N
14 3 Admissions 7.8 6.9 1 N
9 3 Admissions 5.4 4.8 2 N
14 2 Public_Affairs 6.6 5.8 6 Y
12 3 Admissions 3.5 8.6 5 Y
19 3 Human_Resources 5.7 7.2 3 N
4 1 Public_Affairs 6.3 6.5 5 N
8 3 Admissions 8.3 6 6 N
7 2 Human_Resources 4 7.2 6 N
1 2 Human_Resources 4.8 7.7 4 N
11 1 Accounting 3.1 9.8 6 N
15 2 Accounting 5 4.6 3 Y
10 1 Public_Affairs 5.5 8.9 5 N
12 1 Admissions 5.2 5 7 Y
9 2 Public_Affairs 4.6 8.9 1 N
5 3 Admissions 2.2 7.3 1 Y
20 4 Accounting 6.1 7.8 6 N
24 1 Accounting 4.4 8.3 4 N
20 3 Admissions 6 4.7 5 Y
9 3 Financial_Aid 3.9 10 7 N
10 3 Accounting 5.2 7.2 2 N
14 2 Accounting 4.6 5.5 3 N
22 4 Accounting 6.5 8.3 3 N
15 3 Financial_Aid 7.1 5.1 1 Y
2 4 Financial_Aid 6.3 6.6 7 N
10 1 Admissions 4.5 8.5 4 N
2 1 Admissions 7.4 6.4 5 N
18 3 Financial_Aid 5.4 6.9 5 N
23 1 Financial_Aid 5.3 5 2 Y

&F

Lists

Department Public Affairs Human Resources Admissions Accounting Financial Aid
Public Affairs 1 Frozen screen Blackboard Banner Blackboard Internet
Human Resources 2 Voicemail Electrical Intranet Internet Blackboard
Admissions 3 Other Internet Blackboard Intranet
Accounting 4 Intranet Internet
Financial Aid
Day of Week Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Financial Aid
Satisfaction Rating Grade
0 F
4 D
6 C
8 B
9 A+

&F

CallCenterReport

Call Center Report
Department Financial_Aid
Your Office: Public_Affairs Human_Resources Admissions Accounting Financial_Aid Student_Life
Issues # Calls on Issue # On Hold Status
1
2
3
4
Department Average Call Length Total Calls Below C Notes Longest Call
Public_Affairs Department
Human_Resources Score
Admissions
Accounting
Financial_Aid
Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold Issue Grade Weekday
Satisfaction Rating Call Length
Count
Average
Sum
Max
Min

&F