Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Hi bro,Here is the answer to your question. have a look at it and in case you require any edits, please let me know. The visuals are in the tab ...
