In cell C3, find the average wireless data usage for men. In cell C4, find the average wireless data usage for women. In cell C5, find the degrees of freedom for the samples. The telecommunications company would like to test the claim that there is a difference in the wireless data usage between men and women. Is this a one-sided or two-sided test? Ch menu in cell 06. The null hypothesis is that the average difference in the wireless data usage between men and women is equal to zero. What is the alternative hypothesis? Choose your answer from In cell 08, find the value of the test statistic. In cell 09, find a one-sided critical value to test the hypothesis at alpha=0.05. What is/are the sign(s) of the critical value(s) for the test of the hypothesis at alpha=0.05? Choose your answer from the dropdown menu in cell C10. By assessing the answers in cells C8, 19, and C10, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C11. Justify the answer you chose in cell C11. Choose your answer from the dropdown menu in cell C12. Based on your answer in cell C12, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell C13. In cell C14, find the observed level of significance (p-value) for the test. In cell C15, test the null hypothesis. Hint: use the T.TEST function and the data in the table. By considering the p-value, can the same conclusion be made about rejecting or not rejecting the null hypothesis at alpha = 0.05? Choose your answer from the dropdown menu in ce If the level of significance (alpha) was reduced to 0.01, do you reject the null hypothesis that the average difference in the wireless data usage between men and women is equal to dropdown menu in cell C17. In cell C18, find a one-sided critical value to test the hypothesis at alpha=0.01. Hint: use the T.INV.2T function and the appropriate alpha level and degrees of freedom. By considering the critical value(s) at alpha=0.01, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C19. Justify the answer you chose in cell C19. Choose your answer from the dropdown menu in cell C20. Based on your answer in cell C20, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell C21. What is the lowest level of significance for you to reject the null hypothesis that there is no difference in data usage between men and women? Choose your answer from the dropdov In cell C23, find a one-sided critical value to test the hypothesis at alpha=0.1. Hint: use the T.INV.2T function and the appropriate alpha level and degrees of freedom. By considering the critical value(s) at alpha=0.1, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C24. Justify the answer you chose in cell C24. Choose your answer from the dropdown menu in cell C25. Based on your answer in cell C25, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell C26. Based on your answer in cell C11, what type of error might have been made? Choose your answer from the dropdown menu in cell C27. Based on your answer in cell C24, what type of error might have been made? Choose your answer from the dropdown menu in cell C28. Save your file and submit for grading. A B Men Data Usage (GB per Month) Women Data Usage (GB per Month) 2.1 7.1 2.1 3.2 8.7 2.5 6.2 5.3 6.3 2.3 5.3 2.1 7.4 2.2 3.3 6.7 6.8 2.6 3.3 6.7 5.5 5.8 8.1 7.4 7.5 5.5 10.5 3.5 2.5 1.4 6.6 1.6 8.8 1.2 6.6 2.3 2.7 6.5 6.6 4.9 5.1 7.6 6.9 9.1 9.2 14.4 9.2 6.8 7.5 2.3 3.4 11.1 9.9 6.7 5.8 6.8 5.6 4.3 2.3 3.4 8.9 9.0 6.0 5.1 6.1 3.1 35 3 36 37 38 5.1 7.2 9.2 5.5 2.3 3.3 6.6 39 5.9 2.2 2.3 7.1 7.2 5.5 3.7 4.3 7.5 10.5 40 41 42 43 44 In cell C3, find the average wireless data usage for men. In cell C4, find the average wireless data usage for women. In cell C5, find the degrees of freedom for the samples. The telecommunications company would like to test the claim that there is a difference in the wireless data usage between men and women. Is this a one-sided or two-sided test? Ch menu in cell 06. The null hypothesis is that the average difference in the wireless data usage between men and women is equal to zero. What is the alternative hypothesis? Choose your answer from In cell 08, find the value of the test statistic. In cell 09, find a one-sided critical value to test the hypothesis at alpha=0.05. What is/are the sign(s) of the critical value(s) for the test of the hypothesis at alpha=0.05? Choose your answer from the dropdown menu in cell C10. By assessing the answers in cells C8, 19, and C10, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C11. Justify the answer you chose in cell C11. Choose your answer from the dropdown menu in cell C12. Based on your answer in cell C12, we can conclude at alpha = 0.05 that: Choose your answer from the dropdown menu in cell C13. In cell C14, find the observed level of significance (p-value) for the test. In cell C15, test the null hypothesis. Hint: use the T.TEST function and the data in the table. By considering the p-value, can the same conclusion be made about rejecting or not rejecting the null hypothesis at alpha = 0.05? Choose your answer from the dropdown menu in ce If the level of significance (alpha) was reduced to 0.01, do you reject the null hypothesis that the average difference in the wireless data usage between men and women is equal to dropdown menu in cell C17. In cell C18, find a one-sided critical value to test the hypothesis at alpha=0.01. Hint: use the T.INV.2T function and the appropriate alpha level and degrees of freedom. By considering the critical value(s) at alpha=0.01, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C19. Justify the answer you chose in cell C19. Choose your answer from the dropdown menu in cell C20. Based on your answer in cell C20, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell C21. What is the lowest level of significance for you to reject the null hypothesis that there is no difference in data usage between men and women? Choose your answer from the dropdov In cell C23, find a one-sided critical value to test the hypothesis at alpha=0.1. Hint: use the T.INV.2T function and the appropriate alpha level and degrees of freedom. By considering the critical value(s) at alpha=0.1, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C24. Justify the answer you chose in cell C24. Choose your answer from the dropdown menu in cell C25. Based on your answer in cell C25, we can conclude at alpha = 0.01 that: Choose your answer from the dropdown menu in cell C26. Based on your answer in cell C11, what type of error might have been made? Choose your answer from the dropdown menu in cell C27. Based on your answer in cell C24, what type of error might have been made? Choose your answer from the dropdown menu in cell C28. Save your file and submit for grading. A B Men Data Usage (GB per Month) Women Data Usage (GB per Month) 2.1 7.1 2.1 3.2 8.7 2.5 6.2 5.3 6.3 2.3 5.3 2.1 7.4 2.2 3.3 6.7 6.8 2.6 3.3 6.7 5.5 5.8 8.1 7.4 7.5 5.5 10.5 3.5 2.5 1.4 6.6 1.6 8.8 1.2 6.6 2.3 2.7 6.5 6.6 4.9 5.1 7.6 6.9 9.1 9.2 14.4 9.2 6.8 7.5 2.3 3.4 11.1 9.9 6.7 5.8 6.8 5.6 4.3 2.3 3.4 8.9 9.0 6.0 5.1 6.1 3.1 35 3 36 37 38 5.1 7.2 9.2 5.5 2.3 3.3 6.6 39 5.9 2.2 2.3 7.1 7.2 5.5 3.7 4.3 7.5 10.5 40 41 42 43 44
