An efficiency expert wants to determine whether the time an assembly worker requ

Question

An efficiency expert wants to determine whether the time an assembly worker requires to perform a standard task might be related to 1) number of years on the job, 2) the score on a pre-employment aptitude test, and 3) the shift they are working.

The data collected is in the file Employees.xlsx. Please see data below.

Calculate the 90% confidence interval for the partial coefficient score they received on the aptitude test. Provide the upper limit of the confidence interval.

Time Years TestScore Shift 52 7 73 Morning 48 14 78 Morning 56 8 71 Night 52 6 75 Morning 48 10 78 Afternoon 45 6 78 Afternoon 42 10 80 Afternoon 51 11 72 Night 51 10 79 Night 53 6 77 Night 47 8 79 Morning 45 12 84 Afternoon 49 12 72 Afternoon

Explanation / Answer

we can do the analysis in excel

fill all the data in a tabular form.

all other data is numeric rater than shift we will convert into dummy variable

morning=0

afternoon=1

night=2

go to data>data analysis>regression

input y - select the range of time

input x- selected all the range of 3 independent variables - years,test scores, shift

click on labels if you included labels-time,year,stest score, shift in the data

select confidence interval 90%

select output cell where you want the output to be shown

click ok

the summary of regression will be shown

upper limit of test score at 90% confidence level is -0.230000428

(the calculation is shown below)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.