Case Study of Employee Job Satisfaction Survey

GmbHis 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
3. Marital status (Married, single)
4. Age
5. Years of experience
6. City that they come from (areas coded from 1 to 5)
7. Region they come from (east, west, south, north)
8. Departments (1=IT, 2=Marketing, 3= Sales, 4= HR, 5= Finance 6=Innovation)
9. Salary (in thousands)
10. Job satisfaction score before training (1= extremely dissatisfied; 5=extremely satisfied)
11. Job satisfaction score after training (1= extremely dissatisfied; 5=extremely satisfied)
12. Life happiness score (1= extremely unhappy; 10=extremely happy)
13. Promoted (yes, No)

The data set is available on BB108 moodle site. Employee_Job_Satisfaction.xlsx

Tasks:

1. Presentation of the employee job satisfaction problem (20 marks)

You are free to choose the way to present the employee job satisfaction problem.

Hint:

• descriptive statistics tools such as frequency tables, bar chart/pie chart and numerical measures can be used to present and summarise the data.
• A two-way frequency table can be used to gauge the whether the employee job satisfaction depends on other variables.

2. Presentation of your objectives of the data analysis (total = 10 marks)
   1. Describe the main objective of your data analysis (3 marks)
   2. Describe how you want to achieve this objective (3 marks)
   3. List all statistical hypotheses you want to test in this assignment and indicate how the hypotheses are related to the research objective above. (4 marks)

Hint: you may need to complete this after you finish all other tasks

3. Do you think job satisfaction is gender-biased? (20 marks)
   1. Formulate the statistical hypotheses to test the gender-unbiasedness of job satisfaction (5 marks)
   2. Run a statistical test of the hypotheses (12 marks)
   3. Conclude your test result (3 marks)

3. Test whether the training improves the job satisfaction? (20 marks)
   1. Formulate the hypothesis of the statistical test. (3 marks)
   2. What is the null hypothesis and the alternative hypothesis, respectively? (2 marks)
   3. What is your chosen significance level of the test? (1 mark)
   4. Show you test workings (4 marks)
   5. Critically Interpret the test result and show alternative ways of assessment. (10 marks)

5. Run a regression of Life happiness score on Salary and Job Satisfaction? (20 marks)
   1. Create a scatter plot between Life happiness score and Salary, interpret the graphs (5 marks)
   2. Create a scatter plot between Life happiness score and Job satisfaction score after training, interpret the graph (5 marks)
   3. Run a multiple regression of Life happiness score on Salary andJob satisfaction score after training (5 marks)
   4. Interpret the regression output (5 marks)

Summary of your analysis with respect to the employee job satisfaction issues