Question
A human resource consultant is asked to review how equitable a company is in terms of diversity and rewards. As part of his investigations the
A human resource consultant is asked to review how equitable a company is in terms of diversity and rewards. As part of his investigations the consultant asks a statistician to analyze a dataset made available with information on the demographic background, job type and hourly salary of 1,026 employees.
Thedatasetcontainsthevariableslistedinthefollowingtable.
Variablename | Label | Description |
hrwage | Hourlywage | HourlywageinUSdollars |
age | Age | Ageofemployee |
educ | Yearsofeducation | Years spentas a pupil/student in education |
exper | Yearsofrelevant experience | Years of relevant workexperience |
sex | Sexoftheperson | 0=Male 1=Female |
region | Region ofcountryin whichdivisionis located | 0=Notinthesouth 1=South |
union | Union status | 0=Notaunionmember 1=Unionmember |
jobcat | Jobcategory | 1=Manual 2=Administrative/IT(Admin) 3=Supervisor(Sup) 4=Sales 5 =Management(Manag) |
- To examine the correlation between hourly wage, age, years of experience and years of education, the statistician conducts a bivariate correlation separatelyformalesandfemales.The SPSS output is showninAppendix 1.Brieflyexplain what relevant information is shown in this output.
Note:Following academic convention, table numbers appear above the tables and figure numbers appear below the figures.
APPENDIX1 | ||||||||
Table1 | Correlations | |||||||
Hourly | Agein | Yearsof | Yearsof Relevant | |||||
Sex | Wage($) | years | Education | Experience | ||||
Male Hourly Wage($) | PearsonCorrelation | 1 | .235** | .322** | .135** | |||
Sig.(2-tailed) | .000 | .000 | .002 | |||||
N | 516 | 516 | 516 | 516 | ||||
Agein years | PearsonCorrelation | .235** | 1 | -.165** | .974** | |||
Sig.(2-tailed) | .000 | .000 | 0.000 | |||||
N | 516 | 516 | 516 | 516 | ||||
Years of Education | PearsonCorrelation | .322** | -.165** | 1 | -.381** | |||
Sig.(2-tailed) | .000 | .000 | .000 | |||||
N | 516 | 516 | 516 | 516 | ||||
Years of RelevantExperience | PearsonCorrelation Sig.(2-tailed) | .135** .002 | .974** 0.000 | -.381** .000 | 1 | |||
N | 516 | 516 | 516 | 516 | ||||
Female Hourly Wage($) | PearsonCorrelation | 1 | .196** | .347** | .107* | |||
Sig.(2-tailed) | .000 | .000 | .016 | |||||
N | 510 | 510 | 510 | 510 | ||||
Agein years | PearsonCorrelation | .196** | 1 | -.130** | .980** | |||
Sig.(2-tailed) | .000 | .003 | 0.000 | |||||
N | 510 | 510 | 510 | 510 | ||||
Years of Education | PearsonCorrelation | .347** | -.130** | 1 | -.322** | |||
Sig.(2-tailed) | .000 | .003 | .000 | |||||
N | 510 | 510 | 510 | 510 | ||||
Yearsof Relevant | Pearson Correlation | .107* | .980** | -.322** | 1 | |||
Experience Sig.(2-tailed) | .016 | 0.000 | .000 | |||||
N | 510 | 510 | 510 | 510 | ||||
**.Correlationissignificantatthe0.01level(2-tailed).
*.Correlationissignificantatthe0.05level(2-tailed).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started