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