Using AIU’s survey responses from the AIU data set, complete the following requirements in the form of a 2-page report

tutor4helpyou
datasetanddatasetkey.xlsx
Home>Mathematics homework help>Numerical analysis homework help>Using AIU’s survey responses from the AIU data set, complete the following requirements in the form of a 2-page report

SURVEY

Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits
1 1 1 1 3 5.5 5.5 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 6.2 KEY TO SURVEY
1 1 2 2 1 5.5 5.3 5.7 2.3
1 1 3 1 1 5.2 4.7 5.6 4.5 Demographics
1 3 3 1 1 4.9 5.2 4.6 6.2
1 2 2 1 1 5.2 4.7 5.6 4.5 Gender
1 2 1 1 2 5.2 4.7 5.6 4.5 1 Male
1 3 3 1 2 5.5 5.4 5.6 5.4 2 Female
1 2 2 1 3 5.9 3.7 5.5 6.2 Age
1 1 3 2 1 4.9 5.2 4.6 6.2 1 16 - 21
1 1 1 1 3 3.2 5.5 5.5 3.5 2 22 - 49
1 3 3 1 1 4.9 5.2 4.6 6.2 3 50 - 65
1 1 2 2 1 5.5 5.3 5.7 2.3 Department
1 1 3 1 3 5.2 4.7 5.6 4.5 1 Human Resources
1 2 2 1 3 5.5 5.5 5.5 5.4 2 Information Technology
1 3 3 1 1 4.9 5.2 4.6 6.2 3 Administration
1 2 2 1 1 5.2 4.7 5.6 4.5 Position
1 2 2 1 3 5.5 5.4 5.6 5.4 1 Hourly Employee (Overtime Eligible)
1 1 1 1 3 3.2 5.5 4.6 6.2 2 Salaried Employee (No Overtime)
1 2 1 1 2 5.2 4.7 5.6 4.5 Tenure With Company
1 3 3 1 1 4.9 5.2 5.7 6.2 1 Less than 2 years
1 1 1 1 2 5.5 5.3 5.6 5.4 2 2 to 5 years
1 1 1 1 2 5.5 5.3 5.6 5.4 3 Over 5 Years
1 1 1 1 3 5.5 5.5 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 6.2 Four Survey Measures
1 1 2 2 1 5.5 5.3 5.7 2.3
1 1 3 1 1 5.2 4.7 5.6 4.5 SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)
1 3 3 1 1 4.9 5.2 4.6 6.2 1 = Least Satisfied
1 2 2 1 1 5.2 4.7 5.6 4.5 7 = Most Satisfied
1 2 1 1 2 5.2 4.7 5.6 4.5 SURVEY MEASURE #2 INTRINSIC JOB SATISFACTION (Scale 1-7)
1 3 3 1 2 5.5 5.4 5.6 5.4 1= Least Satisfied
1 2 2 1 3 5.9 3.7 5.5 6.2 7= Most Satisfied
1 1 3 2 1 4.9 5.2 4.6 6.2 SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)
1 1 1 1 3 3.2 5.5 5.5 3.5 1 = Least Satisfied
1 3 3 1 1 4.9 5.2 4.6 6.2 7 = Most Satisfied
1 1 3 2 1 5.5 5.3 5.7 2.3 SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1 1 3 1 3 5.2 4.7 5.6 4.5 1= Least Satisfied
1 2 3 1 3 5.5 5.5 5.5 5.4 7= Most Satisfied
1 3 2 1 1 4.9 5.2 4.6 6.2
1 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 1 3 5.5 5.4 5.6 5.4
1 1 3 1 3 3.2 5.5 4.6 6.2
1 2 2 1 2 5.2 4.7 5.6 4.5
1 3 3 1 1 5.5 5.2 5.7 6.2
1 1 1 1 2 5.2 5.3 5.6 5.4
1 3 2 1 1 4.9 5.2 5.7 6.2
1 1 3 1 2 5.2 5.3 5.6 5.4
1 2 1 2 3 5.2 5.3 5.7 2.3
1 2 1 1 1 5.5 5.2 5.6 2.3
1 3 3 1 1 5.9 5.3 5.6 4.5
2 2 3 2 3 4.9 4.7 5.5 5.4
2 2 2 2 1 3.2 5.4 4.6 6.2
2 2 2 1 1 4.9 5.5 5.4 4.5
2 1 2 2 1 5.5 5.3 5.7 2.3
2 1 3 1 1 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 1 1 2 5.2 4.7 5.6 4.5
2 3 3 1 2 5.5 5.4 5.6 5.4
2 2 2 1 3 5.9 3.7 5.5 6.2
2 1 3 2 1 4.9 5.2 4.6 6.2
2 1 1 1 3 3.2 5.5 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 6.2
2 1 2 2 1 5.5 5.3 5.7 2.3
2 1 3 1 3 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.5 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.4 5.6 5.4
2 1 1 1 3 3.2 5.5 4.6 6.2
2 2 1 1 2 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 5.7 6.2
2 1 1 1 2 5.5 5.3 5.6 5.4
2 1 1 1 2 5.5 5.3 5.6 5.4
2 1 1 1 3 5.5 5.5 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 6.2
2 1 2 2 1 5.5 5.3 5.7 2.3
2 1 3 1 1 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 1 1 2 5.2 4.7 5.6 4.5
2 3 3 1 2 5.5 5.4 5.6 5.4
2 1 1 1 3 3.2 5.5 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 6.2
2 1 2 2 1 5.5 5.3 5.7 2.3
2 1 3 1 3 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.5 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.4 5.6 5.4
2 1 1 1 3 3.2 5.5 4.6 6.2
2 2 1 1 2 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.5 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 5.5 5.4 5.6 5.4
2 1 1 1 3 3.2 5.5 4.6 6.2
2 1 3 1 1 5.2 4.7 5.6 4.5
2 3 3 1 1 4.9 5.2 4.6 6.2
2 2 2 1 1 5.2 4.7 5.6 4.5

Sheet1

Gender Male Female
1 5.5 2 4.7
1 5.2 2 5.4
1 5.3 2 5.5
1 4.7 2 5.3 t-Test: Two-Sample Assuming Equal Variances
1 5.2 2 4.7
1 4.7 2 5.2 Male Female
1 4.7 2 4.7 Mean 5.104 5.106
1 5.4 2 4.7 Variance 0.1637 0.1430
1 3.7 2 5.4 Observations 50 50
1 5.2 2 3.7 Pooled Variance 0.1533
1 5.5 2 5.2 Hypothesized Mean Difference 0
1 5.2 2 5.5 df 98
1 5.3 2 5.2 t Stat -0.0255
1 4.7 2 5.3 P(T<=t) one-tail 0.4898
1 5.5 2 4.7 t Critical one-tail 1.6606
1 5.2 2 5.5 P(T<=t) two-tail 0.9797
1 4.7 2 5.2 t Critical two-tail 1.9845
1 5.4 2 4.7
1 5.5 2 5.4
1 4.7 2 5.5
1 5.2 2 4.7
1 5.3 2 5.2
1 5.3 2 5.3
1 5.5 2 5.3
1 5.2 2 5.5
1 5.3 2 5.2
1 4.7 2 5.3
1 5.2 2 4.7
1 4.7 2 5.2
1 4.7 2 4.7
1 5.4 2 4.7
1 3.7 2 5.4
1 5.2 2 5.5
1 5.5 2 5.2
1 5.2 2 5.3
1 5.3 2 4.7
1 4.7 2 5.5
1 5.5 2 5.2
1 5.2 2 4.7
1 4.7 2 5.4
1 5.4 2 5.5
1 5.5 2 4.7
1 4.7 2 5.5
1 5.2 2 5.2
1 5.3 2 4.7
1 5.2 2 5.4
1 5.3 2 5.5
1 5.3 2 4.7
1 5.2 2 5.2
1 5.3 2 4.7

Sheet2

Position Hourly Employee (Overtime Eligible) Salaried Employee (No Overtime)
1 5.5 2 5.7
1 4.6 2 4.6
1 5.6 2 5.7
1 4.6 2 5.7 t-Test: Two-Sample Assuming Equal Variances
1 5.6 2 4.6
1 5.6 2 5.7 Hourly Employee (Overtime Eligible) Salaried Employee (No Overtime)
1 5.6 2 5.7 Mean 5.3291 5.3714
1 5.5 2 5.5 Variance 0.1873 0.2591
1 5.5 2 4.6 Observations 86 14
1 4.6 2 5.7 Pooled Variance 0.1968
1 5.6 2 4.6 Hypothesized Mean Difference 0
1 5.5 2 5.7 df 98
1 4.6 2 5.7 t Stat -0.3313
1 5.6 2 5.7 P(T<=t) one-tail 0.3706
1 5.6 t Critical one-tail 1.6606
1 4.6 P(T<=t) two-tail 0.7411
1 5.6 t Critical two-tail 1.9845
1 5.7
1 5.6
1 5.6
1 5.5
1 4.6
1 5.6
1 4.6
1 5.6
1 5.6
1 5.6
1 5.5
1 5.5
1 4.6
1 5.6
1 5.5
1 4.6
1 5.6
1 5.6
1 4.6
1 5.6
1 5.7
1 5.6
1 5.7
1 5.6
1 5.6
1 5.6
1 5.4
1 5.6
1 4.6
1 5.6
1 5.6
1 5.6
1 5.5
1 5.5
1 4.6
1 5.6
1 5.5
1 4.6
1 5.6
1 5.6
1 4.6
1 5.6
1 5.7
1 5.6
1 5.6
1 5.5
1 4.6
1 5.6
1 4.6
1 5.6
1 5.6
1 5.6
1 5.5
1 4.6
1 5.6
1 5.5
1 4.6
1 5.6
1 5.6
1 4.6
1 5.6
1 5.5
1 4.6
1 5.6
1 5.6
1 4.6
1 5.6
1 4.6
1 5.6