hypergeometric

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6, B7 and B8
batch size 100
sample size 10
acceptance number 1
AQL 10.00% OC Curve

LQ 20.00%

Prob of accept
100.00%

actual producer's risk 26.15%

80.00%
actual consumer's risk 36.30%

Proportion defective in batch prob(acceptance) 60.00%

0 100.00%
0.01 100.00%
0.02 99.09% 40.00%

0.03 97.42%
0.04 95.12% 20.00%
0.05 92.31%
0.06 89.10%
0.07 85.57% 0.00%
0 0.2 0.4 0.6 0.8 1 1.2
0.08 81.81% Proportion defective

0.09 77.88%
0.1 73.85%
0.11 69.77%
0.12 65.68%
0.13 61.63%
0.14 57.65%
0.15 53.75%
0.16 49.98%
0.17 46.33%
0.18 42.83%
0.19 39.49%
0.2 36.30%
0.21 33.29%
0.22 30.45%
0.23 27.77%
0.24 25.27%
0.25 22.93%
0.26 20.75%
0.27 18.73%
0.28 16.86%

Page 1
 hypergeometric

0.29 15.14%
0.3 13.56%
0.31 12.11%
0.32 10.79%
0.33 9.58%
0.34 8.49%
0.35 7.50%
0.36 6.60%
0.37 5.80%
0.38 5.07%
0.39 4.43%
0.4 3.85%
0.41 3.34%
0.42 2.89%
0.43 2.48%
0.44 2.13%
0.45 1.82%
0.46 1.55%
0.47 1.32%
0.48 1.11%
0.49 0.93%
0.5 0.78%
0.51 0.65%
0.52 0.54%
0.53 0.45%
0.54 0.37%
0.55 0.30%
0.56 0.24%
0.57 0.20%
0.58 0.16%
0.59 0.13%
0.6 0.10%
0.61 0.08%
0.62 0.06%
0.63 0.05%
0.64 0.04%
0.65 0.03%
0.66 0.02%
0.67 0.02%
0.68 0.01%
0.69 0.01%
0.7 0.01%
0.71 0.00%
0.72 0.00%

Page 2
 hypergeometric

0.73 0.00%
0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 3
 hypergeometric

urve

0.6 0.8 1 1.2

tion defective

Page 4
 Casting

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 20 Lot Size: 281 to 500
acceptance number 0
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 99.33%
actual consumer's risk 0.67%
100.00%

Defects per unit in batch prob(acceptance)

80.00%
0 100.00%
0.01 81.87%
60.00%
0.02 67.03%
0.03 54.88%
40.00%
0.04 44.93%
0.05 36.79%
0.06 30.12% 20.00%

0.07 24.66%
0.08 20.19% 0.00%
0.09 16.53% 0 20 40
Defects 60 unit 80
per 100 120

0.1 13.53%
0.11 11.08%
0.12 9.07%
0.13 7.43%
0.14 6.08%
0.15 4.98%
0.16 4.08%
0.17 3.34%
0.18 2.73%
0.19 2.24%
0.2 1.83%
0.21 1.50%
0.22 1.23%
0.23 1.01%
0.24 0.82%
0.25 0.67%
0.26 0.55%
0.27 0.45%
0.28 0.37%
0.29 0.30%

Page 5
 Casting

0.3 0.25%
0.31 0.20%
0.32 0.17%
0.33 0.14%
0.34 0.11%
0.35 0.09%
0.36 0.07%
0.37 0.06%
0.38 0.05%
0.39 0.04%
0.4 0.03%
0.41 0.03%
0.42 0.02%
0.43 0.02%
0.44 0.02%
0.45 0.01%
0.46 0.01%
0.47 0.01%
0.48 0.01%
0.49 0.01%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 6
 Casting

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 7
 Casting

281 to 500

Curve

60 unit 80
ects per 100 120

Page 8
 Casting-1

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 32 Lot Size:
acceptance number 0
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 99.97%
actual consumer's risk 0.03% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 72.61%
60.00%
0.02 52.73%
0.03 38.29%
40.00%
0.04 27.80%
0.05 20.19%
0.06 14.66% 20.00%

0.07 10.65%
0.08 7.73% 0.00%
0.09 5.61% 0 20 40
Defects 60 unit
per 80 100 120

0.1 4.08%
0.11 2.96%
0.12 2.15%
0.13 1.56%
0.14 1.13%
0.15 0.82%
0.16 0.60%
0.17 0.43%
0.18 0.32%
0.19 0.23%
0.2 0.17%
0.21 0.12%
0.22 0.09%
0.23 0.06%
0.24 0.05%
0.25 0.03%
0.26 0.02%
0.27 0.02%
0.28 0.01%
0.29 0.01%

Page 9
 Casting-1

0.3 0.01%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 10
 Casting-1

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 11
 Casting-1

Curve

60 unit
cts per 80 100 120

Page 12
 Row Forging

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 80 Lot Size:
acceptance number 1
AQL 0.4
LQ 0.4 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 80.88% 60.00%
0.02 52.49%
0.03 30.84% 40.00%
0.04 17.12%
0.05 9.16% 20.00%
0.06 4.77%
0.07 2.44% 0.00%
0.08 1.23% 0 20 40 60 80 100 120

0.09 0.61% Defects per unit

0.1 0.30%
0.11 0.15%
0.12 0.07%
0.13 0.03%
0.14 0.02%
0.15 0.01%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 13
 Row Forging

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 14
 Row Forging

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 15
 Row Forging

3201 to 10000

Curve

60 80 100 120
cts per unit

Page 16
 Bearing

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 32 Lot Size:
acceptance number 0
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 99.97%
actual consumer's risk 0.03% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 72.61%
60.00%
0.02 52.73%
0.03 38.29%
40.00%
0.04 27.80%
0.05 20.19%
0.06 14.66% 20.00%

0.07 10.65%
0.08 7.73% 0.00%
0.09 5.61% 0 20 40
Defects 60 unit
per 80 100 120

0.1 4.08%
0.11 2.96%
0.12 2.15%
0.13 1.56%
0.14 1.13%
0.15 0.82%
0.16 0.60%
0.17 0.43%
0.18 0.32%
0.19 0.23%
0.2 0.17%
0.21 0.12%
0.22 0.09%
0.23 0.06%
0.24 0.05%
0.25 0.03%
0.26 0.02%
0.27 0.02%
0.28 0.01%
0.29 0.01%

Page 17
 Bearing

0.3 0.01%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 18
 Bearing

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 19
 Bearing

501 to 1200

Curve

60 unit
cts per 80 100 120

Page 20
 Bearing-1

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 125 Lot Size:
acceptance number 1
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 64.46% 60.00%
0.02 28.73%
0.03 11.17% 40.00%
0.04 4.04%
0.05 1.40% 20.00%
0.06 0.47%
0.07 0.15% 0.00%
0.08 0.05% 0 20 40 60 80 100 120

0.09 0.02% Defects per unit

0.1 0.01%
0.11 0.00%
0.12 0.00%
0.13 0.00%
0.14 0.00%
0.15 0.00%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 21
 Bearing-1

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 22
 Bearing-1

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 23
 Bearing-1

501 to 1200

Curve

60 80 100 120
cts per unit

Page 24
 Spring

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 125 Lot Size:
acceptance number 1
AQL 0.4
LQ 0.4 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 64.46% 60.00%
0.02 28.73%
0.03 11.17% 40.00%
0.04 4.04%
0.05 1.40% 20.00%
0.06 0.47%
0.07 0.15% 0.00%
0.08 0.05% 0 20 40 60 80 100 120

0.09 0.02% Defects per unit

0.1 0.01%
0.11 0.00%
0.12 0.00%
0.13 0.00%
0.14 0.00%
0.15 0.00%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 25
 Spring

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 26
 Spring

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 27
 Spring

10001 to 35000

Curve

60 80 100 120
cts per unit

Page 28
 Friction Material

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 80 Lot Size:
acceptance number 1
AQL 0.4
LQ 0.4 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 80.88% 60.00%
0.02 52.49%
0.03 30.84% 40.00%
0.04 17.12%
0.05 9.16% 20.00%
0.06 4.77%
0.07 2.44% 0.00%
0.08 1.23% 0 20 40 60 80 100 120

0.09 0.61% Defects per unit

0.1 0.30%
0.11 0.15%
0.12 0.07%
0.13 0.03%
0.14 0.02%
0.15 0.01%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 29
 Friction Material

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 30
 Friction Material

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 31
 Friction Material

3201 to 10000

Curve

60 80 100 120
cts per unit

Page 32
 Friction Material-1

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 200 Lot Size:
acceptance number 2
AQL 0.4
LQ 0.4 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 67.67% 60.00%
0.02 23.81%
0.03 6.20% 40.00%
0.04 1.38%
0.05 0.28% 20.00%
0.06 0.05%
0.07 0.01% 0.00%
0.08 0.00% 0 20 40 60 80 100 120

0.09 0.00% Defects per unit

0.1 0.00%
0.11 0.00%
0.12 0.00%
0.13 0.00%
0.14 0.00%
0.15 0.00%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 33
 Friction Material-1

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 34
 Friction Material-1

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 35
 Friction Material-1

35001 to 150000

Curve

60 80 100 120
cts per unit

Page 36
 Rivets and Fastners

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 315 Lot Size:
acceptance number 7
AQL 1
LQ 1 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 98.45% 60.00%
0.02 70.17%
0.03 27.39% 40.00%
0.04 6.64%
0.05 1.16% 20.00%
0.06 0.16%
0.07 0.02% 0.00%
0.08 0.00% 0 20 40 60 80 100 120

0.09 0.00% Defects per unit

0.1 0.00%
0.11 0.00%
0.12 0.00%
0.13 0.00%
0.14 0.00%
0.15 0.00%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 37
 Rivets and Fastners

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 38
 Rivets and Fastners

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 39
 Rivets and Fastners

35001 to 150000

Curve

60 80 100 120
cts per unit

Page 40
 Heat Treatment

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 50 Lot Size:
acceptance number 0
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 60.65% 60.00%
0.02 36.79%
0.03 22.31% 40.00%
0.04 13.53%
0.05 8.21% 20.00%
0.06 4.98%
0.07 3.02% 0.00%
0.08 1.83% 0 20 40 60 80 100 120

0.09 1.11% Defects per unit

0.1 0.67%
0.11 0.41%
0.12 0.25%
0.13 0.15%
0.14 0.09%
0.15 0.06%
0.16 0.03%
0.17 0.02%
0.18 0.01%
0.19 0.01%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 41
 Heat Treatment

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 42
 Heat Treatment

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 43
 Heat Treatment

1201 to 3200

Curve

60 80 100 120
cts per unit

Page 44
 Job Work

Operating Characteristic Curve (single sampling plan by attributes)

Choose the appropriate worksheet and fill in cells B4, B5, B6 and B7
sample size 80 Lot Size:
acceptance number 0
AQL 0.25
LQ 0.25 OC Curve

120.00%

Prob of accept
actual producer's risk 100.00%
actual consumer's risk 0.00% 100.00%

Defects per unit in batch prob(acceptance) 80.00%

0 100.00%
0.01 44.93% 60.00%
0.02 20.19%
0.03 9.07% 40.00%
0.04 4.08%
0.05 1.83% 20.00%
0.06 0.82%
0.07 0.37% 0.00%
0.08 0.17% 0 20 40 60 80 100 120

0.09 0.07% Defects per unit

0.1 0.03%
0.11 0.02%
0.12 0.01%
0.13 0.00%
0.14 0.00%
0.15 0.00%
0.16 0.00%
0.17 0.00%
0.18 0.00%
0.19 0.00%
0.2 0.00%
0.21 0.00%
0.22 0.00%
0.23 0.00%
0.24 0.00%
0.25 0.00%
0.26 0.00%
0.27 0.00%
0.28 0.00%
0.29 0.00%

Page 45
 Job Work

0.3 0.00%
0.31 0.00%
0.32 0.00%
0.33 0.00%
0.34 0.00%
0.35 0.00%
0.36 0.00%
0.37 0.00%
0.38 0.00%
0.39 0.00%
0.4 0.00%
0.41 0.00%
0.42 0.00%
0.43 0.00%
0.44 0.00%
0.45 0.00%
0.46 0.00%
0.47 0.00%
0.48 0.00%
0.49 0.00%
0.5 0.00%
0.51 0.00%
0.52 0.00%
0.53 0.00%
0.54 0.00%
0.55 0.00%
0.56 0.00%
0.57 0.00%
0.58 0.00%
0.59 0.00%
0.6 0.00%
0.61 0.00%
0.62 0.00%
0.63 0.00%
0.64 0.00%
0.65 0.00%
0.66 0.00%
0.67 0.00%
0.68 0.00%
0.69 0.00%
0.7 0.00%
0.71 0.00%
0.72 0.00%
0.73 0.00%

Page 46
 Job Work

0.74 0.00%
0.75 0.00%
0.76 0.00%
0.77 0.00%
0.78 0.00%
0.79 0.00%
0.8 0.00%
0.81 0.00%
0.82 0.00%
0.83 0.00%
0.84 0.00%
0.85 0.00%
0.86 0.00%
0.87 0.00%
0.88 0.00%
0.89 0.00%
0.9 0.00%
0.91 0.00%
0.92 0.00%
0.93 0.00%
0.94 0.00%
0.95 0.00%
0.96 0.00%
0.97 0.00%
0.98 0.00%
0.99 0.00%
1 0.00%

Page 47
 Job Work

3201 to 10000

Curve

60 80 100 120
cts per unit

Page 48
 sums

The hypergeotric function does not return cumulative values. These are calculated by this worksheet.
It won't work if the value of c is too small. If necessary copy cells F7:F108 across to the right, and adjust the formulae in B
in the hypergeometric sheet. With small batches there seem to be a few bugs in functions.

Prop defective Cumulative Probability of acceptance

c
0 1 2 3 4
0 100.00% 100.00% 0.00% 0.00% 0.00% 0.00%
0.01 100.00% 90.00% 10.00% 0.00% 0.00% 0.00%
0.02 99.09% 80.91% 18.18% 0.00% 0.00% 0.00%
0.03 97.42% 72.65% 24.77% 0.00% 0.00% 0.00%
0.04 95.12% 65.16% 29.96% 0.00% 0.00% 0.00%
0.05 92.31% 58.38% 33.94% 0.00% 0.00% 0.00%
0.06 89.10% 52.23% 36.87% 0.00% 0.00% 0.00%
0.07 85.57% 46.67% 38.90% 0.00% 0.00% 0.00%
0.08 81.81% 41.66% 40.15% 0.00% 0.00% 0.00%
0.09 77.88% 37.13% 40.75% 0.00% 0.00% 0.00%
0.1 73.85% 33.05% 40.80% 0.00% 0.00% 0.00%
0.11 69.77% 29.38% 40.39% 0.00% 0.00% 0.00%
0.12 65.68% 26.08% 39.61% 0.00% 0.00% 0.00%
0.13 61.63% 23.11% 38.52% 0.00% 0.00% 0.00%
0.14 57.65% 20.46% 37.19% 0.00% 0.00% 0.00%
0.15 53.75% 18.08% 35.68% 0.00% 0.00% 0.00%
0.16 49.98% 15.95% 34.03% 0.00% 0.00% 0.00%
0.17 46.33% 14.05% 32.28% 0.00% 0.00% 0.00%
0.18 42.83% 12.36% 30.47% 0.00% 0.00% 0.00%
0.19 39.49% 10.85% 28.64% 0.00% 0.00% 0.00%
0.2 36.30% 9.51% 26.79% 0.00% 0.00% 0.00%
0.21 33.29% 8.32% 24.97% 0.00% 0.00% 0.00%
0.22 30.45% 7.27% 23.18% 0.00% 0.00% 0.00%
0.23 27.77% 6.34% 21.43% 0.00% 0.00% 0.00%
0.24 25.27% 5.51% 19.75% 0.00% 0.00% 0.00%
0.25 22.93% 4.79% 18.14% 0.00% 0.00% 0.00%
0.26 20.75% 4.15% 16.60% 0.00% 0.00% 0.00%
0.27 18.73% 3.59% 15.14% 0.00% 0.00% 0.00%
0.28 16.86% 3.10% 13.77% 0.00% 0.00% 0.00%
0.29 15.14% 2.67% 12.48% 0.00% 0.00% 0.00%
0.3 13.56% 2.29% 11.27% 0.00% 0.00% 0.00%
0.31 12.11% 1.96% 10.15% 0.00% 0.00% 0.00%
0.32 10.79% 1.68% 9.11% 0.00% 0.00% 0.00%
0.33 9.58% 1.43% 8.15% 0.00% 0.00% 0.00%
0.34 8.49% 1.22% 7.27% 0.00% 0.00% 0.00%
0.35 7.50% 1.03% 6.46% 0.00% 0.00% 0.00%
0.36 6.60% 0.88% 5.73% 0.00% 0.00% 0.00%
0.37 5.80% 0.74% 5.06% 0.00% 0.00% 0.00%

Page 49
 sums

0.38 5.07% 0.62% 4.45% 0.00% 0.00% 0.00%

0.39 4.43% 0.52% 3.91% 0.00% 0.00% 0.00%
0.4 3.85% 0.44% 3.42% 0.00% 0.00% 0.00%
0.41 3.34% 0.36% 2.98% 0.00% 0.00% 0.00%
0.42 2.89% 0.30% 2.58% 0.00% 0.00% 0.00%
0.43 2.48% 0.25% 2.23% 0.00% 0.00% 0.00%
0.44 2.13% 0.21% 1.93% 0.00% 0.00% 0.00%
0.45 1.82% 0.17% 1.65% 0.00% 0.00% 0.00%
0.46 1.55% 0.14% 1.41% 0.00% 0.00% 0.00%
0.47 1.32% 0.11% 1.20% 0.00% 0.00% 0.00%
0.48 1.11% 0.09% 1.02% 0.00% 0.00% 0.00%
0.49 0.93% 0.07% 0.86% 0.00% 0.00% 0.00%
0.5 0.78% 0.06% 0.72% 0.00% 0.00% 0.00%
0.51 0.65% 0.05% 0.61% 0.00% 0.00% 0.00%
0.52 0.54% 0.04% 0.50% 0.00% 0.00% 0.00%
0.53 0.45% 0.03% 0.42% 0.00% 0.00% 0.00%
0.54 0.37% 0.02% 0.34% 0.00% 0.00% 0.00%
0.55 0.30% 0.02% 0.28% 0.00% 0.00% 0.00%
0.56 0.24% 0.01% 0.23% 0.00% 0.00% 0.00%
0.57 0.20% 0.01% 0.19% 0.00% 0.00% 0.00%
0.58 0.16% 0.01% 0.15% 0.00% 0.00% 0.00%
0.59 0.13% 0.01% 0.12% 0.00% 0.00% 0.00%
0.6 0.10% 0.00% 0.09% 0.00% 0.00% 0.00%
0.61 0.08% 0.00% 0.07% 0.00% 0.00% 0.00%
0.62 0.06% 0.00% 0.06% 0.00% 0.00% 0.00%
0.63 0.05% 0.00% 0.05% 0.00% 0.00% 0.00%
0.64 0.04% 0.00% 0.03% 0.00% 0.00% 0.00%
0.65 0.03% 0.00% 0.03% 0.00% 0.00% 0.00%
0.66 0.02% 0.00% 0.02% 0.00% 0.00% 0.00%
0.67 0.02% 0.00% 0.01% 0.00% 0.00% 0.00%
0.68 0.01% 0.00% 0.01% 0.00% 0.00% 0.00%
0.69 0.01% 0.00% 0.01% 0.00% 0.00% 0.00%
0.7 0.01% 0.00% 0.01% 0.00% 0.00% 0.00%
0.71 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.72 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.73 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.74 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.75 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.76 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.77 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.78 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.79 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.8 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.81 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.82 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.83 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.84 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Page 50
 sums

0.85 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

0.86 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.87 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.88 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.89 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.9 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.91 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.92 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.93 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.94 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.95 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.96 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.97 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.98 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.99 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
1 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Page 51
 sums

his worksheet.
e right, and adjust the formulae in B14:B114

Page 52
 notes

There seem to be a few bugs running this with my version of Excel.

With the hypergeometric sheet the consumer's risk sometimes picks up the wrong probability, and strange things happen
for certain small batch numbers. I think the problems may be due to Excel storing integers slightly inaccurately.

Page 53
 notes

ange things happen

Page 54