Model Building: Create the best multiple regression model you can to predict the employee's productivity. Justify the selection of suitable quantitative variables (Search for influential productivity factors in business papers. Test the significance of the model and independent variables, Check for multicollinearity. Interpret the value of R2). Use the data of the first sample (Alpha Company)

1	2023	Female	A	37	14	78	80	75	2	112	2.5	7	89
2	2023	Female	A	40	15	100	90	75	2	133	2.5	8	90
3	2023	Male	B	20	1	110	75	75	3.5	132	2.5	8	70
4	2023	Female	B	37	9	74	75	75	2	179	2.5	8	83
5	2023	Male	B	66	15	101	84	75	2.5	213	1.5	9	90
6	2023	Female	D	21	1	90	85	75	2	99	1.5	9	70
7	2023	Female	B	25	5	85	78	75	2	128	2.5	9	70
8	2023	Male	D	69	30	100	97	75	2	167	2.5	9	115
9	2023	Female	C	19	1	30	83	75	2	121	2.5	9	75
10	2023	Male	D	26	2	67	80	75	1	176	1	3	78
11	2023	Male	B	46	5	90	75	75	1.5	185	1	2	80
12	2023	Female	A	44	4	67	94	75	2	135	1.5	4	80
13	2023	Female	B	50	25	40	87	75	2	142	2.5	1	105
14	2023	Female	B	63	23	80	88	75	2	168	2.5	7	107
15	2023	Male	B	48	24	85	81	75	2	163	2.5	6	108
16	2023	Male	A	27	3	90	91	75	2	567	2.5	7.5	100
17	2023	Male	A	32	6	69	76	75	2	152	2.5	8	58
18	2023	Female	A	28	14	60	99	75	1	112	2.5	6	90
19	2023	Male	D	36	18	75	80	75	6	195	1	6	98
20	2023	Male	D	43	8	55	97	75	5	179	2.5	6	68
21	2023	Female	D	21	2	20	81	75	2	117	1.5	7.5	76
22	2023	Female	C	33	8	75	75	75	2.5	125	1.5	9	84
23	2023	Female	A	29	2	35	92	75	2	130	2.5	8	75
24	2023	Male	B	49	20	85	75	75	2	185	5	8	100
25	2023	Male	C	24	2	80	89	75	2	133	5	6.5	77
26	2023	Male	D	36	18	70	95	75	2	163	1.5	3	99
27	2023	Female	A	34	12	65	83	75	2	140	2.5	8	90
28	2023	Female	B	36	18	79	82	75	2	142	3	8	90
29	2023	Male	C	29	4	50	75	75	2	155	3	4	80
30	2023	Male	D	42	6	432	88	75	2	169	2.5	3	80
ID	Identifier
Gender	Female or Male
Language	Foreign language spoken by employees; A, B, C & D
Age	# of years
Experience	# of years in relavent industry
Education Status	High School Certificate, Diploma, Degree
Marital Status	Single or Married
Smoking Status	Yes: Smoker or No: Non Smoker
IQ	IQ Test Scores
Training	Employee Training Scores. 100 scores is expected
Location	Site Locations: AB, BC & ON
Income	$75 per 1 pc.
Overtime	# of hours a week
Weight	Employee weight is given in pound
Exercise	# of hours employee exercises on Gym per week
Facebook	# of hours employee spends on facebook per week
Leadership	Assessment of Leadership: Not Effective, Neutral or Effective
Work Environment	Assessment of work Environment: Not Supportive, Neutral or Supportive
Productivity	Productivity Scores. 100 pcs a month is expected from each employee