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 companys 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 2. 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 UMGC/MHFallah 3. 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 and the R Square. 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 4. Create a histogram for the units sold per period 5. 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. 3 UMGC/MHFallah 6. 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. Number of Calls Monday 53 Tuesday 52 Wednesday 47 Thursday 49 Friday 60 Saturday 25 Sunday 20 Monday 65 Tuesday 62 Wednesday 60 Thursday 54 Friday 59 Saturday 35 Sunday 37 Monday 70 Tuesday 74 Wednesday 65 Thursday 62 Friday 80 Saturday 40 Sunday 36 Monday 83 Tuesday 86 Wednesday 69 Thursday 63 Friday 89 Saturday 30 Sunday 42