stat

Data

Customer	DEALER	STATE	Income
ERROR:#VALUE!	Excellent	PA	$ 51,907		Problem 1
ERROR:#VALUE!	Excellent	PA	$ 59,985		a)     Each customer classifies the dealer as Excellent, Good, or Average. Create a frequency table (cells G6,G7,G8) and pie chart here for the DEALER variable.
ERROR:#VALUE!	Excellent	PA	$ 68,054
ERROR:#VALUE!	Average	PA	$ 68,331		Dealer Quality	Frequency
ERROR:#VALUE!	Average	PA	$ 68,663		Excellent	78
ERROR:#VALUE!	Good	DE	$ 69,144		Good	57
ERROR:#VALUE!	Good	DE	$ 69,698		Average	25
ERROR:#VALUE!	Excellent	PA	$ 70,046
ERROR:#VALUE!	Good	PA	$ 70,853
ERROR:#VALUE!	Excellent	DE	$ 71,097
ERROR:#VALUE!	Average	DE	$ 71,378
ERROR:#VALUE!	Excellent	PA	$ 71,411
ERROR:#VALUE!	Excellent	NJ	$ 71,461
ERROR:#VALUE!	Good	NY	$ 71,468
ERROR:#VALUE!	Excellent	PA	$ 71,898
ERROR:#VALUE!	Excellent	DE	$ 71,899
ERROR:#VALUE!	Good	DE	$ 71,993
ERROR:#VALUE!	Good	NY	$ 71,996
ERROR:#VALUE!	Average	DE	$ 72,000
ERROR:#VALUE!	Average	NJ	$ 72,098
ERROR:#VALUE!	Average	NJ	$ 72,139
ERROR:#VALUE!	Excellent	PA	$ 72,427
ERROR:#VALUE!	Excellent	PA	$ 72,494
ERROR:#VALUE!	Average	PA	$ 72,832		b)     Each customer lives in one of four states: DE, PA, NJ, or NY (cells G25:G28). Create a frequency table and bar chart here for the STATE variable that shows the number of customers in each state.
ERROR:#VALUE!	Excellent	PA	$ 72,845
ERROR:#VALUE!	Excellent	PA	$ 72,903		State	Frequency	Mean
ERROR:#VALUE!	Excellent	NJ	$ 73,167		PA	67	$ 173,454
ERROR:#VALUE!	Excellent	PA	$ 73,241		DE	34	$ 70,978
ERROR:#VALUE!	Excellent	PA	$ 73,372		NJ	44	$ 80,960
ERROR:#VALUE!	Excellent	NJ	$ 73,797		NY	15	$ 94,056
ERROR:#VALUE!	Excellent	PA	$ 74,160
ERROR:#VALUE!	Excellent	NJ	$ 74,246
ERROR:#VALUE!	Excellent	PA	$ 75,042
ERROR:#VALUE!	Average	DE	$ 75,192
ERROR:#VALUE!	Excellent	PA	$ 75,933
ERROR:#VALUE!	Excellent	DE	$ 76,045
ERROR:#VALUE!	Excellent	PA	$ 76,575
ERROR:#VALUE!	Good	PA	$ 76,828
ERROR:#VALUE!	Good	PA	$ 76,877
ERROR:#VALUE!	Good	NJ	$ 77,223
ERROR:#VALUE!	Good	PA	$ 77,533
ERROR:#VALUE!	Excellent	PA	$ 77,765
ERROR:#VALUE!	Good	NJ	$ 77,790		Problem 2
ERROR:#VALUE!	Average	NY	$ 77,979		a)     Create a histogram for the Income variable just below here. The number of categories (also called bins or class intervals) can be from 6 to 10 (your choice).
ERROR:#VALUE!	Excellent	PA	$ 78,054
ERROR:#VALUE!	Good	NJ	$ 78,632		bin	Frequency	mean	median	Q1	Q3	IQR	SD	z score
ERROR:#VALUE!	Average	PA	$ 78,720		5	2	$ 118,799	$ 88,886	$ 77,455.26	$ 144,257.42	$ 66,802.15	$ 59,976	$ 2.66
ERROR:#VALUE!	Good	PA	$ 78,963		6	5
1000	Excellent	NY	$ 79,167		7	49
1001	Average	NJ	$ 79,203		8	25
1002	Average	DE	$ 79,242		9	13
1003	Average	NJ	$ 79,502		10	7
1004	Good	PA	$ 79,579		11	6
1005	Excellent	PA	$ 79,763		12	4
1006	Excellent	NJ	$ 79,890		13	6
1007	Good	NJ	$ 79,895		14	7
1008	Average	PA	$ 80,700		15	5
1009	Excellent	NJ	$ 80,815		16	3
1010	Good	DE	$ 80,903		17	5
1011	Average	PA	$ 81,265		18	1
1012	Excellent	PA	$ 81,411		19	0
1013	Excellent	NJ	$ 81,641		20	3
1014	Excellent	PA	$ 82,041		21	3
1015	Excellent	DE	$ 82,414		22	0
1016	Excellent	PA	$ 83,340		23	1
1017	Good	PA	$ 83,778		24	1
1018	Good	NY	$ 83,995		25	4
1019	Average	PA	$ 84,003		26	5
1020	Good	NJ	$ 84,043		27	5
1021	Excellent	PA	$ 84,310
1022	Good	PA	$ 84,505
1023	Good	PA	$ 84,573
1024	Good	PA	$ 84,663
1025	Good	PA	$ 84,857
1026	Good	NJ	$ 85,633
1027	Excellent	PA	$ 87,191
1028	Excellent	DE	$ 87,307
1029	Excellent	DE	$ 87,705
1030	Good	NJ	$ 87,922
1031	Excellent	PA	$ 88,321
1032	Excellent	NJ	$ 89,451
1033	Excellent	DE	$ 90,738
1034	Good	NJ	$ 91,845
1035	Excellent	NJ	$ 91,910
1036	Good	PA	$ 94,129
1037	Good	DE	$ 94,511
1038	Average	PA	$ 95,003
1039	Excellent	PA	$ 95,360
1040	Good	NY	$ 97,261
1041	Average	DE	$ 97,584
1042	Good	NJ	$ 98,411
1043	Excellent	NJ	$ 98,750
1044	Average	PA	$ 99,639
1045	Excellent	PA	$ 99,789
1046	Good	NJ	$ 101,748
1047	Excellent	PA	$ 104,645
1048	Good	PA	$ 104,810
1049	Excellent	DE	$ 105,750
1050	Good	DE	$ 105,986
1051	Excellent	NJ	$ 107,888
1052	Excellent	DE	$ 109,438
1053	Good	NY	$ 110,574
1054	Excellent	PA	$ 112,709
1055	Excellent	PA	$ 112,920
1056	Average	NJ	$ 117,137
1057	Good	NJ	$ 118,246
1058	Average	NJ	$ 118,668
1059	Good	DE	$ 120,987
1060	Good	DE	$ 125,228
1061	Good	DE	$ 127,624
1062	Excellent	PA	$ 129,242
1063	Excellent	DE	$ 131,773
1064	Excellent	DE	$ 131,893
1065	Excellent	NJ	$ 132,252
1066	Excellent	NY	$ 133,845
1067	Average	NJ	$ 137,156
1068	Excellent	DE	$ 139,211
1069	Good	NY	$ 140,051
1070	Good	NY	$ 142,371
1071	Excellent	DE	$ 144,214
1072	Excellent	NJ	$ 144,389
1073	Good	NJ	$ 145,267
1074	Excellent	PA	$ 146,218
1075	Good	NY	$ 146,487
1076	Good	NJ	$ 150,505
1077	Good	NJ	$ 151,588
1078	Good	NJ	$ 153,938
1079	Excellent	DE	$ 154,110
1080	Excellent	PA	$ 155,190
1081	Excellent	PA	$ 162,378
1082	Excellent	DE	$ 164,930
1083	Excellent	PA	$ 169,574
1084	Excellent	PA	$ 172,229
1085	Excellent	PA	$ 172,798
1086	Good	PA	$ 174,849
1087	Good	DE	$ 176,031
1088	Excellent	NJ	$ 177,852
1089	Good	NJ	$ 184,604
1090	Good	NJ	$ 200,904
1091	Excellent	PA	$ 203,952
1092	Average	DE	$ 205,933
1093	Excellent	NJ	$ 216,866
1094	Good	DE	$ 217,250
1095	Good	DE	$ 219,494
1096	Excellent	PA	$ 232,169
1097	Good	NJ	$ 249,158
1098	Excellent	NY	$ 250,449
1099	Good	PA	$ 252,559
1100	Average	PA	$ 253,467
1101	Excellent	PA	$ 257,143
1102	Excellent	NJ	$ 260,766
1103	Excellent	NJ	$ 263,216
1104	Excellent	NJ	$ 263,950
1105	Good	NY	$ 265,946
1106	Average	NY	$ 266,800
1107	Good	NY	$ 270,394
1108	Good	PA	$ 270,490
1109	Good	NJ	$ 275,282
1110	Excellent	DE	$ 277,904
1111	Excellent	PA	$ 278,267

Dealer Pie Chart

Frequency Excellent Good Average 78 57 25

State Bar Chart

Frequency PA DE NJ NY 67 34 44 15