1. Using the data of Norge Electronics compensation given in the following table, create a (linear) wage curve about basic salary of Norge Electronic and copy the wage curve here. (Hint: use a scatter plot in excel).

2. What is the regression line of the wage curve in the above question? (The regression line looks like Y = a X + b)

3. What is the expected basic salary for a job in Norge Electronic that has a job grade midpoint of 600?

Position	Incumbent	Employee level	job grade midpoint	Base salary	Bonus	Total case	Lunch subsidy	Auto benefit	Other benefits	Total Compensation
Director genersl	L Freidrickson	20	1500	137,200	NA	NA	594	4752	17150	NA
Director Commercial	S Svenson	18	1130	100,800	NA	NA	594	3456	12,600	NA
Director administrative	J silva	17	980	107,800	21,580	129,360	594	3456	13,475	146,885
Director equipas	H Fonseca	17	980	87080	9000	96080		3456	10885	110,421
Director controlo clients	N Abrantes	15	740	44,800	9000	53800	594		5600	59994
Accounting supervisor	P Pereira	13	560	43,400	6500	49900	594		5425	55919
treasurer	AP Argento	12	490	33,600	6600	40200	594		4200	44994
Lider Equipa N2	J Serra	11	420	56,000	11,400	67400		2160	7000	76560
Lider Equipa N1	M Pronto	11	420	50,400	5000	55400		2160	6300	63860
Lider Equipa c/s	P Paiva	11	420	47,600	4850	52450		2160	5950	60560
Tech rep level V N2	L Ribeiro	8	300	31,500	6200	37700		1464	3938	43102
Tech rep level IV N2	M Antunes	8	300	30,800	6300	37100		1464	3850	42414
Tech rep level V (c/s)	F Franco	8	300	25,900	6500	32240		1464	3238	37102
Tech rep level V (N1)	M Pacheco	8	300	26,040	6200	31240		1464	3255	35959
Tech rep level III (c/s)	W Vieira	8	300	23,100	6500	26600		1464	2888	30952
Tech rep level III (c/s)	M Pinheiro	8	300	23,100	2310	25410		1464	2888	29762
Tech rep level IV (N1)	JL Carvalho	8	300	23,100	2310	25410		1464	2888	29762
Tech rep level III (N2)	L Nogeira	8	300	23,100		23100		1464	2888	27452
Tech rep level III (N2)	S Andres	8	300	23,100		23100		2160	2888	28148
Tech rep level II (N2)	T Sorbal	8	300	18,900	1890	20790		1464	2363	24617
Import/ export clerk	R Ferreira	8	300	19,600	980	20580	396		2450	23426
Tech rep level I (c/s)	P Camara	7	260	16,800		16800		1464	2100	20364
Tech rep level I (N1)	M Antonio	7	260	16,800		16800		1464	2100	20364
Tech rep level I (N2)	E Lemos	7	260	16,800		16800		1464	2100	20364
Tech rep level I (c/s)	L mOdesto	7	260	16,800		16800		1464	2100	20364
Tech rep level I (N2)	J Cruz	7	260	16,800		16800		1464	2100	20364
Bookkeeper	P Costa	7	260	19,880	2000	21880	396		2485	24761
Senior sales clerk	S Jesus	6	230	20,720	4150	24870	396		2590	27856
Waterhouse manager	P Santos	6	230	17,920	1800	19720	396		2240	22356
Clerk (N1)	JL Reis	5	200	18,200		18200	396		2275	20871
Clerk (N2)	H Castelhano	5	200	18,200		18200	396		2275	20871
Clerk (N1)	R coutinhno	5	200	17,500		17500	396		2188	20084
Clerk (N2)	CJ Gouveia	5	200	17,500		17500	396		2188	20084
Clerk (c/s)	P santo Silva	5	200	17,360		17360	396		2170	19926