Discuss the below:
Q: 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 |