Project Title: Employee retention at D&Y consulting firm

Section E:

Group 2:Anshul Garg (11FN-015)-Finance Gokul Sudhakaran(11DM-039)-Marketing Kaviya .A. (11DM-057)- Marketing Nikhil Gagrani(11DM-089)- Marketing Sheth Dharmil Nirupam(11DM-147)-Marketing Taru(11IB-061)-International Business

Submission Date:- 9th September,2011

TABLE OF CONTENTS

1. Case

2. Objective of the problem

3. Methodology used

4. Analysis

5. Excel output

6. Conclusion

7. Managerial implications

CASE: EMPLOYEE RETENTION AT D&Y CONSULTING FIRM

Demand for systems analysts in the consulting industry is very strong.

*…show more content…*

Software used: Excel

(1)Thus for calculating the confidence interval for t-distribution we have used the following equation: ẋ ± [t * (s/√n)]

In the equation: ẋ- the sample mean t- confidence coefficient s-sample standard deviation n-sample size

(2) For calculating the confidence interval for difference between means of two different samples:- calculating common standard deviation- sp = √((n1 – 1)s12 + (n2 – 1)s22)/(n1 + n2 – 2)) calculating standard error:- sp√(1/n1) + (1/n2) confidence interval:- (ẋ1 - ẋ2) ± (t * SE(ẋ1 - ẋ2))

(3) For calculating the confidence interval for proportion of population:-

Formula used-ṕ ± z * √[(ṕ(1 - ṕ))/n]

In the above equation ṕ-sample proportion z-confidence coefficient

ANALYSIS

1. Although starting salaries are in a rather fine band, D&Y questions whether starting compensation correlates to retention. As asked in the question, a 95% confidence interval for the mean starting salary of all employees who stayed with D&Y at least three years is calculated using excel. As we don’t know the population variance,we assume the mean