Find the mean , median and standard deviation of the age of these women.
Stat 2103 Business Statistics
Spring 2016
Homework #
1
,
Take
–
Home
Excel Portion
10
points
Due date:
In class
Tuesday, January 26
th
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 frequ
ency histogram for the age data
using class intervals of 5 years
—
(25
–
30), (30
–
35), (35
–
40),…,(60
–
65)
joyce
0
