Researchers at Purdue University and Wichita State University found that airlines are doing a better job of getting passengers to their destinations on time. AirTran Airways and Southwest Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flights that were delayed, how many minutes were these flights late? Sample data showing the number of minutes that delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines. 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 that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. #₁ = population mean minutes late for delayed AirTran flights #2 = population mean minutes late for delayed Southwest flights Ho: 11-12 =e0 ✔0 H₁:1₁-1₂ b. What is the sample mean number of minutes late for delayed flights for each of these two airlines? (to 2 decimals) (to 2 decimals) Air Tran Southwest 51.68 61.05 c. Using a .05 level of significance, what is the p-value and what is your conclusion? p-value is 0.3097 (to 4 decimals) We cannot reject Ho.
Researchers at Purdue University and Wichita State University found that airlines are doing a better job of getting passengers to their destinations on time. AirTran Airways and Southwest Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flights that were delayed, how many minutes were these flights late? Sample data showing the number of minutes that delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines. 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 that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. #₁ = population mean minutes late for delayed AirTran flights #2 = population mean minutes late for delayed Southwest flights Ho: 11-12 =e0 ✔0 H₁:1₁-1₂ b. What is the sample mean number of minutes late for delayed flights for each of these two airlines? (to 2 decimals) (to 2 decimals) Air Tran Southwest 51.68 61.05 c. Using a .05 level of significance, what is the p-value and what is your conclusion? p-value is 0.3097 (to 4 decimals) We cannot reject Ho.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
Related questions
Question
100%
help asap please. data is given below as well.
Transcribed Image Text:Researchers at Purdue University and Wichita State University found that airlines are doing a better job of getting passengers to their destinations on time. AirTran Airways and
Southwest Airlines were among the leaders in on-time arrivals with both having 88% of their flights arriving on time. But for the 12% of flights that were delayed, how many minutes
were these flights late? Sample data showing the number of minutes that delayed flights were late are provided in the Excel Online file below. Data are shown for both airlines.
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 that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines.
μ₁ = population mean minutes late for delayed AirTran flights
με =
population mean minutes late for delayed Southwest flights
Ho : |1 → |2
H₁ μ₁-2
:
b. What is the sample mean number of minutes late for delayed flights for each of these two airlines?
(to 2 decimals)
(to 2 decimals)
Air Tran
Southwest
#
We cannot
↑
51.68
61.05
c. Using a .05 level of significance, what is the p-value and what is your conclusion?
p-value is 0.3097
(to 4 decimals)
Check My Work
0
0
reject Ho.
Reset Problem
Transcribed Image Text:Excel template - Saved
D2
123456789UHL3
File
10
11
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
22
A
AirTran
111
119
73
21
50
42
7
Home
15
28
10
36
18
20
19
26
53
57
102
120
102
10
118
56
109
69
Insert
Arial
59
Draw Page Layout
Data +
✓10 v
B
Formulas
D
↓
X✓ fx After reading these instructions delete all text in this shaded area.
B
с
F
Southwest
51
68
35
89
49
82
108
38
42
108
66
60
56
43
51
48
79
86
69
Calculation Mode: Automatic Workbook Statistics
Part d
Significance Level (Alpha)
Search (Option + Q)
Data
Can we reject the null hypothesis?
(Enter "Can" or "Cannot")
Review
E
Your t-Test output should fit into this shaded area.
Parts b&c
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).
View
V
0.05
ab
Help
G
General
Formula
H
#N/A
←.0
.00
.00
→.0
1
>
J
Editing
Σ ✓ P
K
Ov
L
Give Feedback to Microsoft
Comments
|
M
100% +
Expert Solution
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 3 steps
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt