Hello! This is just one question.
Posted: Tue Apr 26, 2022 5:48 pm
Hello! This is just one question.
MindTap - Cengage Learning х C MindTap - Cengage Learning C X + 2 Х c ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=583714295110239446224428046&eISBN=9781337615488&snapshotid=2774710&i... ☆ Update: CENGAGE MINDTAP Q Search this course : Ch. 6 Microsoft Excel: Structured Activity - Business Travel X Question 1 0.89/2 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 The domestic alrfare 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. Submit A-Z O 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. H:-H2 Svo H, :μι - με καινο : - What are the t-value, degrees of freedom, and p-value © t-value t (to 4 decimals) 11 Degrees of freedom p-value (to 4 decimals) ce Using a .05 level of significance, what is your conclusion? bonge We cannot conclude that there has been a significance increase in business travel airfares over the one-year period. Back Next I Type here to search 대 IK 71°F 1:01 AM 4/23/2022
MindTap - Cengage Learning х C MindTap - Cengage Learning C X + 2 Х > c ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=583714295110239446224428046&eISBN=9781337615488&snapshotid=2774710&i... ☆ OF Update: CENGAGE MINDTAP Q Search this course : Ch. 6 Microsoft Excel: Structured Activity - BusinessTravel X Question 1 0.89/2 What are the t-value, degrees of freedom, and p-value Submit (4 (to 4 decimals) A-Z O t-value Degrees of freedom p-value - 11 (to 4 decimals) go Using a .05 level of significance, what is your conclusion? We cannot condude that there has been a significance increase in business travel airfares over the one-year period. b? b. What is the sample mean domestic airfare for business travel for each year? Current Year: $ (2 (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) recent bengo Check My Work Reset Problem Back Next I Type here to search 대 71°F 1:01 AM 4/23/2022
х S Excel Online Student Work х C Mind Tap - Cengage Learning C CG X + 2 Х MindTap - Cengage Learning c about:blank OF Update: Excel template - Saved O Search (Alt + 9) (+) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X Arial 10 ~ AA Wrap lext General SU IX LU Paste C BIUD A === + Merge & Center $ % 4898 Insert Delete Format * Editing Conditional Format As Styles Formatting Table Styles Unco Clipboard Font Alignment Number Cells H2 X fx C D E F G H Current Year Previous Year 1 2 2 Parta ಹ ಹ ಹ ಸ ವ ನ ಸಹm 4 0 0 a w M - 3223323338233 - ទទ៖ នaaឱនននន 10 T Test: Paired Two Sample for Means 12 14 15 16 Formula = A Data + Calculation Mode: Automatic Workbook Statistics loading Add-ins Give Feedback to Microsoft - 100% + % 1:02 AM u 4/23/2022 HE Type here to search 라 71°F
х S Excel Online Student Work х C Mind Tap - Cengage Learning C CG X + 2 Х MindTap - Cengage Learning c about:blank OF Update: Excel template - Saved O Search (Alt + Q) (+) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X Arial 10 General SU IX HH 07 ~ A AA DA Paste 三三三 Wrap lext Merge & Center C BIUD ab $ % 948-98 Insert Delete Format Editing * Conditional Format As Styles Formatting Table Styles Show ToolPak Unco Clipboard Font Alignment Number Cells Commands Group H2 ~ x ✓ fx А. A B с C D E F G H H 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 Partc One-year Increase #N/A Percentage Change #N/A 19 20 21 22 23 24 25 26 27 28 29 30 31 = Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + % 1:02 AM 4/23/2022 HE Type here to search 라 71°F
- Hello This Is Just One Question 1 (150.48 KiB) Viewed 29 times
MindTap - Cengage Learning х C MindTap - Cengage Learning C X + 2 Х > c ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=583714295110239446224428046&eISBN=9781337615488&snapshotid=2774710&i... ☆ OF Update: CENGAGE MINDTAP Q Search this course : Ch. 6 Microsoft Excel: Structured Activity - BusinessTravel X Question 1 0.89/2 What are the t-value, degrees of freedom, and p-value Submit (4 (to 4 decimals) A-Z O t-value Degrees of freedom p-value - 11 (to 4 decimals) go Using a .05 level of significance, what is your conclusion? We cannot condude that there has been a significance increase in business travel airfares over the one-year period. b? b. What is the sample mean domestic airfare for business travel for each year? Current Year: $ (2 (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) recent bengo Check My Work Reset Problem Back Next I Type here to search 대 71°F 1:01 AM 4/23/2022
х S Excel Online Student Work х C Mind Tap - Cengage Learning C CG X + 2 Х MindTap - Cengage Learning c about:blank OF Update: Excel template - Saved O Search (Alt + 9) (+) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X Arial 10 ~ AA Wrap lext General SU IX LU Paste C BIUD A === + Merge & Center $ % 4898 Insert Delete Format * Editing Conditional Format As Styles Formatting Table Styles Unco Clipboard Font Alignment Number Cells H2 X fx C D E F G H Current Year Previous Year 1 2 2 Parta ಹ ಹ ಹ ಸ ವ ನ ಸಹm 4 0 0 a w M - 3223323338233 - ទទ៖ នaaឱនននន 10 T Test: Paired Two Sample for Means 12 14 15 16 Formula = A Data + Calculation Mode: Automatic Workbook Statistics loading Add-ins Give Feedback to Microsoft - 100% + % 1:02 AM u 4/23/2022 HE Type here to search 라 71°F
х S Excel Online Student Work х C Mind Tap - Cengage Learning C CG X + 2 Х MindTap - Cengage Learning c about:blank OF Update: Excel template - Saved O Search (Alt + Q) (+) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments X Arial 10 General SU IX HH 07 ~ A AA DA Paste 三三三 Wrap lext Merge & Center C BIUD ab $ % 948-98 Insert Delete Format Editing * Conditional Format As Styles Formatting Table Styles Show ToolPak Unco Clipboard Font Alignment Number Cells Commands Group H2 ~ x ✓ fx А. A B с C D E F G H H 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 Partc One-year Increase #N/A Percentage Change #N/A 19 20 21 22 23 24 25 26 27 28 29 30 31 = Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% + % 1:02 AM 4/23/2022 HE Type here to search 라 71°F