One hundred insurance claim forms are inspected daily at Full Life Insurance Co. over 25 working days,
Question:
One hundred insurance claim forms are inspected daily at Full Life Insurance Co. over 25 working days, and the number of forms with errors have been recorded in the worksheet Prob07-06 in the Ch07Data.xlsx file. Construct a p-chart. If any points occur outside the control limits, assume that assignable causes have been determined and construct a revised chart.
Full Life Insurance Co. | ||||||||
Fraction Nonconforming (p) Chart | ||||||||
This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. | ||||||||
Click on the sheet tab to display the control chart (some rescaling may be needed). | ||||||||
Average (p-bar) | 0.022 | |||||||
Avg. sample size | 100 | |||||||
Sample | Fraction | Standard | ||||||
Sample | Value | Size | Nonconforming | Deviation | LCLp | CL | UCLp | |
1 | 3 | 100 | 0.0300 | 0.0147 | 0 | 0.0220 | 0.0660 | |
2 | 3 | 100 | 0.0300 | 0.0147 | 0 | 0.0220 | 0.0660 | |
3 | 3 | 100 | 0.0300 | 0.0147 | 0 | 0.0220 | 0.0660 | |
4 | 2 | 100 | 0.0200 | 0.0147 | 0 | 0.0220 | 0.0660 | |
5 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
6 | 3 | 100 | 0.0300 | 0.0147 | 0 | 0.0220 | 0.0660 | |
7 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
8 | 1 | 100 | 0.0100 | 0.0147 | 0 | 0.0220 | 0.0660 | |
9 | 7 | 100 | 0.0700 | 0.0147 | 0 | 0.0220 | 0.0660 | |
10 | 3 | 100 | 0.0300 | 0.0147 | 0 | 0.0220 | 0.0660 | |
11 | 2 | 100 | 0.0200 | 0.0147 | 0 | 0.0220 | 0.0660 | |
12 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
13 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
14 | 4 | 100 | 0.0400 | 0.0147 | 0 | 0.0220 | 0.0660 | |
15 | 1 | 100 | 0.0100 | 0.0147 | 0 | 0.0220 | 0.0660 | |
16 | 2 | 100 | 0.0200 | 0.0147 | 0 | 0.0220 | 0.0660 | |
17 | 4 | 100 | 0.0400 | 0.0147 | 0 | 0.0220 | 0.0660 | |
18 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
19 | 1 | 100 | 0.0100 | 0.0147 | 0 | 0.0220 | 0.0660 | |
20 | 1 | 100 | 0.0100 | 0.0147 | 0 | 0.0220 | 0.0660 | |
21 | 0 | 100 | 0.0000 | 0.0147 | 0 | 0.0220 | 0.0660 | |
22 | 2 | 100 | 0.0200 | 0.0147 | 0 | 0.0220 | 0.0660 | |
23 | 8 | 100 | 0.0800 | 0.0147 | 0 | 0.0220 | 0.0660 | |
24 | 1 | 100 | 0.0100 | 0.0147 | 0 | 0.0220 | 0.0660 | |
25 | 4 | 100 | 0.0400 | 0.0147 | 0 | 0.0220 | 0.0660 | |
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 | |||
47 | #N/A | #N/A | #N/A | #N/A | #N/A | |||
48 | #N/A | #N/A | #N/A | #N/A | #N/A | |||
49 | #N/A | #N/A | #N/A | #N/A | #N/A | |||
50 | #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 Improvement
ISBN: 9781133604587
2nd Edition
Authors: James R. Evans, William M. Lindsay
Question Posted: