Signature Assignment: Creating Visuals from Data

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.

• 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.