Need help on week one Quality Control work,

profileDEE9175
week1casestudy1.xlsx
Home>Business & Finance homework help>Management homework help>Need help on week one Quality Control work,

Disciplinary Citation

Chapter 2 Step 1: Create Line Chart using Errors and Average Step 2: Create Pareto Chart using Operator and Errors
Disciplinary Citation Case Select columns Errors and Avg. Click "Insert" and select Line Chart. Select top left option. Chart is created. Explain what chart is showing. Select columns Operators and Errors below. Click "Data" then "Sort." Sort by Errors largest to smallest. Click "Insert" and select Column Chart. Chart is created. Click on the chart graph, then click "Select Data." Click "Operator" then "Remove." Explain what chart is showing.
Data for Package Errors
Operator Errors Avg. Operator Errors
1 8 7 1 22
2 0 7 2 21 Place column chart here
3 3 7 Place line chart here 3 20
4 13 7 4 19
5 3 7 5 15
6 0 7 6 13
7 21 7 7 13
8 0 7 8 12
9 8 7 9 11
10 12 7 10 11
11 3 7 11 10
12 4 7 12 8
13 8 7 13 8
14 4 7 14 8
15 2 7 15 8
16 0 7 16 6
17 4 7 17 6
18 6 7 18 6 The Cumulative % corresponds to the sum of all percentages previous to the highest bar . In this case, in this case removing the highest percentage will help in removing the highest deffects.
19 15 7 19 6
20 22 7 Explanation 20 5
21 5 7 21 5
22 4 7 The graph indicates that the highest number of errors was experience when the operator was at 20 and the lowest was experience when the operator was 2,6,8,16,32,40 22 5
23 5 7 The average remained constant. 23 5
24 3 7 24 4
25 5 7 25 4
26 20 7 26 4
27 6 7 27 4
28 8 7 28 4
29 5 7 29 3
30 6 7 30 3
31 10 7 31 3
32 0 7 32 3
33 11 7 33 3
34 19 7 34 2
35 11 7 35 0
36 3 7 36 0
37 6 7 37 0
38 13 7 38 0
39 4 7 39 0
40 0 7 40 0

Errors and Average Chart

Errors 8 0 3 13 3 0 21 0 8 12 3 4 8 4 2 0 4 6 15 22 5 4 5 3 5 20 6 8 5 6 10 0 11 19 11 3 6 13 4 0 Avg. 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7