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. 1 Average customer Satisfaction Rating 3.5 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 3.8 4.2 4 2.8 3.3 3.7 2.9 2.5 3.4 3.6 3.7 4.2 4.5 3.9 4.7 4.8 4.6 4 4.1 Week 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. 1 © 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 10 15 5 35 20 25 30 40 50 55 4. Sales in units 280 250 220 400 380 360 320 450 500 700 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. 2 © 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. Week 1 Week 2 Week3 Week4 3 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sunday Number of Calls 53 52 47 49 60 25 20 65 62 60 54 59 35 37 70 74 65 62 80 40 36 83 86 69 63 89 30 42 © UMGC/MHFallah