Discrimination in Qfc Layoffs and Rehiring

[pic 1]

FINAL CASE STUDY

[pic 2][pic 3]

To: Ron Lemon
From: Nida Li, Vanessa Lim, YanYi So
Date: November 28, 2016 
Subject: Discrimination in QFC Layoffs and Rehiring

 
The purpose of this memorandum is to explain the relationship between each variable (week, age, tenure, education, marriage, head, and position) and whether or not they are factors that causes the discrimination in QFC layoffs and rehiring.

First, we will start with a brief data description of each variable. We took a sample size of 50 employees and asked about their age, weeks an employee was laid off, tenure in years, years of education, whether they are married and if they were the head of household or not. We also asked the employees’ position.

The mean age among the 50 employees is 34.6, which is the average age of these 50 employees. The median age is 33, which means that 33 is at the 50th percentile among all. The highest (maximum) age is 62 and the lowest age is 20 (minimum). The age standard deviation is 9.06, which means that the age range is between a plus or minus of 9.06 years old. The same explanation style also applies to other variables. The mean laid off week among the 50 employees is 44.5 weeks. The median is 46 weeks. The maximum and minimum weeks are 98 weeks and 6 weeks. The week standard deviation is 25.85 weeks. The mean tenure in years among the 50 employees is 8.36 years. The median year is 8 years. The maximum and minimum years are 30 years and 1 year. The year standard deviation is 5.84 years. The mean education level in years among the 50 employees is 10.36 years. The median year is 9 years. The maximum and minimum years are 19 years and 6 years. The year standard deviation is 3.25 years. Out of 50 employees, 35 of them are married, 34 of them are the head of the household, 36 of them have the position Floor, 9 of them have the position Department Head, and only 5 of them have the position Manager.

Looking at the relationship between each variable, we can see a difference of how many weeks they can are laid off.  As age increases by one year, the number of weeks laid off increases by about 2 weeks. Between tenure and weeks, as the tenure increases by one year, the number of weeks laid off increases by about half a week. As education increases by one year, the number of weeks laid off decreases by about 5 weeks. If you are married, the number of weeks laid off is about 1 week more than if you are not married.  If you are a head of the family, the number of weeks laid off is about 9 weeks less than if you are not a head of the family. If you are have a position on the floor of QFC, the number of weeks laid off is about 7 weeks more than if you were head of the department. If you have a position as a manager of QFC, the number of weeks laid off is about 12 weeks less than if you were head of the department.