## M131 Project Fall 2013

I actually have the form for excel with the actual format and requirements to send you.

The given information shows the Ages and Heights for 100 men and 100 women. For each gender:

1, Create a single bar graph using two different colors to represent the male and female categories. Arrange each gender according to the following age groups: 10-19, 20-29, 30-39, 40-49, 50-59, and 60-69. Then for each age group and gender, find the average height for all the subjects in each age group. The bar graph should show both men and women! Please see the tab labeled “Bar Chart Hint” for a couple of helpful hints on how to approach this chart.

2. Create a pie chart (one for each gender) to show the percentage of heights in each age group for each gender. Please see the tab labeled “Pie Chart Hint” for a couple of helpful hints on how to approach this chart.

3. Find the mean, median, mode, midrange, and standard deviation for each gender’s heights given. See the tab labeled “Summary Statistics” for a couple of helpful hint on how to approach this summary

4. The submission for this assignment is a single Excel file.

Document Preview:

35
65
49
54

65
72
48
62

64
69
58
57

19
70
49
61

42
69
33
63

72
69
29
55

32
80
19
66

41
76
70
56

70
70
55
60

19
72
40
62

50
71
70
65

49
72
49
54

29
70
33
60

42
68
29
57

42
72
44
62

38
72
49
59

30
66
38
56

48
75
41
62

45
71
38
58

29
65
36
61

28
70
45
55

30
73
29
56

27
69
32
62

49
68
44
62

43
68
32
60

29
66
33
55

40
70
38
55

45
71
28
59

42
73
47
59

43
73
37
57

35
73
44
58

38
68
49
62

44
67
48
61

40
69
30
60

47
73
41
63

27
71
51
58

45
69
36
57

31
69
42
62

28
70
37
62

46
68
40
64

30
71
32
62

38
69
34
55

38
75
28
64

34
70
45
58

30
72
33
61

39
70
30
63

31
70
45
62

27
69
42
56

29
71
38
54

27
73
45
58

26
75
47
63

19
71
59
69

56
77
23
64

64
77
64
62

31
77
23
68

42
76
38
60

49
71
43
68

50
76
19
52

38
71
32
66

22
71
57
56

29
76
18
69

57
73
35
57

50
74
22
70

69
77
34
70

29
74
52
58

60
76
30
64

22
74
54
60

18
75
69
61

43
75
39
69

21
72
59
62

28
72
32
65

29
75
60
64

21
77
63
70

21
75
48
64

19
76
44
57

22
76
43
70

41
76
46
52

28
71
62
53

17
74
63
61

24
76
38
62

26
74
50
68

66
76
44
68

56
75
39
64

19
73
26
70

68
72
28
65

58
71
24
55

47
74
25
55

43
72
61
55

46
77
68
65

16
76
51
53

20
73
55
69

21
77
18
62

65
74
35
52

42
76
23
68

55
71
36
60

41
75
36
69

58
74
63
70

53
75
47
61

67
75
39
67

26
76
19
60

35
65
49
54

65
72
48
62

64
69
58
57

19
70
49
61

42
69
33
63

72
69
29
55

32
80
19
66

41
76
70
56

70
70
55
60

19
72
40
62

50
71
70
65

49
72
49
54

29
70
33
60

42
68
29
57

42
72
44
62

38
72
49
59

30
66
38
56

48
75
41
62

45
71
38
58

29
65
36
61

28
70
45
55

30
73
29
56

27
69
32
62

49
68
44
62

43
68
32
60

29
66
33
55

40
70
38
55

45
71
28
59

42
73
47
59

43
73
37
57

35
73
44
58

38
68
49
62

44
67
48
61

40
69
30
60

47
73
41
63

27
71
51
58

45
69
36
57

31
69
42
62

28
70
37
62

46
68
40
64

30
71
32
62

38
69
34
55

38
75
28
64

Attachments:

Posted on: January 10, 2019, by :