On the Data sheet, go to the Data Tab and click onData Analysis. Double click on the "t-Test: Two-Sample Assuming Equal Variances." ForVariable 1 Range, select A1:A71 and forVariable 2 Range, select B1:B61. Type0for the Hypothesized Mean Difference. Check theLabels box, keep the defaultalpha=0.05 and selectOutput Range underOutput Option. TypeD1.

In cell C4, find the mean for the sample of accounting students' salaries from the Data Analysis output table on the Data sheet.

In cell C5, find the variance of the accounting students' salaries from the Data Analysis output table on the Data sheet.

In cell C6, find the sample size of the accounting students from the Data Analysis output table on the Data sheet.

In cell C7, find the mean for the sample of marketing students' salaries from the Data Analysis output table on the Data sheet.

In cell C8, find the variance of the marketing students' salaries from the Data Analysis output table on the Data sheet.

In cell C9, find the sample size of the marketing students from the Data Analysis output table on the Data sheet.

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.

Hint: use the T.TEST function.

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	Salaries of Marketing Students
51,000	52,000
50,000	54,500
53,000	54,000
55,000	51,000
52,000	53,000
51,000	54,000
52,500	52,000
50,000	53,000
49,000	54,000
53,000	53,000
52,500	51,000
50,000	55,000
52,000	52,000
52,000	50,000
51,000	53,000
48,000	53,000
57,500	51,000
56,000	51,000
50,000	54,000
56,000	58,000
50,000	53,000
57,500	47,000
54,000	53,000
55,000	52,000
55,000	52,000
50,000	49,000
54,000	52,000
46,000	47,000
56,000	48,000
52,000	54,000
55,000	48,000
52,000	54,000
53,000	53,000
55,000	52,000
48,000	49,000
55,000	53,000
55,000	50,000
57,000	49,000
50,000	54,000
54,000	54,000
55,000	53,000
55,000	48,000
48,000	48,000
51,000	58,000
56,000	52,000
55,000	50,000
52,000	53,000
50,500	50,000
52,000	51,000
55,000	42,000
50,000	46,000
48,000	48,000
55,000	52,000
51,000	50,000
53,000	47,000
48,000	53,000
56,000	52,000
48,000	50,000
54,000	48,000
49,000	54,000
48,000
56,000
49,000
53,000
53,000
56,000
56,000
49,000
48,000
52,000

will need the functions so i can put tjhem in the cells