Although a large number of tasks in the computer industry are robotic, many operations require human workers. Some jobs require a great deal of dexterity to properly position components into place. A large North American computer maker routinely tests applicants for these jobs by giving a dexterity test that involves a number of intricate finger and hand movements. The tests are scored on a 100-point scale. Only those who have scored above 70 are hired. To determine whether the tests are valid predictors of job performance, the personnel manager drew a random sample of 45 workers who were hired 2 months ago. He recorded their test scores and the percentage of nondefective computers they produced in the last week. Determine the regression line and interpret the coefficients by using a 5% significance level. PLEASE ONLY USE EXCEL AND SHOW ALL EXCEL COMMANDS! Test Nondefective 79 93 81 93 79 94 79 91 76 94 81 94 79 94 79 92 82 93 86 93 83 92 78 95 77 92 77 93 80 95 73 95 87 95 75 93 82 96 74 93 81 95 81 95 82 94 73 94 75 94 82 92 87 95 84 94 86 94 79 94 82 95 70 92 86 96 84 94 75 95 75 95 77 93 78 95 76 95 84 94 76 94 78 94 81 94 79 94 78 94
Although a large number of tasks in the computer industry are robotic, many operations require human workers. Some jobs require a great deal of dexterity to properly position components into place. A large North American computer maker routinely tests applicants for these jobs by giving a dexterity test that involves a number of intricate finger and hand movements. The tests are scored on a 100-point scale. Only those who have scored above 70 are hired. To determine whether the tests are valid predictors of job performance, the personnel manager drew a random sample of 45 workers who were hired 2 months ago. He recorded their test scores and the percentage of nondefective computers they produced in the last week. Determine the regression line and interpret the coefficients by using a 5% significance level.
PLEASE ONLY USE EXCEL AND SHOW ALL EXCEL COMMANDS!
Test | Nondefective |
79 | 93 |
81 | 93 |
79 | 94 |
79 | 91 |
76 | 94 |
81 | 94 |
79 | 94 |
79 | 92 |
82 | 93 |
86 | 93 |
83 | 92 |
78 | 95 |
77 | 92 |
77 | 93 |
80 | 95 |
73 | 95 |
87 | 95 |
75 | 93 |
82 | 96 |
74 | 93 |
81 | 95 |
81 | 95 |
82 | 94 |
73 | 94 |
75 | 94 |
82 | 92 |
87 | 95 |
84 | 94 |
86 | 94 |
79 | 94 |
82 | 95 |
70 | 92 |
86 | 96 |
84 | 94 |
75 | 95 |
75 | 95 |
77 | 93 |
78 | 95 |
76 | 95 |
84 | 94 |
76 | 94 |
78 | 94 |
81 | 94 |
79 | 94 |
78 | 94 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images