Top Billers processes bills for customers. Lately, they have been getting complaints of errors in the bills
Question:
Top Billers processes bills for customers. Lately, they have been getting complaints of errors in the bills they have processed. Bills can contain errors resulting from a number of causes, such as incorrect amounts, wrong dates, wrong customer information, etc. The quality manager for Top Billers decides to sample one customer’s batch of bills per day to determine the number and proportion of errors. Use a u-chart to analyze the data found in the table in the worksheet Prob07-09 in the Ch07Data.xlsx file.
Top Billers | ||||||||||||
Average Number of Nonconformances Per Unit (u) Chart | ||||||||||||
This spreadsheet is designed for up to 75 samples. Enter data ONLY in yellow-shaded cells. | ||||||||||||
Click on the sheet tab to display the control chart (some rescaling may be needed). | ||||||||||||
Average (u-bar) | 0.01406 | |||||||||||
Sample | ||||||||||||
Number of | Unit | Defects | Standard | |||||||||
Sample | Nonconformances | Size | per unit | Deviation | LCLu | CL | UCLu | |||||
1 | 2 | 171 | 0.0117 | 0.00907 | 0 | 0.0141 | 0.0413 | 2 | 171 | |||
2 | 1 | 194 | 0.0052 | 0.00851 | 0 | 0.0141 | 0.0396 | 1 | 194 | |||
3 | 1 | 121 | 0.0083 | 0.01078 | 0 | 0.0141 | 0.0464 | 1 | 121 | |||
4 | 3 | 200 | 0.0150 | 0.00839 | 0 | 0.0141 | 0.0392 | 3 | 200 | |||
5 | 1 | 159 | 0.0063 | 0.00940 | 0 | 0.0141 | 0.0423 | 1 | 159 | |||
6 | 3 | 162 | 0.0185 | 0.00932 | 0 | 0.0141 | 0.0420 | 3 | 162 | |||
7 | 4 | 186 | 0.0215 | 0.00870 | 0 | 0.0141 | 0.0402 | 4 | 186 | |||
8 | 1 | 182 | 0.0055 | 0.00879 | 0 | 0.0141 | 0.0404 | 1 | 182 | |||
9 | 2 | 155 | 0.0129 | 0.00953 | 0 | 0.0141 | 0.0426 | 2 | 155 | |||
10 | 2 | 185 | 0.0108 | 0.00872 | 0 | 0.0141 | 0.0402 | 2 | 185 | |||
11 | 1 | 179 | 0.0056 | 0.00886 | 0 | 0.0141 | 0.0407 | 1 | 179 | |||
12 | 3 | 160 | 0.0188 | 0.00938 | 0 | 0.0141 | 0.0422 | 3 | 160 | |||
13 | 1 | 159 | 0.0063 | 0.00940 | 0 | 0.0141 | 0.0423 | 1 | 159 | |||
14 | 1 | 154 | 0.0065 | 0.00956 | 0 | 0.0141 | 0.0427 | 1 | 154 | |||
15 | 7 | 151 | 0.0464 | 0.00965 | 0 | 0.0141 | 0.0430 | 7 | 151 | |||
16 | 5 | 169 | 0.0296 | 0.00912 | 0 | 0.0141 | 0.0414 | 5 | 169 | |||
17 | 3 | 189 | 0.0159 | 0.00863 | 0 | 0.0141 | 0.0399 | 3 | 189 | |||
18 | 4 | 178 | 0.0225 | 0.00889 | 0 | 0.0141 | 0.0407 | 4 | 178 | |||
19 | 2 | 161 | 0.0124 | 0.00935 | 0 | 0.0141 | 0.0421 | 2 | 161 | |||
20 | 1 | 198 | 0.0051 | 0.00843 | 0 | 0.0141 | 0.0393 | 1 | 198 | |||
21 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
22 | #N/A | #N/A | #N/A | #N/A | #N/A | SUM = | 48 | 3413 | ||||
23 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
24 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
25 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
26 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
27 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
28 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
29 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
30 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
31 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
32 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
33 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
34 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
35 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
36 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
37 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
38 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
39 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
40 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
41 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
42 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
43 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
44 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
45 | #N/A | #N/A | #N/A | #N/A | #N/A | |||||||
46 | #N/A | #N/A | #N/A | #N/A | #N/A |
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
An Introduction To Six Sigma And Process ImprovementISBN: 9781133604587 2nd Edition Authors: James R. Evans, William M. Lindsay
Question Posted:
|