View the step-by-step solution to:

# Your boss, Ms. Piper, has asked you to analyze the age and salaries of 60 CEOs. They provide you with the raw data in an excel document (see...

Your boss, Ms. Piper, has asked you to analyze the age and salaries of 60 CEOs. They provide you with the raw data in an excel document (see “application1.xlsx” in Blackboard). Your boss wants you to create several charts/graphs and give a detailed analysis of each one. The calculations you have been asked to do include creating charts/graphs for:
1. Histogram of the ages of the CEOs. Use bin sizes of 5 years. (i.e. 30-34, 35-39, 40-44, etc.).
2. Histogram of the salaries of the CEOs. Determine your own bin size that you feel best describes the data.
3. Compute the mean and standard deviation of the ages and salaries. Use these numbers in your discussion of your histograms.
4. A pie chart showing the percentage of CEOs age 30-44, 45-59, and 60 or older.
Some things to keep in mind with your calculations, charts, and graphs:
1. Label the axes carefully and accurately.
2. Include titles for charts/graphs.
3. Use units when appropriate.
4. Make note of skewness/symmetrical data.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents