Carry out the correct statistical analysis and draw conclusions, to determine if
ID: 3224050 • Letter: C
Question
Carry out the correct statistical analysis and draw conclusions, to determine if there are differences between males and females, in terms of their weight and length?
Are infants always smaller and lighter then the adults?
Sex_Male_Female_Infant
Length_mm
Whole_grams
M
91
102.8
M
70
45.1
F
106
135.4
M
88
103.2
I
66
41
I
85
70.3
F
106
155.5
F
109
153.6
M
95
101.9
F
110
178.9
F
105
121.3
M
86
81.2
M
98
108.3
F
107
136.9
F
94
95.1
M
100
132.9
I
71
58.1
F
88
90.2
M
73
51.1
M
90
76.2
M
71
49.1
I
76
45.1
F
113
187.9
F
110
152.7
F
123
232.3
F
112
185.7
F
116
199.1
M
118
186.2
M
121
187.3
M
115
172.7
M
116
199.5
F
136
327.8
M
133
267.6
F
136
359.6
F
141
341.9
M
93
95.9
F
108
243.4
F
90
104.5
F
115
176.6
M
71
65.5
F
90
85
F
110
170.3
I
48
14
I
41
8.4
I
42
8.4
I
78
40.6
M
94
115.9
F
92
92.1
I
65
32.2
F
105
167.1
I
104
119
M
80
60.6
M
97
108.3
F
94
95.5
M
81
77
F
100
132.3
M
89
88.5
M
94
117.9
I
49
17.2
F
101
116.6
M
90
82.3
M
101
125
F
106
139.3
M
85
75.7
M
104
116
M
95
96
F
113
183
F
119
257
F
95
106.1
I
62
30.2
M
111
153.3
F
80
70.6
F
119
249.4
M
114
237
F
121
219.6
F
120
201.5
M
119
188.8
F
120
184.4
F
111
157.6
F
123
220.5
F
115
188.2
M
124
323
F
104
197.7
M
119
263.5
M
116
202.6
F
114
259
M
125
239
M
112
172.9
F
92
103.4
F
115
195.5
M
113
162.3
M
111
151
M
119
223
F
125
252.4
M
139
298.8
M
133
321.2
M
107
145
M
94
104.6
M
94
104.5
F
95
115.7
I
72
46.3
M
110
168.6
M
106
176.6
M
106
144.8
M
121
234.7
F
104
145.4
F
109
160.4
F
100
133.5
F
102
126.7
F
87
72.7
M
99
108.3
M
93
86.2
I
87
66.5
M
85
78.6
F
109
138.7
F
106
118.3
F
98
122.5
M
88
80.4
F
112
176.5
M
81
52.1
F
94
84.1
I
77
50.7
F
103
153.2
M
74
42.8
I
72
35.1
I
54
14.6
I
75
47.6
I
77
50.1
M
140
345.1
M
142
391.8
M
119
252.4
F
88
80.7
F
65
38.3
I
70
42.2
I
53
19.5
F
85
81.2
F
61
31.2
M
69
40.1
F
81
71.1
M
75
50.6
F
113
165.2
F
110
148.2
M
130
268.9
M
112
159.4
M
95
103.5
F
98
109.8
M
92
103
I
56
25.4
I
35
6.3
I
34
6
M
118
210.6
F
121
223.7
F
127
274.3
F
121
211.3
F
113
197.7
M
103
144.4
F
115
198.8
M
129
302.8
F
116
181.5
F
115
224.8
M
121
211.2
F
121
244.4
M
122
248.9
F
145
428.2
F
130
350.4
M
145
510
F
145
424.8
F
136
368.4
M
141
396.2
F
136
323.7
M
139
391.3
F
106
155
M
105
213
F
104
155.2
I
47
9.6
I
72
35.7
I
63
25
I
63
28.7
I
45
9.3
M
116
194
M
114
187.9
M
128
273.6
F
112
204.7
F
124
203.3
F
129
313.5
M
124
243.6
F
126
210.5
F
126
276.6
F
126
239.8
F
117
186.5
M
123
231.9
M
122
204.5
M
116
185.4
I
71
44
F
102
162.9
M
100
154.4
F
101
128.8
M
128
260.7
M
112
184.4
M
Sex_Male_Female_Infant
Length_mm
Whole_grams
M
91
102.8
M
70
45.1
F
106
135.4
M
88
103.2
I
66
41
I
85
70.3
F
106
155.5
F
109
153.6
M
95
101.9
F
110
178.9
F
105
121.3
M
86
81.2
M
98
108.3
F
107
136.9
F
94
95.1
M
100
132.9
I
71
58.1
F
88
90.2
M
73
51.1
M
90
76.2
M
71
49.1
I
76
45.1
F
113
187.9
F
110
152.7
F
123
232.3
F
112
185.7
F
116
199.1
M
118
186.2
M
121
187.3
M
115
172.7
M
116
199.5
F
136
327.8
M
133
267.6
F
136
359.6
F
141
341.9
M
93
95.9
F
108
243.4
F
90
104.5
F
115
176.6
M
71
65.5
F
90
85
F
110
170.3
I
48
14
I
41
8.4
I
42
8.4
I
78
40.6
M
94
115.9
F
92
92.1
I
65
32.2
F
105
167.1
I
104
119
M
80
60.6
M
97
108.3
F
94
95.5
M
81
77
F
100
132.3
M
89
88.5
M
94
117.9
I
49
17.2
F
101
116.6
M
90
82.3
M
101
125
F
106
139.3
M
85
75.7
M
104
116
M
95
96
F
113
183
F
119
257
F
95
106.1
I
62
30.2
M
111
153.3
F
80
70.6
F
119
249.4
M
114
237
F
121
219.6
F
120
201.5
M
119
188.8
F
120
184.4
F
111
157.6
F
123
220.5
F
115
188.2
M
124
323
F
104
197.7
M
119
263.5
M
116
202.6
F
114
259
M
125
239
M
112
172.9
F
92
103.4
F
115
195.5
M
113
162.3
M
111
151
M
119
223
F
125
252.4
M
139
298.8
M
133
321.2
M
107
145
M
94
104.6
M
94
104.5
F
95
115.7
I
72
46.3
M
110
168.6
M
106
176.6
M
106
144.8
M
121
234.7
F
104
145.4
F
109
160.4
F
100
133.5
F
102
126.7
F
87
72.7
M
99
108.3
M
93
86.2
I
87
66.5
M
85
78.6
F
109
138.7
F
106
118.3
F
98
122.5
M
88
80.4
F
112
176.5
M
81
52.1
F
94
84.1
I
77
50.7
F
103
153.2
M
74
42.8
I
72
35.1
I
54
14.6
I
75
47.6
I
77
50.1
M
140
345.1
M
142
391.8
M
119
252.4
F
88
80.7
F
65
38.3
I
70
42.2
I
53
19.5
F
85
81.2
F
61
31.2
M
69
40.1
F
81
71.1
M
75
50.6
F
113
165.2
F
110
148.2
M
130
268.9
M
112
159.4
M
95
103.5
F
98
109.8
M
92
103
I
56
25.4
I
35
6.3
I
34
6
M
118
210.6
F
121
223.7
F
127
274.3
F
121
211.3
F
113
197.7
M
103
144.4
F
115
198.8
M
129
302.8
F
116
181.5
F
115
224.8
M
121
211.2
F
121
244.4
M
122
248.9
F
145
428.2
F
130
350.4
M
145
510
F
145
424.8
F
136
368.4
M
141
396.2
F
136
323.7
M
139
391.3
F
106
155
M
105
213
F
104
155.2
I
47
9.6
I
72
35.7
I
63
25
I
63
28.7
I
45
9.3
M
116
194
M
114
187.9
M
128
273.6
F
112
204.7
F
124
203.3
F
129
313.5
M
124
243.6
F
126
210.5
F
126
276.6
F
126
239.8
F
117
186.5
M
123
231.9
M
122
204.5
M
116
185.4
I
71
44
F
102
162.9
M
100
154.4
F
101
128.8
M
128
260.7
M
112
184.4
M
111 170.4Explanation / Answer
Excel formula:
1) Comparing length of boys & girls: 2 sample 2sided t-test with equal variance p-value= 0.244891727 >.05 Cant reject H0 so no significant difference 2) Comparing weights of boys & girls: 2 sample 2-sided t-test with equal variance p-value= 0.441835398 >.05 Cant reject H0 so no significant difference 3) checking if average height of boys & girls > that of infants?: 2sample, 1 sided t-test with equal variance p-value= 2.79111E-28 >.05 reject H0 so, yes infants are significantly shorter than boys & girls 3) checking if average weight of boys & girls > that of infants?: 2sample, 1 sided t-test with equal variance p-value= 8.23554E-16 >.05 reject H0 so, yes infants are significantly lighter than boys & girls