Question: One call-center is analyzing their Jan service data, which is saved to table T. Table T has four columns: Type: enquiry type, categorical. urgency:problem urgency
One call-center is analyzing their Jan service data, which is saved to table T. Table T has four columns:
Type: enquiry type, categorical.
urgency:problem urgency level,higher value means higher urgency level. Integer type
length: call length in mins,numerical type
solved:if the enquiry is loved, logical:true or false
See example data below.
type
urgency
length
solved
A
1
5
Y
B
1
2
Y
B
2
20
N
C
3
1
Y
...
...
...
...
1(1).Code to find the maximum urgency value in the data.
2(4). Code to calculate the total call length for the highest urgency cases in Jan. Require to solve using loop.For example, if the highest "urgency" level in Jan is 4, then calculate the sum of "length" for which urgency is 4.
3(3). Same question as part 2, code to calculate the total call length for the highest urgency cases in Jan. Require to solve WITHOUT using loop.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
