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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!