\fA B C D Hypothesis Testing for Two Population Means - Assuming Equal Variances 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, as you will not receive full credit for your answers. On the Data sheet, go to the Data Tab and click on Data Analysis. Double click on the ":-Test: Two-Simple Assuming Equal Variances." 1-2. For Variable 1 Range, select A1:71 and for Variable 2 Range, select Bi:Bol. Type O for the Hypothesized Mean Difference. Check the Labels box, keep the default alpha=0.05 and select Output Range under Output Option. Type Di. 3. In cell C4, find the mean for the sample of accounting students' salaries from the Data Analysis output table on the Data sheet. 4. In cell CS, find the variance of the accounting students' salaries from the Data Analysis output table on the Data sheet. 5. In cell CS, find the sample size of the accounting students from the Data Analysis output table on the Data sheet. 6. In cell CY, find the mean for the sample of marketing stodents' salaries from the Data Analysis output table on the Data sheet. T. In cell CB, find the variance of the marketing students' salaries from the Data Analysis output table on the Data sheet. 8. In cell C9, find the sample size of the marketing students from the Data Analysis output table on the Data sheet. 9. In cell C10, find the pooled variance for the two samples from the Data Analysis output table on the Data sheet. "10. In cell Cl 1, find the degrees of freedom for the two samples from the Data Analysis output table on the Data sheet. The office of career services would like to test the claim (null hypothesis) that the average salary of accounting students is less than or equal to the average salary of 1 1. marketing students, against the ahernative hypothesis that the average salary of accounting students is higher than the average salary of marketing students. Is this a two-sided fest! Choose the correct answer from the dropdown menu in cell C12. "12. In cell C13, find the value of the test statistic from the Data Analysis output table on the Data sheet. "13. In cell C14, find the critical value from the Data Analysis output table on the Data sheet. "14. What is the sign of the critical value in C14? Choose your answer from the dropdown menu in cell CIS. 15. By assessing the values in cells C13, C14, and CIS, do you reject the wall hypothesis? Choose your answer from the dropdown menu in cell CIG. 16. Justify the answer you chose in cell CIG. Choose your answer from the dropdown menu in cell CIT. 18 17. Based on your answer in cell C17, we can conclude at alpha = 0.05 that: Choose the correct answer from the dropdown menu in cell CIS. "18. In cell C19, find the observed level of significance (p-value) for the test from the Data Analysis output table on the Data sheet. 19. In cell C20, test the null hypothesis. 21 20. 21. If the level of significance (alpha) was reduced to 0.01, would you reject the null hypothesis that the average salary of accounting students is lower than the average salary of marketing students? Choose your answer from the dropdown menu in cell C22. /22. Based on your answer in cell C21, what type of error might have been made? Choose your answer from the dropdown menu in cell C23. 23. Based on your answer in cell C22, what type of error might have been made? Choose your answer from the dropdown menu in cell C24