Quantitative Exercise Assignment

profileamonh_1
-QuantitativeExerciseDataset.xlsx
Home>Business & Finance homework help>Management homework help>Quantitative Exercise Assignment

Variables Description

Variable Names Variable Descriptions Response Scales
Gender 1= Male | 2= Female
Job Sat Satisfaction with job 1=strongly disagree | 5=strongly agree
Pay Sat Satisfaction with pay 1=strongly disagree | 5=strongly agree
Turnover Intent Likelihood that you will leave their job (Higher number means you are more likely to leave) 1=strongly disagree | 5=strongly agree
Affective Commitment Degree to which you have affective commitment to the organization 1=strongly disagree | 5=strongly agree
Extrinsic Motivation Degree to which you have extrinsic (or external) motivation 1=strongly disagree | 5=strongly agree
Intrinsic motivation Degree to which you have intrinsic (or internal) motivation 1=strongly disagree | 5=strongly agree
Percieved Org Support Perception of support from the organization 1=strongly disagree | 5=strongly agree
Work Family Conflict Degree to which you experience conflict between work and family demands 1=strongly disagree | 5=strongly agree

Data

Gender Job Sat Pay Sat Turnover Intent Affective Commitment Extrinsic Motivation Intrinsic motivation Percieved Org Support Work Family Conflict
2 4.33 3.33 2.6 4 3.33 4.33 4.25 2.5
2 3 1.33 3 3 3.67 3 2.75 2.67
2 4.33 3 3 4 1.33 4 3.75 3.17
1 4 2.67 3.6 3 2.33 4.33 3 3
2 4 2 2 3.4 1.67 4 3.25 2
1 4 3.33 2 4 2.67 4 4 4
2 4.5 2.67 3 4 4 3 5 3.33
2 3.67 1 3.2 4 2.33 3.33 4.75 3.33
1 4 3 2.8 4 3 2.67 4.25 3.5
2 3 3 3 3 3 3.33 3.25 3
1 3.33 1 4.4 3.8 2 3.67 2 5
1 3 2.67 2.2 2.4 3 3.67 2.5 5
2 4 5 2.8 3.6 3.67 4.33 4 4.33
2 5 3.67 2.4 5 4.33 5 4 2.67
2 4 2 2.6 3.6 2.33 3.67 4 3.5
2 5 4 1 4.8 1.33 4.67 4.75 3.33
1 4.33 4 2 4 2.33 4.33 4.5 3.5
1 2.33 1 5 2.4 1.67 1 2 3.33
1 4.33 3.33 2.6 3.2 3.67 3.67 2.5 3.17
1 1 2 5 1 5 1 1.25 4
1 3 1.33 3 3.2 3 2.67 2.75 2.67
1 4.33 4 2 4.2 1.33 3.67 4.25 2.33
2 4 1 2.4 3.6 1.67 4.33 3.5 2.67
1 3.67 1 4.2 2.2 3.33 5 3.25 4.83
1 5 1.67 1 4.8 1.33 4.33 5 3.5
1 3 2 3 3 3 3 3 3.5
2 4 3.33 2 4 1.67 4.67 4 4
1 4.67 3 1.2 5 2.67 4.67 3.25 5
2 4 2 2 3.6 1.33 4.67 3.5 3.33
1 5 3 1.8 5 2 5 5 3.33
1 5 3.33 1.8 4.6 3.33 5 5 2.67
1 3 3 3.2 2.8 3.33 2.33 3.25 3
2 5 5 1 4.2 2.33 5 4.75 2.6
2 3.33 3 3.8 2.2 4 3 3.75 3
1 4 3.33 2 3.8 3.67 3.67 4 3.17
2 2.33 1.33 5 2.8 3.33 2 3.5 4.17
2 5 3.33 1 5 1 4.67 5 1
1 5 4 1 4 1.67 3.67 4.25 1.67
1 4 3 2.4 3.2 2.67 3.67 3 2.83
2 4.67 3.67 1.6 3.8 2.33 4.67 3.75 3
2 4.33 4 1.4 3.2 3 4.33 4.25 2.83
2 4 4 3 3.8 3.67 4 4 2.5
1 2.67 3.67 4.6 2.8 3 3 3.25 2.33
1 4.33 4 1.6 3.8 2 5 4 2.67
1 3.33 3.67 3.4 3.6 2.67 3.33 3.5 4.17
2 4.67 4 3 3.4 3.67 4.67 4 1.67
2 4.67 4 1.4 3.4 3.33 4.67 4 2
1 4.67 3 1.6 3.6 1.67 3.33 3.25 1.33
2 3.33 3.67 2.8 2.6 2 5 3 3.17
2 3.67 3.67 3.8 2.8 3.67 3.67 4.25 2.67
2 4.67 3.67 1.8 4.2 2.67 5 4.25 3.83
2 3.67 2 4 4.2 2.33 4 4 2.33
1 4 4.33 2.8 4 4.33 4.33 4 2.83
2 4 4 1.6 3.8 4 4.33 3.75 2.17
1 3.67 2.33 3.2 2.6 3.67 2.33 3 2.17
1 4 4 1 3.4 3.33 2.67 4 2.67
2 4.67 4 2 4 2.33 4.67 4 2.67
1 4.33 4.33 1.4 4.4 2.33 3 4 2.5
2 2.33 3.33 3.4 2.8 4.33 3 1.75 1.33
1 3.33 5 2 3.8 3.33 4.33 4 2.17
1 3 2 3.2 3 4 3.67 3.5 3
1 4 4 2 4 4 4 2.75 4
2 4 4 1.8 3.8 2.67 3.33 4 2
1 4.33 4 1.6 3.6 3.33 3.67 4 2.33
2 1.67 2 4.2 2 4 1.33 1.33 5
2 4.33 3.67 1 3.8 3.33 3.67 4 1.83
2 4.33 4 2.8 3.4 3 3.33 4.25 2.33
2 3.33 3.67 3.2 4 3.33 4 3.67 3
1 4.33 2.67 3 4 2.33 3.67 4.25 3.5
1 5 2 1.8 5 3.67 5 5 2.67
1 4.67 4 2.4 4 3.67 4 4.25 3.17
1 4 3.67 2.4 4 3 4 4 3
1 4.33 3.33 2 3.8 3.67 4 4.5 2.5
1 4 2.67 2.4 4.2 3 3.67 4.25 2.33
1 4
1 4.67 2.33 1.2 5 3.33 4.67 4.75 2.67
1 3.67 2 3.2 3.4 3 3.67 3.75 1.83
2 1 2 5 1 5 4 1 3
1 5 2.67 1.8 4.4 2.67 4.67 4 2
1 4 5 2.6 3 2.33 4 4.5 1.67
1 4 3 2 3.2 3 3.67 4.25 2.67
1 4.33 2 2.2 4 1.33 4 3.75 4
2 3.67 2.33 4 2.8 4.33 3 4 2
1 4.67 3 1.8 4.4 2.67 4 4.5 2.67
1 4 3.67 2.4 4.2 3 5 3.25 3.67
2 4 3.33 1.4 4.2 3.67 4.33 4.75 1.67
2 5 2.67 1.4 4.4 2 4.67 4.33 3.67
2 5 1.33 4.4 3.6 2.67 4.67 4.5 1.67
1 3.33 2 2.8 2.8 3 3.67 3 3.67
2 5 4 1.5 3.8 2.33 5 4.25 3.67
1 4.33 4.67 2 4.4 2.33 4 4 2.33
1 2.67 2.67 4 2.6 3 2 4 3.67
1 4.67 4.33 1 3.8 3 4.33 3.75 2.17
1 5 4 1 4.8 3 4.33 5 1
2 5 4 1 4.4 3.33 3.67 4.75 2.83
1 4 3.33 2.4 4 2.67 3 4 3.17
1 4 4 2 3.6 4 3.33 4 4
2 4 2.33 2.8 3.4 3 3 4.25 3.33
1 4 4 3.2 3.2 3 1.67 3.5 2.83
1 3.67 3.33 3 3.2 4 3.67 4.25 2.33
2 2.33 1 4 3.4 1.67 2.67 1.75 2.83
2 4.33 2.67 1.4 4 3.67 4.67 3.5 2.17
1 5 5 1.4 4 3 4 4.25 2
2 1.67 2.33 4.8 1.6 3.33 1.67 2.5 4
2 5 1 1.6 4.8 3.67 5 4.75 2.17
1 3.33 3.33 3.4 2.4 3.67 2.33 3 4
2 5 2.67 2.6 4.8 3 5 5 2.67
1 3.33 1.67 3.2 2.4 3.33 2.67 3 3.17
1 3.67 2 2.6 2.8 1.33 3.33 3 3.83
1 3.67 3.67 2 2.8 3 3 3.67 2
1 5 5 2.33 4.5 3 4.33 3.75 4
1 5 4.67 1 5 1.33 5 5 1.67
1 4.67 3 1 4.2 3.67 4.67 4.5 3.17
2 4 3 2.6 3.8 2.33 4.67 4.5 2.17
1 5 4 1 4 3 3.67 4 1
1 3.67 4 3.8 3 1 3.33 3.5 2.2
2 3 2.67 2.6 2.2 2.33 2.67 3.25 3
1 4 2.67 1 4.8 3 4.33 4 2
2 4.67 4 2.2 3 3.67 4.67 3.5 4
1 4 3 2.6 3 2.67 3 3 3.17
2 3.67 1 4.8 4.2 2.33 5 2.25 2
2 5 3 1.2 4.8 3.33 4.33 4.5 2
1 5 4 1.8 4.8 1.67 4.67 5 2
2 4.67 3 3 3.8 1.67 4 5 1.17
2 4.33 4 3.2 3.6 4 3 2.25 4.83
1 4 3 1.6 4.4 1 3.33 3 4.33
2 3 4 3.2 3 4 4 3 3
1 4 3 3 3.6 2.67 3 3.5 4
1 4.33 3 1.8 3.6 3.33 3 4 2.17
1 2.33 3 3 3.8 3.67 2.33 2.5 4.33
1 4 4 1 4.2 4.33 4.67 4.25 3.2
1 3.67 4 1.8 2.4 5 4.33 1 1.17
2 4.33 4 2.6 4.2 3.67 4.33 3.5 3.8
1 5 5 1.2 4.6 2.33 5 4.25 3.33
2 3 3.33 3 2.8 3 3 2.75 3.33
2 5 2.33 2 3.6 2.33 4.67 4 4.17
1 4 3.67 2 2.6 2.67 2.67 3.25 3.5
2 4 1 2 3.4 4 5 4 1.17
2 4.33 3 3 3.6 2.67 4.33 4 2
1 4 4 2.4 3.6 3.33 4 4 2.83
2 5 2 2 3.6 3.33 4.67 4 2.33
2 1 1.33 5 1.4 3.67 3 1.25 4.33
2 5 3 1 4.4 1.33 4.33 5 3.17
2 3.67 2 2.4 3.8 3.25 3.83
2 4.67 4 1.6 4.2 3.33 4.33 4.5 3.67
1 3 3 2.8 2.4 3.67 2.33 3.5 3.67
2 3.33 2.67 4 2.8 4 3.67 2.25 2.17
1 5 2 1 4.6 4 4.33 4.5 3.5
2 5 5 1 5 3.33 3 5 2.83
2 5 1 1.6 5 1.67 4.67 5 3.5
2 3.33 3.67 5 1.8 3.67 3.67 2 4
1 4 3.33 3 3.6 4 3 3.75 3.83
2 4 2.33 1.6 3.6 4.33 3.67 3.5 2.67
1 4 4 2.8 3.6 2.33 2.67 4.25 2.33
2 3 2.33 3.5 3
2 4.33 2 1.4 3.8 4 4 2.5 4
1 3 1.33 2 3.6 2.67 2 2.75 3.83
2 5 3 1 4.2 3 4.33 4 2
2 4 3 2 3.6 2.67 3.33 4.5 2.67
1 5 4 2 3.8 2.67 4 4.5 2.67
2 5 3 1 3.8 2 3 4 2
1 4 4 1.4 4.2 3.67 2.33 3.5 3.33
2 4.33 5 2.6 2.8 4.33 4.67 4.5 3.67
1 5 4.67 1 4.8 2.67 4.67 5 4
1 1 4 5 1.2 3 1 2 3.5
2 3 3 3 1.8 5 1.33 2.5 2.8
2 3 3.33 3.6 2.4 4 4.33 3 2.17
1 5 3.33 1 4.6 1 5 5 2.17
2 2 4 5 2.4 2.33 1.33 2 3.5
1 4 2 2 3.2 1 4 3.75 3.5
1 4.33 1.67 1 3.8 1.67 4.33 2.75 3.5
2 5 4 1 4.4 3.67 5 3.75 3.5
2 3 1 3.6 2 3 1 2.5 1.33
2 4 2.33 1.8 4 2.67 4.67 4 2
2 4.33 4.67 1.2 3.4 4.33 3 4 1
2 4 1.67 5 3.4 2.67 2 4 5
2 4 1.67 4 3.8 2.67 4.33 3 4.67
2 5 1 2.8 5 2.33 1.33 5 4.17
2 2 2.33 3.8 2.6 4 3.33 1 4
1 4.33 2.33 1.2 4.4 2.33 2.67 5 1.5
2 4 4 4 3.4 2.67 4 3.75 3.5
2 5 3 1.8 5 1 4.67 4.75 3.33
1 5 5 2.2 4.8 4 4.33 5 3
1 5 5 1.4 4.6 1 5 5 1.4
2 3 4.33 4.2 1.2 5 2.67 2.75 2.67
1 2.33 2 4.4 2.8 3.33 3 1.75 3.67
2 3 2 3.4 3.2 2.67 1.67 3.5 3.67
1 4.33 2 2 3.8 3.33 3.67 4.5 3.67
1 5 5 1 5 4 5 4.5 3.33
1 4 1.33 4.6 3.4 2.33 3 4.5 2.83
1 4 2.33 2.8 3.6 2 3.67 3.5 3.33
2 5 3.33 1.8 5 2.67 5 4.75 2.5
2 5 3.33 1.2 5 2.67 4.67 3.75 3.67
2 4 4 1.2 4.2 3 3.67 4 4
1 5 2 1 5 1 5 3.5 2
2 4 2 3.2 3.8 1.67 2 4.25 3.33
2 4.67 3 1 4.6 2.33 4.33 3.75 3.17
1 4.33 3.33 3.2 3.8 3.33 5 4 1.5
2 2.67 2 3.4 2.8 4.33 3 3 2.33
2 4.33 2.67 1.6 3.2 2 3 4.25 2.67
1 5 4 1.8 3.4 3.33 5 5 1.67
1 4.33 4 2.6 2.6 3.33 3.67 3.25 2
2 4.67 3 1.2 4.4 2.67 5 3.5 3.17
1 4.67 4 1 4.2 3.33 4.67 4.75 2.17
1 4 5 2.4 3.6 3.33 4 4.25 2.33
1 1 3.33 5 1.6 3.33 4 1.75 5
2 3 1.67 2.6 2 2 2.33 3 2.5
2 4.33 4 3 3.4 2.67 3.67 4.25 2.67
2 4 3 2 3.8 2.33 4 3.5 3
1 4.33 2.67 1.8 3.8 3 4 4.25 2.83
2 5 5 1 5 2.33 5 5 2.33
2 3 3 3 2.8 2.67 3 4.25 3
2 5 2.33 2.2 3 3.33 4.33 4.75 2
2 4.33 2.33 1.8 3.6 2.67 4.33 3.25 1.17
1 4.67 2.33 5 4.2 4 1 4.5 4.33
2 4.67 4 2.4 4.4 2.67 4.67 4.5 2.83
1 5 4 1 5 2 4.33 5 4.33
2 2.67 1.67 4 2.8 3 3 2.75 4.17
1 3.67 4 3.8 3.8 1.33 4 3.5 3.33
1 4.33 4 2.2 4 2 4.67 4 2.67
2 5 4 1 5 2 5 4.25 1.67
1 4.67 4 1.2 3.25 4 3.33 4.5 2.67
2 5 4 1.8 3.4 4 2.67 4.75 1
2 3.33 2 3.6 2.8 3 3.33 2.75 2.67
1 3.67 2.67 4.67 4
2 2.67 3 5 3.2 2 3.67 2.5 4.17
2 3.67 3.67 2 2.6 4.33 2.33 3 2.83
1 5 3 2.4 4.2 1.67 4 5 1.4
1 4 4 2 3.4 2.67 3.67 4.25 2.33
2 2.67 4 2 2.4 3.67 2 3.25 2.33
1 4.67 3.67 1.2 4.8 2.67 3.67 4 3
2 4 2 2.2 3.6 3 3 4 2.33
1 5 1 5 3 5 5 1
2 2.33 3 3 3 3.33 3.5 3.25 3.33
2 3.67 3 2.6 5 5 5 3 5
2 4.33 2 1 4.4 2.67 4.67 3.5 1.67
2 3 1 3 3 2.33 1.33 3 3
2 5 5 1 4.6 4.33 4.67 4.5 4.17
1 4.67 4 2.8 4.2 3 4.33 4 2.5
1 4.33 2.67 3 3.8 2.33 3.33 3.5 4
1 4 3 3 3 2.67 3.67 3.25 3.17
2 4 4 3.4 2.4 4 4.33 3.5 4.33
2 4.67 3.33 2.2 3.8 3.67 2.67 4.5 3.5
2 5 1 4 3.4 2.33 2 4 3
2 2.67 4 4.6 1 4 2.67 2.5 2
1 4.67 3.67 1.2 4.8 3.67 4.33 4.5 2.33
1 4 4.67 1.8 5 4.67 2.33 5 2.33
1 5 5 3 4.4 4.33 3.33 5 3.33
1 4 4 1.8 3.4 3.33 4 4 2.33
1 4 3.33 2 3.6 3.33 1.67 2.25 4
2 4.67 3.67 1.2 3.2 3.67 4 4 1.67
1 4.33 5 2 4 4.33 4.67 4 1.67
1 4.33 2 1.4 3 2.67 3.67 3.5 3.17
1 4 3.67 3 4 4 4 3.5 2
2 4 5 2.4 4 2.67 3.67 4.25 4
1 4.33 2.33 2.8 2.6 3.33 3 3.5 3
2 4 1.67 2.4 3 3 5 3.75 4
1 5 3 2.6 3.6 3 4 4.25 3
2 3 4 4.4 2.4 4.33 2.67 2.75 4.17
1 5 2 1.8 4.2 1.67 3 4 4
2 4 2 3 3 2.67 2 2.33
2 4.67 2 1.6 5 1.33 5 4.5 2.83
2 4.33 4.33 1.8 2.2 3 3.67 4.25 2
1 5 4.67 1.2 4.6 3.67 5 5 2.17
2 5 5 2.2 4.4 3 4.33 3.25 3
1 3.33 4.33 3.4 3.4 4.67 4 3.25 2.17
1 5 3.67 2.2 3.8 2.67 4 4.5 2.5
1 4.67 2.67 1.6 4 4.33 5 4 2.17
2 3.67 3 3 3.2 2.33 3.33 2.5 3.33
1 4.33 3.33 1.6 3.6 3 5 3.75 2.17
1 4.67 4 1.2 4 2 5 4 2
1 5 1 2.2 3.4 3 3 4 1
1 4 1 1.6 4 4.33 2 4.25 1.83
1 4.67 2 1.2 4.6 3.33 4 4.75 3.67
2 4 3.33 2 3.8 1.67 3.67 3.5 4.5
2 4.33 4.33 2 3.6 2.67 4 4.5 2
2 2.67 1.67 5 3 2.33 3 3 3.5
1 4.33 3.67 1.8 4 2.33 5 3.25 2.67
1 5 2 1 4.8 2.67 4 5 4.17
1 5 5 1 5 1.33 4.67 5 2
2 4.67 1 2.4 3.2 2.67 4.33 4.25 2.17
1 1.33 1 4 1.8 2.67 1.33 1.75 3.67
1 4 4 2.5 3.4 5 2.67 4 5
1 1.33 1 2.67 4
2 4.67 1.67 1.6 3.8 2 3.67 4.25 4.33
1 4 2.67 2.6 3.8 4.67 4.33 3.75 2.83
1 4 4 2.4 4 3.33 5 4.25 2.33
2 3.33 3 3 3.2 1.33 3 3.5 2.5
1 5 2 2 4.2 3.33 4.67 5 3
1 3.33 4 3.4 2 1.33 4 3.75 3
1 4.67 1.67 3.4 5 3.33 5 5 3.83
2 3 2 5 3.4 1.33 3.67 2.5 4.6
1 5 5 1.8 5 2.33 5 5 1.33
1 4.33 3 1.2 4.4 2 4 3.5 3.67
2 4.33 4 1 4.2 5 2.67 4.25 1.33
2 4.67 4 1.4 3.2 3.67 4 4.25 3
1 4 4 2.6 3.8 2.67 4 4.5 2.67
2 3.67 1 5 4.2 2 4.33 2.5 3.33
1 3.33 4 3.4 2.4 3.67 3 3.25 3.33
2 4 2 3.6 3.2 3 3 2 2.33
Descriptive Statistics
Minimum 1
Maximum 2
Average 1.48
Standard Deviation 0.50
Correlations
Gender Job Sat Pay Sat Turnover Intent Affective Commitment Extrinsic Motivation Intrinsic motivation Percieved Org Support Work Family Conflict
Gender 1
Job Sat -0.0901873144
Pay Sat
Turnover Intent
Affective Commitment
Extrinsic Motivation
Intrinsic motivation
Percieved Org Support
Work Family Conflict

Table of Critical Values

Sample Size Level of Significance (p)
(Number of people responding) 0.1 0.05 0.02 0.01
4 0.9 0.95 0.99 0.999
5 0.805 0.878 0.959 0.991
6 0.729 0.811 0.917 0.974
7 0.669 0.754 0.875 0.951
8 0.621 0.707 0.834 0.925
9 0.582 0.666 0.798 0.898
10 0.549 0.632 0.765 0.872
11 0.521 0.602 0.735 0.847
12 0.497 0.576 0.708 0.823
13 0.476 0.553 0.684 0.801
14 0.458 0.532 0.661 0.78
15 0.441 0.514 0.641 0.76
16 0.426 0.497 0.623 0.742
17 0.412 0.482 0.606 0.725
18 0.4 0.468 0.59 0.708
19 0.389 0.456 0.575 0.693
20 0.378 0.444 0.561 0.679
21 0.369 0.433 0.549 0.665
22 0.36 0.423 0.537 0.652
23 0.352 0.413 0.526 0.64
24 0.344 0.404 0.515 0.629
25 0.337 0.396 0.505 0.618
26 0.33 0.388 0.496 0.607
27 0.323 0.381 0.487 0.597
28 0.317 0.374 0.479 0.588
29 0.311 0.367 0.471 0.579
30 0.306 0.361 0.463 0.57
35 0.283 0.334 0.43 0.532
40 0.264 0.312 0.403 0.501
45 0.248 0.294 0.38 0.474
50 0.235 0.279 0.361 0.451
60 0.214 0.254 0.33 0.414
70 0.198 0.235 0.306 0.385
80 0.185 0.22 0.286 0.361
90 0.174 0.207 0.27 0.341
100 0.165 0.197 0.256 0.324
200 0.117 0.139 0.182 0.231
300 0.095 0.113 0.149 0.189
400 0.082 0.098 0.129 0.164
500 0.074 0.088 0.115 0.147
1000 0.052 0.062 0.081 0.104