Use data National Income xlsx, which sampled the income of 500 respondent in a county Apply the Histogram function in Data Analysis to plot the frequency distribution of national income in the sample Apply the Descriptive Statistics function in Data Analysis to obtain the descriptive stats of national income in the sample Based on the histogram and descriptive stats, what is the likely distribution of the in the sample Use Excel functions to find What is the range of values that are about two standard deviations (SD) from the mean What is the probability that a person's income falls within 2 SDs from the mean What is the approximate probability that a person's income is more than 100,000 What is the level of income that is lower than about 90 of the population in the country What is the level of income that is higher than about 99 the population in the country Use data National Income xlsx, which sampled the income of 500 respondent in a county Repondent Income ($) 1 64342 35 2 61888 02 3 58326 81 4 42009 92 5 74280 27 6 65629 98 7 73580 49 8 89356 54 9 41863 46 10 67368 59 11 42551 04 12 47750 3 13 65955 1 14 51651 21 15 104142 1 16 33414 74 17 66596 12 18 61348 29 19 55763 25 20 49941 11 21 50665 08 22 37773 64 23 73810 41 24 36073 07 25 71429 09 26 67512 57 27 85437 44 28 64988 99 29 86205 08 30 12671 9 31 52578 9 32 17794 32 33 51169 95 34 47965 05 35 47634 58 36 55107 42 37 66101 65 38 39504 97 39 63348 14 40 55752 33 41 72428 39 42 28280 84 43 52131 52 44 43700 93 45 59327 03 46 93587 28 47 68589 85 48 76242 02 49 72242 06 50 62967 04 51 62930 61 52 84066 8 53 85177 26 54 76473 6 55 67616 02 56 49745 93 57 25456 2 58 53366 2 59 58335 19 60 17764 7 61 48994 31 62 58949 89 63 31401 03 64 74729 94 65 50149 94 66 111755 9 67 88667 69 68 66378 18 69 50373 41 70 74292 13 71 70909 84 72 64164 03 73 77187 56 74 70243 54 75 57124 43 76 56051 66 77 57184 13 78 13175 2 79 6560 018 80 30817 68 81 64934 2 82 16922 51 83 85561 15 84 37369 94 85 42984 52 86 63298 88 87 48954 51 88 41182 12 89 66506 84 90 35032 57 91 85406 94 92 70562 06 93 37385 19 94 70566 54 95 83165 68 96 43679 79 97 50012 11 98 50065 37 99 62724 81 100 59927 69 101 85064 39 102 47668 15 103 26000 33 104 57825 15 105 36611 75 106 70187 34 107 49563 71 108 63084 76 109 31226 47 110 69241 52 111 63330 21 112 61375 51 113 78915 41 114 77089 11 115 43489 5 116 80186 5 117 53243 76 118 69055 69 119 63173 26 120 59989 09 121 37905 54 122 75791 97 123 81235 75 124 81556 07 125 91606 05 126 69514 92 127 65690 71 128 20437 95 129 80294 88 130 43872 43 131 74702 31 132 38119 46 133 62066 62 134 40009 77 135 44086 03 136 98849 72 137 61649 62 138 39914 73 139 42021 71 140 76336 86 141 39378 17 142 103282 7 143 44131 77 144 83299 62 145 60703 02 146 39470 71 147 51928 38 148 33468 26 149 71389 95 150 105907 3 151 75395 84 152 69966 77 153 91243 01 154 80797 93 155 76016 35 156 121077 6 157 53442 67 158 62643 93 159 60613 49 160 45689 72 161 86597 94 162 81827 91 163 82804 22 164 64937 81 165 46630 98 166 83675 41 167 60613 49 168 41345 15 169 94864 37 170 46037 86 171 45897 2 172 58270 84 173 48684 2 174 52442 55 175 47808 39 176 44160 02 177 42488 6 178 73177 98 179 50741 07 180 40196 89 181 57108 92 182 48707 08 183 74802 03 184 79694 77 185 94102 09 186 82436 56 187 72874 51 188 46296 44 189 74499 65 190 72786 24 191 32239 6 192 69868 84 193 66918 31 194 66006 51 195 62328 79 196 62170 03 197 60985 66 198 53376 3 199 62865 7 200 67140 38 201 42721 34 202 85726 6 203 38454 78 204 60946 65 205 62286 95 206 67293 67 207 45496 74 208 61609 37 209 81457 33 210 48928 81 211 36544 11 212 54938 27 213 63451 81 214 78588 41 215 55697 72 216 72036 29 217 102204 218 66959 91 219 49631 81 220 87305 71 221 75148 26 222 60097 14 223 67870 64 224 67136 02 225 76574 89 226 72310 02 227 46773 4 228 72201 29 229 39426 2 230 73194 92 231 38049 59 232 57844 233 85710 12 234 53833 75 235 87397 65 236 34326 65 237 81709 19 238 26515 34 239 44800 26 240 38959 36 241 42184 07 242 67934 14 243 43843 44 244 50897 15 245 70647 59 246 73633 84 247 39881 16 248 64584 94 249 43749 29 250 57315 49 251 60738 62 252 56640 36 253 90446 09 254 60113 56 255 53987 7 256 47134 42 257 68857 83 258 49349 14 259 48361 86 260 52362 09 261 80859 43 262 38023 5 263 64894 84 264 69962 84 265 68163 9 266 97493 16 267 63509 79 268 49106 07 269 50817 54 270 70943 04 271 66408 67 272 100715 1 273 29067 85 274 60214 84 275 60783 09 276 70187 71 277 38715 61 278 69811 67 279 64660 87 280 57023 52 281 109151 282 64139 29 283 33666 67 284 77977 02 285 59329 03 286 33757 2 287 108132 288 41678 41 289 59806 95 290 70880 291 67550 86 292 63600 63 293 76692 22 294 67834 06 295 48735 93 296 82913 85 297 25045 58 298 85844 7 299 55148 66 300 70113 34 301 42525 13 302 77107 8 303 58099 2 304 79385 49 305 90654 46 306 55977 14 307 69809 31 308 47295 52 309 48290 48 310 45502 87 311 52925 82 312 77776 43 313 42200 57 314 29043 92 315 28606 28 316 81084 74 317 53395 14 318 62995 04 319 60573 5 320 46524 36 321 29976 41 322 17338 94 323 58920 85 324 43197 48 325 89722 03 326 49029 34 327 36530 02 328 61772 35 329 73362 75 330 54531 8 331 59270 59 332 67024 82 333 95266 37 334 83360 29 335 56228 78 336 39967 29 337 41813 12 338 110417 8 339 53929 71 340 36229 85 341 58653 04 342 38486 17 343 70277 38 344 60176 31 345 77867 72 346 78014 36 347 72013 66 348 51894 04 349 42097 44 350 31907 9 351 53108 42 352 86789 06 353 97785 6 354 66171 47 355 73913 9 356 33675 85 357 49965 39 358 34572 59 359 55506 06 360 67977 39 361 42140 97 362 65693 17 363 55278 76 364 32572 31 365 59412 54 366 85022 67 367 84743 25 368 62653 9 369 64258 63 370 9900 735 371 74622 93 372 29627 87 373 31268 75 374 60862 77 375 43146 73 376 73872 4 377 79922 92 378 74705 05 379 62442 86 380 60310 65 381 90488 9 382 63440 69 383 58998 96 384 51154 08 385 50576 51 386 46185 23 387 31798 03 388 93413 34 389 53255 78 390 74942 25 391 37088 02 392 49359 07 393 38733 77 394 75442 69 395 38296 32 396 56141 47 397 48615 67 398 95376 33 399 40845 68 400 121802 1 401 85978 32 402 82494 45 403 55364 83 404 58338 35 405 54046 82 406 74860 76 407 66440 35 408 39138 66 409 78153 22 410 76736 64 411 70491 76 412 54180 29 413 37225 28 414 93035 05 415 59819 53 416 14743 91 417 72179 6 418 25682 84 419 75658 86 420 59727 05 421 29169 72 422 77946 8 423 61426 55 424 28075 53 425 44595 49 426 38190 27 427 59168 52 428 63495 98 429 71934 28 430 48673 51 431 60417 03 432 69892 04 433 60348 58 434 36262 59 435 80948 23 436 53973 76 437 82620 57 438 32083 83 439 59780 94 440 73113 76 441 76784 64 442 47339 55 443 65027 17 444 51897 16 445 63725 87 446 59588 42 447 21892 18 448 53474 85 449 50805 6 450 32958 35 451 74852 1 452 84084 02 453 96354 16 454 51740 76 455 45269 88 456 60542 19 457 41571 75 458 77455 36 459 110863 6 460 48680 81 461 58874 45 462 76281 94 463 72247 82 464 34999 89 465 62890 47 466 57415 72 467 24198 83 468 73784 77 469 75201 35 470 85700 03 471 90065 01 472 96407 74 473 87846 76 474 50774 9 475 49247 29 476 66486 74 477 54561 28 478 102929 4 479 64363 83 480 48643 31 481 77237 96 482 77380 31 483 95933 89 484 86354 06 485 74524 77 486 68872 39 487 27795 4 488 59732 28 489 55326 36 490 36106 54 491 21197 74 492 81375 02 493 58261 45 494 67911 95 495 88754 77 496 30942 05 497 74496 89 498 48960 19 499 69708 45 500 40185 96

The Answer is in the image, click to view ...

Question: Use data National Income.xlsx, which sampled the income of 500 respondent in a county. Apply the Histogram function in Data Analysis to plot the frequency

Use data National Income.xlsx, which sampled the income of 500 respondent in a county.
1. Apply the Histogram function in Data Analysis to plot the frequency distribution of national income in the sample
2. Apply the Descriptive Statistics function in Data Analysis to obtain the descriptive stats of national income in the sample
3. Based on the histogram and descriptive stats, what is the likely distribution of the in the sample?
4. Use Excel functions to find:
  1. What is the range of values that are about two standard deviations (SD) from the mean?
  2. What is the probability that a person's income falls within 2 SDs from the mean?
  3. What is the approximate probability that a person's income is more than 100,000?
  4. What is the level of income that is lower than about 90% of the population in the country?
  5. What is the level of income that is higher than about 99% the population in the country?Use data National Income.xlsx, which sampled the income of 500 respondent in a county.

Repondent	Income ($)
1	64342.35
2	61888.02
3	58326.81
4	42009.92
5	74280.27
6	65629.98
7	73580.49
8	89356.54
9	41863.46
10	67368.59
11	42551.04
12	47750.3
13	65955.1
14	51651.21
15	104142.1
16	33414.74
17	66596.12
18	61348.29
19	55763.25
20	49941.11
21	50665.08
22	37773.64
23	73810.41
24	36073.07
25	71429.09
26	67512.57
27	85437.44
28	64988.99
29	86205.08
30	12671.9
31	52578.9
32	17794.32
33	51169.95
34	47965.05
35	47634.58
36	55107.42
37	66101.65
38	39504.97
39	63348.14
40	55752.33
41	72428.39
42	28280.84
43	52131.52
44	43700.93
45	59327.03
46	93587.28
47	68589.85
48	76242.02
49	72242.06
50	62967.04
51	62930.61
52	84066.8
53	85177.26
54	76473.6
55	67616.02
56	49745.93
57	25456.2
58	53366.2
59	58335.19
60	17764.7
61	48994.31
62	58949.89
63	31401.03
64	74729.94
65	50149.94
66	111755.9
67	88667.69
68	66378.18
69	50373.41
70	74292.13
71	70909.84
72	64164.03
73	77187.56
74	70243.54
75	57124.43
76	56051.66
77	57184.13
78	13175.2
79	6560.018
80	30817.68
81	64934.2
82	16922.51
83	85561.15
84	37369.94
85	42984.52
86	63298.88
87	48954.51
88	41182.12
89	66506.84
90	35032.57
91	85406.94
92	70562.06
93	37385.19
94	70566.54
95	83165.68
96	43679.79
97	50012.11
98	50065.37
99	62724.81
100	59927.69
101	85064.39
102	47668.15
103	26000.33
104	57825.15
105	36611.75
106	70187.34
107	49563.71
108	63084.76
109	31226.47
110	69241.52
111	63330.21
112	61375.51
113	78915.41
114	77089.11
115	43489.5
116	80186.5
117	53243.76
118	69055.69
119	63173.26
120	59989.09
121	37905.54
122	75791.97
123	81235.75
124	81556.07
125	91606.05
126	69514.92
127	65690.71
128	20437.95
129	80294.88
130	43872.43
131	74702.31
132	38119.46
133	62066.62
134	40009.77
135	44086.03
136	98849.72
137	61649.62
138	39914.73
139	42021.71
140	76336.86
141	39378.17
142	103282.7
143	44131.77
144	83299.62
145	60703.02
146	39470.71
147	51928.38
148	33468.26
149	71389.95
150	105907.3
151	75395.84
152	69966.77
153	91243.01
154	80797.93
155	76016.35
156	121077.6
157	53442.67
158	62643.93
159	60613.49
160	45689.72
161	86597.94
162	81827.91
163	82804.22
164	64937.81
165	46630.98
166	83675.41
167	60613.49
168	41345.15
169	94864.37
170	46037.86
171	45897.2
172	58270.84
173	48684.2
174	52442.55
175	47808.39
176	44160.02
177	42488.6
178	73177.98
179	50741.07
180	40196.89
181	57108.92
182	48707.08
183	74802.03
184	79694.77
185	94102.09
186	82436.56
187	72874.51
188	46296.44
189	74499.65
190	72786.24
191	32239.6
192	69868.84
193	66918.31
194	66006.51
195	62328.79
196	62170.03
197	60985.66
198	53376.3
199	62865.7
200	67140.38
201	42721.34
202	85726.6
203	38454.78
204	60946.65
205	62286.95
206	67293.67
207	45496.74
208	61609.37
209	81457.33
210	48928.81
211	36544.11
212	54938.27
213	63451.81
214	78588.41
215	55697.72
216	72036.29
217	102204
218	66959.91
219	49631.81
220	87305.71
221	75148.26
222	60097.14
223	67870.64
224	67136.02
225	76574.89
226	72310.02
227	46773.4
228	72201.29
229	39426.2
230	73194.92
231	38049.59
232	57844
233	85710.12
234	53833.75
235	87397.65
236	34326.65
237	81709.19
238	26515.34
239	44800.26
240	38959.36
241	42184.07
242	67934.14
243	43843.44
244	50897.15
245	70647.59
246	73633.84
247	39881.16
248	64584.94
249	43749.29
250	57315.49
251	60738.62
252	56640.36
253	90446.09
254	60113.56
255	53987.7
256	47134.42
257	68857.83
258	49349.14
259	48361.86
260	52362.09
261	80859.43
262	38023.5
263	64894.84
264	69962.84
265	68163.9
266	97493.16
267	63509.79
268	49106.07
269	50817.54
270	70943.04
271	66408.67
272	100715.1
273	29067.85
274	60214.84
275	60783.09
276	70187.71
277	38715.61
278	69811.67
279	64660.87
280	57023.52
281	109151
282	64139.29
283	33666.67
284	77977.02
285	59329.03
286	33757.2
287	108132
288	41678.41
289	59806.95
290	70880
291	67550.86
292	63600.63
293	76692.22
294	67834.06
295	48735.93
296	82913.85
297	25045.58
298	85844.7
299	55148.66
300	70113.34
301	42525.13
302	77107.8
303	58099.2
304	79385.49
305	90654.46
306	55977.14
307	69809.31
308	47295.52
309	48290.48
310	45502.87
311	52925.82
312	77776.43
313	42200.57
314	29043.92
315	28606.28
316	81084.74
317	53395.14
318	62995.04
319	60573.5
320	46524.36
321	29976.41
322	17338.94
323	58920.85
324	43197.48
325	89722.03
326	49029.34
327	36530.02
328	61772.35
329	73362.75
330	54531.8
331	59270.59
332	67024.82
333	95266.37
334	83360.29
335	56228.78
336	39967.29
337	41813.12
338	110417.8
339	53929.71
340	36229.85
341	58653.04
342	38486.17
343	70277.38
344	60176.31
345	77867.72
346	78014.36
347	72013.66
348	51894.04
349	42097.44
350	31907.9
351	53108.42
352	86789.06
353	97785.6
354	66171.47
355	73913.9
356	33675.85
357	49965.39
358	34572.59
359	55506.06
360	67977.39
361	42140.97
362	65693.17
363	55278.76
364	32572.31
365	59412.54
366	85022.67
367	84743.25
368	62653.9
369	64258.63
370	9900.735
371	74622.93
372	29627.87
373	31268.75
374	60862.77
375	43146.73
376	73872.4
377	79922.92
378	74705.05
379	62442.86
380	60310.65
381	90488.9
382	63440.69
383	58998.96
384	51154.08
385	50576.51
386	46185.23
387	31798.03
388	93413.34
389	53255.78
390	74942.25
391	37088.02
392	49359.07
393	38733.77
394	75442.69
395	38296.32
396	56141.47
397	48615.67
398	95376.33
399	40845.68
400	121802.1
401	85978.32
402	82494.45
403	55364.83
404	58338.35
405	54046.82
406	74860.76
407	66440.35
408	39138.66
409	78153.22
410	76736.64
411	70491.76
412	54180.29
413	37225.28
414	93035.05
415	59819.53
416	14743.91
417	72179.6
418	25682.84
419	75658.86
420	59727.05
421	29169.72
422	77946.8
423	61426.55
424	28075.53
425	44595.49
426	38190.27
427	59168.52
428	63495.98
429	71934.28
430	48673.51
431	60417.03
432	69892.04
433	60348.58
434	36262.59
435	80948.23
436	53973.76
437	82620.57
438	32083.83
439	59780.94
440	73113.76
441	76784.64
442	47339.55
443	65027.17
444	51897.16
445	63725.87
446	59588.42
447	21892.18
448	53474.85
449	50805.6
450	32958.35
451	74852.1
452	84084.02
453	96354.16
454	51740.76
455	45269.88
456	60542.19
457	41571.75
458	77455.36
459	110863.6
460	48680.81
461	58874.45
462	76281.94
463	72247.82
464	34999.89
465	62890.47
466	57415.72
467	24198.83
468	73784.77
469	75201.35
470	85700.03
471	90065.01
472	96407.74
473	87846.76
474	50774.9
475	49247.29
476	66486.74
477	54561.28
478	102929.4
479	64363.83
480	48643.31
481	77237.96
482	77380.31
483	95933.89
484	86354.06
485	74524.77
486	68872.39
487	27795.4
488	59732.28
489	55326.36
490	36106.54
491	21197.74
492	81375.02
493	58261.45
494	67911.95
495	88754.77
496	30942.05
497	74496.89
498	48960.19
499	69708.45
500	40185.96

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

WHAT FINAL EXCEL SHOULD LOOK LIKE: EXCEL GIVEN: Exp19_Excel_Ch08_CapAssessment_Employee_Satisfaction Project Description: You work as a data analyst for Camino Marketing, a U.S.-based web marketing...

Show step by step in excel \fH4 Jx A B C D G H K N P Home Valuation Worksheet Purchase Date Sqft Purchase Price Current Value Sqft Frequency BIN Frequency Standard Deviation 3/1/21 904 71,252.00 5...

PINE TREES, INC. Memo To: Daniel Martinez, Manager of Risk Management Department From: Erica Marcus, Supervisor, Sales Department Date: February 20, 2006 Re: Burger Ranch...

STAB22H3 Statistics I 2020 1.A researcher used a linear regression model to investigate the relationship between sexually transmitted disease rate (y) and poverty rate (x) in the U.S.A. The...

Can someone assist with any of these questions below: Question 1.The time required to play a certain game is uniformly distributed between 30 and 52 minutes. Complete parts a through c below. a. Find...

FEMALE AGE HT 295 17 64.3 2739 32 66.4 2992 25 62.3 3745 55 62.3 4486 27 59.6 4488 29 63.6 4878 25 59.8 4880 12 63.3 4881 41 67.9 4835 32 61.4 4842 31 66.7 6225 19 64.8 8680 19 63.1 8681 23 66.7...

1 Assignment 1 consists of a theory component (1A, worth 80%) and a computer component (1B, worth 20%). The total marks allocated are summarized below. Assignment Grade weight Assignment 1A. Theory...

Question 301 pts In a research project, data from surveys and interviews were collected. The research team needed to analyse, and organise the data by assigning codes to different themes and...

RACE OF RESPONDENT Cumulative Frequency Valid Valid Percent Percent WHITE 1477 74.8 74.8 74.8 BLACK 301 15.2 15.2 90.1 OTHER 196 9.9 9.9 100.0 1974 100.0 100.0 Total Statistics AGE OF RESPONDENT N...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Show that T: Pn Pn defined by T(p(x) ) = p(x - 2) is an isomorphism.

1. Why didnt this team receive the RFP at the same time the larger consulting firms did? 2. Why is this team being considered as a candidate to submit a proposal? 3. What should Maggie, Paul, and...

Can children estimate their reading ability? The main purpose of the study cited in Exercise 2.11 was to ask whether schoolchildren can estimate their own reading ability. The researchers had the...

The force constant of a massless spring is 2 5 . 0 N / m . A mass of 0 . 4 5 kg is oscillating in simple harmonic motion at the end of the spring

L.C. Conday plc has 50 million 10 per cent 1 preference shares in issue. The current market price is 0.92 and the shares are due to be redeemed in three years time at their nominal value. What is the...

How did government intervention evolve between the first and second halves of the twentieth century? LO.1

Discuss the relationship between government intervention and protectionism. LO.1