Question

# Data showing the population by state in millions of people follow (The World Almanac, 2012). The...

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

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.

#### Earn Coins

Coins can be redeemed for fabulous gifts.