please help asap i will upvote!! 5D2168 69 SAWN2345File7910111213141516171819202122232425262728293031วาHomeACurrent Year246657321240687414519246528477447678InsertDataArialDraw Page LayoutBPrevious Year261315339+441441564372297345534402264✓10BCalculation Mode: Automatic Workbook StatisticsFormulasX ✓ fx After reading these instructions delete all text in this shaded area.с↓DataDPart cOne-year IncreasePercentage ChangeReviewCan we conclude that there has been asignificance increase in business travelairfares over the one-year period? (Enter"Can conclude" or "Cannot conclude")ViewVEabPart aAfter reading these instructions delete all text in this shaded area.Use the XLMiner Analysis ToolPak to conduct your t-Test analysis.After deleting all text in this shaded area, set the output range inthe ToolPak to the top left cell of this area (D2).Your t-Test analysis output should fit into this shaded area.HelpGeneralFG←0.00Formula.00→.0H#N/A#N/A#N/AEditingΣ ✓ PJ0Give Feedback to MicrosoftCommentsK100% +L 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 containedin the Excel Online file below. Construct a spreadsheet to answer the following questions.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 ToolPakXOpen spreadsheeta. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period.Ho: μ1 μ2H₂ μ1 - μ₂↑What are thet-value, degrees of freedom, andp-valuet-valueDegrees of freedomp-valueWe0(to 4 decimals)Using a .05 level of significance, what is your conclusion?Current Year: $Previous Year: $(to 4 decimals)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?(to 2 decimals)(to 2 decimals)c. What is the percentage change in the airfare for the one-year period?% (to 2 decimals)

The random sample of sizes are n=12 (i.e. n1=n2). The current year's and previous year's data are:…

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. 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 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. Ho 1-2 H₂:1-12 What are the t-value, degrees of freedom, and p-value Ⓒ0 0 t-value Degrees of freedom. p-value We (to 4 decimals) Using a .05 level of significance, what is your conclusion? (to 4 decimals) Current Year: $ Previous Year: $ 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? (to 2 decimals) (to 2 decimals) c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals)