Employee Retention at D&Y 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 form 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.xlsx (Found in BB). The variables are as follows:

· Starting salary: employee’s starting salary at D&Y

· On Road Pct: percentage of time employee has spent on the road with clients

· State Univ: whether the employee graduated from State University (D&Y’s principal source of recruits)

· CIS Degree: whether the employee majored in Computer Information Systems (CIS) or a similar computer-related area

· Stayed 3 Years: whether the employee stayed at least 3 years with D&Y

· Tenure: tenure of employee at D&Y (months) if he or she moved before 3 years 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.

1. Although starting salaries are in a fairly-narrow band, D&Y wonders whether they have anything to do with retention.

a. Calculate a 95% confidence interval for the mean starting salry of all empoyees who stay at least 3 years with D&Y. Do the same for those who leave before 3 years. Then calculate a 95% confidence interval for the difference between these means.

b. Among all employees whose staring salary is below the median ($37,750), calculate a 95% confidence interval for the proportion who stay with D&Y for at least 3 years. Do the same for the employees with starting salaries above the median. Then calculate a 95% confidence interval for the difference between these proportions.

2. D&Y wonders whether the percentage of time on the road might influence who stays and who leaves. Repeat the previous problem but now do the analysis in terms of percentage of time on the road rather than starting salary. (The median percentage of time on the road is 54%.)

3. Find a 95% confidence interval for the mean tenure (in months) of all employees who leave D&Y within 3 years of being hired. Why is it not possible with the given data to calculate a confidence interval for the mean tenure at D&Y among all systems analysis hired by D&Y?

4. State University’s students, particularly those in its nationally acclaimed CIS area, have traditionally been among the best of D&Y’s recruits. But are they relatively hard to retain? Calculate one or more confidence intervals to help you make an argument one way or the other

Employee	Starting Salary	On Road Pct	State Univ	CIS Degree	Stayed 3 Years	Tenure
4	35700	29%	No	Yes	Yes
7	37300	41%	Yes	No	Yes
11	37800	73%	No	Yes	Yes
13	36100	56%	Yes	Yes	Yes
14	36100	42%	Yes	Yes	Yes
15	33800	35%	No	Yes	Yes
16	38900	36%	No	Yes	Yes
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
24	37700	55%	Yes	Yes	Yes
28	36700	56%	Yes	Yes	Yes
36	36900	42%	No	Yes	Yes
40	40600	70%	Yes	Yes	Yes
41	41600	63%	Yes	Yes	Yes
42	40800	44%	No	No	Yes
45	36100	56%	Yes	Yes	Yes
46	36100	42%	No	Yes	Yes
48	39100	38%	No	Yes	Yes
49	40300	53%	Yes	Yes	Yes
50	38800	78%	Yes	Yes	Yes
52	38400	23%	No	Yes	Yes
53	35200	33%	No	Yes	Yes
54	36100	24%	No	No	Yes
55	37100	44%	No	Yes	Yes
57	36800	46%	Yes	No	Yes
58	36500	27%	No	No	Yes
59	35900	29%	No	No	Yes
63	36700	37%	No	Yes	Yes
65	38200	62%	Yes	Yes	Yes
1	38900	57%	Yes	Yes	No	11
2	42300	68%	Yes	Yes	No	5
3	39800	75%	No	Yes	No	21
5	40400	71%	No	Yes	No	19
6	36400	62%	No	Yes	No	18
8	36600	37%	No	Yes	No	Related Book For   College Physics Reasoning and Relationships ISBN: 978-0840058195 2nd edition Authors: Nicholas Giordano See More Books Posted Date: Feb 17, 2019 11:50 PM See More Questions Students also viewed these accounting questions Employee Retention at D&Y 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... A university administrator has collected data on total Scholastic Aptitude Test (SAT) score versus freshman grade point average (GPA) for a sample of students who recently finished their first year... A polling organization collected data on a sample of 60 registered voters regarding a tax on the market value of equity transactions as one remedy for the budget deficit. a. Compute gamma for the... Suppose that you just purchased 200 shares of Talk&Tell stock for $60 per share. a. If the initial margin requirement is 71.00%, how much money must you borrow? b. Construct the balance sheet... Use EDGAR to find Qualcomm's 10-K filing for 2015. From the balance sheet, answer the following questions: a. How much did Qualcomm have in cash and short-term investments? b. What were Qualcomm's... A limitation of calculating a bond portfolios duration as the weighted average of the yield durations of the individual bonds that compose the portfolio is that it: A. Assumes a parallel shift to the... Kia Motors America sells its cars through hundreds of dealerships in the United States. Kia has the exclusive right to use and license others to use its trademarks, service marks, and trade name. If... White Company has two departments, Cutting and Finishing. The company uses a job-order costing system and computes a predetermined overhead rate in each department. The Cutting Department bases its... Mickley Company's plantwide predetermined overhead rate is $23.00 per direct labor-hour and its direct labor wage rate is $11.00 per hour. The following information pertains to Job A-500: Direct... The following two situations involve the capitalization of borrowing costs. Situation I: On January 1, 2022, Columbia Outfitters signed a fixed-price contract to have Builder Associates construct a... Get access to MatLab (or some equivalent software package). (b) Read the MatLab overview (c) Plot the functions r(t) and r(t) using MatLab, where x(t) = te [-T, 0] te [0, 1] 0 : otherwise. sin(2t)... The incomes of families in a town are assumed to be uniformly distributed between $15,000 and $85,000. What is the probability that a randomly selected family will have an income above $40,000? A poll reported that 48 % of probable voters seem determined to vote against the president. Assume that this sample was based on a random selection of 789 probable voters. Construct a 99 % confidence... From India to New Zealand, from Indonesia to Japan, the airline industry in the Asia Pacific region is vast. It carries 30% of the worlds passenger traffic and 40% of the cargo traffic and is growing... Suppose the ages of members of a senior citizens bridge club are 63, 71, 82, 60, 84, 75, 77, 65, and 70. (a) Compute the population mean and standard deviation for the age of the bridge club members.... Suppose a random variable is distributed as Students t distribution with (n - 1) degrees of freedom. Consider the probability P(t .7). Explain the relationship between the probability and the... At the end of the current year, the accountant correctly made the adjusting entry to record fees earned but not yet billed to clients (accrued revenue). How will the accounting equation be affected? Willingness to pay as a measure of a person's value for a particular good measures the maximum a person would be willing to pay requires that payment actually be made depends on the satisfaction that... Francisco Company purchased the assets of Nick Nack Company at an auction for $750,000. An independent appraisal of the fair value of the assets provided: Land at an appraisal value of $350,000,... Some early spacecrafts used tape recorders to store data. These recorders have spools of magnetic tape that are rotated in spindles to move the tape past heads that record or read data. Explain why a... A constant force of magnitude 25 N acts on an object for 3.0 s. What is the magnitude of the impulse? The Earths magnetic field has a magnitude of approximately 5.0x10 -5 T, and in New York City this field is directed toward the north geographic pole. If a proton is traveling in an easterly direction... Complete the following sentences: A critical part of designing the deciding how to distribute the system's data. and to different Databases are a resource typically. by many- future. In designing for... Meet local small business owners or representatives of as profit organizations. Find a company or organization that will host your team to produce a web site for them (nonmonetary, of course). Find... More often than not, database environments in in organization reflect data structures that have been developed over a period of years, sometimes haphazardly, and that often reflect a variety of... Previous Question Next Question Financial Accounting A Users Perspective 3rd Canadian Edition - ISBN: 0470832274 - Free Book Study smarter with the SolutionInn App Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Company Info Security Copyrights Privacy Policy Terms & Condition SolutionInn Fee Scholarship Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Copyright © 2024 SolutionInn All Rights Reserved. Get the SolutionInn - Study Help App