Use the FAM100.xls data set to perform the operations listed below.

1. Determine each variable's type - quantitative or qualitative. This will help determine which graphical display to use.
2. Create a histogram with one of the quantitative variables. You decide the appropriate number of bins. Copy and paste to a Word/pdf document. You will turn this in.
3. Comment on the histogram's shape, central tendency, dispersion, and any extreme values.
4. Create a pie chart or bar chart with one of the qualitative variables. Copy and paste to your Word/pdf document.
5. Comment on what you see in the pie/bar chart.
6. Search online for a deceptive (bad) graph. Copy and paste to your Word/pdf document and comment on why the graph is deceptive.

Data Dictionary:

• Income1: primary wage earner's income in dollars
• Income2: secondary wage earner's income in dollars
• FamSize: number of people in the family
• Own?: Do you own or rent your house? (1=own, 0=rent)
• total debt: total debt owned by the family in dollars
• Housing: total mortgage payment in dollars
• Utility: total cost of power, water, and sewer utility bills in dollars
• City: what city does the family live in (Springfield=1, Carbondale=2, Jackson=3, New York=4)

Income1	Income2	FamSize	Own?	TotalDebt	Housing	Utility	City	Total Income	Own?	City
48554	17886	4	1	15420	714	269	2	66440	1	2
31870	24656	2	1	12586	1138	272	1	56526	1	1
28860	17399	4	1	14133	863	260	1	46259	1	1
33920	12295	2	1	6898	915	190	1	46215	1	1
32241	29927	5	1	17027	1258	317	3	62168	1	3
33886	0	2	1	7359	483	105	3	33886	1	3
47959	20102	2	1	15804	1354	314	1	68061	1	1
35663	18797	2	1	13083	388	110	1	54460	1	1
29519	0	1	0	5242	537	98	4	29519	0	4
29208	20891	2	1	14962	460	162	1	50099	1	1
38612	22231	3	0	18138	894	266	1	60843	0	1
40730	23069	3	1	20165	1029	236	1	63799	1	1
18317	0	4	0	4318	544	150	3	18317	0	3
31307	0	2	0	5881	545	158	3	31307	0	3
30786	19922	2	1	12427	816	191	3	50708	1	3
48358	0	1	1	14344	402	132	1	48358	1	1
35361	28243	4	1	16644	1109	271	1	63604	1	1
35881	12698	6	0	14941	1727	390	3	48579	0	3
27873	8100	2	0	9302	312	99	2	35973	0	2
26405	0	3	0	5802	438	127	4	26405	0	4
44600	14550	4	1	17267	1167	316	1	59150	1	1
41107	17739	2	1	15182	520	142	2	58846	1	2
40395	13581	5	0	13743	1260	298	1	53976	0	1
28763	0	2	0	9542	420	100	4	28763	0	4
27122	0	1	1	3395	518	96	4	27122	1	4
39441	27834	4	1	15447	1532	381	1	67275	1	1
35996	0	4	1	9250	504	162	2	35996	1	2
36582	22969	4	0	14593	1250	283	1	59551	0	1
25405	20289	5	1	11208	1239	309	1	45694	1	1
32840	16718	4	0	11588	1470	338	4	49558	0	4
25745	21368	2	1	6825	757	164	2	47113	1	2
50386	0	3	0	14129	1095	260	2	50386	0	2
32328	0	2	0	8003	475	122	2	32328	0	2
40364	0	6	1	11330	1024	291	2	40364	1	2
23878	0	5	1	2812	1009	274	4	23878	1	4
32400	17673	5	0	10571	1435	336	1	50073	0	1
33096	26124	2	1	15251	449	140	2	59220	1	2
31878	0	4	1	7991	959	257	2	31878	1	2
29959	0	4	0	6507	737	145	3	29959	0	3
57626	0	3	1	11716	750	180	1	57626	1	1
46123	12141	2	1	17352	272	86	1	58264	1	1
40674	0	6	1	14872	1657	385	1	40674	1	1
38300	0	2	1	9796	877	211	2	38300	1	2
36992	25137	6	1	14976	1798	467	1	62129	1	1
31033	0	2	0	4429	485	112	2	31033	0	2
37293	29326	5	1	15830	1371	337	1	66619	1	1
46384	14564	6	1	16285	1529	389	1	60948	1	1
40430	0	2	1	11044	627	168	1	40430	1	1
34441	0	4	1	9095	1067	230	2	34441	1	2
41118	16880	4	1	13285	1296	313	2	57998	1	2
72709	0	7	1	17005	1911	457	1	72709	1	1
27953	0	4	1	6121	1060	259	4	27953	1	4
35457	27082	4	1	15345	1130	297	3	62539	1	3
30635	0	3	0	6205	696	163	2	30635	0	2
37428	16366	4	1	16642	1080	289	2	53794	1	2
41204	15424	3	0	16615	1176	296	1	56628	0	1
40706	17934	3	1	17002	524	152	3	58640	1	3
42254	27414	4	0	14771	1333	362	1	69668	0	1
32366	19812	2	1	11425	819	196	2	52178	1	2
38550	14399	5	1	11768	802	236	1	52949	1	1
26891	21434	3	0	13958	691	169	2	48325	0	2
32349	0	1	0	6755	620	131	2	32349	0	2
25211	24836	2	1	14696	858	242	1	50047	1	1
34647	25727	3	1	15578	884	233	1	60374	1	1
26726	15547	5	1	9412	1141	265	1	42273	1	1
33587	0	2	0	7295	554	166	4	33587	0	4
46093	24734	5	1	15534	1277	352	1	70827	1	1
20672	18632	3	1	10785	774	215	1	39304	1	1
40444	22724	2	1	14965	561	161	1	63168	1	1
43817	0	2	1	14585	594	143	1	43817	1	1
37284	0	4	0	13405	983	253	2	37284	0	2
45033	17140	2	1	16706	677	179	4	62173	1	4
32942	0	3	1	10401	674	166	3	32942	1	3
42574	21643	3	1	15573	1345	324	1	64217	1	1
22341	0	3	0	5204	349	115	4	22341	0	4
29770	0	2	1	9134	857	184	4	29770	1	4
49823	20657	4	1	16990	1329	324	1	70480	1	1
35126	0	1	1	7934	354	86	3	35126	1	3
29013	26783	6	1	12004	1101	278	4	55796	1	4
27416	18895	2	1	10657	434	110	1	46311	1	1
29671	22336	4	1	11862	858	244	3	52007	1	3
35611	0	3	1	6535	576	157	2	35611	1	2
32052	0	3	1	8255	328	69	2	32052	1	2
27413	0	2	0	6232	419	117	3	27413	0	3
38598	17680	2	0	14150	662	162	1	56278	0	1
44604	23670	4	1	17235	1160	272	1	68274	1	1
37350	25073	4	1	15253	1127	289	1	62423	1	1
30927	0	2	0	8049	510	144	2	30927	0	2
32165	21483	2	1	13396	817	227	1	53648	1	1
26181	11830	5	0	10734	817	221	4	38011	0	4
41795	13727	2	0	13782	539	149	1	55522	0	1
28263	0	5	0	12149	1016	257	2	28263	0	2
25878	0	1	1	7682	317	94	4	25878	1	4
55392	0	4	0	13489	1018	250	2	55392	0	2
29530	0	2	0	7901	645	135	4	29530	0	4
15514	0	2	1	2429	488	125	3	15514	1	3
36022	19247	6	1	13525	1635	353	1	55269	1	1
27988	0	8	0	11155	1727	432	4	27988	0	4
44780	0	5	0	11085	1060	256	2	44780	0	2
22582	19066	7	0	9864	1583	414	4	41648	0	4