Classification of IT management

1. An IT manager has classified Helpdesk problems into 5 categories A, B, C, D and E. Reviewing recent helpdesk calls produced the following data
   A, B, B, B, A, C, E, E, C, D, A, A, B, D, B, B, C, C, B, B, E, B, B, B, C, B, C.
   Create a Pareto chart to identify the top priority problem for the helpdesk staff.
2. The Best Delivery Corporation has collected the following set of data on Dollars spent on advertisement and the number of units sold in the same period. Create a scatter plot. Indicate if there is any correlation. If so add a trend line and get the equation of the line. Is a linear trend line a good fit?
   AD in $1000 Sales in units
   10 280
   15 250
   5 220
   35 400
   20 380
   25 360
   30 320
   40 450
   50 500
   55 700
3. Create a histogram for the units sold per period
4. You are the marketing manager and want to find out the root causes of drop in sale. Create a fishbone diagram to identify the possible causes. Apply your general knowledge to populate the fishbone.
5. A call center manager has been collecting call data. The following table shows the number of calls received. Please create a trend chart and comment on the call center workload.
6. Please create a detailed process map with all tasks, decision points and loopbacks for a function that you are responsible for or familiar with. Then use the approach illustrated in, Value-added Flow Charting, to analyze its cycle-time.
   https://www.moresteam.com/toolbox/value-added-flow-chart.cf

Sample Solution