Question

Data showing the population by state in millions of people follow (The World Almanac, 2012). The dataset in Excel file 2012Population.xlsx.

a. Develop a frequency distribution, a percent frequency distribution, and a histogram. Use a class width of 2.5 million.

b. Does there appear to be any skewness in the distribution? Explain.  

c. What observations can you make about the population of the 50 states?

State	Population
Alabama	4.8
Alaska	0.7
Arizona	6.4
Arkansas	2.9
California	37.3
Colorado	5
Connecticut	3.6
Delaware	0.9
Florida	18.8
Georgia	9.7
Hawaii	1.4
Idaho	1.6
Illinois	12.8
Indiana	6.5
Iowa	3.0
Kansas	2.9
Kentucky	4.3
Louisiana	4.5
Maine	1.3
Maryland	5.8
Massachusetts	6.5
Michigan	9.9
Minnesota	5.3
Mississippi	3
Missouri	6
Montana	0.9
Nebraska	1.8
Nevada	2.7
New Hampshire	1.3
New Jersey	8.8
New Mexico	2
New York	19.4
North Carolina	9.5
North Dakota	0.7
Ohio	11.5
Oklahoma	3.8
Oregon	4.3
Pennsylvania	12.7
Rhode Island	1
South Carolina	4.6
South Dakota	0.8
Tennessee	6.3
Texas	25.1
Utah	2.8
Vermont	0.6
Virginia	8
Washington	6.7
West Virginia	1.9
Wisconsin	5.7
Wyoming	0.6

Answer 1

a)

class	frequency	percent frequency
0	2.5	15	0.3	30
2.5	5	14	0.28	28
5	7.5	9	0.18	18
7.5	10	5	0.1	10
10	12.5	1	0.02	2
12.5	15	2	0.04	4
15	17.5	0	0	0
17.5	20	2	0.04	4
20	22.5	0	0	0
22.5	25	0	0	0
25	27.5	1	0.02	2
27.5	30	0	0	0
30	32.5	0	0	0
32.5	35	0	0	0
35	37.5	1	0.02	2
	total	50	1

b)

Skewness: 2.64637.

Kurtosis: 8.762658.

c)  up to 2.5 milion population is 30% in 15 states.  

Between 2.5 to 5 milion population is 28% in 14 states.

Between 5 to7. 5 milion population is 18% in 9 states.

Between 7.5 to 10 milion population is 10% in 5 states.