MTH217 University of Phoenix Week 4 Unemployment Rates Assignment

The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 3. Creating charts and trendlines is an important skill used in many careers.

Watch the following Excel® Training Videos:

  • The Five Number Summary In Excel®
  • Creating a Box and Whisker Plot in Excel® 2013.

Create at least three visuals using your data.

  • Visuals must include two visuals where central tendency and outliers can be seen:
    • Histogram
    • Box and Whisker plot
      • Note: If you have outliers, make sure you create one visual with the outlier(s) and one without the outlier(s).
  • Visuals must include a pie chart
    • Be sure visual shows percentages on pie chart.

Hints for Making an Effective Graph/Map:

  • Decide why you are making graph/map from this data.
  • Decide the type of graph/map you are making.
  • Put in a legend (if applicable)
  • Put in a descriptive x-axis label (if applicable).
  • Put in a descriptive y-axis label (if applicable).
  • Put in a scale (if applicable).
  • Resize the chart as needed so it is easily viewable.

Your assignment will be graded using the Week 4 Grading Guide.

Submit your visuals in either an Excel® file or a Word document.