06762 Topic: PROCESS ANALYSIS

ltdprinwival
P-CHART_solver.xlsx

p-chart Input

Defective trucks Trucks built
per day per day
12 78
15 69
19 75
13 73
9 71
26 79
18 68
14 73
17 76
18 78
16 73
24 81
11 76
31 82

p-chart Output

Defective trucks Trucks built Percentage of defects
per day per day
12 78 15%
15 69 22%
19 75 25%
13 73 18%
9 71 13%
26 79 33%
18 68 26%
14 73 19%
17 76 22%
18 78 23%
16 73 22%
24 81 30%
11 76 14%
31 82 38%
Average 23%
UCL 44%
LCL 2%
Standard Deviation 7%
p~ UCL LCL % Defects
1 23% 44% 2% 15%
2 23% 44% 2% 22%
3 23% 44% 2% 25%
4 23% 44% 2% 18%
5 23% 44% 2% 13%
6 23% 44% 2% 33%
7 23% 44% 2% 26%
8 23% 44% 2% 19%
9 23% 44% 2% 22%
10 23% 44% 2% 23%
11 23% 44% 2% 22%
12 23% 44% 2% 30%
13 23% 44% 2% 14%
14 23% 44% 2% 38%
StdD 7%

p-chart of Defective Trucks

p~ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 0.22912340124189218 UCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 0.43522350895444095 LCL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343 E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 2.302329352934343E-2 % Defects 1 2 3 4 5 6 7 8 9 10 11 12 13 14 0.15384615384615385 0.21739130434782608 0.25333333333333335 0.17808219178082191 0.1267605633802 8169 0.32911392405063289 0.26470588235294118 0.19178082191780821 0.22368421052631579 0.23076923076923078 0.21917808219178081 0.29629629629629628 0.14473684210526316 0.37804878048780488

Data Point

Percent

Sheet3