F G H D E Parta After reading these instructions delete all text in this shaded area. Use the XL Miner Analysis ToolPak to conduct your t-Test analysis. Current Year 297 528 315 564 360 660 213 648 492 507 513 633 Previous Year 480 582 414 273 213 369 504 489 261 492 552 408 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (D2). Your t-Test analysis output should fit into this shaded area. Formula Can we conclude that there has been a a significance increase in business travel airfares over the one-year period? (Enter "Can conclude" or "Cannot conclude") #N/A Parto One-year Increase #N/A Percentage Change #N/A 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. 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. a - H:A-12 vo H, AL-M2 HV0 What are the t-value, degrees of freedom, and p-value t-, - t-value (to 4 decimals) Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? Web 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? Current Year: $ (to 2 decimals) 2 ) Previous Year: $ : 1 (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals) F G H D E Parta After reading these instructions delete all text in this shaded area. Use the XL Miner Analysis ToolPak to conduct your t-Test analysis. Current Year 297 528 315 564 360 660 213 648 492 507 513 633 Previous Year 480 582 414 273 213 369 504 489 261 492 552 408 After deleting all text in this shaded area, set the output range in the ToolPak to the top left cell of this area (D2). Your t-Test analysis output should fit into this shaded area. Formula Can we conclude that there has been a a significance increase in business travel airfares over the one-year period? (Enter "Can conclude" or "Cannot conclude") #N/A Parto One-year Increase #N/A Percentage Change #N/A 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. 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. a - H:A-12 vo H, AL-M2 HV0 What are the t-value, degrees of freedom, and p-value t-, - t-value (to 4 decimals) Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? Web 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? Current Year: $ (to 2 decimals) 2 ) Previous Year: $ : 1 (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals)