EXCEL计算PPK

制程能力分析（ 制程能力分析（PPK） ）
Fubon electricity limited company.
General Information Project Number : Model Number : Motor Number : Process : Characteristic: Instrument : Specification Maximum = Minimum = 1 1~10 11~20 21~30 31~40 41~50 51~60 61~70 71~80 81~90 91~100 Mean : SD (σ) : Minimum : Maximum : Range : 54.398 1.470 50.600 57.900 7.300 Mean + 4σ : Mean - 4σ : 60.278 48.518 Mean + 3σ : Mean - 3σ : 58.808 49.988 Pp : PpL : PpU : CP: PpK : 2.27 2.131 2.404 2.268 2.131
51.70 56.90 54.50 53.30 54.30
Results
Report No. : Date : Inspector : Location : Process Potential Pp = 2.27 Process Capability Ppk = 2.13
65.0 45.0 2
50.60 51.90 55.30 53.90 55.10
Nominal = 55.000 Range = 20.000 Sample Test Results 4
56.90 55.10 54.30 53.50 54.50
3
57.90 52.10 54.90 53.50 54.10
5
56.70 54.90 53.70 52.50 53.90
6
56.70 54.70 53.10 53.30 53.10
7
55.30 55.30 54.50 53.50 53.30
8
56.10 55.30 53.10 53.30 55.30
9
53.70 54.50 53.90 56.70 55.70
10
54.50 54.90 53.50 54.50 56.10
Distribution Graph
35
30
25
20
15
10
5
0 35 40 45 50 55 60 65 70
Page: 1