Demand for systems analysts in the consulting industry is greater than ever. Graduates with a combination of business and computer knowledge—some even from liberal arts programs—are 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 C08_02.xlsxDownload C08_02.xlsx
The variables are as follows:
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.
For this case study, submit only Excel file.
(1) Calculate a 95% confidence interval for the mean starting salary of all employees who stay (Yes) at least three years with D&Y.
(2)Calculate a 95% confidence interval for the mean starting salary of all employees who do not stay (No) at least three years with D&Y.
(3) Based on your findings on Part 1 and 2, does it appear the employees who do not stay at least 3 years are underpaid than the employees who do stay at least 3 years. Explain.