Reference no: EM131667742

Assignment

1- Read the all slides of PowerPoint about Mission Statements, then read the last two slides to get the instructions.

2- Follow the instructions and answer the question(check the file).

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

Paste your Excel graph into the Word submission template document. Intepret the graph based on shape and trend. Make sure you have appropriate axis titles and graph title.

QUESTION 2. Create a stacked bar graph showing education level by gender in the lab1a.xlsx file. Interpret this graph based on shape and trend.

Paste your Excel graph into the Word submission template document. Intepret the graph based on shape and trend. Make sure you have appropriate axis titles and graph title.

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

Paste your Excel graph into the Word submission template document. Make sure you have appropriate axis titles and graph title.

QUESTION 4

Create two more histograms to categorize the Blackberry and Google Stock Prices in the lab1b.xlsx.

Paste your Excel graph into the Word submission template document. Make sure you have appropriate axis titles and graph titles.

QUESTION 5

How do the histograms of the stock prices compare?

a. The histograms all have a similar shape.
b. The histograms have different shapes.
c. The distributions all follow the bell curve.
d. Unable to determine.

QUESTION 6

The most volatile stock appears to be and the most stable stock appears to be according to a visual inspection of the histograms.

QUESTION 7

Create two more scatterplots comparing: 1) Apple's Adjusted Closing Price Per Stock to Google's Adjusted Closing Price Per Stock and 2) Google's Adjusted Closing Price Per Stock to Blackberry's Adjusted Closing Price Per Stock in the lab1b.xlsx. Title your graphs appropriately and adjust the axes as necessary.

Paste your Excel graph into the Word submission template document. Make sure you have appropriate axis titles and graph titles.

QUESTION 8

Which adjusted closing stock price per share (Apple or Google) explains the most variation in Blackberry's adjusted closing stock price per share?

QUESTION 9

Which two stocks display the strongest correlation coefficient?

a. Google and Blackberry
b. Apple and Blackberry
c. Google and Apple
d. Unable to determine without further calculations.

QUESTION 10

Which two stocks display the weakest association between their prices?

a. Google and Apple
b. Apple and Blackberry
c. Blackberry and Google
d. Unable to determine without further calculations

QUESTION 11

Fifty percent of the time, Apple's adjusted price per share was less than __________________approximately.

a. $120
b. $100
c. $140
d. $150

Attachment:- Mission-Vision-Values.rar