The spreadsheet data for this case is provided here, called: FAAtxt.xlsx Answer all the questions in this case, using Excel spreadsheet, and submit your Excel file to Blackboard. Here is the case: In January 2003, the FAA ordered that passengers be either weighed or surveyed about their weight prior to boarding 10-to 19-seat passenger planes. The order was instituted in response to a crash that occurred on January 8, 2003, in Charlotte, North Carolina, in which all 21 passengers, including the pilot and copilot, of a 19-seat Beech 1900 turboprop died. One possible cause of the crash was that the plane may have been carrying too much weight. (Source: Matthew L. Wald, “Weight estimates on air passengers will be increased,” www.nytimes.com, May 13, 2003.) The airlines were asked to weigh adult passengers and carry-on 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
146	Female	47
131	Female	45
139	Female	37
152	Female	45
139	Female	42
117	Female	37
123	Female	31
138	Female	36
109	Female	36
128	Female	35
123	Female	47
121	Female	32
171	Female	37
127	Female	48
96	Female	36
139	Female	37
130	Female	45
127	Female	28
160	Female	45
152	Female	48
164	Female	29
90	Female	39
107	Female	32
134	Female	27
108	Female	36
110	Female	33
114	Female	48
143	Female	31
168	Female	36
140	Female	43
135	Female	40
148	Female	43
160	Female	44
102	Female	37
154	Female	37
128	Female	37
144	Female	44
145	Female	36
120	Female	24
159	Female	47
135	Female	43
127	Female	55
136	Female	46
147	Female	41
157	Female	58
112	Female	57
133	Female	47
103	Female	43
156	Female	45
122	Female	52
159	Female	47
108	Female	73
171	Female	50
122	Female	55
163	Female	47
148	Female	53
159	Female	48
127	Female	50
132	Female	53
136	Female	55
123	Female	62
135	Female	55
128	Female	50
142	Female	60
116	Female	48
113	Female	48
124	Female	55
122	Female	48
155	Female	57
149	Female	49
113	Female	52
139	Female	59
182	Female	44
137	Female	70
115	Female	61
115	Female	58
152	Female	48
116	Female	58
93	Female	51
140	Female	49
103	Female	54