MA508 Business Statistics - Case Study Assignment Help

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)      

  1. 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)
  1. 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)         
  1. 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)
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
East 71 3692 52 76.0571429
North 47 2471 52.5744681 62.0758557
south 59 3111 52.7288136 106.54588
West 123 6453 52.4634146 86.2506997
ANOVA
Source of Variation SS df MS F P-value F crit
Between Groups 19.5009222 3 6.50030739 0.07732945 0.972216 2.635106
Within Groups 24881.7357 296 84.0599181
Total 24901.2367 299        

 

  1. 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)
t-Test: Two-Sample Assuming Unequal Variances
  Variable 1 Variable 2
Mean 53.86842105 51.53763441
Variance 91.08872846 76.88776518
Observations 114 186
Hypothesized Mean Difference 0
df 224
t Stat 2.116799544
P(T<=t) one-tail 0.017690046
t Critical one-tail 1.65168456
P(T<=t) two-tail 0.035380093
t Critical two-tail 1.970610961  

 

  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)
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.76
R Square 0.57
Adjusted R Square 0.57
Standard Error 5.99
Observations 300.00
ANOVA
  df SS MS F Significance F
Regression 1.00 14198.88 14198.88 395.36 0.00
Residual 298.00 10702.36 35.91
Total 299.00 24901.24      
  Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 24.07 1.47 16.40 0.00 21.18 26.96 21.18 26.96
X Variable 1 0.68 0.03 19.88 0.00 0.61 0.74 0.61 0.74

 

  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)

Expert's Answer

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

Professional

Online Tutoring Services

17,148

Orders Delivered

4.9/5

5 Star Rating

748

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

Ask a New Question
*
*
  • United States+1
  • Afghanistan+93
  • Albania+355
  • Algeria+213
  • American Samoa+1684
  • Andorra+376
  • Angola+244
  • Anguilla+1264
  • Antigua and Barbuda+1268
  • Argentina+54
  • Armenia+374
  • Aruba+297
  • Australia+61
  • Austria+43
  • Azerbaijan+994
  • Bahamas+1242
  • Bahrain+973
  • Bangladesh+880
  • Barbados+1246
  • Belarus+375
  • Belgium+32
  • Belize+501
  • Benin+229
  • Bermuda+1441
  • Bhutan+975
  • Bolivia+591
  • Bosnia and Herzegovina+387
  • Botswana+267
  • Brazil+55
  • British Indian Ocean Territory+246
  • British Virgin Islands+1284
  • Brunei+673
  • Bulgaria+359
  • Burkina Faso+226
  • Burundi+257
  • Cambodia+855
  • Cameroon+237
  • Canada+1
  • Cape Verde+238
  • Caribbean Netherlands+599
  • Cayman Islands+1345
  • Central African Republic+236
  • Chad+235
  • Chile+56
  • China+86
  • Christmas Island+61
  • Cocos (Keeling) Islands+61
  • Colombia+57
  • Comoros+269
  • Congo (DRC) (Jamhuri ya Kidemokrasia ya Kongo)+243
  • Congo (Republic) (Congo-Brazzaville)+242
  • Cook Islands+682
  • Costa Rica+506
  • Cote d'Ivoire+225
  • Croatia+385
  • Cuba+53
  • Curacao+599
  • Cyprus+357
  • Czech Republic+420
  • Denmark+45
  • Djibouti+253
  • Dominica+1767
  • Dominican Republic+1
  • Ecuador+593
  • Egypt+20
  • El Salvador+503
  • Equatorial Guinea+240
  • Eritrea+291
  • Estonia+372
  • Ethiopia+251
  • Falkland Islands+500
  • Faroe Islands+298
  • Fiji+679
  • Finland+358
  • France+33
  • French Guiana+594
  • French Polynesia+689
  • Gabon+241
  • Gambia+220
  • Georgia+995
  • Germany+49
  • Ghana+233
  • Gibraltar+350
  • Greece+30
  • Greenland+299
  • Grenada+1473
  • Guadeloupe+590
  • Guam+1671
  • Guatemala+502
  • Guernsey+44
  • Guinea+224
  • Guinea-Bissau+245
  • Guyana+592
  • Haiti+509
  • Honduras+504
  • Hong Kong+852
  • Hungary+36
  • Iceland+354
  • India+91
  • Indonesia+62
  • Iran+98
  • Iraq+964
  • Ireland+353
  • Isle of Man+44
  • Israel+972
  • Italy+39
  • Jamaica+1876
  • Japan+81
  • Jersey+44
  • Jordan+962
  • Kazakhstan+7
  • Kenya+254
  • Kiribati+686
  • Kosovo+383
  • Kuwait+965
  • Kyrgyzstan+996
  • Laos+856
  • Latvia+371
  • Lebanon+961
  • Lesotho+266
  • Liberia+231
  • Libya+218
  • Liechtenstein+423
  • Lithuania+370
  • Luxembourg+352
  • Macau+853
  • Macedonia+389
  • Madagascar+261
  • Malawi+265
  • Malaysia+60
  • Maldives+960
  • Mali+223
  • Malta+356
  • Marshall Islands+692
  • Martinique+596
  • Mauritania+222
  • Mauritius+230
  • Mayotte+262
  • Mexico+52
  • Micronesia+691
  • Moldova+373
  • Monaco+377
  • Mongolia+976
  • Montenegro+382
  • Montserrat+1664
  • Morocco+212
  • Mozambique+258
  • Myanmar (Burma)+95
  • Namibia+264
  • Nauru+674
  • Nepal+977
  • Netherlands (Nederland)+31
  • New Caledonia+687
  • New Zealand+64
  • Nicaragua+505
  • Niger+227
  • Nigeria+234
  • Niue+683
  • Norfolk Island+672
  • North Korea+850
  • Northern Mariana Islands+1670
  • Norway (Norge)+47
  • Oman+968
  • Pakistan+92
  • Palau+680
  • Palestine+970
  • Panama+507
  • Papua New Guinea+675
  • Paraguay+595
  • Peru+51
  • Philippines+63
  • Poland+48
  • Portugal+351
  • Puerto Rico+1
  • Qatar+974
  • Reunion+262
  • Romania+40
  • Russia+7
  • Rwanda+250
  • Saint Barthelemy+590
  • Saint Helena+290
  • Saint Kitts and Nevis+1869
  • Saint Lucia+1758
  • Saint Martin+590
  • Saint Pierre and Miquelon+508
  • Saint Vincent and the Grenadines+1784
  • Samoa+685
  • San Marino+378
  • Sao Tome and Principe+239
  • Saudi Arabia+966
  • Senegal+221
  • Serbia+381
  • Seychelles+248
  • Sierra Leone+232
  • Singapore+65
  • Sint Maarten+1721
  • Slovakia+421
  • Slovenia+386
  • Solomon Islands+677
  • Somalia+252
  • South Africa+27
  • South Korea+82
  • South Sudan+211
  • Spain+34
  • Sri Lanka+94
  • Sudan+249
  • Suriname+597
  • Svalbard and Jan Mayen+47
  • Swaziland+268
  • Sweden (Sverige)+46
  • Switzerland+41
  • Syria+963
  • Taiwan+886
  • Tajikistan+992
  • Tanzania+255
  • Thailand+66
  • Timor-Leste+670
  • Togo+228
  • Tokelau+690
  • Tonga+676
  • Trinidad and Tobago+1868
  • Tunisia+216
  • Turkey+90
  • Turkmenistan+993
  • Turks and Caicos Islands+1649
  • Tuvalu+688
  • U.S. Virgin Islands+1340
  • Uganda+256
  • Ukraine+380
  • United Arab Emirates+971
  • United Kingdom+44
  • United States+1
  • Uruguay+598
  • Uzbekistan+998
  • Vanuatu+678
  • Vatican City+39
  • Venezuela+58
  • Vietnam+84
  • Wallis and Futuna+681
  • Western Sahara+212
  • Yemen+967
  • Zambia+260
  • Zimbabwe+263
  • Aland Islands+358
*
*
*

TOP

Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X

Your solution is just a click away! Get it Now

PrevNext
MoTuWeThFrSaSu
31123456
78910111213
14151617181920
21222324252627
2829301234