Bin | Sr. no | class interval | frequency | |
222.5 | 1 | 218.5-222.5 | 25 | |
227.5 | 2 | 223.5-227.5 | 37 | |
232.5 | 3 | 228.5-232.5 | 22 | |
237.5 | HOME | 4 | 233.5-237.5 | 22 |
242.5 | 5 | 238.5-242.5 | 25 | |
247.5 | 6 | 243.5-247.5 | 14 | |
252.5 | 7 | 248.5-252.5 | 37 | |
257.5 | 8 | 253.5-257.5 | 29 | |
262.5 | 9 | 258.5-262.5 | 26 | |
267.5 | 10 | 263.5-267.5 | 27 | |
272.5 | 11 | 268.5-272.5 | 36 |
data points are
X
234
218.5
228
271
231
222
241
234
231
245
262
228
230
258
229
257
223
255
250
268
229
219
256
221
255
258
254
267
245
242
272
236
253
232
254
248
268
261
239
251
251
269
254
227
259
268
228
261
240
260
245
255
270
222
252
227
253
258
241
254
264
267
226
228
257
261
224
223
248
225
222
227
252
269
268
257
260
266
269
220
237
268
272
267
246
251
268
222
226
262
246
225
268
228
219
264
230
260
242
224
229
222
268
223
263
251
237
260
232
231
234
257
226
255
239
238
250
238
225
226
240
224
271
237
268
261
234
221
260
235
271
251
272
271
259
239
245
250
254
237
267
219
230
239
225
222
250
266
271
227
221
272
243
221
242
242
255
268
256
236
261
263
263
225
265
222
227
222
240
227
238
252
263
251
227
265
222
263
248
219
258
252
226
252
236
253
226
248
242
221
262
250
252
268
253
271
265
256
267
261
248
233
222
240
252
247
261
246
268
265
227
270
263
256
233
267
254
239
226
272
236
263
248
251
269
227
255
227
228
251
259
252
271
233
250
234
234
226
225
229
230
250
223
265
263
227
243
250
255
255
262
258
258
272
222
245
268
265
249
251
229
270
232
257
268
245
252
252
228
238
240
223
246
252
239
267
222
248
223
265
225
250
246
236
240
222
235
253
233
254
219
271
225
234
226
268
267
260
238
239
Next, generate a random sample of 300 data points, Createa that histogram as an image file...
generate a random sample of 130 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5. You can have your last bin be 272.5 Save that histogram as an image file and attach it here using the Insert Image option
Then. generate a random sample of 1300 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5. You can have your that histogram as an image file and attach it here using the insert image option.
e a sample of 10 data points. Create a histogram where the first bin starts at 222.5 and the width of each bin is 5, You can have your last bin be 2725. Save that histogram as an image file and attach it here using the Insert Image option f this option doesn't work for adding the images you may have to drag the image directy from your Explorer window into the answer image option. Some students have reported this...
We will be using Excel to simulate a normal distribution with a mean of 500 and a standard deviation of 9. Please note there are five parts to this question. First, generate a random sample of 50 data points. 1. Create a histogram where the first bin starts at 475.25 and the width of each bin is 4.5. You can have your last bin be 520.25. Save that histogram as an image file and attach it here using the Insert...
use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. generate a random sample of 150 data points in excel. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here using the Insert Image option.
Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. First, generate a random sample of 50 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram as an image file and attach it here.
Next. generate a random sample of 280 data points (1-10) Create a pie graph in Excel to show the proportion of left-handed vs. right handed people are in your sample and save it as an image file Attach the pie graph using the insert image option and note what percentage of your sample was actualily left-handed. Insert. Formats. Blux,x'A.즈.o
Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5 In Excel generate a random sample of 290 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. Save that histogram
Use Excel to simulate a normal distribution with a mean of 700 and a standard deviation of 5. use excel generate a random sample of 1300 data points. Create a histogram where the first bin starts at 686.25 and the width of each bin is 2.5. You can have your last bin be 711.25. post your histogram
We will be using Excel to simulate the number of left-handed people in a particular sample. Left-handed people make up about 10% of the population. We will randomly pick numbers between 1 and 10, where 1 represents a left-handed person and 2 - 10 represents a right-handed person. This should result in about 10% of our sample being left-handed. Please note there are five parts to this question. 1. Create a pie graph in Excel to show the proportion of...