A6 V Xfx B Note-read the details of what is given carefully to make sure you understand n, s and Sigma. D E F G H 1234 Suppose an airline claims that its flights are consistently on time with an average delay of at most 15 minutes. It claims that the average delay is so consistent that the variance is no more than 150 minutes. Doubting the consistency part of the claim, a disgruntled traveler calculates the delays for his next 25 flights. The average delay for those 25 5 flights is 22 minutes with a standard deviation of 15 minutes. 6 Note-read the details of what is given carefully to make sure you understand n, s and Sigil 7 8 Given 9 n = Value 25 10 s = 11 Sigma = 15 12.24744871 0.95 150 12 CL= 95% (n-1)s2 x=. 13 14 CV Excel X2 (TS) Excel 15 #N/A #N/A 16 17 Based on Ho: o <150 state the rejection rule and decsion 18 19 20 21 I J K 1 Ho²≥7-2² H²<7.2² This is a lower or left-tailed test 2 Given Value 3 n= 25 4 s= 3.5 5 Sigma = 7.2 6 CL= 0.95 7 8 CV 9 Excel 13.85 =CHISQ.INV(1-B6,24 5.67 =(B3-1)*(B4^2)/(B5^2) (n − 1)s² X2 (TS) Excel 10 11 12 a=0.05 13 14 15 16 X x=5.67 17 13.85 18 19 20 02 7.2 Ho< 7.2 CANNOT ACCEPT H 21 22 23

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 11PPS
icon
Related questions
Question
Please read the question in the picture and answer the questions in excel with the formulas used. And answer the decision at the bottom please explain. The photo with the graph is a guide example.
A6
V
Xfx
B
Note-read the details of what is given carefully to make sure you understand n, s and Sigma.
D
E
F
G
H
1234
Suppose an airline claims that its flights are consistently on time with an average delay
of at most 15 minutes. It claims that the average delay is so consistent that the variance
is no more than 150 minutes. Doubting the consistency part of the claim, a disgruntled
traveler calculates the delays for his next 25 flights. The average delay for those 25
5 flights is 22 minutes with a standard deviation of 15 minutes.
6 Note-read the details of what is given carefully to make sure you understand n, s and Sigil
7
8 Given
9
n =
Value
25
10 s =
11 Sigma =
15
12.24744871
0.95
150
12 CL=
95%
(n-1)s2
x=.
13
14 CV
Excel
X2 (TS)
Excel
15
#N/A
#N/A
16
17 Based on Ho: o <150 state the rejection rule and decsion
18
19
20
21
I
J
K
Transcribed Image Text:A6 V Xfx B Note-read the details of what is given carefully to make sure you understand n, s and Sigma. D E F G H 1234 Suppose an airline claims that its flights are consistently on time with an average delay of at most 15 minutes. It claims that the average delay is so consistent that the variance is no more than 150 minutes. Doubting the consistency part of the claim, a disgruntled traveler calculates the delays for his next 25 flights. The average delay for those 25 5 flights is 22 minutes with a standard deviation of 15 minutes. 6 Note-read the details of what is given carefully to make sure you understand n, s and Sigil 7 8 Given 9 n = Value 25 10 s = 11 Sigma = 15 12.24744871 0.95 150 12 CL= 95% (n-1)s2 x=. 13 14 CV Excel X2 (TS) Excel 15 #N/A #N/A 16 17 Based on Ho: o <150 state the rejection rule and decsion 18 19 20 21 I J K
1
Ho²≥7-2²
H²<7.2²
This is a lower or left-tailed test
2 Given Value
3 n=
25
4 s=
3.5
5 Sigma = 7.2
6
CL=
0.95
7
8 CV
9
Excel
13.85 =CHISQ.INV(1-B6,24 5.67 =(B3-1)*(B4^2)/(B5^2)
(n − 1)s²
X2 (TS) Excel
10
11
12
a=0.05
13
14
15
16
X
x=5.67
17
13.85
18
19
20
02 7.2
Ho< 7.2
CANNOT ACCEPT H
21
22
23
Transcribed Image Text:1 Ho²≥7-2² H²<7.2² This is a lower or left-tailed test 2 Given Value 3 n= 25 4 s= 3.5 5 Sigma = 7.2 6 CL= 0.95 7 8 CV 9 Excel 13.85 =CHISQ.INV(1-B6,24 5.67 =(B3-1)*(B4^2)/(B5^2) (n − 1)s² X2 (TS) Excel 10 11 12 a=0.05 13 14 15 16 X x=5.67 17 13.85 18 19 20 02 7.2 Ho< 7.2 CANNOT ACCEPT H 21 22 23
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
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