Using the Age column, take a Simple Random Sample (SRS) of n=30. Show the sample

Using the Age column, take a Simple Random Sample (SRS) of n=30. Show the sample and explain how you took the sample.

Use StatCrunch sampling, Excel Analysis Toolpak sampling, or Excel function Randbetween (using row numbers)

Taking the first 30, or every 5th row, or other such schemes are NOT random.

ID	Age	Gender	Height	Weight	Ideal Weight
1	17	F	68	120	125
2	19	F	63	142	130
3	20	F	62.5	135	120
4	20	M	71	165	165
5	20	F	60	123	115
6	20	F	62	130	115
7	21	F	65	125	110
8	21	F	67	130	125
9	22	F	65	132	125
10	22	F	65	132	125
11	22	M	71	215	195
12	22	F	64	127	117
13	22	F	65	132	125
14	22	F	78	150	175
15	23	M	66	164	155
16	23	F	68	143	143
17	24	M	75	201	200
18	24	F	64	235	140
19	24	F	65	147	140
20	24	F	60	150	120
21	24	M	67	165	160
22	25	F	64	148	138
23	25	M	73	170	180
24	25	F	63	225	175
25	25	F	71	165	150
26	25	M	70	160	175
27	25	M	73	235	180
28	25	M	70	150	175
29	25	M	72	220	200
30	25	F	64	198	145
31	26	F	66	160	150
32	26	M	70	260	180
33	26	F	68	125	125
34	26	M	72	220	205
35	26	F	66	150	125
36	26	M	73	190	180
37	26	M	68	170	160
38	26	F	63	140	128
39	27	M	71	155	165
40	27	M	72	210	200
41	27	M	76	200	215
42	27	M	72	215	195
43	27	F	56	130	105
44	27	F	62	181.8	125
45	28	F	63	116	110
46	28	F	67	165	150
47	28	F	67	165	150
48	28	M	71	260	200
49	28	F	61	135	115
50	28	F	62	130	115
51	29	M	75	235	180
52	29	M	73.5	301	205
53	29	M	70	210	200
54	29	M	72	248	220
55	30	M	73	185	180
56	30	M	73	185	180
57	30	M	73	205	180
58	30	F	68	200	175
59	30	M	71	140	175
60	30	F	60	112	115
61	30	F	60	114	115
62	31	F	63	128	120
63	31	M	72	165	175
64	31	F	64	120	110
65	31	M	74	227	220
66	31	M	68	200	170
67	31	F	62	120	115
68	31	M	71	412	250
69	31	F	61	123	135
70	32	M	72	230	200
71	32	M	75	260	230
72	33	F	64	250	150
73	33	F	67	134	125
74	33	F	67	134	125
75	33	F	64	163	130
76	33	M	70	190	175
77	33	F	67	191	150
78	33	F	69	310	150
79	33	F	67	177	160
80	33	F	67	210	180
81	34	F	68	212	140
82	34	M	73	185	165
83	35	M	73	190	200
84	35	F	63	161	135
85	35	F	64	235	160
86	35	M	76	240	205
87	36	M	69	204	185
88	36	F	65	144	128
89	36	M	74	215	205
90	37	M	71	226	190
91	37	F	69	230	175
92	37	F	69	200	165
93	37	M	71	223	190
94	37	M	74	160	185
95	37	M	69	150	150
96	37	F	63	124	118
97	38	F	65.5	133	125
98	38	F	68	155	130
99	38	F	62	125	120
100	38	F	70	185	175
101	38	F	69	190	170
102	38	M	70	220	185
103	38	F	69	255	155
104	38	M	67	185	165
105	39	M	73	260	220
106	39	F	64	165	140
107	40	M	71	190	175
108	40	F	64	145	120
109	41	M	72	220	190
110	41	F	64	116	116
111	41	M	76	245	220
112	42	F	66	135	130
113	42	F	63	180	135
114	43	M	74	255	190
115	43	F	63	160	125
116	43	F	70	180	150
117	44	M	70	450	180
118	44	M	67	187	160
119	45	F	68	148	140
120	45	F	63	160	130
121	45	F	66	227	155
122	45	F	62	125	121
123	45	F	72	160	140
124	45	M	70	230	220
125	45	F	67	145	132
126	46	M	73	195	180
127	46	M	73	195	180
128	46	M	73	195	180
129	46	F	68	172	140
130	46	F	62	121	115
131	46	F	60	126	120
132	46	M	73	250	225
133	46	F	62	135	130
134	47	F	67	154	150
135	47	F	62	130	115
136	47	M	73	220	200
137	48	F	63	115	113
138	49	M	75	285	240
139	49	M	69	188	185
140	50	M	66	190	180
141	50	F	63	115	110
142	51	M	66	215	195
143	51	M	75	225	225
144	51	F	62	150	120
145	52	F	62	130	120
146	55	F	66	180	150
147	55	M	68	290	175
148	57	M	74	277	240
149	58	F	62	125	115
150	66	F	66	150	140

10 years ago

Report issue

Using the Age column, take a Simple Random Sample (SRS) of n=30. Show the sample

NOT RATED

Purchase the answer to view it

using_the_age_column_take_a_simple_random_sample_srs.xlsx