60.1K

Verified Solution

Link Copied!

Employee	Starting Salary	On Road Pct	State Univ	CIS Degree	Stayed 3 Years	Tenure
1	38900	57%	Yes	Yes	No	11
2	42300	68%	Yes	Yes	No	5
3	39800	75%	No	Yes	No	21
4	35700	29%	No	Yes	Yes
5	40400	71%	No	Yes	No	19
6	36400	62%	No	Yes	No	18
7	37300	41%	Yes	No	Yes
8	36600	37%	No	Yes	No	17
9	34600	65%	No	Yes	No	20
10	42300	53%	Yes	Yes	No	16
11	37800	73%	No	Yes	Yes
12	39700	60%	No	Yes	No	12
13	36100	56%	Yes	Yes	Yes
14	36100	42%	Yes	Yes	Yes
15	33800	35%	No	Yes	Yes
16	38900	36%	No	Yes	Yes
17	35500	50%	No	Yes	No	15
18	37600	58%	No	Yes	Yes
19	38100	78%	Yes	Yes	Yes
20	38300	16%	No	No	Yes
21	34600	29%	No	Yes	Yes
22	36300	26%	No	Yes	Yes
23	37200	59%	Yes	Yes	No	14
24	37700	55%	Yes	Yes	Yes
25	36600	45%	No	Yes	No	13
26	41000	81%	Yes	Yes	No	9
27	40800	111%	Yes	Yes	No	7
28	36700	56%	Yes	Yes	Yes
29	37700	56%	No	Yes	No	22
30	37700	42%	No	Yes	No	11
31	39300	69%	Yes	Yes	No	16
32	37500	50%	No	Yes	No	18
33	40000	69%	Yes	Yes	No	9
34	41500	64%	Yes	No	No	5
35	39600	72%	No	Yes	No	18
36	36900	42%	No	Yes	Yes
37	39500	62%	No	Yes	No	5
38	37800	20%	No	Yes	No	23
39	38600	57%	No	Yes	No	8
40	40600	70%	Yes	Yes	Yes
41	41600	63%	Yes	Yes	Yes
42	40800	44%	No	No	Yes
43	36200	68%	No	Yes	No	31
44	39600	59%	No	Yes	No	10
45	36100	56%	Yes	Yes	Yes
46	36100	42%	No	Yes	Yes
47	39500	53%	Yes	Yes	No	17
48	39100	38%	No	Yes	Yes
49	40300	53%	Yes	Yes	Yes
50	38800	78%	Yes	Yes	Yes
51	39400	34%	Yes	Yes	No	27
52	38400	23%	No	Yes	Yes
53	35200	33%	No	Yes	Yes
54	36100	24%	No	No	Yes
55	37100	44%	No	Yes	Yes
56	37200	64%	Yes	Yes	No	23
57	36800	46%	Yes	No	Yes
58	36500	27%	No	No	Yes
59	35900	29%	No	No	Yes
60	37900	76%	Yes	Yes	No	14
61	37900	58%	No	Yes	No	26
62	37900	28%	No	Yes	No	14
63	36700	37%	No	Yes	Yes
64	37400	49%	No	Yes	No	19
65	38200	62%	Yes	Yes	Yes
66	36600	51%	Yes	Yes	No	7

CASE 8.2 EMPLOYEE RETENTION AT D&Y emand for systems analysts in the consulting Industry is greater than ever. Graduates with a b. Find a 95% confidence Interval for the mean starting salary of all employees who stay at combination of business and computer knowledge some even from liberal arts programs are getting great offers from consulting companles. Once these people are hired, they frequenty 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 fle C08 02.xlsx. The variables are as follows: least three years with D&Y. Do the same for those who leave before three years. Then find a 95% confidence interval for the difference between these means. c. Among all employees whose starting salary is below the median ($37,750), find a 95% confidence Interval for the proportion who stay with D&Y for at least three years. Do the same for the employees with starting salaries above the median-Then find a 95% confidence Starting Salary: employee's starting salary at DRY Interval for the difference between these pro- portions. On Road Pct percentage of time employee has spent on the road with clients 2. D&Y wonders whether the percentage of time on the road might infuence who stays and who leaves. Repeat the previous problem, but now do the analysls In terms of percentage of time on the road rather than starting salary. (The medlan percentage of time on the road is 54%) Find a 95% confidence interval for the mean State Unl. whether the employee graduated from State Unlversity (D&Ys principal source of recrults) CIS Degree: whether the employee majored in Computer Information Systems (CIS) or a similar computer-related area 3. Stayed 3 Years: whether the employee stayed at least three years with D&Y Tenure: tenure or she moved before three years D&Y within three years of belng hired Why Is It not possible with the gtven data to find a confidence Interval for the mean tenure at D&Y among all systems analysts hired by D&Y? of employee at D&Y (months) If he D&Y is trying to learn everything It can about 4. State University's students, particularly those In Its natlonally acclalmed CIS area, have traditionally been among the best of D&Y's recrults. But are they relatively hard to retaln? Find one or more relevant confidence intervals to help you make an argument one way or the other 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 I. Although starting salarles are In a fairy narrow band, D&Y wonders whether they have anything to do with retention CASE 8.2 EMPLOYEE RETENTION AT D&Y emand for systems analysts in the consulting Industry is greater than ever. Graduates with a b. Find a 95% confidence Interval for the mean starting salary of all employees who stay at combination of business and computer knowledge some even from liberal arts programs are getting great offers from consulting companles. Once these people are hired, they frequenty 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 fle C08 02.xlsx. The variables are as follows: least three years with D&Y. Do the same for those who leave before three years. Then find a 95% confidence interval for the difference between these means. c. Among all employees whose starting salary is below the median ($37,750), find a 95% confidence Interval for the proportion who stay with D&Y for at least three years. Do the same for the employees with starting salaries above the median-Then find a 95% confidence Starting Salary: employee's starting salary at DRY Interval for the difference between these pro- portions. On Road Pct percentage of time employee has spent on the road with clients 2. D&Y wonders whether the percentage of time on the road might infuence who stays and who leaves. Repeat the previous problem, but now do the analysls In terms of percentage of time on the road rather than starting salary. (The medlan percentage of time on the road is 54%) Find a 95% confidence interval for the mean State Unl. whether the employee graduated from State Unlversity (D&Ys principal source of recrults) CIS Degree: whether the employee majored in Computer Information Systems (CIS) or a similar computer-related area 3. Stayed 3 Years: whether the employee stayed at least three years with D&Y Tenure: tenure or she moved before three years D&Y within three years of belng hired Why Is It not possible with the gtven data to find a confidence Interval for the mean tenure at D&Y among all systems analysts hired by D&Y? of employee at D&Y (months) If he D&Y is trying to learn everything It can about 4. State University's students, particularly those In Its natlonally acclalmed CIS area, have traditionally been among the best of D&Y's recrults. But are they relatively hard to retaln? Find one or more relevant confidence intervals to help you make an argument one way or the other 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 I. Although starting salarles are In a fairy narrow band, D&Y wonders whether they have anything to do with retention

Answer & Explanation Solved by verified expert

See Answer