Employee Tenure by Departments
BA/EC 311 – QUANTITATIVE ANALYSIS
BIRMINGHAM-SOUTHERN COLLEGE
Employee Tenure by Departments
The president of your company is interested in developing a program to provide incentives to company employees to remain with the firm throughout their career.
The company has 72 employees who work in five divisions
(Accounting; Engineering; Production; Marketing; Support). All employees are
college graduates who attended either public or private colleges/universities.
You also have data that indicates each employee’s gender, the number of years
with the company (tenure) and the number of years since completing their
college degree (years out).
As a starting point for developing the incentive program,
the president has asked you to perform a regression analysis that can be used
to predict the number of years an employee has been with the company based on their
gender, division, type of college/university and number of years since
completing their degree. The data (contained in the Excel file below) have
been recoded as follows:
Type of College: Private=1; Public=0
Gender: Male=1; Female=0
Assume that you have hypothesized direction about the effect that each division will have on tenure. Also, this is an exploratory study so you should relax the requirement for statistical significance of p<.05. You are now willing to accept p<.10.
What is the predicted tenure with the firm for an employee from each division who attended a public college/university 15 years ago?
What
about a private college/university 12 years ago?
Save your work in a word doc and post on Moodle.