Generate Binomial random counts

Example: nonconforming items per tray

Simulate 200 trays of 50 items. Each item has a supplied 4% probability of being nonconforming, independently of the other items.

Download the generator parameters (reference CSV)

This is the same example used in Help. The CSV lists the generator parameters for reference. Enter them manually on Inputs; importing the CSV does not configure the generator or provide measured observations.

1. Create the generator

In the sidebar, choose Data utilities, then Create Random Data. Name the analysis, select New blank worksheet and choose Create analysis. This worksheet receives the generated columns.

2. Set the generated variable

On Inputs, under Generated variables, enter nonconforming_per_tray in Column name and 200 in Number of observations. Choose Binomial in Distribution.

Enter 50 in Number of trials (n) and 0.04 in Probability of success (p). Here “success” means the counted event: a nonconforming item.

3. Set the seed and destination

Open Reproducibility and enter 42 in Random seed.

Check Worksheet output: the destination should be your analysis worksheet, with one new column. Generate once to reproduce this example. Each successful run appends new columns.

Create Random Data: Inputs with the example’s assignments and settings — The Binomial definition and seed 42 on Inputs. The worksheet receives one new column. View full-size image (opens in a new tab)

4. Generate data

Choose Generate data, then open Results. Open Worksheet to see the new columns.

5. Interpret results

Check the generated output
There is one new column, nonconforming_per_tray, with 200 values. These are simulated observations for practice, not measured production data.
Read the model
Each tray contains 50 item trials with the same 4% nonconformance probability. The model assumes independent item outcomes. These are practice assumptions, not findings about a production line.
Read a generated row
The first generated tray has 3 nonconforming items; the fifth has 0. Each value is a whole-number count from 0 through 50. It counts nonconforming items, not several defects on one item.
Use the sample deliberately
Use the generated columns to practise an analysis or explore the supplied model. Seed 42 repeats this sample with the same ordered definitions and calculation version. A blank seed requests a fresh sample. Running Generate data again appends columns; it does not replace the earlier output.

More details: read each result section

Complete result tables use six significant digits, as in Help.

Generation summary

The summary lists nonconforming_per_tray, its 200 valid values, the distribution and seed 42.

Calculated example output. Running a practice copy writes new columns to its independent worksheet.

Generation summary · 1 row
Definition	Output column	Distribution	Valid values	Seed
nonconforming_per_tray	nonconforming_per_tray	binomial	200	42

Captured generator parameters

Each tray contains 50 item trials with the same 4% nonconformance probability. The model assumes independent item outcomes. These are practice assumptions, not findings about a production line.

Captured generator parameters · 2 rows
Definition	Parameter	Value
nonconforming_per_tray	n	50
nonconforming_per_tray	p	0.04

Generated values

All 200 generated rows are retained in generation order. The first generated tray has 3 nonconforming items; the fifth has 0. Each value is a whole-number count from 0 through 50. It counts nonconforming items, not several defects on one item.

Captured values in original row order. Exports retain full precision.

Generated values · 200 rows
Row	nonconforming_per_tray
1	3
2	2
3	3
4	3
5	0
6	5
7	3
8	3
9	0
10	2
11	1
12	4
13	2
14	3
15	2
16	1
17	2
18	0
19	3
20	2
21	3
22	1
23	5
24	4
25	3
26	1
27	2
28	0
29	1
30	3
31	3
32	5
33	1
34	1
35	2
36	1
37	1
38	2
39	1
40	2
41	2
42	3
43	3
44	1
45	3
46	3
47	1
48	1
49	3
50	1
51	1
52	0
53	3
54	2
55	3
56	3
57	2
58	2
59	1
60	0
61	2
62	2
63	2
64	3
65	2
66	2
67	2
68	1
69	0
70	2
71	1
72	2
73	3
74	1
75	0
76	1
77	1
78	2
79	2
80	3
81	2
82	2
83	3
84	1
85	0
86	0
87	3
88	2
89	1
90	2
91	1
92	3
93	2
94	1
95	1
96	2
97	1
98	0
99	0
100	5
101	4
102	3
103	1
104	5
105	3
106	3
107	2
108	1
109	0
110	4
111	2
112	1
113	1
114	2
115	1
116	3
117	3
118	3
119	2
120	2
121	2
122	2
123	0
124	2
125	0
126	2
127	1
128	1
129	0
130	2
131	1
132	4
133	2
134	1
135	2
136	0
137	5
138	2
139	3
140	0
141	2
142	2
143	4
144	2
145	2
146	1
147	1
148	2
149	2
150	0
151	3
152	4
153	1
154	2
155	0
156	2
157	1
158	2
159	3
160	3
161	0
162	4
163	1
164	0
165	2
166	1
167	3
168	3
169	1
170	5
171	1
172	2
173	1
174	4
175	1
176	0
177	2
178	6
179	4
180	3
181	4
182	4
183	2
184	1
185	3
186	2
187	1
188	0
189	3
190	1
191	4
192	1
193	0
194	3
195	1
196	1
197	2
198	4
199	1
200	1

6. Create a report

Keep Generation summary, Captured generator parameters and Generated values. Record the seed, the model and its units. Label the output as simulated practice data.

Choose Add to report from the completed run. Open Choose individual items and advanced options to select tables and charts, then choose Add to draft. Hidden items stay in the saved analysis.

Name the report and add the purpose of the study and your interpretation. Choose Save, review Preview, then use Export → Download HTML. The example below contains the full selected content, including results beyond one screen.

Complete native output for this Help example, including applicable tables, charts and run notes. Report numbers use the app’s displayed precision. Exported charts are static. On narrow screens, scroll wide charts and tables sideways.

Open full report Download HTML report

View example report

Row	nonconforming_per_tray
1	3
2	2
3	3
4	3
5	0
6	5
7	3
8	3
9	0
10	2
11	1
12	4
13	2
14	3
15	2
16	1
17	2
18	0
19	3
20	2
21	3
22	1
23	5
24	4
25	3
26	1
27	2
28	0
29	1
30	3
31	3
32	5
33	1
34	1
35	2
36	1
37	1
38	2
39	1
40	2
41	2
42	3
43	3
44	1
45	3
46	3
47	1
48	1
49	3
50	1
51	1
52	0
53	3
54	2
55	3
56	3
57	2
58	2
59	1
60	0
61	2
62	2
63	2
64	3
65	2
66	2
67	2
68	1
69	0
70	2
71	1
72	2
73	3
74	1
75	0
76	1
77	1
78	2
79	2
80	3
81	2
82	2
83	3
84	1
85	0
86	0
87	3
88	2
89	1
90	2
91	1
92	3
93	2
94	1
95	1
96	2
97	1
98	0
99	0
100	5
101	4
102	3
103	1
104	5
105	3
106	3
107	2
108	1
109	0
110	4
111	2
112	1
113	1
114	2
115	1
116	3
117	3
118	3
119	2
120	2
121	2
122	2
123	0
124	2
125	0
126	2
127	1
128	1
129	0
130	2
131	1
132	4
133	2
134	1
135	2
136	0
137	5
138	2
139	3
140	0
141	2
142	2
143	4
144	2
145	2
146	1
147	1
148	2
149	2
150	0
151	3
152	4
153	1
154	2
155	0
156	2
157	1
158	2
159	3
160	3
161	0
162	4
163	1
164	0
165	2
166	1
167	3
168	3
169	1
170	5
171	1
172	2
173	1
174	4
175	1
176	0
177	2
178	6
179	4
180	3
181	4
182	4
183	2
184	1
185	3
186	2
187	1
188	0
189	3
190	1
191	4
192	1
193	0
194	3
195	1
196	1
197	2
198	4
199	1
200	1

Row	nonconforming_per_tray
1	3
2	2
3	3
4	3
5	0
6	5
7	3
8	3
9	0
10	2
11	1
12	4
13	2
14	3
15	2
16	1
17	2
18	0
19	3
20	2
21	3
22	1
23	5
24	4
25	3
26	1
27	2
28	0
29	1
30	3
31	3
32	5
33	1
34	1
35	2
36	1
37	1
38	2
39	1
40	2
41	2
42	3
43	3
44	1
45	3
46	3
47	1
48	1
49	3
50	1
51	1
52	0
53	3
54	2
55	3
56	3
57	2
58	2
59	1
60	0
61	2
62	2
63	2
64	3
65	2
66	2
67	2
68	1
69	0
70	2
71	1
72	2
73	3
74	1
75	0
76	1
77	1
78	2
79	2
80	3
81	2
82	2
83	3
84	1
85	0
86	0
87	3
88	2
89	1
90	2
91	1
92	3
93	2
94	1
95	1
96	2
97	1
98	0
99	0
100	5
101	4
102	3
103	1
104	5
105	3
106	3
107	2
108	1
109	0
110	4
111	2
112	1
113	1
114	2
115	1
116	3
117	3
118	3
119	2
120	2
121	2
122	2
123	0
124	2
125	0
126	2
127	1
128	1
129	0
130	2
131	1
132	4
133	2
134	1
135	2
136	0
137	5
138	2
139	3
140	0
141	2
142	2
143	4
144	2
145	2
146	1
147	1
148	2
149	2
150	0
151	3
152	4
153	1
154	2
155	0
156	2
157	1
158	2
159	3
160	3
161	0
162	4
163	1
164	0
165	2
166	1
167	3
168	3
169	1
170	5
171	1
172	2
173	1
174	4
175	1
176	0
177	2
178	6
179	4
180	3
181	4
182	4
183	2
184	1
185	3
186	2
187	1
188	0
189	3
190	1
191	4
192	1
193	0
194	3
195	1
196	1
197	2
198	4
199	1
200	1