1. Using the data of Norge Electronic's compensation (attached excel file), add (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?

Norge Electronics (Portugal), S.A. (in Euros) JOB GRADE LUNCH AUTO OTHER POSITION INCUMBENT Employee Level MIDPOINT BASE SALARY TOTAL BONUS TOTAL CASE SUBSIDY BENEFIT BENEFITS COMPENSATION 3 Director Gera L Freidrickson 20 1500 137,200 NA NA 594 4,752 17,150 NA Director Comercial S Svenson 18 1130 100,800 NA NA 594 3.456 12,600 NA 5 Director Administrativo J Silva 17 980 107,800 21,560 129,360 594 3,456 13,475 146,885 Director Equipas H Fonseca 17 980 87,080 9,000 96,080 3,456 10,885 110,421 Director Controlo 740 Cliente N Abrantes 15 44.800 9,000 53,800 594 5,600 59,994 Accounting Supervisor P Pereira 13 560 43,400 ,500 49,900 594 5,425 55.919 Treasurer AP Argento 12 490 33,600 6,600 10,200 594 4.200 44,994 10 Lider Equipa N2 J Serra 11 420 56,000 11.400 67,400 2,160 7.000 76,560 11 Lider Equipa N1 M Pronto 11 420 50,400 5,000 55,400 2,160 6,300 63,860 12 Lider Equipa C/S P Paiva 11 420 47,600 4.850 52.450 2,160 5,950 60.560 13 Tech Rep Level V (N2) L Ribeiro 8 300 31,500 6,200 37,700 1,464 3,938 43,102 14 Tech Rep Level IV (NZ) M Antunes 8 300 30,800 6,300 37,100 1.464 3,850 42,414 15 Tech Rep Level V (C/S) F Franco 8 300 25,900 6,500 32,400 ,464 3,238 37,102 16 Tech Rep Level V (N1) M Pacheco 8 300 26,040 5,200 31.240 1.464 3.255 35,959 17 Tech Rep Level III (C/S) W Vieira 8 300 23,100 3,500 26,600 1,464 2.888 30,952 18 Tech Rep Level III (C/S) M Pinheiro 8 300 23,100 2,310 25,410 1,464 2,888 29,762 19 Tech Rep Level IV (N1) JL Carvalho 8 300 23,100 2,310 25,410 1,464 2888 29,762 20 Tech Rep Level III (N2) L Nogeira 8 300 23,100 23,100 1,464 2,888 27,452 21 Tech Rep Level III (N2) S Andres 8 300 23,100 23,100 2.160 2.888 28,148 22 Tech Rep Level II (N2) T Sobral 8 300 18,900 1,890 20,790 1,464 2 363 24,617 23 Import/ Export Clerk R Ferreira 8 300 19,600 980 20,580 396 2,450 23,426 24 Tech Rep Level I (C/S) P Camara 7 260 16,800 16,800 1,464 2,100 20,364 25 Tech Rep Level I (N1) M Antonio 7 260 16,800 16,800 1,464 2,10 20,364 26 Tech Rep Level I (N2) E Lemos 260 16,800 16,800 1.464 2,100 20,364 27 Tech Rep Level I (C/S) L Modesto 260 16,800 16,800 1,464 2,100 20,364 28 Tech Rep Level I (N2) J Cruz 260 16,800 16,800 1,464 2,100 20,364 29 Bookkeeper P Costa 7 260 19,880 2,000 21,880 396 2,485 24,761 23030 Senior Sales Clerk Warehouse Manager P Santos 6 230 17,920 1,800 31 19,720 396 2.240 22,356 JL Reis 5 200 18,200 32 Clerk (N1) 18,200 396 2,275 20,871 Clerk (NZ) H Castelhano 5 200 18,200 33 18,200 396 2,275 20,871 5 34 Clerk (N1) R Coutinho 200 17,500 17,500 396 2,188 20,084 Clerk (N2) CJ Gouvela 5 200 17,500 17,500 396 2,188 20,084 Clerk (C/S) P Santos Silva 5 200 17,360 17,360 396 2,170 19,926