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

Current Year	Previous Year
381	564
510	525
507	222
231	540
333	306
609	405
636	420
696	231
294	447
396	522
654	429
267	462

Extracted text: 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. X Open spreadsheet a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period. Но : и Ha : µ1 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? We cannot conclude that there has been a significance increase in business travel airfares over the one-year period.


Extracted text: b. What is the sample mean domestic airfare for business travel for each year? Current Year: $ (to 2 decimals) Previous Year: $ (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals)