Question

Employee # Perf. Rating Cognitive Ability Emotional Intelligence y-hat (to be calculated) 1 1 56 3.5...

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?

Homework Answers

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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Listed in the accompanying data table are student evaluation ratings of courses and​ professors, where a...
Listed in the accompanying data table are student evaluation ratings of courses and​ professors, where a rating of 5 is for​ "excellent." Assume that each sample is a simple random sample obtained from a population with a normal distribution. a. Use the 93 course evaluations to construct a 98​% confidence interval estimate of the standard deviation of the population from which the sample was obtained. b. Repeat part​ (a) using the 93 professor evaluations. c. Compare the results from part​...
In a recent year, according to the Bureau of Labor Statistics, the median number of years...
In a recent year, according to the Bureau of Labor Statistics, the median number of years that wage and salary workers had been with their current employer (called employee tenure) was 3.5 years. Information on employee tenure has been gathered since the early 1950's using the Current Population Survey (CPS), a monthly survey of 50,000 households that provides information on employment, unemployment, earnings, demographics, and other characteristics of the U. S. population. With respect to employee tenure, the questions measure...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (1), somewhat satisfied (2), satisfied (3), and very satisfied (4). For each broker summary scores were computed by calculating a weighted average...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (1), somewhat satisfied (2), satisfied (3), and very satisfied (4). For each broker summary scores were computed by calculating a weighted average...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences...
The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (1), somewhat satisfied (2), satisfied (3), and very satisfied (4). For each broker summary scores were computed by calculating a weighted average...
Student What is your height in inches? What is your weight in pounds? What is your...
Student What is your height in inches? What is your weight in pounds? What is your cumulative Grade Point Average (GPA) at FTCC or your primary college? How many hours do you sleep each night? 1 67 100 4 7 2 62 105 4 5 3 72 120 4 8 4 61 125 4 7 5 56 105 3.7 6 6 61 120 4 7 7 65 172 3.8 7 8 72 235 3.22 5 9 63 135 4 6...
home / study / math / statistics and probability / statistics and probability questions and answers...
home / study / math / statistics and probability / statistics and probability questions and answers / the american association of individual investors (aaii) on-line discount broker survey polls ... Question: The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls memb... Edit question The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed...
Year-Year Percent Change in Commodities CPI Year-Year Percent Change in Services CPI Year Commodities% Services% 1960...
Year-Year Percent Change in Commodities CPI Year-Year Percent Change in Services CPI Year Commodities% Services% 1960 0.9 3.4 1961 0.6 1.7 1962 0.9 2.0 1963 0.9 2.0 1964 1.2 2.0 1965 1.1 2.3 1966 2.6 3.8 1967 1.9 4.3 1968 3.5 5.2 1969 4.7 6.9 1970 4.5 8.0 1971 3.6 5.7 1972 3.0 3.8 1973 7.4 4.4 1974 11.9 9.2 1975 8.8 9.6 1976 4.3 8.3 1977 5.8 7.7 1978 7.2 8.6 1979 11.3 11.0 1980 12.3 15.4 1981 8.4...
Please show your work 11.3.2 Levi-Strauss Co manufactures clothing. The quality control department measures weekly values...
Please show your work 11.3.2 Levi-Strauss Co manufactures clothing. The quality control department measures weekly values of different suppliers for the percentage difference of waste between the layout on the computer and the actual waste when the clothing is made (called run-up). The data is in table #11.3.3, and there are some negative values because sometimes the supplier is able to layout the pattern better than the computer ("Waste run up," 2013). Do the data show that there is a...
While job opportunities for men and women are considerably more balanced than they were 40 years...
While job opportunities for men and women are considerably more balanced than they were 40 years ago, the career aspirations may still differ. Is there a difference in majors chosen by men and women? Using the sample of 200 MBA students (in the data file), conduct a Chi Square Test of Independence to determine if one's choice of major is independent of their gender. Use a .05 significance level. ID Gender Major Employ Age MBA_GPA BS GPA Hrs_Studying Works FT...