QUESTIONS

1- ABC Corporation has been tracking its average weekly customer satisfaction rating on a scale of 1 to 5. The data for the past 20 weeks are listed below. What is a trend chart? And comment on the company's customer satisfaction performance.

Average customer

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

What is a Pareto chart to identify the top priority problem for the helpdesk staff?

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. What is 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 Sales in units

$1000

10 280

15 250

5 220

35 400

20 380

25 360

30 320

40 450

50 500

55 700

4- What is a histogram of the units sold per period?

5- John is the marketing manager and wants to discover the root causes of the drop in sales. What is a fishbone diagram to identify the possible causes? Apply the general knowledge to populate the fishbone.

6 - A call center manager has been collecting call data. The following table shows the number of calls received. What is a trend chart and comment on the call center workload?

		Number of Calls
Week 1	Monday	53
Tuesday	52
Wednesday	47
Thursday	49
Friday	60
Saturday	25
Sunday	20
Week 2	Monday	65
Tuesday	62
Wednesday	60
Thursday	54
Friday	59
Saturday	35
Sunday	37
Week3	Monday	70
Tuesday	74
Wednesday	65
Thursday	62
Friday	80
Saturday	40
Sunday	36
Week4	Monday	83
Tuesday	86
Wednesday	69
Thursday	63
Friday	89
Saturday	30
Sunday	42