This is data from Company X that has 2 departments. The questionnaire measured 1) Overall job satisfaction (labelled Satisfaction); 2) Performance at the job (labelled Performance); and 3) Satisfaction with motivation system (labelled Motivation system). Each of the categories were measured with 3 questions using a Likert scale from 1 (not at all) to 5 (very much). The questionnaire also recorded the gender or the respondent and department the respondent worked at. Answers for each of the question are labelled A1...A9 for each individual respondent. Calculate the following: 1. Average satisfaction score for each respondent 2. Average performance score for each respondent 3. Average motivation system score for each respondent 4. Average and standard deviation of satisfaction scores of all respondents 5. Average and standard deviation of performance scores of all respondents 6. Average and standard deviation of motivation system scores of all respondents 7. Average satisfaction score for males and females 8. Conduct a suitable statistical test to find out whether satisfaction of males and females is statistically equal to each other 9. Tabulate answers for question A1 to find out: 9.a. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 1 9.b. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 2 9.c. The count of each response (i.e. 1, 2, 3, 4 or 5) for males working in department 1 9.d. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 2 10. Find a correlation between satisfaction scores (i.. average of A1, A2, A3) of all individual respondents with the scores of performance (i.e. average of A4, A5, A6) of all individual respondents. 10.a. Do the same as in 10 for a subsample of males. 10.b. Do the same as in 10 for a subsample of females. 11. Based on the previously calculated correlation results: is job performance affected by job satisfaction? How? 12. Construct at least 3 charts to visualize/describe the data about Motivation system. Satisfaction Performance A5 Respondent Gender 1 Female 2 Female 3 Female 4 Male 5 Female 6 Male Department number 1 2 1 2 2 2 A1 5 2 2 2 4 5 2 A2 5 4 3 3 4 5 A3 3 3 2 2 5 1 A4 4 2 1 4 4 2 2 2 4 2 3 4 5 3 5 5 4 3 2 Motivation system A7 A8 A9 4 5 2 1 3 4 3 1 2 1 1 1 2 1 5 1 2 2 5 8899 8 GO ANNNNNNNNN NNNNNNNN wwNNUAN AN-NN-wch un och Now wo Now Non NA NN A woh na NSA ANN AN Cach w NO SA UUNNUNNON GAUAN CANAAAAAAACN Athu ch ANANWAN UW WW-00-AANN+WAN WANN+NANWNWAN+W+unch - ANU NNUN Wow ON-WANNWANANNAAANNN WWWWWUWWANWNWA NA NAJN CNNEJ NNW N N N N N N N w Wow - - - - EEE - - h h +++ UUU UTC ON AN N N N N Oh ON ANNUNG NWW-NNWANN WWW NWU AAN WUWUNWNAN W 07-AN 01 UhA-ANN 4 3 3 5 3 3 1 4 4 3 3 2 3 1 4 5 1 5 1 2 2 4 2 1 2 60 Female 61 Female 62 Female 63 Female 64 Female 65 Female 66 Male Mare 67 Female 68 Female 69 Female 03 Femal 70 Male 71 Female Tema 72 Male 7. 73 Female 2 74 Male 75 Male MA 76 Male 27 77 Female 78 Female 1 79 Male 80 Male 81 Female 82 Female 83 Female 84 Female 85 Male Male 86 Male Male 87 Female or renal 88 Female 89 Female 90 Female 91 Female rental 92 Male 93 Male 94 Male are 95 Female 96 Male 97 Male 98 Male 99 Male 100 Male 1 1 1 2 2 1 2 1 1 1 2 1 2 - 1 1 2 2 2 2 2 1 2 2 2 1 1 1 1 2 1 2 1 1 1 2 - 2 2 1 2 2 1 5 5 1 1 2 4 4 2 5 5 3 2 5 3 3 4 1 2 4 3 3 2 - 1 2 3 3 4 + 5 1 5 3 4 2 2 5 3 1 2 1 1 5 4 2 2 4 2 1 3 3 1 4 3 4 1 3 5 3 3 3 1 3 1 3 2 5 4 2 1 4 4 2 1 2 4 5 3 2 4 4 4 2 3 3 2 3 2 2 1 2 1 5 1 4 3 3 5 5 2 1 5 3 4 5 2 3 3 2 2 4 3 3 3 4 2 1 3 2 1 4 3 2 5 1 1 5 1 5 5 5 2 2 5 2 2 2 3 3 3 2 5 5 4 2 4 3 2 1 4 3 2 2 3 2 4 4 5 5 1 4 5 5 1 3 1 2 2 1 3 5 5 1 1 1 1 4 5 5 5 1 1 2 5 4 5 5 3 5 3 2 4 5 3 2 2 1 4 1 5 5 1 2 3 4 5 5 1 3 5 5 1 3 5 1 2 5 1 5 1 3 5 2 1 1 5 3 5 4 2 2 4 3 1 1 2 3 3 3 5 1 1 2 1 5 1 2 1 1 1 1 5 5 2 5 2 5 4 2 4 2 3 2 1 4 3 1 4 3 4 4 2 3 3 1 5 5 5 3 4 3 3 5 1 4 3 4 1 1 2 4 4 2 3 5 1 5 5 3 4 5 2 1 2 4 5 5 4 5 5 2 5 4 2 5 5 2 2 2 1 5 3 3 4 1 5 1 1 3 4 1 2 3 2 3 1 * 4 5 1 1 3 2 2 5 5 5 3 2 3 4 3 2 1 5 1 4 4 5 This is data from Company X that has 2 departments. The questionnaire measured 1) Overall job satisfaction (labelled Satisfaction); 2) Performance at the job (labelled Performance); and 3) Satisfaction with motivation system (labelled Motivation system). Each of the categories were measured with 3 questions using a Likert scale from 1 (not at all) to 5 (very much). The questionnaire also recorded the gender or the respondent and department the respondent worked at. Answers for each of the question are labelled A1...A9 for each individual respondent. Calculate the following: 1. Average satisfaction score for each respondent 2. Average performance score for each respondent 3. Average motivation system score for each respondent 4. Average and standard deviation of satisfaction scores of all respondents 5. Average and standard deviation of performance scores of all respondents 6. Average and standard deviation of motivation system scores of all respondents 7. Average satisfaction score for males and females 8. Conduct a suitable statistical test to find out whether satisfaction of males and females is statistically equal to each other 9. Tabulate answers for question A1 to find out: 9.a. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 1 9.b. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 2 9.c. The count of each response (i.e. 1, 2, 3, 4 or 5) for males working in department 1 9.d. The count of each response (i.e. 1, 2, 3, 4 or 5) for females working in department 2 10. Find a correlation between satisfaction scores (i.. average of A1, A2, A3) of all individual respondents with the scores of performance (i.e. average of A4, A5, A6) of all individual respondents. 10.a. Do the same as in 10 for a subsample of males. 10.b. Do the same as in 10 for a subsample of females. 11. Based on the previously calculated correlation results: is job performance affected by job satisfaction? How? 12. Construct at least 3 charts to visualize/describe the data about Motivation system. Satisfaction Performance A5 Respondent Gender 1 Female 2 Female 3 Female 4 Male 5 Female 6 Male Department number 1 2 1 2 2 2 A1 5 2 2 2 4 5 2 A2 5 4 3 3 4 5 A3 3 3 2 2 5 1 A4 4 2 1 4 4 2 2 2 4 2 3 4 5 3 5 5 4 3 2 Motivation system A7 A8 A9 4 5 2 1 3 4 3 1 2 1 1 1 2 1 5 1 2 2 5 8899 8 GO ANNNNNNNNN NNNNNNNN wwNNUAN AN-NN-wch un och Now wo Now Non NA NN A woh na NSA ANN AN Cach w NO SA UUNNUNNON GAUAN CANAAAAAAACN Athu ch ANANWAN UW WW-00-AANN+WAN WANN+NANWNWAN+W+unch - ANU NNUN Wow ON-WANNWANANNAAANNN WWWWWUWWANWNWA NA NAJN CNNEJ NNW N N N N N N N w Wow - - - - EEE - - h h +++ UUU UTC ON AN N N N N Oh ON ANNUNG NWW-NNWANN WWW NWU AAN WUWUNWNAN W 07-AN 01 UhA-ANN 4 3 3 5 3 3 1 4 4 3 3 2 3 1 4 5 1 5 1 2 2 4 2 1 2 60 Female 61 Female 62 Female 63 Female 64 Female 65 Female 66 Male Mare 67 Female 68 Female 69 Female 03 Femal 70 Male 71 Female Tema 72 Male 7. 73 Female 2 74 Male 75 Male MA 76 Male 27 77 Female 78 Female 1 79 Male 80 Male 81 Female 82 Female 83 Female 84 Female 85 Male Male 86 Male Male 87 Female or renal 88 Female 89 Female 90 Female 91 Female rental 92 Male 93 Male 94 Male are 95 Female 96 Male 97 Male 98 Male 99 Male 100 Male 1 1 1 2 2 1 2 1 1 1 2 1 2 - 1 1 2 2 2 2 2 1 2 2 2 1 1 1 1 2 1 2 1 1 1 2 - 2 2 1 2 2 1 5 5 1 1 2 4 4 2 5 5 3 2 5 3 3 4 1 2 4 3 3 2 - 1 2 3 3 4 + 5 1 5 3 4 2 2 5 3 1 2 1 1 5 4 2 2 4 2 1 3 3 1 4 3 4 1 3 5 3 3 3 1 3 1 3 2 5 4 2 1 4 4 2 1 2 4 5 3 2 4 4 4 2 3 3 2 3 2 2 1 2 1 5 1 4 3 3 5 5 2 1 5 3 4 5 2 3 3 2 2 4 3 3 3 4 2 1 3 2 1 4 3 2 5 1 1 5 1 5 5 5 2 2 5 2 2 2 3 3 3 2 5 5 4 2 4 3 2 1 4 3 2 2 3 2 4 4 5 5 1 4 5 5 1 3 1 2 2 1 3 5 5 1 1 1 1 4 5 5 5 1 1 2 5 4 5 5 3 5 3 2 4 5 3 2 2 1 4 1 5 5 1 2 3 4 5 5 1 3 5 5 1 3 5 1 2 5 1 5 1 3 5 2 1 1 5 3 5 4 2 2 4 3 1 1 2 3 3 3 5 1 1 2 1 5 1 2 1 1 1 1 5 5 2 5 2 5 4 2 4 2 3 2 1 4 3 1 4 3 4 4 2 3 3 1 5 5 5 3 4 3 3 5 1 4 3 4 1 1 2 4 4 2 3 5 1 5 5 3 4 5 2 1 2 4 5 5 4 5 5 2 5 4 2 5 5 2 2 2 1 5 3 3 4 1 5 1 1 3 4 1 2 3 2 3 1 * 4 5 1 1 3 2 2 5 5 5 3 2 3 4 3 2 1 5 1 4 4 5