Federal Aviation Administration The airlines were asked to weigh adult passengers and carryon bags randomly over a one-month period to estimate the mean weight per passenger (including luggage). A total of 426 people and their luggage were weighed, and the sample data are contained in a data file called FAA . Required Tasks: 1. Prepare a descriptive analysis of the data using charts, graphs, and numerical measures. 2. Construct and interpret a 95% confidence interval

Federal Aviation Administration

The airlines were asked to weigh adult passengers and carryon bags randomly over a one-month period to estimate the mean weight per passenger (including luggage). A total of 426 people and their luggage were weighed, and the sample data are contained in a data file called
FAA
.
Required Tasks:
1. Prepare a descriptive analysis of the data using charts, graphs, and numerical measures.
2. Construct and interpret a 95% confidence interval estimate for the mean weight for male passengers.
3. Construct and interpret a 95% confidence interval estimate for the mean weight for female passengers.
4. Construct and interpret a 95% confidence interval estimate for the mean weight for all passengers.
5. Indicate what sample size would be required if the margin of error in the estimate for the mean of all passengers is to be reduced by half.

Weight Gender Age
197 Male 55
171 Male 47
212 Male 62
239 Male 49
237 Male 36
252 Male 47
146 Male 46
199 Male 47
235 Male 52
176 Male 62
186 Male 56
159 Male 51
155 Male 67
179 Male 51
184 Male 56
148 Male 44
190 Male 53
194 Male 52
209 Male 55
195 Male 50
196 Male 51
195 Male 54
241 Male 47
203 Male 59
200 Male 57
191 Male 58
258 Male 52
228 Male 57
269 Male 50
187 Male 54
250 Male 42
161 Male 53
220 Male 50
229 Male 61
257 Male 42
203 Male 53
191 Male 48
223 Male 50
195 Male 44
225 Male 53
166 Male 64
182 Male 52
164 Male 65
195 Male 47
204 Male 51
206 Male 49
196 Male 55
264 Male 47
158 Male 61
185 Male 52
135 Male 70
244 Male 52
170 Male 50
187 Male 53
225 Male 55
218 Male 58
229 Male 49
221 Male 48
168 Male 53
175 Male 68
224 Male 45
214 Male 51
180 Male 56
198 Male 56
209 Male 53
220 Male 56
209 Male 47
180 Male 56
256 Male 53
218 Male 59
207 Male 54
227 Male 58
228 Male 48
188 Male 65
180 Male 55
235 Male 44
173 Male 47
163 Male 48
224 Male 46
222 Male 47
265 Male 49
244 Male 65
240 Male 55
208 Male 43
205 Male 56
217 Male 46
204 Male 60
177 Male 49
157 Male 49
227 Male 55
217 Male 59
222 Male 40
211 Male 43
177 Male 51
238 Male 55
197 Male 73
182 Male 48
183 Male 45
193 Male 61
193 Male 49
191 Male 42
228 Male 46
219 Male 43
189 Male 61
240 Male 62
157 Male 55
220 Male 43
202 Male 66
206 Male 57
187 Male 47
190 Male 62
228 Male 50
227 Male 50
217 Male 51
224 Male 65
249 Male 46
213 Male 51
221 Male 54
255 Male 51
196 Male 49
233 Male 53
209 Male 41
236 Male 62
201 Male 53
184 Male 48
234 Male 51
189 Male 62
219 Male 38
220 Male 60
196 Male 44
193 Male 40
168 Male 55
259 Male 60
190 Male 45
207 Male 50
199 Male 55
282 Male 56
239 Male 50
229 Male 47
241 Male 52
210 Male 54
220 Male 62
198 Male 34
172 Male 49
239 Male 59
197 Male 52
170 Male 60
226 Male 53
226 Male 54
217 Male 56
216 Male 54
188 Male 47
225 Male 53
219 Male 54
234 Male 51
130 Male 56
218 Male 58
245 Male 56
158 Male 43
206 Male 55
242 Male 56
251 Male 56
211 Male 40
209 Male 38
255 Male 59
204 Male 72
187 Male 54
229 Male 44
205 Male 53
233 Male 57
217 Male 46
244 Male 42
202 Male 73
179 Male 58
163 Male 50
136 Male 59
208 Male 56
213 Male 57
205 Male 57
210 Male 54
212 Male 57
245 Male 54
207 Male 60
175 Male 48
167 Male 50
210 Male 65
231 Male 45
164 Male 44
189 Male 48
219 Male 46
199 Male 61
196 Male 54
201 Male 52
193 Male 48
183 Male 57
222 Male 61
207 Male 61
239 Male 49
212 Male 54
207 Male 59
211 Male 48
211 Male 47
205 Male 48
172 Male 53
211 Male 66
209 Male 49
225 Male 44
185 Male 51
222 Male 45
211 Male 46
208 Male 46
228 Male 51
254 Male 50
170 Male 50
172 Male 58
220 Male 60
237 Male 54
181 Male 58
147 Male 55
181 Male 43
210 Male 36
217 Male 48
178 Male 58
182 Male 56
217 Male 43
208 Male 55
190 Male 41
208 Male 60
180 Male 60
181 Male 53
233 Male 55
249 Male 59
187 Male 49
200 Male 47
208 Male 51
255 Male 61
221 Male 52
250 Male 56
210 Male 40
247 Male 58
188 Male 48
179 Male 67
237 Male 47
230 Male 49
158 Male 64
239 Male 57
200 Male 53
174 Male 49
154 Male 35
183 Male 45
218 Male 57
230 Male 65
203 Male 53
204 Male 46
211 Male 60
195 Male 50
230 Male 48
192 Male 49
268 Male 60
225 Male 37
221 Male 61
179 Male 47
229 Male 45
244 Male 48
185 Male 58
197 Male 65
169 Male 55
242 Male 38
233 Male 63
210 Male 39
146 Male 49
219 Male 65
219 Male 54
238 Male 44
179 Male 52
238 Male 68
190 Male 48
185 Male 60
158 Male 41
242 Male 48
179 Male 50
247 Male 46
173 Male 52
194 Male 62
170 Male 40
248 Male 34
206 Male 56
214 Male 44
231 Male 55
258 Male 46
203 Male 59
177 Male 47
190 Male 47
228 Male 44
229 Male 44
219 Male 59
165 Male 62
167 Male 51
201 Male 56
188 Male 53
188 Male 53
229 Male 43
182 Male 59
202 Male 57
199 Male 59
246 Male 56
169 Male 49
180 Male 50
200 Male 54
176 Male 43
166 Male 53
147 Male 35
221 Male 46
196 Male 59
216 Male 44
150 Male 48
237 Male 47
152 Male 59
191 Male 45
179 Male 49
202 Male 49
209 Male 46
252 Male 52
191 Male 53
184 Male 27
185 Male 33
221 Male 51
240 Male 35
166 Male 33
231 Male 46
248 Male 30
187 Male 38
207 Male 40
183 Male 45
224 Male 46
211 Male 42
206 Male 54
177 Male 52
197 Male 29
225 Male 35
205 Male 45
232 Male 30
178 Male 27
225 Male 41
239 Male 28
I have more data but it limited me so I can add the rest before you begin to work on the problem.  Please send me a message and I will add the missing data.  Thank you!