If you have observed counts that are summarized by category, complete the following steps.
- In Part
numbers, enter the column that contains the part names or numbers.
- In Reference
values, enter the column that contains the reference values for each part. The reference value is the known standard measurement for each part.
- Under Binary attributes
in, select Summarized
counts. Organize summarized data in the worksheet so that each row contains the part name or number, reference value, and summarized count. Parts can be text or numeric. Reference values and counts must be numeric.
- In Number of
trials, enter the number of times that each part was measured.
- In Attribute
label, you can enter a custom label.
In this worksheet, Part contains the part number identifiers, Reference contains the known standard measurement, and Acceptances contains the summarized count of acceptances of that part.
| C1 |
C2 |
C3 |
| Part |
Reference |
Acceptances |
| 1 |
1.35 |
0 |
| 2 |
1.40 |
3 |
| 3 |
1.45 |
8 |
| 4 |
1.50 |
13 |
| 5 |
1.55 |
15 |
| 6 |
1.60 |
18 |
| 7 |
1.65 |
19 |
| 8 |
1.70 |
20 |