Question

1. The human resources manager at Humber Electronics is interested in relating an employee’s score on a job satisfaction questionnaire to his or her length of service, hourly wage rate, and workload. She defined the variables as follows:
   
   x₁ = number of years with company
   
   x₂ = number of years in current position
   
   x₃ = annual salary (in thousands of dollars)
   
   x₄ = workload (number of hours worked per week)
   
   y = job satisfaction score (out of 15)
   
   The HR manager randomly selected relevant information (see below) about 30 employees. Using Excel, obtain the regression output for the data and answer the following questions:
   1. Explain the meaning of the b₃ coefficient as it relates to this data. [5 point]
      
   2. Calculate the coefficient of determination ( R² ) (4 decimal places). Explain the meaning as it relates to this data. [10 point]
      
   3. State the values of the adjusted coefficient of determination and the standard error of estimate (4 decimals). [5 point]
      
   4. Estimate the job satisfaction score for an employee with 10 years with the company, 4 years in the same position, who is paid $35,450 annually and works 35 hours per week . [5 point]

Employee	Years with company	Years in Current Postion	Annual Salary ($000)	Workload	Job Satisfaction Score
1	12	11	53	33	16
2	9	7	35	31	17
3	11	8	42	32	16
4	10	6	53	30	14
5	8	8	60	37	14
6	14	10	44	37	16
7	11	10	36	25	20
8	20	17	51	35	18
9	10	10	57	40	15
10	19	18	51	37	19
11	12	8	35	36	16
12	5	3	53	40	12
13	18	16	40	35	20
14	11	9	40	33	17
15	13	13	58	36	16
16	6	2	50	33	12
17	10	6	37	27	16
18	10	8	38	25	17
19	6	4	54	32	12
20	19	18	46	27	19
21	19	19	51	26	18
22	20	16	45	31	19
23	15	12	38	39	17
24	17	16	54	25	17
25	13	13	54	27	15
26	17	15	53	28	17
27	5	2	38	35	13
28	17	14	39	37	18
29	7	6	58	38	11
30	14	14	42	37	16

Answer 1