Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.





WeightGenderAge
197Male55
171Male47
212Male62
239Male49
237Male36
252Male47
146Male46
199Male47
235Male52
176Male62
186Male56
159Male51
155Male67
179Male51
184Male56
148Male44
190Male53
194Male52
209Male55
195Male50
196Male51
195Male54
241Male47
203Male59
200Male57
191Male58
258Male52
228Male57
269Male50
187Male54
250Male42
161Male53
220Male50
229Male61
257Male42
203Male53
191Male48
223Male50
195Male44
225Male53
166Male64
182Male52
164Male65
195Male47
204Male51
206Male49
196Male55
264Male47
158Male61
185Male52
135Male70
244Male52
170Male50
187Male53
225Male55
218Male58
229Male49
221Male48
168Male53
175Male68
224Male45
214Male51
180Male56
198Male56
209Male53
220Male56
209Male47
180Male56
256Male53
218Male59
207Male54
227Male58
228Male48
188Male65
180Male55
235Male44
173Male47
163Male48
224Male46
222Male47
265Male49
244Male65
240Male55
208Male43
205Male56
217Male46
204Male60
177Male49
157Male49
227Male55
217Male59
222Male40
211Male43
177Male51
238Male55
197Male73
182Male48
183Male45
193Male61
193Male49
191Male42
228Male46
219Male43
189Male61
240Male62
157Male55
220Male43
202Male66
206Male57
187Male47
190Male62
228Male50
227Male50
217Male51
224Male65
249Male46
213Male51
221Male54
255Male51
196Male49
233Male53
209Male41
236Male62
201Male53
184Male48
234Male51
189Male62
219Male38
220Male60
196Male44
193Male40
168Male55
259Male60
190Male45
207Male50
199Male55
282Male56
239Male50
229Male47
241Male52
210Male54
220Male62
198Male34
172Male49
239Male59
197Male52
170Male60
226Male53
226Male54
217Male56
216Male54
188Male47
225Male53
219Male54
234Male51
130Male56
218Male58
245Male56
158Male43
206Male55
242Male56
251Male56
211Male40
209Male38
255Male59
204Male72
187Male54
229Male44
205Male53
233Male57
217Male46
244Male42
202Male73
179Male58
163Male50
136Male59
208Male56
213Male57
205Male57
210Male54
212Male57
245Male54
207Male60
175Male48
167Male50
210Male65
231Male45
164Male44
189Male48
219Male46
199Male61
196Male54
201Male52
193Male48
183Male57
222Male61
207Male61
239Male49
212Male54
207Male59
211Male48
211Male47
205Male48
172Male53
211Male66
209Male49
225Male44
185Male51
222Male45
211Male46
208Male46
228Male51
254Male50
170Male50
172Male58
220Male60
237Male54
181Male58
147Male55
181Male43
210Male36
217Male48
178Male58
182Male56
217Male43
208Male55
190Male41
208Male60
180Male60
181Male53
233Male55
249Male59
187Male49
200Male47
208Male51
255Male61
221Male52
250Male56
210Male40
247Male58
188Male48
179Male67
237Male47
230Male49
158Male64
239Male57
200Male53
174Male49
154Male35
183Male45
218Male57
230Male65
203Male53
204Male46
211Male60
195Male50
230Male48
192Male49
268Male60
225Male37
221Male61
179Male47
229Male45
244Male48
185Male58
197Male65
169Male55
242Male38
233Male63
210Male39
146Male49
219Male65
219Male54
238Male44
179Male52
238Male68
190Male48
185Male60
158Male41
242Male48
179Male50
247Male46
173Male52
194Male62
170Male40
248Male34
206Male56
214Male44
231Male55
258Male46
203Male59
177Male47
190Male47
228Male44
229Male44
219Male59
165Male62
167Male51
201Male56
188Male53
188Male53
229Male43
182Male59
202Male57
199Male59
246Male56
169Male49
180Male50
200Male54
176Male43
166Male53
147Male35
221Male46
196Male59
216Male44
150Male48
237Male47
152Male59
191Male45
179Male49
202Male49
209Male46
252Male52
191Male53
184Male27
185Male33
221Male51
240Male35
166Male33
231Male46
248Male30
187Male38
207Male40
183Male45
224Male46
211Male42
206Male54
177Male52
197Male29
225Male35
205Male45
232Male30
178Male27
225Male41
239Male28
146Female47
131Female45
139Female37
152Female45
139Female42
117Female37
123Female31
138Female36
109Female36
128Female35
123Female47
121Female32
171Female37
127Female48
96Female36
139Female37
130Female45
127Female28
160Female45
152Female48
164Female29
90Female39
107Female32
134Female27
108Female36
110Female33
114Female48
143Female31
168Female36
140Female43
135Female40
148Female43
160Female44
102Female37
154Female37
128Female37
144Female44
145Female36
120Female24
159Female47
135Female43
127Female55
136Female46
147Female41
157Female58
112Female57
133Female47
103Female43
156Female45
122Female52
159Female47
108Female73
171Female50
122Female55
163Female47
148Female53
159Female48
127Female50
132Female53
136Female55
123Female62
135Female55
128Female50
142Female60
116Female48
113Female48
124Female55
122Female48
155Female57
149Female49
113Female52
139Female59
182Female44
137Female70
115Female61
115Female58
152Female48
116Female58
93Female51
140Female49
103Female54

Step by Step Solution

3.42 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Management Leadership questions