For all data-based problems, use Excel. The tables you will be graphing are in the spreadsheet GraphHWData.xlsx on Blackboard in the Excel Data Files folder.

All of the tables you will be graphing are based on data about unemployment from the Bureau of Labor Statistics. You will be analyzing how unemployment has changed from Feb. 2007 to Feb. 2011 (or Dec. 2006 to Dec. 2010).

Please include your graphs and your write ups in your Word document. You do not have to include the tables, but you can if you would like to. All your graphs should be easy to read and have clear and accurate titles, axis labels, axis titles, and legends. If you will be printing your homework in black and white, make your graphs in black and white, which you can do with the Chart Design tools.

1. Using the table on the sheet "Unemployment by region," make a graph or graphs that depict how the distribution across regions of people who are unemployed has changed from Dec. 2006 to Dec. 2010. (You can think of this table as two column percentages tables put together, one for 2006 and one for 2010.) Look at the graph and table and determine what noticeable changes there have been. Write a paragraph describing the patterns you see.
2. Using the table on the sheet "Unemployment by race," make a single graph that allows you to compare the unemployment rates (the percent of people in the labor force who are unemployed) of three different racial and ethnic groups and how those unemployment rates have changed over time. Look at the graph and table and determine what noticeable differences there are across the groups and how the unemployment rates have changed over time. Write one to two paragraphs describing the patterns you see.
3. Using the table on the sheet "Unemployment by education," make a column bar graph (what Excel calls a Column chart) that allows you to compare the unemployment rates of the four different education categories and how those unemployment rates have changed over time. Also make a line graph for the same purposes. Explain why using a line graph is a reasonable option. Discuss which graph you think works better and why (there is no one right answer on this part). Look at the graph you prefer and table and determine what noticeable differences there are across the groups and how the unemployment rates have changed over time. Write one to two paragraphs describing the patterns you see.

Price: $9.21

Solution: The downloadable solution consists of 4 pages, 521 words and 3 charts.
Deliverable: Word Document