Discussion:
Token thickness and Bank transaction problem to excel worksheet.
Q: A bank has determined that an average transaction time of sixty seconds with a variation of plus or minus five seconds for automated teller machines (ATM's) is expected. A survey shows the following transaction times.
| Day |
|
|
Time in Seconds |
|
|
| M |
63 |
55 |
56 |
53 |
61 |
| T |
60 |
63 |
60 |
65 |
61 |
| W |
57 |
60 |
61 |
65 |
66 |
| TH |
58 |
64 |
60 |
61 |
57 |
| F |
79 |
68 |
65 |
61 |
71 |
| M |
55 |
66 |
62 |
63 |
56 |
| T |
57 |
61 |
58 |
64 |
55 |
| W |
58 |
51 |
61 |
57 |
66 |
| TH |
65 |
66 |
62 |
68 |
67 |
| F |
73 |
66 |
61 |
70 |
72 |
a. Calculate the process mean.
b. Calculate the average range.
c. Calculate the process control limits for the process mean and the range.
d. Calculate the process capability index (Cp; PCI).
e. Calculate the CpK for the process.
f. Determine if the process is capable and in control.