Hello, Please look at the document "excel assignment 7 - instructions" and follow the instructions...

Question

Hello, Please look at the document "excel assignment 7 - instructions" and follow the instructions to complete "excel assignment 7 - question". Then answer the four questions asked at the end of "excel assignment 7 - instructions" (slide 26)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 correlation 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 concurrent 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 correlation 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 correlation matrix that contains the intercorrelations between the three selection procedure scores and the customer service job performance scores. To do so, in the Data Analysis window, select Correlation. Click OK. Step 6 Bauer, Human Resource Management, First Edition. SAGE Publishing, 2020. When the Correlation 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 bubble 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, “Correlations” 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 “Correlations” should open automatically, and this sheet contains the correlation matrix we requested.  The following correlation 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 correlation (validity) coefficient as follows:

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

Get Answer To This Question

Related Questions & Answers

Submit New Assignment