NEED A REWRITE ON WEEK ONE Quality Control

Ch02_Case.xlsx

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	8
2	0	7					2	0	Place column chart here
3	3	7	Place line chart here				3	3
4	13	7					4	13
5	3	7					5	3
6	0	7					6	0
7	21	7					7	21
8	0	7					8	0
9	8	7					9	8
10	12	7					10	12
11	3	7					11	3
12	4	7					12	4
13	8	7					13	8
14	4	7					14	4
15	2	7					15	2
16	0	7					16	0
17	4	7					17	4
18	6	7					18	6
19	15	7					19	15
20	22	7					20	22
21	5	7					21	5
22	4	7					22	4
23	5	7					23	5
24	3	7					24	3
25	5	7					25	5
26	20	7					26	20
27	6	7					27	6
28	8	7					28	8
29	5	7					29	5
30	6	7					30	6
31	10	7					31	10
32	0	7					32	0
33	11	7					33	11
34	19	7					34	19
35	11	7					35	11
36	3	7					36	3
37	6	7					37	6
38	13	7					38	13
39	4	7					39	4
40	0	7					40	0