I just need my information checked. if the answer is wrong would you please provide the correct formula to use. thank you

6 in cell B6 1 Hypothesis Testing for the Population Mean - Sigma Unknown 2 Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, as you will not receive full credit for your answers. 3 1-2. In cell B3, find the average flight time for the sample of flights. 45.96 4 3. In cell B4, find the standard deviation of flight time for the sample of flights. 4.101 5 4. In cell B5, find the sample size of the sample of flights. 90 5. To test the null hypothesis for the mean flight time, what is the appropriate probability table to use? Choose your answer from the dropdown menu Student's t-distribution 7 6. In cell B7, identify the degrees of freedom needed to find the critical valve(). 89 7. The company would like to test the claim (null hypothesis) that the flight takes 45 minutes against the alternative that it does not. Is this a two- 8 sided test? Choose your answer from the dropdown menu in cell BS. Yes, it is two-sided. 9 8. In cell B9, find the value of the test statistic. 2.21 109. In cell B10, find a one-sided critical valve from the appropriate probability table to test the claim at alpha = 0.05. 1.99 10. What is are the sign(s) of the critical valve(s) for the test of the hypothesis at alpha=0.05? Choose your answer from the dropdown menu cell 11 B11 12 11. By assessing the answers in cells B9, B10, and Bll, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B12. Yes, I reject. 12. Justify the answer you chose in cell B12. Choose your answer from the dropdown menu in cell B13. Because the test statistic falls in the rejection region 13. Based on your answer in cell B13, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell B14. There is not enough evidence to reject the claim that the flight duration is equal to 45 minutes. 15 14. In cell B15, find a one-sided critical valve from the appropriate probability table to test the claim at alpha=0.01. 2.63 15. What is/are the sign(s) of the critical valve(s) for the test of the hypothesis at alpha=0.017 Choose your answer from the dropdown menu in cell 14 + 16 B16, Yes, I reject Because the test statistic falls in the rejection region There is enough evidence to reject the claim that the flight duration is equal to 45 minutes. 0.03 19 17 16. By assessing the answers in cells B9, B15, and B16, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B17. 18 17. Justify the answer you chose in cell B17. Choose your answer from the dropdown menu in cell B18. 18. Based on your answer in cell B18, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell B19. 20 19. In cell B20, find the observed level of significance (p-valve). 20. By considering the p-valve, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.057 Choose your answer from 21 the dropdown menu in cell B21. 21. By considering the p-valve, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.01? Choose your answer from 22 the dropdown menu in cell B22. 23 22. Based on your answer in cell B12, what type of error might have been made? Choose your answer from the dropdown menu in cell B23. 23. Based on your answer in cell B17, what type of error might have been made? Choose your answer from the dropdown menu in cell B24. 25 Yes, reject the claim since the p-value is less than alpha. No, do not reject the claim since the p-value is greater than alpha. Type II: Not rejecting the null hypothesis that might be false Type II: Not rejecting the null hypothesis that might be false 24 Hypothesis Testing for the population Mean - Sigma Unknown Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, an you will not receive full credit for your answers. 1-2 In cell B3, find the average flight time for the sample of flights 45.96 * 3. In cell B4, find the standard deviation of flight time for the sample of flights 4.10 5. 4. In cell B5, find the sample size of the sample of flights 90 5. To test the full hypothesis for the mean flight time, what is the appropriate probability table to we? Choose your answer from the dropdown menu 6 in cell B6 Student's t-distribution 76. In cell B7, identify the degree of freedom needed to find the critical value() 89 The company would like to that the claim (null hypothema) that the flight takes 45 minutes against the alternative that it does not. Is this a two- Buded test? Choose your answer from the dropdown menu in cell B5 Yes, it is two-sided. S S In cell B9, find the value of the test statistic 2021 109 In cell B10 find a one-sided critical value from the appropriate probability table to test the claim at alpha=0.05 1991 10. What are the sign() of the critical value(1) for the test of the hypothem at alpha 0.057 Choose your answer from the dropdown menu in cell 11 t= BII 311 11. By usenting the men in cella B9, B10, and B11, do you reject the null hypothesis? Choose yuz anoree from the dropdown menu in cell B12. Yes, I reject 13 12 Pratify the arter you chose in cell B12 Choose your are from the dropdown menu in cell B13. Because the test statistic falls in the rejection region 13 Based on your answer in cell B13, we can conclude at alpha=0.05 that Choose your answer from the dropdown mano in cell B14 There is not enough evidence to reject the claim that the flight duration is equal to 45 minute 15 14 In cell B15, find a one-sided critical value from the appropriate probability table to test the claim at alpha=0.01. 2.63 15 What are the rigo(a) of the critical value() for the test of the hypothesis at alph=0.017 Choose your answer from the dropdown mens in cell H 16 B16 18 19 16 By meaning the towers in cells B9, B15, and B16, do you reject the mall hypothesi? Choose your answer from the dropdown menu in cell B17 Yes, I reject 17 Justify the anne you chose in call B17 Choose your fer from the dropdown menu in cell B18 Because the test statistic falls in the rejection region 18 Based on your answer in cell B18, we can conclude at alpha=0,01 that: Choose your answer from the dropdown menu in cell B19 There is enough evidence to reject the claim that the flight duration is equal to 15 minutes 19. In cell 320, find the observed level of significance p-valo) 0.03 20. By considering the p-valse can the same concloan be made ahoot rejecting or not rejecting the claim at alpha= 0.037 Choose your answer from 21 the dropdown ment cell B22 Yes, reject the claim since the p-value is less than alpha Because the test statista falls in the rejection resion There is enough evidence to reject the claim that the flashr duration is equal to 15 0 0 16 By assing the war in cella B9 B15 and 16. do you reje! 16+ 17 Justify the are you chose in cell B17 Choose your are from the dropdown meno cell 18 18 Band on you are in cellBIE, TE Cat conclude at alpha - 0,01 that: Choose you are from the dropdown men in call B19 20 19 In cell B20 find the observed level of pificance (p-value) 20. By considering the p-value can the same conclusion be made about rejecting er at rejecting the claim at alpha=0.057 Choose yone from 21 the dropdowme in cell B21 21 By continence the p valse can the same concluso be made about rejecting or not resecting the claim at alpha 0.017 Choose your ser from the dropdown men cell 22 22. Based on your answer is cell B12 what type of emot might have been made? Choose yra ape from the dropdown my cell B25 23 Based on your are in cell at type of mor might have bees made Choose you are from the dropdoen mann i 324 Yes, reject the claim since the p-value is less than alpha No, do not reject the diam since the p-value is greater than alpha Type II: Not rejecting the mill hypothesis that might be false Type II Not rejecting the sull hypothesis that meht be false B 3 4 5 3 5 6 CO 1 Non-stop Flight Flight Duration (Time in the air) in minutes 2 1 45.0 3 2 42.0 4 3 41.0 5 4 38.0 6 5 41.0 7 44.0 7 51.0 9 8 47.0 10 9 43.0 10 40.0 12 11 46.0 12 45.0 14 13 43.0 14 44.0 16 15 43.0 17 16 39.0 18 44.0 19 18 48.0 20 19 48.0 21 20 22 21 50.0 22 43.0 24 23 41.0 25 24 51.0 26 25 40.0 13 15 17 51.0 23 B 27 8 26 27 29 28 0 1 e 9 29 30 31 32 33 34 35 36 35 56 37 38 38 39 45.0 49.0 55.0 41.0 41.0 40.0 41.0 45.0 50.0 47.0 50.0 42.0 46.0 48.0 44.0 42.0 47.0 46.0 48.0 48.0 51.0 48.0 59.0 46.0 47.0 2.0 49.0 11 43 42 43 14 45 44 45 46 46 47 18 49 48 50 49 50 51 52 53 51 52 Instructions Data Questions 54 55 53 54 55 56 50.0 50.0 52.0 49.0 57 56 58 57 58 59 60 59 61 60 63 Hum3uBGBDn2E 42.0 42.0 43.0 45.0 39.0 49.0 48.0 49.0 43.0 41.0 63 65 64 68 66 67 68 69 70 73 74 73 43.0 43.0 50.0 2.0 46.0 410 470 43.0 51.0 48.0 47.0 43.0 75 74 75 76 77 78 76 78 79 80 Fill 79 80 78 79 80 81 82 81 83 82 83 84 85 47.0 43.0 50.0 44.0 42.0 56.0 49.0 46.0 44.0 48.0 51.0 86 87 88 89 84 85 86 87 88 89 90 90 11.0 49.0 91 92 6 in cell B6 1 Hypothesis Testing for the Population Mean - Sigma Unknown 2 Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, as you will not receive full credit for your answers. 3 1-2. In cell B3, find the average flight time for the sample of flights. 45.96 4 3. In cell B4, find the standard deviation of flight time for the sample of flights. 4.101 5 4. In cell B5, find the sample size of the sample of flights. 90 5. To test the null hypothesis for the mean flight time, what is the appropriate probability table to use? Choose your answer from the dropdown menu Student's t-distribution 7 6. In cell B7, identify the degrees of freedom needed to find the critical valve(). 89 7. The company would like to test the claim (null hypothesis) that the flight takes 45 minutes against the alternative that it does not. Is this a two- 8 sided test? Choose your answer from the dropdown menu in cell BS. Yes, it is two-sided. 9 8. In cell B9, find the value of the test statistic. 2.21 109. In cell B10, find a one-sided critical valve from the appropriate probability table to test the claim at alpha = 0.05. 1.99 10. What is are the sign(s) of the critical valve(s) for the test of the hypothesis at alpha=0.05? Choose your answer from the dropdown menu cell 11 B11 12 11. By assessing the answers in cells B9, B10, and Bll, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B12. Yes, I reject. 12. Justify the answer you chose in cell B12. Choose your answer from the dropdown menu in cell B13. Because the test statistic falls in the rejection region 13. Based on your answer in cell B13, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell B14. There is not enough evidence to reject the claim that the flight duration is equal to 45 minutes. 15 14. In cell B15, find a one-sided critical valve from the appropriate probability table to test the claim at alpha=0.01. 2.63 15. What is/are the sign(s) of the critical valve(s) for the test of the hypothesis at alpha=0.017 Choose your answer from the dropdown menu in cell 14 + 16 B16, Yes, I reject Because the test statistic falls in the rejection region There is enough evidence to reject the claim that the flight duration is equal to 45 minutes. 0.03 19 17 16. By assessing the answers in cells B9, B15, and B16, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell B17. 18 17. Justify the answer you chose in cell B17. Choose your answer from the dropdown menu in cell B18. 18. Based on your answer in cell B18, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell B19. 20 19. In cell B20, find the observed level of significance (p-valve). 20. By considering the p-valve, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.057 Choose your answer from 21 the dropdown menu in cell B21. 21. By considering the p-valve, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.01? Choose your answer from 22 the dropdown menu in cell B22. 23 22. Based on your answer in cell B12, what type of error might have been made? Choose your answer from the dropdown menu in cell B23. 23. Based on your answer in cell B17, what type of error might have been made? Choose your answer from the dropdown menu in cell B24. 25 Yes, reject the claim since the p-value is less than alpha. No, do not reject the claim since the p-value is greater than alpha. Type II: Not rejecting the null hypothesis that might be false Type II: Not rejecting the null hypothesis that might be false 24 Hypothesis Testing for the population Mean - Sigma Unknown Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, an you will not receive full credit for your answers. 1-2 In cell B3, find the average flight time for the sample of flights 45.96 * 3. In cell B4, find the standard deviation of flight time for the sample of flights 4.10 5. 4. In cell B5, find the sample size of the sample of flights 90 5. To test the full hypothesis for the mean flight time, what is the appropriate probability table to we? Choose your answer from the dropdown menu 6 in cell B6 Student's t-distribution 76. In cell B7, identify the degree of freedom needed to find the critical value() 89 The company would like to that the claim (null hypothema) that the flight takes 45 minutes against the alternative that it does not. Is this a two- Buded test? Choose your answer from the dropdown menu in cell B5 Yes, it is two-sided. S S In cell B9, find the value of the test statistic 2021 109 In cell B10 find a one-sided critical value from the appropriate probability table to test the claim at alpha=0.05 1991 10. What are the sign() of the critical value(1) for the test of the hypothem at alpha 0.057 Choose your answer from the dropdown menu in cell 11 t= BII 311 11. By usenting the men in cella B9, B10, and B11, do you reject the null hypothesis? Choose yuz anoree from the dropdown menu in cell B12. Yes, I reject 13 12 Pratify the arter you chose in cell B12 Choose your are from the dropdown menu in cell B13. Because the test statistic falls in the rejection region 13 Based on your answer in cell B13, we can conclude at alpha=0.05 that Choose your answer from the dropdown mano in cell B14 There is not enough evidence to reject the claim that the flight duration is equal to 45 minute 15 14 In cell B15, find a one-sided critical value from the appropriate probability table to test the claim at alpha=0.01. 2.63 15 What are the rigo(a) of the critical value() for the test of the hypothesis at alph=0.017 Choose your answer from the dropdown mens in cell H 16 B16 18 19 16 By meaning the towers in cells B9, B15, and B16, do you reject the mall hypothesi? Choose your answer from the dropdown menu in cell B17 Yes, I reject 17 Justify the anne you chose in call B17 Choose your fer from the dropdown menu in cell B18 Because the test statistic falls in the rejection region 18 Based on your answer in cell B18, we can conclude at alpha=0,01 that: Choose your answer from the dropdown menu in cell B19 There is enough evidence to reject the claim that the flight duration is equal to 15 minutes 19. In cell 320, find the observed level of significance p-valo) 0.03 20. By considering the p-valse can the same concloan be made ahoot rejecting or not rejecting the claim at alpha= 0.037 Choose your answer from 21 the dropdown ment cell B22 Yes, reject the claim since the p-value is less than alpha Because the test statista falls in the rejection resion There is enough evidence to reject the claim that the flashr duration is equal to 15 0 0 16 By assing the war in cella B9 B15 and 16. do you reje! 16+ 17 Justify the are you chose in cell B17 Choose your are from the dropdown meno cell 18 18 Band on you are in cellBIE, TE Cat conclude at alpha - 0,01 that: Choose you are from the dropdown men in call B19 20 19 In cell B20 find the observed level of pificance (p-value) 20. By considering the p-value can the same conclusion be made about rejecting er at rejecting the claim at alpha=0.057 Choose yone from 21 the dropdowme in cell B21 21 By continence the p valse can the same concluso be made about rejecting or not resecting the claim at alpha 0.017 Choose your ser from the dropdown men cell 22 22. Based on your answer is cell B12 what type of emot might have been made? Choose yra ape from the dropdown my cell B25 23 Based on your are in cell at type of mor might have bees made Choose you are from the dropdoen mann i 324 Yes, reject the claim since the p-value is less than alpha No, do not reject the diam since the p-value is greater than alpha Type II: Not rejecting the mill hypothesis that might be false Type II Not rejecting the sull hypothesis that meht be false B 3 4 5 3 5 6 CO 1 Non-stop Flight Flight Duration (Time in the air) in minutes 2 1 45.0 3 2 42.0 4 3 41.0 5 4 38.0 6 5 41.0 7 44.0 7 51.0 9 8 47.0 10 9 43.0 10 40.0 12 11 46.0 12 45.0 14 13 43.0 14 44.0 16 15 43.0 17 16 39.0 18 44.0 19 18 48.0 20 19 48.0 21 20 22 21 50.0 22 43.0 24 23 41.0 25 24 51.0 26 25 40.0 13 15 17 51.0 23 B 27 8 26 27 29 28 0 1 e 9 29 30 31 32 33 34 35 36 35 56 37 38 38 39 45.0 49.0 55.0 41.0 41.0 40.0 41.0 45.0 50.0 47.0 50.0 42.0 46.0 48.0 44.0 42.0 47.0 46.0 48.0 48.0 51.0 48.0 59.0 46.0 47.0 2.0 49.0 11 43 42 43 14 45 44 45 46 46 47 18 49 48 50 49 50 51 52 53 51 52 Instructions Data Questions 54 55 53 54 55 56 50.0 50.0 52.0 49.0 57 56 58 57 58 59 60 59 61 60 63 Hum3uBGBDn2E 42.0 42.0 43.0 45.0 39.0 49.0 48.0 49.0 43.0 41.0 63 65 64 68 66 67 68 69 70 73 74 73 43.0 43.0 50.0 2.0 46.0 410 470 43.0 51.0 48.0 47.0 43.0 75 74 75 76 77 78 76 78 79 80 Fill 79 80 78 79 80 81 82 81 83 82 83 84 85 47.0 43.0 50.0 44.0 42.0 56.0 49.0 46.0 44.0 48.0 51.0 86 87 88 89 84 85 86 87 88 89 90 90 11.0 49.0 91 92