Destination Dayton Louisville Q1 Based on the air fare data, is it significantly more costly to fly out of Dayton than it Chicago-O Hare 319 142 is to fly out of Louisville? Assume there is unequal variance in the two samples. Grand Rapids, Mich. 192 213 Use a 90% confidence level, or alpha = .1. Show you calculations using excel formulas Portland, Ore. 503 317 Select one: Atlanta 256 387 a. Yes, it is almost 25% more expensive to fly out of Dayton. Seattle 339 317 b. Yes, the t critical is bigger than the t statistic. South Bend, Ind. 379 167 c. No, we can conclude the one tail test has a p value of greater than . 1, Miami 268 273 which does not allow us to reject the claim of equal means at the 10% level of Dallas-Ft. Worth 288 274 significance. d. Yes, we can conclude the two tail test has a p value of .1, which allows us to reject the claim of equal meansSouthwest AirTran Q2 The data show the number of minutes that delayed flights by AirTran Airways and Southwest 45 34 Airlines. Is there a difference in the number of delayed minutes between the two airlines. 64 59 Use a 0.01 significance level and assume there is unequal variance in the two samples. 42 43 Select one: 33 30 a. Yes, the difference between the two airlines is over 2 minutes. 66 3 b. Yes, the t critical is bigger than the t statistic. 105 32 c. No, we can conclude the two-tail test has a p value of greater than .01, 45 42 which does not allow us to reject the claim of equal means at the 1% level of 28 85 significance. 38 30 d. Yes, we can conclude the one tail test has a p-value of .377, which allows 85 48 us to reject the claim of equal means 75 110 45 50 33 10 Use excel to and show all the formulas used 50 26 63 70 42 52 35 83 33 78 64 27 65 70 27 90 38 52 76