MA508 Business Statistics - Final Assessment

Case Study of Employee Job Satisfaction Survey

GmbH is a global corporation with over 300000 employees and offices across the whole country. The management had noticed that employee job satisfaction became an issue in the company. For this reason, the company HR department has decided to conduct a survey in order to identify factors influencing satisfaction level of the employees. They measure employees’ satisfaction in two periods of before and after training. The survey consists of the following variables:

The variables include:

1. ID
2. Gender 1= male or 2=female

• Marital status (Married, single)

1. Age
2. Years of experience
3. City that they come from (areas coded from 1 to 5)

• Region they come from (east, west, south, north)
• Departments (1=IT, 2=Marketing, 3= Sales, 4= HR, 5= Finance 6=Innovation)

1. Salary (in thousands)
2. Job satisfaction score before training (1= extremely dissatisfied; 5=extremely satisfied)
3. Job satisfaction score after training (1= extremely dissatisfied; 5=extremely satisfied)

• Life happiness score (1= extremely unhappy; 10=extremely happy)
• Promoted (yes, No)
• Organization relation and employee satisfaction survey (OR) (1 to 5)

1. Teamwork and employee satisfaction survey (TW) (1 to 5)

• Information and employee satisfaction survey (INF) (1 to 5)
• Job passion and self-evaluation employee satisfaction survey (JP) (1 to 5)
• Work/Life balance and employee satisfaction survey (WLB) (1 to 5)

The data set is available on BB108 Moodle site. Employee Survey Data 2022T1 .xlsx

Tasks:

1. Presentation of the employee job satisfaction problem             (10 marks)
2. Present the job satisfaction problem of the company through tables, graphs and numerical measure.                         (5 marks)
3. Describe how you are going to address the job satisfaction issue.

(5 marks)      

2. Do you think job satisfaction is a Region related problem?             (20 marks)
   1. Formulate statistical hypotheses to test if job satisfaction is a region related problem                                                                                                                 (5 marks)
   2. Run a statistical test on the hypotheses                                                 (12 marks)
   3. Conclude your test result                                                 (3 marks)

3. Test whether the pay is gender biased?                         (10 marks)
   1. Compare the average salary of male employees with that pf the female employees. What is your tentative hypothesis on the biasedness? (3 marks)
   2. Formulate a statistical hypothesis test to verify the tentative statement. (2 marks)
   3. What is your chosen significance level of the test? (1 mark)
   4. Show your test output                                                                                 (2 marks)
   5. Conclude your test result.                                                                                 (2 marks)         

4. Quantify the relationship between Age and Salary (20 marks)
   1. Describe how regression can be used to quantify the impact of salary on Life happiness score (4 marks)
   2. Create a scatter plot between Salary and Age in computer, calculate the correlation coefficient between Salary and Age, Interpret the graphs

(4 marks)

1. Run a regression of Salary on Age in computer.                                                (4 marks)
2. Do you think Age has a significant influence on Salary? Formulate a statistical test to confirm your answer in d.                                                                 (4 marks)
3. Complete the test formulated in part d and interpret the results. (4 marks)

1 Presentation of the employee job satisfaction problem                                                     (10 marks)

1. Present the job satisfaction problem of the company through tables, graphs and numerical measure. (5 marks)

Average of Job satisfaction score before training:

1. Describe how you are going to address the job satisfaction issue.

(5 marks)     

2 Do you think job satisfaction is a Region related problem?                                        (20 marks)

1. Formulate statistical hypotheses to test if job satisfaction is a region related problem                                                                                                                         (5 marks)
2. Run a statistical test on the hypotheses (12 marks)

3. Conclude your test result (3 marks)

• Test whether the pay is gender biased? (10 marks)
  1. Compare the average salary of male employees with that of the female employees. What is your tentative hypothesis on the biasedness? (3 marks)

1. Formulate a statistical hypothesis test to verify the tentative statement.         (2 marks)
2. What is your chosen significance level of the test?                 (1 mark)
3. Show your test output                                                                                 (2 marks)

1. Conclude your test result.                                                                                 (2 marks)         

• Quantify the relationship between Age and Salary (20 marks)
  1. Describe how regression can be used to quantify the impact of Age on Salary                                                       (4 marks)

1. Create a scatter plot between Salary and Age in computer, calculate the correlation coefficient between Salary and Age, Interpret the graphs

(4 marks)

1. Run a regression of Salary on Age in computer.                                                (4 marks)

1. Do you think Age has a significant influence on Salary? Formulate a statistical test to confirm your answer in d.                                                                 (4 marks)
2. Complete the test formulated in part d and interpret the results. 4 (marks)