A B C D Pair Male Female 56,200 52,600 2 54,700 53,600 3 58,200 59,300 4 51,700 52,300 5 58,600 56,200 6 59,300 55,900 7 58,300 58,500 8 54,400 51,4001. (4) A college placement office wants to determine whether male and female economics graduates receive, on average, different salary offers for their first position after graduation. The placement officer randomly selected eight pairs of business graduates in such a sway that the qualifications, interests, and backgrounds of the members of any pair were as similar as possible. The data file 611h3_data_2021Su.xIsx contains the highest salary offer received by each sample member at the end of the recruiting round. Assume that the population distributions are normal. a. Calculate the difference for each pair. Then use Excel to get the printout of the descriptive statistics for the differences. Note that we have paired samples. b. Use the descriptive statistics in part a to compute a 95% confidence interval for the population mean difference. 1 c. Use the descriptive statistics in part a to test the null hypothesis that the population means are equal against the alternative hypothesis that the true mean for males is higher than for females with the 5% significance level. d. Use "t-Test: Paired Two Sample for Means" in Excel's Data Analysis to get the printout for the test in part c and draw your conclusion of the test based on the p-value