Stat excel hw

Stat 2103 Business Statistics

Spring 2016

Homework #1, Take-Home Excel Portion

10 points

Due date: In class Tuesday, January 26th

Fortune (Oct. 16, 2008) published a list of the 50 most powerful women in business in the

United States. The data on age (in years) of these women is located in the Assignments folder on

Blackboard called WPOWER50. Use EXCEL to:

1. Find the mean, median and standard deviation of the age of these women

2. Is the data skewed to the left, skewed to the right, or symmetric? Explain why.

3. Construct a frequency histogram for the age data using class intervals of 5 years—(25- 30), (30-35), (35-40),…,(60-65)

*Please attach the excel output. You may use the “Example Output for Excel HW” as a

guide for how to present your output and answers.