Create a clustered bar graph showing employment status and education level in the lab1a.xlsx file. Interpret this graph based on shape and trend.
statistics
Description
GRAPHING
AND DESCRIPTIVE STATISTICS IN EXCEL 2017
Q 1: Create a clustered bar graph showing employment status and education level in the lab1a.xlsx file. Interpret this graph based on shape and trend.
Q 2: Create
a stacked bar graph showing education level by gender in the lab1a.xlsx file.
Interpret this graph based on shape and trend.
Q 3: Create a clustered box plot
showing annual salary based on education in the lab1a.xlsx file. Annual salary
is measured in 1000’s of dollars. Please indicate this on the vertical axis.
This is an extension of the long procedure done in class. Use YouTube or Google
to find out how to make a Boxplot in Excel 2016.
Q 4: Create
two more histograms to categorize the Blackberry and Google Stock Prices in the
lab1b.xlsx. How do the histograms compare? Which stock prices seem the most
stable? Which stock prices seem the most volatile?
