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)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter9: Quadratic Functions And Equations
Section9.8: Analyzing Functions With Successive Differences
Problem 2BGP
icon
Related questions
Question

please help asap i will upvote!!

5
D2
1
68 69 SAWN
2
3
4
5
File
7
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
วา
Home
A
Current Year
246
657
321
240
687
414
519
246
528
477
447
678
Insert
Data
Arial
Draw Page Layout
B
Previous Year
261
315
339
+
441
441
564
372
297
345
534
402
264
✓10
B
Calculation Mode: Automatic Workbook Statistics
Formulas
X ✓ fx After reading these instructions delete all text in this shaded area.
с
↓
Data
D
Part c
One-year Increase
Percentage Change
Review
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")
View
V
E
ab
Part a
After 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 in
the ToolPak to the top left cell of this area (D2).
Your t-Test analysis output should fit into this shaded area.
Help
General
F
G
←0
.00
Formula
.00
→.0
H
#N/A
#N/A
#N/A
Editing
Σ ✓ P
J
0
Give Feedback to Microsoft
Comments
K
100% +
L
Transcribed Image Text:5 D2 1 68 69 SAWN 2 3 4 5 File 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 วา Home A Current Year 246 657 321 240 687 414 519 246 528 477 447 678 Insert Data Arial Draw Page Layout B Previous Year 261 315 339 + 441 441 564 372 297 345 534 402 264 ✓10 B Calculation Mode: Automatic Workbook Statistics Formulas X ✓ fx After reading these instructions delete all text in this shaded area. с ↓ Data D Part c One-year Increase Percentage Change Review 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") View V E ab Part a After 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 in the ToolPak to the top left cell of this area (D2). Your t-Test analysis output should fit into this shaded area. Help General F G ←0 .00 Formula .00 →.0 H #N/A #N/A #N/A Editing Σ ✓ P J 0 Give Feedback to Microsoft Comments K 100% + 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 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
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.
Ho: μ1 μ2
H₂ μ1 - μ₂
↑
What are the
t-value, degrees of freedom, and
p-value
t-value
Degrees of freedom
p-value
We
0
(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)
Transcribed Image 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. 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 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. Ho: μ1 μ2 H₂ μ1 - μ₂ ↑ What are the t-value, degrees of freedom, and p-value t-value Degrees of freedom p-value We 0 (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)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

test statistic value, degrees of freedom and p value are all wrong. please provide correct answers for them!!

Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Algebra
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University