The domestic airfare for business travel for the current year and the previous year was reported. A sample of 12 flights with their domestic airfares shown for both years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

Current Year 207 570 486 270 468 519 420 444 246 678 237 699 Previous Year 552 300 303 501 279 273 591 576 429 237 585 393 a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period. H: M1 M2 0 He: Mi - H2 10 What are the t-value, degrees of freedom, and p-value t-value (to 4 decimals) Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? that there has been a significance increase in business travel airfares over the one-year period. b. What is the sample mean domestic airfare for business travel for each year? We Current Year: $ Previous Year: $ (to 2 decimals) (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals) Current Year 207 570 486 270 468 519 420 444 246 678 237 699 Previous Year 552 300 303 501 279 273 591 576 429 237 585 393 a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period. H: M1 M2 0 He: Mi - H2 10 What are the t-value, degrees of freedom, and p-value t-value (to 4 decimals) Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? that there has been a significance increase in business travel airfares over the one-year period. b. What is the sample mean domestic airfare for business travel for each year? We Current Year: $ Previous Year: $ (to 2 decimals) (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals)