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 0 H₂:41-42 0 What are the t-value, degrees of freedom, and p-value t-value Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? We (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)
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 0 H₂:41-42 0 What are the t-value, degrees of freedom, and p-value t-value Degrees of freedom p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? We (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)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
100%
![Excel template - Saved
D2
123456789UINH
10
11
15
16
78
File
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
วา
<
Home
Ú
A
Current Year
204
540
486
612
309
615
630
387
309
525
300
552
=
Data
Insert
Arial
Draw Page Layout
+
✓ 10
V
B
Formulas
☆
Search (Option + Q)
Part c
One-year Increase
Data
fx After reading these instructions delete all text in this shaded area.
B
с
D
Previous Year
255
597
279
432
285
513
570
597
414
369
210
360
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
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.
ab
Help
General
F
G
←0
.00
Formula
.00
→.0
H
#N/A
#N/A
#N/A
V
Editing
Σ ✓ P
J
Comments
K](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc3ad949-79b2-4a66-83f9-922936cf2321%2F74016393-27aa-4e24-b023-eb40989f9890%2F9uvqowm_processed.png&w=3840&q=75)
Transcribed Image Text:Excel template - Saved
D2
123456789UINH
10
11
15
16
78
File
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
วา
<
Home
Ú
A
Current Year
204
540
486
612
309
615
630
387
309
525
300
552
=
Data
Insert
Arial
Draw Page Layout
+
✓ 10
V
B
Formulas
☆
Search (Option + Q)
Part c
One-year Increase
Data
fx After reading these instructions delete all text in this shaded area.
B
с
D
Previous Year
255
597
279
432
285
513
570
597
414
369
210
360
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
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.
ab
Help
General
F
G
←0
.00
Formula
.00
→.0
H
#N/A
#N/A
#N/A
V
Editing
Σ ✓ P
J
Comments
K
![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 ↑ 0
H₂ : 1 - 2
↑
What are the
t-value, degrees of freedom, and
p-value
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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbc3ad949-79b2-4a66-83f9-922936cf2321%2F74016393-27aa-4e24-b023-eb40989f9890%2Fd9t5w4m_processed.png&w=3840&q=75)
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
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 ↑ 0
H₂ : 1 - 2
↑
What are the
t-value, degrees of freedom, and
p-value
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)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman