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
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
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.
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 2 steps
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
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…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL