Please answer this assignment in excel. Thank you.

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 dont 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