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.

 

Session 7 Homework Problems

  1. The ABC Corporation has been tracking its average weekly customer satisfaction rating on scale of 1 to 5.  The data for the past 20 weeks are listed below.  Please create a trend chart and comment on the company’s customer satisfaction performance.
Week Average customer Satisfaction Rating
1 3.5
2 3.8
3 4.2
4 4
5 2.8
6 3.3
7 3.7
8 2.9
9 2.5
10 3.4
11 3.6
12 3.7
13 4.2
14 4.5
15 3.9
16 4.7
17 4.8
18 4.6
19 4
20 4.1
 

 

 

  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.

 

 

 

 

  1. 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 trendline 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

 

 

  1. Create a histogram for the  units sold per period

 

 

  1. 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.

 

"Looking for a Similar Assignment? Order now and Get a Discount!

"Looking for a Similar Assignment? Order now and Get a Discount!