ASSIGNMENT 7 Name: CIN: 1. Using the data of Norge Electronic's 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). 2. What is the regression line of the wage curve in the above question? (The regression line looks like Yua 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) POSITION TOTAL CASE LUNCH SUBSIDY AUTO BENEFIT OTHER BENEFITS INCUMBENT L Freidrickson Employee Love 20 JOB GRADE MOPOINT BASE SALARY 1500 137,200 1130 100.800 BONUS NA TOTAL COMPENSATION NA Director Geral NA 594 4.752 17,150 Director Comercial S Svenson 18 NA NA 594 3.456 NA 12,600 13,475 17 980 107,800 21,560 129,360 594 3,456 146,885 17 980 87,080 9,000 96,080 3.456 10,885 110,421 Director Administrativo Silva Director Equipas Fonseca Director Controlo Clientes N Abrantes Accounting Supervisor P Pereira 15 740 44.800 9,000 53,800 594 5,600 59.994 13 580 43,400 6,500 49,900 594 5,425 55,919 12 490 33,600 6,600 40.200 594 4,200 44,994 11 420 56,000 11,400 67,400 2.160 7,000 76.560 11 420 50,400 5,000 55.400 2.160 6,300 63,860 11 420 47,600 4,850 52.450 2.160 5,950 60,560 8 300 31,500 6.200 1.464 3,938 43,102 37.700 37,100 300 6,300 1.464 3,850 42.414 30,800 25,900 8 300 6,500 32.400 1,464 3.238 37,102 300 26,040 5,200 31.240 1,464 3,255 35,959 Treasurer AP Argento Lider Equipa NZ J Serra Lider Equipa N1 M Pronto Lider Equipa CIS P Paiva Tech Rep Level V (N2) L Ribeiro Tech Rep Level IV (NZ) Antunes Tech Rep Level V (C/S) F Franco Tech Rep Level V(N1) Pacheco Tech Rep Level III (C/S) w Vieira Tech Rep Level 1 (C/S) M Pinheiro Tech Rep Level IV (N1) JL Carvalho Tech Rep Level 11 (2) Nogeira Tech Rep Level I (NZ) Andres Tech Rep Level II (N2) T Sobral import Export Clerk R Ferreira Tech Rep Level 1 (C/S) P Camara 8 300 23.100 3,500 26.600 1.464 2,888 30,952 300 23,100 2,310 25.410 1,484 2.888 29,762 8 300 23.100 2.310 25,410 1,464 2.888 29,762 8 300 23,100 23.100 1.464 2,888 27,452 8 300 23.100 23.100 2. 160 2.888 28.148 300 18,900 1,890 20.790 1,464 2,363 24,617 8 300 19,600 980 20,580 396 2,450 23,426 20,364 7 200 16,800 16,800 1,464 2,100 Tech Rep Level I (N1) M Antonio 7 250 16,800 16,800 1,464 2.100 20,364 E Lemos 7 280 16,800 16.800 1,464 2,100 20,364 Tech Rep Level 1 (N2) Tech Rep Level 1 (CIS) Tech Rep Level 1 (N2) L Modesto 7 260 16,800 16.800 1.464 2.100 20,364 J Cruz 7 260 16,800 16,800 1,464 2.100 20,364 P Costa 7 260 19,880 2,000 21,880 396 2,485 24,761 Bookkeeper Senior Sales Clerk S Jesus 6 230 20,720 4.150 24,870 396 2.590 27,856 P Santos 6 230 17.920 1,800 19.720 396 2.240 22,356 Warehouse Manager Clerk (N1) JL Reis 5 200 18,200 18,200 396 2.275 20,871 Clerk (N2) H Castelhano 5 200 18,200 18,200 396 2,275 20,871 Clerk (N1) R Coutinho 5 200 17.500 17,500 396 2,188 20,084 Clerk (N2) CJ Gouveia 5 200 17,500 17.500 396 2.188 20.084 Clerk (CIS) P Santos Siva 5 200 17,380 17,360 396 2,170 19,926