FlightStats, Inc., collects data on the number of flights scheduled and the number of flights

flown at major airports throughout the United States. FlightStats data showed 56% of flights

scheduled at Newark, La Guardia, and Kennedy airports were flown during a three-day

snowstorm. All airlines say they always operate within set safety parameters if conditions

are too poor, they don't fly. The following data show a sample of 600 scheduled flights

during the snowstorm. Use the chi- square test with a .10 level of significance to determine

whether or not flying/ not flying in a snowstorm is independent of Airliner. State the

Hypotheses. What is your conclusion based on Critical-Value test? Is it any different from

conclusion based on a p-value approach? Sample data follows:

Flight. American. Continental. Delta. United

Yes. 70. 105. 95 45

No 80 55 85 65

Show all the steps in the hypothesis testing process in the solution. That includes stating

hypothesis statements as English sentences; the decision on the hypothesis test (the basis

for why the hypothesis is being rejected or not); and state the conclusion in the business

problem context in English sentence of the decision at the end of the hypothesis testing.

please use excel functions!