basic statistic
IM311-HW3 NAME________________
1-)“SEMO” is producing “metal washer” that will have to fit into a slot in an assembly. The dimensions are given as below (in millimeters). Assume that you are hired as a manufacturer engineer and company SEMO is requesting following items from you (14pts)
A) Please build a histogram in excel and interpret it (5pts)
B) What would be an appropriate chart to use to determine whether is in control or not. Give your justification (4pts)
C) Please draw the chart (that you determined in part b) in excel and interpret your results (5pts)
|
Sample |
x |
|||||
|
1 |
28 |
42 |
54 |
46 |
64 |
54 |
|
2 |
33 |
36 |
28 |
75 |
63 |
48 |
|
3 |
36 |
38 |
36 |
37 |
62 |
61 |
|
4 |
34 |
45 |
47 |
37 |
62 |
48 |
|
5 |
54 |
45 |
75 |
55 |
18 |
85 |
2-)Please create a pareto chart in excel for the following problem
|
Items |
Number of Defective Parts |
|
Part A |
1550 |
|
Part B |
1365 |
|
Part C |
1200 |
|
Part D |
900 |
|
Part E |
880 |
|
Part F |
450 |
|
Part G |
387 |