Requirement for Airline 3_COLLAPSE_ALL_SESSIONS_TEST1.dta a) The purpose of this analyse is to find out all possible correlations between variables that might affect the success of the company to sell the most tickets with the maximum fare. 1. Compare the selected fare, the mean minimum fare (mean_min_fare) and the mean maximum fare (mean_max_fare) for different destination location 2. Comparing the fares for the city pairs as well. 3. Compare the booking transaction types for different destination locations, city pairs,. 4. Check how the transaction count, response time affect the selected fare? 5. Check how the insurance affects the selected fare? b) Please check any other relationship between any variable and the selected price or the mean maximum price. c) Please use the more descriptive statistics possible and at least one Log it and Marginal effect analysis. d) Please send me the dta file, the do-file and a detailed word file with explications.