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

profiletutor4helpyou
data.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 - Table 1

Gender Age Department Position Tenure Job Satisfaction Intrinsic Extrinsic Benefits
1 1 1 1 3 4.9 6.4 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 4.2 KEY TO SURVEY
1 1 2 2 1 4.9 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 4.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 4.9 5.4 5.6 5.4 2 Female
1 2 2 1 3 5.9 3.7 5.5 4.2 Age
1 1 3 2 1 4.9 5.2 4.6 4.2 1 16 - 21
1 1 1 1 3 3.2 6.4 5.5 3.5 2 22 - 49
1 3 3 1 1 4.9 5.2 4.6 4.2 3 50 - 65
1 1 2 2 1 4.9 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 4.9 6.4 5.5 5.4 2 Information Technology
1 3 3 1 1 4.9 5.2 4.6 4.2 3 Administration
1 2 2 1 1 5.2 4.7 5.6 4.5 Position
1 2 2 1 3 4.9 5.4 5.6 5.4 1 Hourly Employee (Overtime Eligible)
1 1 1 1 3 3.2 6.4 4.6 4.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 4.2 1 Less than 2 years
1 1 1 1 2 4.9 5.3 5.6 5.4 2 2 to 5 years
1 1 1 1 2 4.9 5.3 5.6 5.4 3 Over 5 Years
1 1 1 1 3 4.9 6.4 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 4.2 Four Survey Measures
1 1 2 2 1 4.9 5.2 4.6 4.2
1 1 3 1 1 5.2 6.4 5.5 3.5 SURVEY MEASURE #1 OVERALL JOB SATISFACTION (Scale 1-7)
1 3 3 1 1 4.9 5.2 4.6 4.2 1 = Least Satisfied
1 2 2 1 1 5.2 5.3 5.7 2.3 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 4.9 6.4 5.5 5.4 1= Least Satisfied
1 2 2 1 3 5.9 5.2 4.6 4.2 7= Most Satisfied
1 1 3 2 1 4.9 4.7 5.6 4.5 SURVEY MEASURE #3 EXTRINSIC JOB SATISFACTION (Scale 1-7)
1 1 1 1 3 3.2 5.4 5.6 5.4 1 = Least Satisfied
1 3 3 1 1 4.9 6.4 4.6 4.2 7 = Most Satisfied
1 1 3 2 1 4.9 4.7 5.6 4.5 SURVEY MEASURE #4 BENEFITS (Scale 1-7)
1 1 3 1 3 5.2 5.2 5.7 4.2 1= Least Satisfied
1 2 3 1 3 4.9 5.2 4.6 4.2 7= Most Satisfied
1 3 2 1 1 4.9 6.4 5.5 3.5
1 2 2 1 1 5.2 4.7 5.6 4.5
1 2 2 2 3 4.9 5.4 5.6 5.4
1 1 3 2 3 4.9 5.2 4.6 4.2
1 2 2 1 2 5.2 6.4 5.5 3.5
1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 1 1 2 5.2 5.3 5.7 2.3
1 3 2 1 1 5.2 4.7 5.6 4.5
1 1 3 1 2 4.9 6.4 5.5 5.4
1 2 1 2 3 5.9 5.2 4.6 4.2
1 2 1 1 1 4.9 4.7 5.6 4.5
1 1 1 2 3 4.9 6.4 5.5 5.4
1 3 3 1 1 4.9 5.2 4.6 4.2
1 1 2 2 1 4.9 5.3 5.7 2.3
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.2
2 2 1 2 2 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 6.4 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.2
2 1 3 1 1 5.2 4.7 5.6 4.5
2 3 3 2 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 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 4.2
2 2 2 1 1 4.9 6.4 5.4 4.5
2 1 2 2 1 4.9 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 4.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 4.9 5.4 5.6 5.4
2 2 2 1 3 5.9 3.7 5.5 4.2
2 1 3 2 1 4.9 5.2 4.6 4.2
2 1 1 1 3 3.2 6.4 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 4.2
2 1 2 2 1 4.9 5.3 5.7 2.3
2 1 3 1 3 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 6.4 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.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 4.2
2 1 3 2 1 4.9 5.2 4.6 4.2
2 1 1 1 3 3.2 6.4 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 4.2
2 1 2 2 1 4.9 5.3 5.7 2.3
2 1 1 1 3 3.2 6.4 5.5 3.5
2 3 3 1 1 4.9 5.2 4.6 4.2
2 1 2 2 1 4.9 5.3 5.7 2.3
2 1 3 1 3 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 6.4 5.5 5.4
2 3 3 1 1 4.9 5.2 4.6 4.2
2 2 2 1 1 5.2 4.7 5.6 4.5
2 2 2 1 3 4.9 5.4 5.6 5.4
2 1 1 1 3 3.2 6.4 4.6 4.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 4.2
2 1 3 2 1 4.9 5.2 4.6 4.2
2 1 1 1 3 3.2 6.4 5.5 3.5