Question

A random sample of 12 attendees who registered for an advanced class on Microsoft Excel is listed below:

Candidate Last Name	Degree	GPA (Points out of 4.00)	Starting Salary ($)	Work Experience (Years)	City	Job Title
Arnold	BA	3.51	65000	3	Detroit	Business Analyst
Banks	MBA	3.56	85000	3	Detroit	Project Manager
Biden	MSE	3.87	90000	8	Detroit	Data Analyst
Blunt	BA	2.85	42000	1	Lansing	Marketing Assistant
Brown	MBA	3.75	75000	6	Lansing	Project Manager
Dao	MBA	3.2	85000	10	Detroit	Data Analyst
Hayes	BA	2.94	55000	3	Flint	Business Analyst
Jackson	BA	3.25	65000	1	Lansing	Data Analyst
Lin	BSE	2.65	60000	4	Detroit	Project Manager
Robertson	BSE	3.47	85000	5	Detroit	Project Manager
Smith	MSE	3.2	100000	10	Lansing	Data Analyst
Williams	MBA	3.2	80000	2	Flint	Data Analyst

1. What is the mean salary?
   1.   42,000.00
   2.   73,916.67
   3.   77,500.00
   4. 100,000.00
      
2. What is the standard deviation of the salary of this sample?
   1. 16,000.59
   2. 16,719.39
   3. 21,250.00
   4. 28,000.00
      
3. What graph would be the best way to display the salaries for the attendees?
   1. Pie chart
   2. Histogram
   3. Box plot
   4. Scatter plot

4. What graph would be the best way to display the relationship between salary and work experience?
   1. Pie Chart
   2. Histogram
   3. Box Plot
   4. Scatter Plot
      
5. What graph would be the best way to display the relationship between the distributions of salaries across different cities (may need larger sample)?
   1. Pie Chart
   2. Histogram
   3. Box Plot
   4. Scatter Plot

Answer 1

1) What is the mean salary?

Ans : 73,916.67

2) What is the standard deviation of the salary of this sample?

Ans : 16,719.39

3) What graph would be the best way to display the salaries for the attendees?

Ans : Histogram

4) What graph would be the best way to display the relationship between salary and work experience?

Ans : Scatter Plot

5) What graph would be the best way to display the relationship between the distributions of salaries across different cities (may need larger sample)?

Ans: Pie Chart