Question

Employee #	Perf. Rating	Cognitive Ability	Emotional Intelligence	y-hat (to be calculated)
1	1	56	3.5
2	2	66	3.1
3	3	59	2.9
4	3	67	2.3
5	4	67	3.1
6	4	68	2.6
7	4	69	3.5
8	4	70	3.5
9	4	73	3.2
10	4	77	1.8
11	4	72	3.4
12	4	75	3.5
13	4	76	3.8
14	4	58	2.7
15	5	65	2.8
16	4	67	3.2
17	5	67	3.5
18	5	68	3.5
19	5	76	3.5
20	5	77	2.2
21	5	78	3.1
22	5	79	2.7
23	5	79	2.9
24	5	81	3.5
25	5	82	3.3
26	5	84	2.9
27	5	88	3.5
28	5	92	3.4
29	5	93	2.5
30	5	97	2.1
31	5	68	3.6
32	6	67	3.4
33	6	74	3.5
34	6	73	3.3
35	6	75	3.7
36	6	75	3.9
37	6	75	3.5
38	6	76	3.4
39	6	77	2.7
40	6	78	3.9
41	6	79	3.7
42	6	79	3.9
43	7	79	3.6
44	7	82	3.7
45	7	83	3.2
46	7	88	3.5
47	7	90	3.1
48	7	92	3.3
49	7	94	3.9
50	7	100	2.7
Use the data above to answer the questions.. This is a dataset of a typical validation study, using cognitive ability and emotional intelligence to predict job performance. Thus, this dataset contains the following variables (variable names are across the top): Employee #—employee identification numbers Perf. Rating—the supervisor’s ratings of the employee’s performance Cognitive Ability—total scores on the cognitive ability test Emotional Intelligence—mean scores on the emotional intelligence test A basic understanding of how to calculate functions (i.e., equations) in MS Excel is needed to do this exercise. 1. We decide to use a multiple hurdle approach for promotions, using the pre-employment data we have on the employees. If the hurdles and cutscores are as follows: Hurdle 1: Cognitive Ability, cutscore = 76 Hurdle 2: Emotional Intelligence, cutscore = 3.0 Which employees (by number) would pass the first hurdle and why? Which of those employees who passed the first hurdle would then pass the second hurdle and why? 2. We decide to use a multiple cutoff approach for promotions, using the pre-employment data we have on the employees. If the cutscores are as follows: Cognitive Ability, cutscore = 70 Emotional Intelligence, cutscore = 3.2 Which employees (by number) would we consider for promotion and why? 3. We decide to use a multiple regression approach for promoting employees. Use the equation below to calculate the predicted supervisory rating for each employee (i.e., based on the employee’s actual scores for cognitive ability and emotional intelligence). y-hat = -4.48 + (.08*Cognitive Ability) + (.82*Emotional Intelligence) If we set a minimum cutoff on the predicted supervisory rating of 6.0, which employees (by number) would we consider promoting?

Answer 1

Hi,

Please find the solution below in the colored cells. The corresponding employee numbers are the answers for question 1, 2 and 3.