Tutorial ProactivityEmotional IntelligenceSJTCustomer Service 28922 36811 4675 55611 65612 75512 74512 82412 92312 27810 34710 36710 56712 65612 65612...

Tutorial
    Proactivity    Emotional Intelligence    SJT    Customer Service
    2    8    9    22
    3    6    8    11
    4    6    7    5
    5    5    6    11
    6    5    6    12
    7    5    5    12
    7    4    5    12
    8    2    4    12
    9    2    3    12
    2    7    8    10
    3    4    7    10
    3    6    7    10
    5    6    7    12
    6    5    6    12
    6    5    6    12
    7    4    5    12
    7    4    5    12
    7    3    4    11
    7    3    3    10
    8    1    2    18
    8    8    9    12
    9    8    9    11
    9    5    6    15
    9    6    7    16
    9    6    7    16
    12    6    7    11
    12    4    5    14
    14    7    4    12
    3    2    3    6
    4    2    2    6
    5    3    1    6
    5    8    9    14
    6    9    10    14
    7    7    8    15
    4    6    7    11
    4    5    6    10
    7    4    5    12
    8    3    4    12
    9    2    3    12
    3    1    2    5
    3    2    1    8
    8    8    9    10
    7    7    8    15
    7    6    7    14
    6    6    7    13
    6    5    6    12
    5    5    6    11
    5    4    5    10
    4    4    5    9
    4    4    5    9
    3    4    5    8
    3    3    4    7
    2    3    4    9
    9    2    3    12
    9    1    2    11
    8    8    8    16
    7    7    8    15
    6    6    7    13
    6    6    7    13
    5    6    7    12
    4    7    6    10
    5    5    6    11
    4    4    5    9
    4    4    5    9
    3    4    5    8
    2    3    4    6
    1    3    4    5
    1    2    3    4
    1    1    2    18
    12    8    10    5
    7    8    9    16
    5    7    8    13
    5    6    7    12
    4    6    7    11
    4    5    6    10
    3    5    6    9
    3    1    5    8
    2    4    5    7
    2    4    5    7
    2    3    4    6
    4    2    3    7
    4    1    2    14
    5    7    9    14
    7    10    9    12
    7    6    7    14
    4    5    6    10
    4    4    5    9
    3    4    5    8
    3    4    5    8
    2    2    4    6
    2    2    3    5
    15    7    8    10
    4    6    7    11
    4    5    6    10
    3    4    5    8
    3    1    3    6
    3    1    2    14
    4    4    5    9
    3    4    5    8
    3    3    4    7
    2    8    9    22
    3    6    8    11
    4    6    7    5
    5    5    6    11
    6    5    6    12
    7    5    5    12
    7    4    5    12
    8    2    4    12
    9    2    3    12
    2    7    8    10
    3    4    7    10
    3    6    7    10
    5    6    7    12
    6    5    6    12
    6    5    6    12
    7    4    5    12
    7    4    5    12
    7    3    4    11
    7    3    3    10
    8    1    2    18
    8    8    9    12
    9    8    9    11
    9    5    6    15
    9    6    7    16
    9    6    7    16
    12    6    7    11
    12    4    5    14
    14    7    4    12
    3    2    3    6
    4    2    2    6
    5    3    1    6
    5    8    9    14
    6    9    10    14
    7    7    8    15
    4    6    7    11
    4    5    6    10
    7    4    5    12
    8    3    4    12
    9    2    3    12
    3    1    2    5
    3    2    1    8
    8    8    9    10
    7    7    8    15
    7    6    7    14
    6    6    7    13
    6    5    6    12
    5    5    6    11
    5    4    5    10
    4    4    5    9
    4    4    5    9
    3    4    5    8
    3    3    4    7
    2    3    4    9
    9    2    3    12
    9    1    2    11
    8    8    8    16
    7    7    8    15
    6    6    7    13
    6    6    7    13
    5    6    7    12
    4    7    6    10
    5    5    6    11
    4    4    5    9
    4    4    5    9
    3    4    5    8
    2    3    4    6
    1    3    4    5
    1    2    3    4
    1    1    2    18
    12    8    10    5
    7    8    9    16
    5    7    8    13
    5    6    7    12
    4    6    7    11
    4    5    6    10
    3    5    6    9
    3    1    5    8
    2    4    5    7
    2    4    5    7
    2    3    4    6
    4    2    3    7
    4    1    2    14
    5    7    9    14
    7    10    9    12
    7    6    7    14
    4    5    6    10
    4    4    5    9
    3    4    5    8
    3    4    5    8
    2    2    4    6
    2    2    3    5
    15    7    8    10
    4    6    7    11
    4    5    6    10
    3    4    5    8
    3    1    3    6
    3    1    2    14
    4    4    5    9
    3    4    5    8
    3    3    4    7
    1    8    9    24
    3    6    8    11
    4    6    7    5
    5    5    6    11
    6    5    6    12
    7    5    5    12
    7    4    5    12
    8    2    4    12
    9    2    3    12
    2    7    8    10
    3    4    7    10
    3    6    7    10
    5    6    7    12
    6    5    6    12
    6    5    6    12
    7    4    5    12
    7    4    5    12
    7    3    4    11
    7    3    3    10
    8    1    2    9
    8    8    9    12
    9    8    9    11
    9    5    6    15
    9    6    7    16
    9    6    7    16
    12    6    7    11
    12    4    5    14
    14    7    4    12
    3    2    3    6
    4    2    2    6
    5    3    1    6
    5    8    9    14
    6    9    10    27
    7    7    8    15
    4    6    7    11
    4    5    6    10
    7    4    5    12
    8    3    4    12
    9    2    3    12
    3    1    2    5
    5    2    1    8
    4    8    9    10
    7    7    8    15
    7    6    7    14
    6    6    7    13
    6    5    6    12
    5    5    6    11
    5    4    5    10
    4    4    5    9
    4    4    5    9
    3    4    5    8
    3    3    4    7
    2    3    4    9
    9    2    3    12
    9    1    2    11
    8    8    8    16
    7    7    8    15
    6    6    7    13
    6    6    7    13
    5    6    7    12
    4    7    6    10
    5    5    6    11
    4    4    5    9
    4    4    5    9
    3    4    5    8
    2    3    4    6
    1    3    4    5
    1    2    3    4
    5    1    2    18
    12    8    10    5
    7    8    9    16
    5    7    8    13
    5    6    7    12
    4    6    7    11
    4    5    6    10
    3    5    6    9
    3    1    5    8
    2    4    5    7
    2    4    5    7
    2    3    4    6
    4    2    3    7
    4    1    2    14
    5    7    9    22
    7    10    9    12
    7    6    7    14
    4    5    6    10
    4    4    5    9
    3    4    5    8
    3    4    5    8
    2    2    4    6
    2    2    3    5
    15    7    8    10
    4    6    7    11
    4    5    6    10
    3    4    5    8
    3    1    3    6
    3    1    2    14
    4    4    5    9
    3    4    5    8
    3    3    4    7
Practice
    WorkSample    StructuredInterview    JobPerformance
    2.29    3.17    3.53
    2.20    3.61    3.07
    5.52    2.85    3.21
    1.87    2.08    1.58
    1.00    2.82    1.56
    6.21    3.62    3.92
    2.00    2.86    1.79
    6.64    3.55    3.75
    2.29    3.07    1.54
    7.21    4.33    1.87
    3.42    3.36    2.77
    5.26    2.88    3.64
    7.06    3.00    2.49
    3.75    2.26    2.81
    5.84    2.60    3.85
    3.73    2.87    2.41
    5.14    2.66    3.03
    3.99    2.89    2.54
    4.78    2.91    3.28
    3.85    3.44    2.07
    2.51    3.75    2.54
    3.13    1.77    1.00
    6.56    3.59    3.96
    6.41    5.00    3.40
    4.02    2.39    2.80
    7.41    2.38    3.38
    5.72    3.30    1.95
    5.98    3.25    4.12
    6.49    3.83    5.00
    2.67    2.16    4.29
    6.77    1.91    3.98
    2.88    3.73    3.08
    8.57    2.18    3.57
    6.12    2.14    2.66
    6.13    2.76    3.41
    2.75    2.85    2.78
    1.00    3.22    2.94
    3.68    2.79    3.83
    4.55    2.63    3.78
    3.26    3.28    2.11
    4.80    4.37    4.29
    4.57    3.88    3.21
    4.29    3.29    2.87
    7.26    1.00    3.96
    3.78    2.90    2.79
    6.26    3.58    4.52
    8.02    3.90    4.22
    6.23    3.37    3.41
    7.97    3.38    2.93
    4.88    3.32    3.60
    5.57    2.99    2.89
    6.75    3.19    3.78
    5.99    2.08    3.41
    9.26    2.83    3.76
    5.64    3.52    4.29
    6.08    3.14    3.51
    4.35    2.53    1.75
    5.73    3.64    3.15
    7.21    2.84    4.12
    8.20    3.35    4.40
    3.56    3.64    2.25
    4.97    2.68    4.35
    4.94    2.51    2.14
    5.88    3.63    2.94
    6.34    3.70    3.61
    4.01    3.60    2.70
    6.94    2.81    3.35
    3.85    3.41    2.82
    3.82    3.42    4.86
    7.26    3.23    3.33
    3.53    2.49    1.52
    6.73    4.20    3.24
    6.97    3.75    3.45
    3.86    3.77    2.89
    4.06    3.13    1.68
    7.23    3.73    3.43
    2.52    3.52    3.34
    5.79    2.79    4.39
    4.34    3.34    2.50
    5.69    3.13    2.78
    6.24    2.26    3.32
    4.13    3.15    2.77
    6.07    3.20    4.40
    5.56    2.88    2.06
    6.85    3.21    4.90
    7.13    2.40    3.10
    9.60    3.25    3.87
    5.45    2.82    2.35
    3.79    2.60    3.96
    1.00    3.19    2.35
    6.52    2.64    3.03
    5.52    2.30    2.13
    8.04    3.78    3.31
    6.18    2.90    2.79
    3.50    2.58    2.31
    4.30    3.88    3.20
    3.58    2.90    3.27
    1.00    3.61    3.09
    4.56    3.40    2.27
    7.65    3.51    4.07
    2.75    3.11    2.40
    6.37    3.26    3.49
    8.06    2.70    3.13
    6.28    3.16    4.17
    6.51    2.17    3.34
    2.96    3.76    2.01
    6.85    3.94    3.45
    4.12    2.01    3.21
    4.52    3.58    3.16
    7.34    3.46    3.99
    4.16    4.04    2.59
    7.03    3.90    4.04
    2.81    1.78    2.16
    3.13    2.04    1.00
    5.45    3.20    4.38

PowerPoint Presentation
Chapter 7
Excel Extension: Now You Try!
Assessing the Criterion-Related Validity of Selection Procedures
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Background
In this Excel Extension tutorial, you will learn how to assess the criterion-related validity of selection procedures using co
elation and regression analyses.
For the purposes of this exercise, imagine that your HR team is revamping the selection procedures for the Sales Associate job. Your team has conducted a concu
ent validation study in which Sales Associate job incumbents complete the following selection procedures: proactivity assessment, emotional intelligence inventory, and situational judgment test (SJT). With regard to the criterion (outcome) of interest, the job incumbents were also assessed in terms of their customer service job performance.
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Open the Excel workbook titled “Chapter 7 - Excel Extension.xlsx”.
Click on the sheet called Tutorial. You will use the data contained in this sheet to learn how to create a co
elation matrix and a multiple linear regression model in Excel.
Note that the sheet includes four fields/columns/variables:
Proactivity (productivity assessment; 1 = low proactivity, 15 = high proactivity)
Emotional Intelligence (emotional intelligence inventory; 1 = low emotional intelligence, 10 = high emotional intelligence)
SJT (situational judgment test; 1 = low SJT, 10 = high SJT)
Customer Service (customer service job performance; 1 = low performance, 30 = high performance)
Note that there are 300 employees in this sample.
Step 1
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
If you haven’t already, be sure to add in the Analysis ToolPak feature in Excel, which requires the following steps.
First, click on the File tab.
Step 2
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Select Options.
Step 3
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
When the Excel Options window opens, select the Add-Ins tab on the left, and then select the Analysis ToolPak in the Excel Add-Ins list, which appears next Manage at the bottom of the window, and click Go…. A window will open, and simply check the box next to Analysis ToolPak.
If you already have the Analysis ToolPak application activated, it will appear in the Active Application Add-ins list, as shown in the image.
Click OK.
Step 4
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Click on the Data tab.
Click on the Data Analysis button.
Step 5
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
As a first step in the criterion-related validation process, let’s create a co
elation matrix that contains the interco
elations between the three selection procedure scores and the customer service job performance scores.
To do so, in the Data Analysis window, select Co
elation.
Click OK.
Step 6
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
When the Co
elation window opens, in the field next to Input Range: enter the range of cells that contains all four variables and associated values, including the variable labels.
Check the box next to Labels in First Row.
Click the bu
le next to New Worksheet Ply.
If you would like, next to New Worksheet Ply:, type in what you would like to name the new sheet. Here, “Co
elations” is entered in the field.
Click OK.
Step 7
5
1
2
3
4
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
The sheet that we named “Co
elations” should open automatically, and this sheet contains the co
elation matrix we requested.
The following co
elation coefficients in the matrix represent the validity coefficients, which all happen to be statistically significant:
Proactivity – Customer Service (.391)
Emotional Intelligence – Customer Service (.426)
SJT – Customer Service (.417)
Note that the validity coefficients are all of about the same magnitude. We can describe the magnitude of a co
elation (validity) coefficient as follows:
.10 (negligible)
.10 ̶̶ .29 (small)
.30 ̶ .49 (medium)
.50 ̶ 1.00 (large)
These three validity coefficients can be considered medium in magnitude.
Step 8
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Now, take note of the co
elations between the selection procedure variables. They are as follows:
Proactivity – Emotional Intelligence (.318)
Proactivity – SJT (.237)
SJT – Emotional Intelligence (.932)
The co
elations between proactivity and emotional intelligence and between proactivity and SJT are small-to-medium in magnitude, which indicates that there is not much redundancy (shared variance) between them. The co
elation between SJT and Emotional Intelligence, however, is concerning, as the co
elation is nearly 1.00, which would indicate 100% redundancy (100% shared variance). As a rule of thumb, variables that share a co
elation of .85 or higher can be considered nearly indistinguishable. This very high co
elation indicates that we should pick the least resource-intensive and costly selection procedure of the two. For the time being, let’s assume the SJT procedure is considerably less costly and results in virtually no disparate (adverse) impact. Thus, the next step is to determine how to weight proactivity and SJT using regression.
Step 9
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Now we’re ready to run a multiple linear regression analysis to determine the respective regression weights for the proactivity and SJT in relation to customer service when included in the same model.
Excel can be a bit fussy when it comes to how the variables are ordered when running a regression analysis. Specifically, the predictor variables need to be in adjacent columns. As such, let’s move the emotional intelligence column to the leftmost column, as we won’t need it for the time being.
First, select the column containing Emotional Intelligence, and cut the cells by holding CTRL+X (or Command+X on a Mac).
Step 10
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Second right click on the header of the leftmost column (A).
Third, select Insert Cut Cells.
Step 11
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Now the variables are in an order that will be amenable to multiple linear regression analysis in Excel.
Step 12
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
Click on the Data tab.
Click on the Data Analysis button.
Step 13
Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020.
To specify our multiple linear regression model, in the Data Analysis window, select Regression.
Click OK.
Step 14
Oct 23, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here