Information is attached
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 "t-Test: Two-Sample Assuming Equal Variances." For Variable 1 Range, select A1:A71 and for Variable 2 Range, select B1:B61. Type 0 for the Hypothesized Mean Difference. Check the Labels box, keep the default alpha=0.05 and select Output Range under Output Option. Type D1. In cell C4, find the mean for the sample of accounting students' salaries from the Data Analysis output table on the Data sheet. 52,398.55 In cell C5, find the variance of the accounting students' salaries from the Data Analysis output table on the Data sheet. 8,401,321.40 In cell C6, find the sample size of the accounting students from the Data Analysis output table on the Data sheet. 69 In cell C7, find the mean for the sample of marketing students' salaries from the Data Analysis output table on the Data sheet. $ 51,432.20 In cell C8, find the variance of the marketing students' salaries from the Data Analysis output table on the Data sheet. 8,262,565.75 In cell C9, find the sample size of the marketing students from the Data Analysis output table on the Data sheet. 59 In cell C10, find the pooled variance for the two samples from the Data Analysis output table on the Data sheet. In cell C11, 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 marketing students, against the alternative hypothesis that the average salary of accounting students is higher than the average salary of marketing students. Is this a two-sided test? Choose the correct answer from the dropdown menu in cell C12. In cell C13, find the value of the test statistic from the Data Analysis output table on the Data sheet. In cell C14, find the critical value from the Data Analysis output table on the Data sheet. What is the sign of the critical value in C14? Choose your answer from the dropdown menu in cell C15. By assessing the values in cells C13, C14, and C15, do you reject the null hypothesis? Choose your answer from the dropdown menu in cell C16. Justify the answer you chose in cell C16. Choose your answer from the dropdown menu in cell C17. 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 C18. In cell C19, find the observed level of significance (p-value) for the test from the Data Analysis output table on the Data sheet. In cell C20, test the null hypothesis. By considering the p-value, can the same conclusion be made about rejecting or not rejecting the claim at alpha = 0.05? Choose your answer from the dropdown menu in cell C21. 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. 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. 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.Salaries of Accounting Students 51,000 50,000 53,000 55,000 52,000 51,000 52,500 50,000 49,000 53,000 52,500 50,000 52,000 52,000 51,000 48,000 57,500 56,000 50,000 56,000 50,000 57,500 54,000 55,000 55,000 50,000 54,000 46,000 56,000 52,000 55,000 52,000 53,000 55,000 48,000 55,000 55,000 57,000 50,000 54,000 55,000 55,000 48,000 51,000 56,000 55,000 52,000 50,500 52,000 Salaries of Marketing Students 52,000 54,500 54,000 51,000 53,000 54,000 52,000 53,000 54,000 53,000 51,000 55,000 52,000 50,000 53,000 53,000 51,000 51,000 54,000 58,000 53,000 47,000 53,000 52,000 52,000 49,000 52,000 47,000 48,000 54,000 48,000 54,000 53,000 52,000 49,000 53,000 50,000 49,000 54,000 54,000 53,000 48,000 48,000 58,000 52,000 50,000 53,000 50,000 51,000
