Question 1 Demand for systems analysts in the consulting industry is greater than ever. Graduates with a combination of business and computer knowledgesome even from liberal arts programsare getting great offers from consulting companies. Once these people are hired, they frequently switch from one company to another as competing companies lure them away with even better offers. One consulting company, D&Y, has collected data on a sample of systems analysts with undergraduate degrees they hired several years ago. The data are in the file Retention.xlsx. The variables are as follows: Variable Description Employee's starting salary at D&Y OnRoad Pct Percentage of time employee has spent on the road with clients Whether the employee majored in Computer Information Systems or a similar computer-related ' ClSDegree area StayedSYrs Whether the employee stayed at least three years with D&Y D&Y is trying to learn everything it can about retention of these valuable employees. You can help by solving the following problems and then, based on your analysis, presenting a report to D&Y. (Note: You can benefit from using Pivot Tables in answering some of the questions) a. Although starting salaries are in a fairly narrow band, D&Y wonders whether they have anything to do with retention. Find a 95% confidence interval for the mean starting salary of all employees who stay at least three years with D&Y. Do the same for those who leave before three years. b. Among all employees whose starting salary is below the median ($37,750), what proportion stay with D&Y for at least three years? Do the same for the proportion of employees which their starting salary is above median ($37,750) and stay for at least three years. c. D&Y wonders whether the percentage of time on the road might influence who stays and who leaves. Find a 95% confidence interval for the percentage of time on road of all employees who stay at least three years with D&Y. Do the same for those who leave before three years. d. Among all employees whose percentage of time on road is below the median (%54), what proportion stay with D&Y for at least 3 years. Do the same for all employees whose percentage of time on road is above the median (%54) and who stay with D&Y for at least 3 years. e. What proportion of employees with CIS degree leave before three years? Find the same proportion for employees without CIS degree. f. Write a short report about employees' retention at D&Y based on your findings