BUSINESS STATISTICS ASSIGNMENT
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…
METHODOLOGY USED
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