Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of Financial Derivatives

Authors: Ali Hirsa, Salih N. Neftci

3rd edition

012384682X, 978-0123846822

More Books

Students also viewed these Mathematics questions