DATASET EXERCISE FROM EXCEL
marjo241
GroupCohesivenessin-classexercise.xlsxSurvey
| 123456 Corp. | |||||||||
| Group Cohesiveness. Determinants and Consequences Survey | |||||||||
| Population = 137 employees | |||||||||
| Objective: | |||||||||
| To measure the level of group cohesiveness perceived by the employees | |||||||||
| To identify the relevant causes of the group cohesiveness | |||||||||
| To analyze the impact of group cohesiveness on its consequences | |||||||||
| Group Size: __________ | |||||||||
| 1. The group I belong to is diverse in knowledge, experience, expertise, and it is managed effectively by my boss. | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 2. My boss promoltes team members performance by showing individual performance measures, and public recognition | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 3. My boss makes me feel that I am a valued member of the organization | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 4. My boos makes me see that I can achieve noticeable and visible successes as employees | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 5. My participation within the group concerning discussion, setting goals, decision making is high | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 6. I perceive a high level of conformity to norms within the group I belong to | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 7. The group I belong to make a strong emphasis on group goal accomplishment | |||||||||
| Totally disagree | Totally agree | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 8. Indique how satisfied you are with the cohesiveness shown in the group you belong to. | |||||||||
| Low | High | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Dataset
| GroupSize | EffMgDiv | IdenHealComp | Success | ParWithGroup | ConfGroupNorms | EmpGGoalAcc | Cohess |
| 5 | 8 | 6 | 7 | 7 | 8 | 5 | 7 |
| 3 | 7 | 6 | 7 | 7 | 6 | 6 | 7 |
| 6 | 8 | 6 | 7 | 7 | 8 | 5 | 7 |
| 9 | 7 | 6 | 7 | 8 | 7 | 7 | 7 |
| 8 | 8 | 6 | 7 | 7 | 8 | 5 | 7 |
| 5 | 7 | 6 | 7 | 8 | 7 | 6 | 7 |
| 5 | 7 | 6 | 8 | 7 | 8 | 5 | 7 |
| 5 | 7 | 7 | 7 | 8 | 9 | 7 | 7 |
| 5 | 7 | 6 | 8 | 7 | 8 | 4 | 8 |
| 5 | 7 | 7 | 7 | 8 | 7 | 5 | 8 |
| 4 | 7 | 6 | 8 | 7 | 8 | 6 | 9 |
| 4 | 6 | 7 | 7 | 8 | 9 | 7 | 9 |
| 4 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 4 | 6 | 7 | 7 | 7 | 7 | 8 | 8 |
| 4 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 3 | 7 | 7 | 7 | 7 | 9 | 6 | 8 |
| 3 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 6 | 6 | 7 | 7 | 7 | 7 | 7 | 8 |
| 6 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 5 | 7 | 7 | 7 | 7 | 9 | 6 | 8 |
| 9 | 8 | 7 | 8 | 7 | 6 | 5 | 9 |
| 5 | 7 | 7 | 7 | 8 | 9 | 4 | 8 |
| 8 | 8 | 7 | 8 | 7 | 8 | 5 | 9 |
| 4 | 7 | 6 | 7 | 8 | 9 | 6 | 8 |
| 4 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 3 | 6 | 6 | 7 | 8 | 9 | 4 | 8 |
| 5 | 8 | 7 | 7 | 7 | 5 | 5 | 9 |
| 4 | 7 | 6 | 7 | 8 | 8 | 6 | 8 |
| 5 | 8 | 7 | 7 | 7 | 7 | 5 | 9 |
| 5 | 6 | 8 | 7 | 8 | 8 | 5 | 8 |
| 4 | 8 | 6 | 7 | 7 | 9 | 5 | 7 |
| 4 | 7 | 8 | 7 | 8 | 5 | 5 | 8 |
| 6 | 8 | 7 | 8 | 7 | 8 | 4 | 9 |
| 6 | 6 | 8 | 8 | 8 | 7 | 4 | 8 |
| 2 | 8 | 6 | 8 | 7 | 5 | 4 | 8 |
| 5 | 7 | 8 | 8 | 8 | 8 | 4 | 8 |
| 3 | 8 | 7 | 8 | 7 | 7 | 6 | 9 |
| 4 | 7 | 8 | 8 | 7 | 4 | 6 | 8 |
| 4 | 8 | 7 | 8 | 7 | 5 | 6 | 7 |
| 4 | 7 | 8 | 7 | 7 | 6 | 6 | 8 |
| 3 | 8 | 7 | 8 | 7 | 9 | 7 | 7 |
| 3 | 7 | 8 | 7 | 7 | 6 | 7 | 8 |
| 3 | 8 | 6 | 8 | 7 | 6 | 7 | 7 |
| 6 | 6 | 6 | 7 | 7 | 9 | 7 | 8 |
| 6 | 8 | 6 | 8 | 7 | 8 | 8 | 7 |
| 5 | 7 | 6 | 7 | 7 | 9 | 8 | 8 |
| 6 | 8 | 6 | 8 | 7 | 8 | 8 | 9 |
| 5 | 7 | 7 | 7 | 7 | 9 | 5 | 9 |
| 6 | 8 | 6 | 8 | 7 | 8 | 4 | 9 |
| 8 | 6 | 7 | 7 | 7 | 5 | 5 | 9 |
| 8 | 8 | 6 | 8 | 7 | 8 | 8 | 9 |
| 8 | 7 | 7 | 8 | 7 | 7 | 4 | 8 |
| 2 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 4 | 6 | 7 | 8 | 8 | 9 | 8 | 8 |
| 7 | 8 | 6 | 8 | 7 | 8 | 7 | 9 |
| 8 | 7 | 8 | 8 | 8 | 7 | 8 | 8 |
| 8 | 8 | 8 | 8 | 7 | 8 | 7 | 7 |
| 5 | 7 | 8 | 8 | 8 | 9 | 8 | 8 |
| 5 | 8 | 6 | 8 | 8 | 8 | 7 | 7 |
| 4 | 6 | 8 | 8 | 8 | 7 | 8 | 8 |
| 4 | 8 | 6 | 8 | 8 | 5 | 7 | 7 |
| 6 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 6 | 8 | 7 | 8 | 8 | 7 | 7 | 7 |
| 2 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 2 | 8 | 7 | 7 | 8 | 9 | 7 | 7 |
| 3 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 7 | 7 |
| 5 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 4 | 7 | 8 | 8 | 7 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 8 | 8 | 7 | 8 | 6 | 8 |
| 6 | 7 | 7 | 7 | 8 | 7 | 9 | 7 |
| 8 | 7 | 8 | 8 | 7 | 8 | 8 | 7 |
| 4 | 7 | 8 | 7 | 8 | 9 | 5 | 7 |
| 8 | 7 | 6 | 7 | 7 | 5 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 6 | 7 | 7 |
| 9 | 7 | 6 | 7 | 7 | 9 | 4 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 6 | 7 | 7 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 9 | 7 |
| 7 | 8 | 6 | 7 | 9 | 7 | 5 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 8 | 7 |
| 3 | 8 | 7 | 7 | 7 | 7 | 4 | 7 |
| 5 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 8 | 8 | 7 | 7 | 9 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 7 | 7 |
| 4 | 8 | 7 | 8 | 7 | 7 | 8 | 7 |
| 5 | 7 | 7 | 8 | 8 | 8 | 9 | 7 |
| 8 | 8 | 7 | 8 | 7 | 9 | 8 | 8 |
| 9 | 6 | 7 | 7 | 8 | 5 | 9 | 7 |
| 6 | 8 | 7 | 8 | 8 | 6 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 8 | 8 | 7 | 8 | 8 | 7 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 4 | 8 | 7 | 8 | 8 | 4 | 8 | 8 |
| 5 | 6 | 6 | 7 | 8 | 5 | 5 | 7 |
| 6 | 6 | 6 | 8 | 8 | 8 | 6 | 8 |
| 3 | 8 | 6 | 7 | 8 | 7 | 5 | 7 |
| 8 | 7 | 7 | 8 | 8 | 8 | 8 | 7 |
| 5 | 8 | 6 | 7 | 7 | 8 | 4 | 7 |
| 4 | 7 | 7 | 8 | 7 | 8 | 5 | 7 |
| 7 | 8 | 6 | 7 | 8 | 5 | 8 | 7 |
| 5 | 7 | 7 | 8 | 7 | 5 | 7 | 7 |
| 6 | 8 | 6 | 7 | 8 | 5 | 8 | 7 |
| 5 | 7 | 7 | 7 | 7 | 8 | 5 | 8 |
| 9 | 8 | 6 | 7 | 8 | 8 | 8 | 8 |
| 5 | 7 | 7 | 7 | 7 | 8 | 7 | 8 |
| 8 | 8 | 7 | 7 | 8 | 7 | 8 | 8 |
| 6 | 7 | 7 | 7 | 7 | 7 | 5 | 8 |
| 5 | 8 | 7 | 7 | 8 | 7 | 8 | 8 |
| 4 | 7 | 7 | 7 | 7 | 7 | 7 | 8 |
| 2 | 8 | 7 | 7 | 8 | 7 | 8 | 8 |
| 5 | 8 | 7 | 7 | 7 | 9 | 5 | 8 |
| 4 | 8 | 7 | 7 | 8 | 9 | 7 | 7 |
| 7 | 8 | 7 | 8 | 8 | 9 | 9 | 8 |
| 8 | 8 | 7 | 7 | 8 | 9 | 5 | 7 |
| 5 | 8 | 7 | 8 | 8 | 9 | 7 | 8 |
| 2 | 8 | 6 | 7 | 8 | 9 | 8 | 7 |
| 3 | 8 | 6 | 8 | 8 | 1 | 5 | 8 |
| 3 | 8 | 6 | 7 | 8 | 10 | 4 | 7 |
| 3 | 7 | 6 | 7 | 8 | 8 | 8 | 7 |
| 3 | 8 | 6 | 8 | 8 | 8 | 5 | 7 |
| 3 | 7 | 6 | 7 | 7 | 8 | 8 | 7 |
| 5 | 8 | 6 | 8 | 8 | 5 | 4 | 7 |
| 5 | 7 | 8 | 7 | 7 | 8 | 8 | 7 |
| 6 | 8 | 6 | 8 | 8 | 9 | 5 | 8 |
| 4 | 7 | 8 | 7 | 7 | 8 | 8 | 8 |
| 5 | 8 | 8 | 8 | 8 | 9 | 8 | 8 |
| 4 | 6 | 8 | 7 | 7 | 8 | 8 | 8 |
| 5 | 8 | 6 | 7 | 8 | 7 | 8 | 8 |
| 6 | 6 | 6 | 7 | 7 | 8 | 8 | 8 |
| 9 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 8 | 7 | 6 | 7 | 7 | 8 | 5 | 8 |
| 5 | 8 | 6 | 7 | 8 | 7 | 5 | 8 |
| 7 | 7 | 6 | 7 | 8 | 8 | 6 | 8 |
| 4 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 5 | 7 | 6 | 8 | 8 | 7 | 6 | 8 |
| 8 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 5 | 6 | 8 | 7 | 8 | 8 | 6 | 8 |
| 9 | 8 | 8 | 7 | 8 | 9 | 5 | 7 |
| 6 | 7 | 8 | 7 | 8 | 8 | 6 | 8 |
| 8 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 7 | 8 | 7 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 7 | 8 | 7 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 6 | 7 | 7 |
| 5 | 8 | 8 | 7 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 8 | 7 | 9 | 5 | 7 |
| 4 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 3 | 8 | 6 | 8 | 8 | 8 | 5 | 7 |
| 3 | 7 | 6 | 7 | 7 | 8 | 8 | 7 |
| 5 | 8 | 6 | 8 | 8 | 5 | 4 | 7 |
| 5 | 7 | 8 | 7 | 7 | 8 | 8 | 7 |
| 6 | 8 | 6 | 8 | 8 | 9 | 5 | 8 |
| 4 | 7 | 8 | 7 | 7 | 8 | 8 | 8 |
| 5 | 8 | 8 | 8 | 8 | 9 | 8 | 8 |
| 4 | 6 | 8 | 7 | 7 | 8 | 8 | 8 |
| 5 | 8 | 6 | 7 | 8 | 7 | 8 | 8 |
| 6 | 6 | 6 | 7 | 7 | 8 | 8 | 8 |
| 9 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 8 | 7 | 6 | 7 | 7 | 8 | 5 | 8 |
| 5 | 8 | 6 | 7 | 8 | 7 | 5 | 8 |
| 7 | 7 | 6 | 7 | 8 | 8 | 6 | 8 |
| 4 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 5 | 7 | 6 | 8 | 8 | 7 | 6 | 8 |
| 8 | 8 | 6 | 7 | 8 | 9 | 5 | 8 |
| 5 | 6 | 8 | 7 | 8 | 8 | 6 | 8 |
| 9 | 8 | 8 | 7 | 8 | 9 | 5 | 7 |
| 6 | 7 | 8 | 7 | 8 | 8 | 6 | 8 |
| 8 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 7 | 8 | 7 | 8 | 8 | 8 | 8 |
| 8 | 7 | 7 | 8 | 7 | 7 | 4 | 8 |
| 2 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 4 | 6 | 7 | 8 | 8 | 9 | 8 | 8 |
| 7 | 8 | 6 | 8 | 7 | 8 | 7 | 9 |
| 8 | 7 | 8 | 8 | 8 | 7 | 8 | 8 |
| 8 | 8 | 8 | 8 | 7 | 8 | 7 | 7 |
| 5 | 7 | 8 | 8 | 8 | 9 | 8 | 8 |
| 5 | 8 | 6 | 8 | 8 | 8 | 7 | 7 |
| 4 | 6 | 8 | 8 | 8 | 7 | 8 | 8 |
| 4 | 8 | 6 | 8 | 8 | 5 | 7 | 7 |
| 6 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 6 | 8 | 7 | 8 | 8 | 7 | 7 | 7 |
| 2 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 2 | 8 | 7 | 7 | 8 | 9 | 7 | 7 |
| 3 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 7 | 7 |
| 5 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 4 | 7 | 8 | 8 | 7 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 8 | 8 | 7 | 8 | 6 | 8 |
| 6 | 7 | 7 | 7 | 8 | 7 | 9 | 7 |
| 8 | 7 | 8 | 8 | 7 | 8 | 8 | 7 |
| 4 | 7 | 8 | 7 | 8 | 9 | 5 | 7 |
| 8 | 7 | 6 | 7 | 7 | 5 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 6 | 7 | 7 |
| 9 | 7 | 6 | 7 | 7 | 9 | 4 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 6 | 7 | 7 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 9 | 7 |
| 7 | 8 | 6 | 7 | 9 | 7 | 5 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 8 | 7 |
| 3 | 8 | 7 | 7 | 7 | 7 | 4 | 7 |
| 5 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 8 | 8 | 7 | 7 | 9 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 7 | 7 |
| 6 | 8 | 6 | 8 | 7 | 8 | 4 | 9 |
| 8 | 6 | 7 | 7 | 7 | 5 | 5 | 9 |
| 8 | 8 | 6 | 8 | 7 | 8 | 8 | 9 |
| 8 | 7 | 7 | 8 | 7 | 7 | 4 | 8 |
| 2 | 8 | 6 | 8 | 7 | 8 | 5 | 9 |
| 4 | 6 | 7 | 8 | 8 | 9 | 8 | 8 |
| 7 | 8 | 6 | 8 | 7 | 8 | 7 | 9 |
| 8 | 7 | 8 | 8 | 8 | 7 | 8 | 8 |
| 8 | 8 | 8 | 8 | 7 | 8 | 7 | 7 |
| 5 | 7 | 8 | 8 | 8 | 9 | 8 | 8 |
| 5 | 8 | 6 | 8 | 8 | 8 | 7 | 7 |
| 4 | 6 | 8 | 8 | 8 | 7 | 8 | 8 |
| 4 | 8 | 6 | 8 | 8 | 5 | 7 | 7 |
| 6 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 6 | 8 | 7 | 8 | 8 | 7 | 7 | 7 |
| 2 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 2 | 8 | 7 | 7 | 8 | 9 | 7 | 7 |
| 3 | 7 | 8 | 8 | 8 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 7 | 7 |
| 5 | 6 | 8 | 8 | 8 | 8 | 8 | 8 |
| 5 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 4 | 7 | 8 | 8 | 7 | 8 | 8 | 8 |
| 3 | 8 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 8 | 8 | 7 | 8 | 6 | 8 |
| 6 | 7 | 7 | 7 | 8 | 7 | 9 | 7 |
| 8 | 7 | 8 | 8 | 7 | 8 | 8 | 7 |
| 4 | 7 | 8 | 7 | 8 | 9 | 5 | 7 |
| 8 | 7 | 6 | 7 | 7 | 5 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 6 | 7 | 7 |
| 9 | 7 | 6 | 7 | 7 | 9 | 4 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 5 | 8 | 6 | 7 | 7 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 9 | 7 |
| 7 | 8 | 6 | 7 | 9 | 7 | 5 | 7 |
| 6 | 7 | 7 | 7 | 8 | 8 | 8 | 7 |
| 3 | 8 | 7 | 7 | 7 | 7 | 4 | 7 |
| 5 | 7 | 7 | 7 | 8 | 8 | 5 | 7 |
| 8 | 8 | 7 | 7 | 9 | 7 | 8 | 7 |
| 4 | 7 | 7 | 7 | 8 | 8 | 7 | 7 |
| 4 | 8 | 7 | 8 | 7 | 7 | 8 | 7 |
