Explore BrainMass
Share

Business statistics

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 March 21, 2019, 9:56 pm ad1c9bdddf
https://brainmass.com/statistics/statistical-figures/business-statistics-398172

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