Explore BrainMass
Share

Business statistics

Construct a column chart for the data in the excel file state unemployment rates to allow a comparison of the June rate with historical highs and lows. Would any other charts be better to visually covey this information? Why or why not?

State Unemployment Rates

State June 2008 Rate Historical High Historical Low
Alabama 4.7 14.4 3.3
Alaska 6.8 11.5 5.9
Arizona 4.8 11.5 3.6
Arkansas 5 10.2 4.1
California 6.9 11 4.7
Colorado 5.1 9.1 2.5
Connecticut 5.4 10 2.1
Delaware 4.2 8.2 2.9
District of Columbia 6.4 11.4 4.8
Florida 5.5 9.7 3.3
Georgia 5.7 8.3 3.4
Hawaii 3.8 10.2 2.2
Idaho 3.8 9.4 2.7
Illinois 6.8 12.9 4.1
Indiana 5.8 12.8 2.6
Iowa 4 8.5 2.6
Kansas 4.3 7.4 2.9
Kentucky 6.3 12.1 4
Louisiana 3.8 12.9 3.2
Maine 5.3 9 3
Maryland 4 8.3 3.3
Massachusetts 5.2 10.9 2.7
Michigan 8.5 16.9 3.2
Minnesota 5.3 9 2.5
Mississippi 6.9 13.7 4.9
Missouri 5.7 10.5 2.6
Montana 4.1 8.7 3.1
Nebraska 3.3 6.8 2.2
Nevada 6.4 10.7 4.1
New Hampshire 4 7.7 1.9
New Jersey 5.3 10.6 3.5
New Mexico 3.9 9.9 3.1
New York 5.3 10.5 4
North Carolina 6 10.2 3.1
North Dakota 3.2 6.9 2.5
Ohio 6.6 13.8 3.9
Oklahoma 3.9 9.4 2.7
Oregon 5.5 12.1 4.7
Pennsylvania 5.2 12.9 4
Rhode Island 7.5 9.7 2.9
South Carolina 6.2 11.4 3.1
South Dakota 2.8 5.9 2.4
Tennessee 6.5 12.4 3.8
Texas 4.4 9.3 4.1
Utah 3.2 9.7 2.4
Vermont 4.7 9 2.2
Virginia 4 7.8 2.2
Washington 5.5 12.2 4.4
West Virginia 5.3 18.2 4.3
Wisconsin 4.6 11.8 2.9
Wyoming 3.2 10.1 1.9

© BrainMass Inc. brainmass.com August 15, 2018, 4:28 pm ad1c9bdddf

Attachments

Solution Summary

Excel file shows column chart for the data of state unemployment rates to allow a comparison of the June rate with historical highs and lows.

$2.19