Reference no: EM1320817

Q1) Human Resources Department at large corporation hired statistician to collect and process data on productivity of their factory workers.  As they wished a report "on the double," statistician collected a random sample of 20 workers and processed data by multiple regression program in Excel.  Below are the data.

Employee	Job Satisfaction (Y)	Productivity (X1)	Dexterity  (X2)
1	56	24	48
2	58	26	52
3	60	29	59
4	50	22	43
5	54	23	47
6	61	26	54
7	59	27	58
8	63	31	63
9	69	35	75
10	57	36	55
11	70	38	70
12	67	34	68
13	72	40	71
14	50	20	42
15	68	24	70
16	52	25	50
17	59	26	58
18	74	42	74
19	70	40	68
20	75	52	70

a) Write down the multiple regression equation.

b) Assume HR hires new group of factory workers as they have received new contract for additional work.  Determine the predicted job satisfaction rating for new employee who has worked for 3 months in factory and has earned a score of 33 in productivity and 65 in dexterity by his supervisor?  Illustrate your procedure.

c) What percentage of variation in job satisfaction is described by combined variation in productivity and dexterity? 

d) Is global F ratio significant?  Identify this F ratio, and describe whether it is important.

c) Is coefficient for X1 (productivity) significant?  How do you know?  Mention its t value and accompanying P-value.

d) Is coefficient for X2 (dexterity) significant?  How do you know?  Mention its t value and accompanying P-value.