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.

I want to know how to set it up in excel. I need tutoring help, not homework help.