A German human resource analyst would like to study the main contributing factors of the base salaries of employees in Germany. He selects age, competence level and gender of the employees to predict the yearly salaries. He collects the data of a sample of 250 employees from Germany ('Employee'). Only those employees are surveyed, who have been working at the company for more than a year.

a. State the multiple regression equation.

b. Are there any predictors, which do not have significant contribution to the model? Justify your answer. (need to calculate H0 , H1 , p_value)

c. Interpret the meaning of the slope that belongs to the predictor: gender.

d. Compute the relative standard error of the estimate and interpret its meaning.

e. What is the residual value in case of the employee #14.

use Excel.

I need clear short answers for the Interpretation

#	Age (years)	Gender (1-Male)	Service at the company (month)	Yearly Base Salary ()	Yearly Benefits ()	Competence level (0-100)	Education
1	30	1	79	38,894	12,314	40	Diploma
2	44	1	98	71,643	13,112	85	Diploma
3	23	0	23	23,588	3,374	22	College
4	39	1	54	36,151	5,797	47	College
5	38	0	15	57,500	7,238	65	Diploma
6	53	1	98	45,113	7,871	70	High School
7	39	0	30	25,594	3,730	30	College
8	41	1	60	50,327	2,640	51	Master
9	57	1	94	116,266	18,928	60	Diploma
10	27	0	18	30,000	17,194	23	Diploma
11	38	1	99	42,317	13,149	25	Diploma
12	38	0	43	51,141	5,320	50	College
13	30	1	36	50,156	5,450	57	Diploma
14	27	0	22	39,000	3,988	30	Master
15	35	0	85	31,258	555	52	Master
16	33	0	37	20,503	4,588	50	Diploma
17	33	1	40	49,581	4,961	55	Master
18	35	0	67	32,335	6,045	35	College
19	44	0	89	45,416	7,024	70	Master
20	32	0	37	24,065	6,342	40	Diploma
21	41	1	13	26,250	2,013	25	College
22	40	1	45	71,544	13,261	70	Master
23	27	1	14	39,000	4,416	20	Master
24	57	1	66	49,690	2,728	25	High School
25	62	0	60	59,289	21,330	80	High School
26	34	0	94	12,476	3,213	40	High School
27	41	1	78	81,150	17,235	85	Master
28	31	0	20	30,491	6,708	25	Diploma
29	41	1	38	53,934	16,839	55	Diploma
30	39	0	146	52,701	17,122	60	Diploma
31	31	0	18	46,091	1,320	40	College
32	41	1	66	49,270	2,728	35	High School
33	51	1	88	180,000	31,278	91	Master
34	34	1	41	41,068	7,456	55	Diploma
35	50	0	112	53,790	16,352	40	Diploma
36	41	1	98	40,625	8,413	60	High School
37	53	1	98	39,272	7,862	60	High School
38	38	0	44	65,856	12,434	65	Master
39	37	1	60	43,636	7,334	65	Diploma
40	58	1	66	43,398	7,057	30	High School
41	37	1	58	49,590	7,514	55	Diploma
42	53	1	94	101,536	19,123	65	High School
43	32	1	14	30,360	6,607	30	High School
44	61	1	77	87,293	12,285	95	Diploma
45	29	1	23	41,820	7,450	45	Master
46	36	0	24	30,491	10,651	35	Diploma
47	42	1	46	52,554	4,999	50	Master
48	42	0	37	42,832	6,807	65	Master
49	49	1	39	105,465	17,614	80	Master
50	44	1	128	104,975	17,141	75	Diploma
51	35	0	38	44,288	6,681	40	Master
52	32	1	64	47,115	403	25	Master
53	32	0	57	55,099	8,649	80	Diploma
54	51	0	20	56,250	12,757	50	Diploma
55	36	1	66	48,726	7,527	70	Master
56	33	0	21	33,142	6,179	35	Diploma
57	23	1	37	38,990	3,335	40	Master
58	37	1	23	43,695	11,946	50	Diploma
59	44	0	68	58,373	14,535	45	Diploma
60	46	1	213	48,340	20,244	70	Diploma
61	38	0	18	48,000	7,200	62	Master
62	38	0	20	40,000	4,011	55	Master
63	37	1	15	55,000	5,823	50	Master
64	34	0	31	50,857	15,651	55	College
65	48	1	127	37,581	807	60	High School
66	30	1	35	42,534	7,572	42	Master
67	41	0	105	49,349	19,115	50	College
68	40	0	223	59,269	17,949	60	Diploma
69	27	1	17	39,000	5,846	40	Master
70	47	1	64	42,833	3,570	30	High School
71	31	1	25	32,829	4,725	35	Master
72	30	0	47	27,149	3,823	30	College
73	36	1	79	65,434	12,798	70	Diploma
74	36	1	36	26,937	3,688	60	Diploma
75	32	0	51	32,398	5,198	50	College
76	33	1	63	46,201	4,310	35	Diploma
77	49	0	77	29,973	4,592	47	College
78	36	1	83	49,297	2,841	65	Master
79	43	0	91	66,000	4,888	65	Master
80	30	1	24	39,781	4,470	50	Master
81	24	1	18	11,531	1,831	20	College
82	39	1	16	38,049	1,192	75	College
83	38	1	116	40,929	822	37	High School
84	34	1	36	39,819	833	75	Master
85	41	1	66	40,974	2,850	25	High School
86	61	1	61	112,487	19,470	80	College
87	30	0	26	40,561	5,364	25	Master
88	29	0	27	17,033	1,584	25	Diploma
89	52	1	66	38,709	2,728	25	High School
90	28	0	20	38,445	8,768	50	Master
91	43	0	15	42,350	8,191	55	High School
92	38	1	119	70,284	23,479	80	Master
93	34	1	15	31,250	4,069	30	Diploma
94	41	0	102	32,059	3,324	35	College
95	56	0	66	48,460	7,348	25	High School
96	45	1	58	60,463	11,612	70	Diploma
97	37	1	52	55,000	3,327	45	Master
98	46	0	90	106,128	8,421	85	Diploma
99	42	1	69	86,867	17,869	81	Master
100	49	1	98	47,112	9,244	60	Diploma
101	49	0	83	90,072	29,695	80	Master
102	32	1	36	64,874	926	83	Master
103	35	0	14	31,460	6,606	40	Diploma
104	39	0	22	34,468	7,368	35	Diploma
105	27	0	14	29,124	2,755	35	Master
106	30	1	47	48,612	3,788	55	Master
107	24	1	41	34,479	2,891	30	High School
108	39	1	48	47,021	4,727	40	Master
109	38	1	20	63,066	7,858	65	Master
110	44	1	72	59,635	9,282	80	Diploma
111	37	1	41	55,882	5,622	51	College
112	27	1	37	32,210	10,685	35	Diploma
113	46	0	66	38,427	2,728	25	High School
114	43	0	90	59,178	9,998	75	Diploma
115	49	0	24	29,744	6,492	40	College
116	32	1	48	46,477	9,621	70	Master
117	37	1	103	51,339	555	55	Master
118	38	0	71	37,375	3,928	50	Diploma
119	41	1	21	40,350	4,407	80	Diploma
120	35	1	131	38,153	11,404	40	Master
121	53	1	203	52,697	15,955	50	High School
122	38	1	70	36,168	11,276	35	Diploma
123	55	1	66	41,830	7,249	30	High School
124	44	1	61	67,904	11,367	70	Master
125	28	1	15	39,000	4,828	40	Master
126	34	0	52	36,300	2,940	30	Diploma
127	30	0	47	42,874	9,222	40	Master
128	53	1	43	94,382	26,867	90	Master
129	38	1	14	45,000	6,858	45	Master
130	33	0	14	16,678	2,112	45	Diploma
131	29	1	57	41,824	4,314	51	Master
132	45	1	48	54,844	17,973	55	High School
133	56	1	141	61,199	20,989	83	College
134	38	1	83	91,738	24,211	87	Diploma
135	45	1	36	24,681	3,428	30	College
136	52	0	89	70,273	20,421	86	College
137	49	1	65	55,938	5,835	50	Master
138	32	1	46	43,073	7,327	50	Master
139	31	1	48	41,419	7,373	45	Master
140	39	1	69	60,497	6,036	60	Master
141	43	1	98	32,635	7,491	30	High School
142	44	1	113	59,587	8,968	60	High School
143	35	0	46	55,400	5,512	70	High School
144	42	0	98	33,515	7,521	60	High School
145	35	0	37	28,570	3,923	40	Diploma
146	30	1	17	39,000	6,040	40	Master
147	29	0	23	40,171	7,845	51	Master
148	46	0	105	42,966	4,481	50	Diploma
149	29	0	24	36,894	5,812	35	Master
150	45	0	43	49,221	6,603	50	Diploma
151	35	0	116	33,546	6,132	60	College
152	47	1	204	74,520	26,071	80	Diploma
153	40	1	76	60,725	9,576	65	Master
154	26	0	91	27,500	3,543	30	Diploma
155	41	0	18	19,018	1,734	25	Diploma
156	47	1	102	71,845	10,658	35	Diploma
157	38	1	28	42,870	980	35	High School
158	34	0	40	43,929	8,246	45	Master
159	26	0	13	39,000	3,734	40	Master
160	48	0	72	70,495	9,856	65	College
161	47	1	141	63,543	18,088	82	College
162	55	1	65	60,743	8,029	60	High School
163	41	1	102	55,174	5,072	45	College
164	52	1	123	101,250	9,833	85	Master
165	41	1	32	29,038	4,568	30	High School
166	35	1	37	27,662	10,220	25	Diploma
167	30	0	24	27,955	3,314	40	College
168	24	0	25	27,071	6,539	25	High School
169	31	1	100	30,231	9,524	35	High School
170	50	0	76	48,340	14,350	50	Master
171	51	1	45	79,149	13,288	75	Master
172	46	1	45	33,354	11,443	45	Diploma
173	64	1	81	65,702	12,347	50	College
174	51	1	87	83,371	15,888	70	Master
175	34	1	85	72,866	8,349	76	Master
176	28	0	41	22,584	2,721	45	Diploma
177	38	1	48	37,961	3,518	35	Master
178	35	0	81	44,564	6,239	45	Master
179	35	0	62	45,242	14,080	65	Master
180	32	1	48	44,315	6,408	60	Master
181	30	0	37	33,465	4,826	48	College
182	55	1	66	45,446	2,728	25	High School
183	32	1	103	34,406	11,110	35	Diploma
184	43	1	22	39,770	3,437	35	High School
185	48	1	27	58,661	6,330	50	Master
186	36	0	24	41,996	5,796	35	Master
187	54	1	68	36,789	6,005	60	College
188	27	1	27	37,440	4,511	60	Diploma
189	51	1	13	158,774	17,835	100	Diploma
190	44	1	42	69,970	19,071	85	Diploma
191	45	1	26	54,784	3,652	55	Diploma
192	37	1	82	68,103	11,897	81	Master
193	46	1	133	35,988	11,882	35	Diploma
194	46	1	38	28,286	5,830	30	Diploma
195	44	1	27	93,404	14,947	85	Master
196	31	0	113	31,325	5,172	42	College
197	38	0	100	28,925	5,211	33	College
198	38	1	62	51,184	838	50	Diploma
199	50	1	38	54,303	17,343	56	College
200	37	0	90	62,192	14,873	75	Master
201	38	0	58	76,593	11,382	75	Master
202	34	0	24	45,778	7,992	45	Master
203	38	1	56	66,461	16,254	65	Master
204	29	1	17	33,750	4,280	33	College
205	30	0	72	42,749	5,571	65	Diploma
206	40	0	84	32,225	5,174	30	High School
207	39	1	40	61,678	15,541	45	Master
208	52	1	75	58,182	15,907	60	College
209	47	1	83	73,038	7,905	55	Diploma
210	37	1	114	37,007	8,063	35	High School
211	31	0	63	53,348	12,087	60	Master
212	32	1	18	14,746	1,605	25	College
213	48	0	71	64,479	11,367	65	Master
214	41	0	65	41,675	6,749	60	Diploma
215	40	1	70	71,227	23,156	80	Diploma
216	38	0	65	31,223	6,006	30	Diploma
217	36	1	19	39,000	4,890	10	Diploma
218	42	0	98	24,772	4,532	30	Diploma
219	42	1	98	38,671	5,869	65	High School
220	35	0	48	44,315	4,473	50	Master
221	53	1	70	108,660	30,105	80	High School
222	33	1	38	44,185	6,747	50	Diploma
223	38	1	22	49,440	6,631	50	Diploma
224	50	1	39	103,144	29,208	70	Diploma
225	26	0	16	42,106	3,146	40	Master
226	57	1	141	52,684	9,783	58	College
227	40	1	65	41,032	15,034	42	High School
228	44	1	82	83,399	18,542	60	Master
229	30	1	104	44,000	2,728	40	Diploma
230	39	1	160	34,235	11,661	35	Diploma
231	30	1	40	44,163	5,280	55	Master
232	45	1	38	46,370	14,756	50	High School
233	29	1	15	36,000	4,757	20	Diploma
234	29	1	13	39,000	3,282	51	Master
235	45	1	79	83,780	15,153	80	Master
236	28	1	22	40,171	7,366	25	Master
237	35	0	18	35,000	4,294	30	Diploma
238	33	0	54	39,000	2,662	40	Master
239	32	1	25	31,875	4,107	30	College
240	44	1	88	97,029	14,480	80	Master
241	35	1	55	37,220	3,142	35	Diploma
242	39	1	57	53,052	8,022	55	Master
243	25	0	16	9,759	1,266	10	High School
244	52	0	60	62,387	5,295	50	High School
245	61	1	66	133,882	17,835	80	High School
246	36	1	65	52,795	8,326	60	Diploma
247	50	0	17	28,955	1,538	50	Diploma
248	48	0	87	40,649	3,158	40	Diploma
249	33	0	51	44,315	4,886	45	Master
250	61	1	66	50,497	2,728	25	High School

.