Dashbo X G The oxy X Pokemo X h Hulu + L X 10.3 Mic X MindTar X " Excel Ol X Question X C | Chegg X C Target p X (119) Yo X Course X + C https:/g.cengage.com/staticb/ui/evo/index.html? deploymentld=5935112189509097482354739820&elSBN=9780357110614&snapshotl.. 0 * GP* 30 Update : C Chapter 16 Learn... Khoi v CENGAGE | MINDTAP Q Search this course ? X My Home 10.3 Microsoft Excel: Structured Activity #2 Question 1 Courses 0/10 Video Catalog and Study Tools Submit 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. A-7 Rental Options Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak College Success Tips Open spreadsheet Career Success Tips a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period. RECOMMENDED FOR YOU Ho : M1 - 12 vo Ha : M1 - 12 vo What are the t-value, degrees of freedom, and p-value t-value (to 4 decimals) bongo Check In! Your Body and Degrees of freedom Numeric input field Wellness Self-Assessment iz!] p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? Help We 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? Give Feedback Current Year: $ (to 2 decimals) A+ Previous Year: $ (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals) Back Nexth Hulu + x 10.3 M X MindT: X + Dashb X G The ox X & Pokem x Excel ( X Excel ( X Questi X C | Cheg x C Target X (119) \\ X Cours( X Update : @ about:blank C Chapter 16 Learn... Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 10 B V MAv . .. Ev ab General $ v 00 H B B BV Ev ATV OV . .. 5 v [ v Arial D2 X V fx After reading these instructions delete all text in this shaded area. K A B C D E F G H I J Current Year Previous Year Part a 627 504 After reading these instructions delete all text in this shaded area. WNI 537 363 264 408 Use the XLMiner Analysis ToolPak to conduct your t-Test analysis. 396 336 216 297 After deleting all text in this shaded area, set the output range in 603 417 the ToolPak to the top left cell of this area (D2). 477 222 627 399 Your t-Test analysis output should fit into this shaded area. 10 555 207 11 519 471 12 348 387 13 558 315 14 15 16 17 18 Formula Can we conclude that there has been a significance increase in business travel airfares over the one-year period? (Enter "Can conclude" or "Cannot conclude") #N/A Part c One-year Increase #N/A #N/A 24 Percentage Change 26 27 28 29 30 E Data + Give Feedback to Microsoft 100% + Calculation Mode: Automatic Workbook Statistics