Using the data of Norge Electronics compensation (attached excel file), create a (linear) wage

curve about basic salary of Norge Electronic and copy the wage curve here. (Hint: use a scatter

plot in excel).

Norge Electronics (Portugal), S.A. (in Euros) L Freidrickson Svenson J Silva Fonseca ancartes 20 18 17 17 MOPOINT 1500 1130 9 80 980 BASE SALARY 137,200 100,800 107,400 87,080 BONUS NA NA 21,560 9.000 594 594 594 4.752 3.456 3.456 3.456 NA NA 129,360 96,080 53,800 49,900 40,200 67 400 17,150 12,600 13,475 10,895 5.600 5.425 4.200 7000 NA NA 146,885 110,421 59,994 55,919 44,994 75.560 15 Director Geral Director Comercial s Director Administrativo Director Equipas Director Controlo Clientes Accounting Supervisor Treasurer Lider Equipa N2 Lider Equipa N1 Lider Equipa CIS P 7 40 44900 9.000 594 594 694 P Pereira AP Argento Serra M Pronto 1 3 12 11 11 5 60 490 4 20 43,400 33,600 56,000 50 400 6.500 6.600 1,400 5.000 2.160 420 55.400 2.160 6300 63.960 Paiva 11 420 47,600 4,850 52.450 2.160 5.950 6 0,560 300 31,500 6.200 37.700 1,464 3.938 43,102 8 8 8 300 30,800 6.300 37.100 1,464 3.850 4 2414 32400 300 300 300 300 300 6.500 .200 3.500 2310 2310 1.464 1.464 1,464 1.464 1.464 31,240 25,600 25,410 25,410 23.100 3.239 3.256 2.988 2.888 2.889 37,102 35,959 30,952 29,762 29,762 8 8 300 1.464 2.88 27,452 eira 8 23.100 1,454 1,990 980 $ 1 396 7 Tech Rep Level V (N2) Ribeiro Tech Rep Level IV (N2) MAntunes Tech Rep Level V(CIS) F Franco Tech Rep Level V (N1) M Pacheco Tech Rep Level III (CIS) W Vieira Tech Rep Level III (CIS) M Pinheiro Tech Rep Level IV (N1) JL Carvalho Tech Rep Level III (N2) Nogeira Tech Rep Level III (N2) S Andres Tech Rep Level 11 (N2) Sobral import/Export Clerk Ferreira Tech Rep Level 1 (CIS) P Camara Tech Rep Levell(N1) MAntonio Tech Rep Levell(N2) E Lemos Tech Rep Level (CIS) L Modesto Tech Rep Level 1 (N2) J Cruz Bookkeeper PCosta Senior Sales Clerk Jesus Warehouse Manager P Santos Clerk (N1) JL Reis Clerk (N2) Castelhano Clerk (N1) R Coutinho Clerk (N2) CJ Gouveia Clerk (C/S) P Santos Silva 7 7 7 25,900 25,040 23,100 23,100 23,100 23,100 23,100 18,900 9,600 16,800 16,800 16,800 16,900 16,800 19,890 20,720 17,920 18,200 18,200 17,500 17,500 17,360 1 20,790 20,540 16,800 16,800 16, 900 16,800 16,900 21,880 24,870 19,720 18,200 18,200 300 300 300 2 50 250 250 280 2 50 250 230 230 2 00 200 200 2 00 200 1.464 1,464 .464 1.464 1.464 2.363 2450 2.100 2.100 2.100 2.100 2.100 2.495 2.590 2240 2.275 2.275 24.617 23,426 20,364 20,364 20,364 20,364 20,364 24,761 27,866 22,356 20,871 20,871 7 7 6 6 2.000 4.160 1.800 3 96 396 396 396 396 5 S 17,500 396 2.188 20,084 5 17,500 396 2.189 20,094 5 17,360 396 2,170 19,926