Explore BrainMass
Share

Explore BrainMass

    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 April 1, 2020, 7:11 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