1. 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