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 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) TOTAL CASE POSITION INCUMBENT BONUS OTHER BENEFITS Employee Love 20 LUNCH SUBSIDY 594 AUTO BENEFIT 4.752 TOTAL COMPENSATION JOB GRADE MIOPONT BASE SALARY 1500 137 200 1130 100,800 NA NA 17.150 NA 18 NA NA 594 3.456 12.600 NA 17 980 107,800 21.560 129 360 594 3.456 13.475 146.885 Director Geral L Freidrickson Director Comercial s Svenson Director Administrativo Silva Director Equipas H Fonseca Director Controlo N Abrantes Clientes Accounting Supervisor P Pereira Treasurer AP Argento 17 980 87.080 9,000 96 080 3,456 10.885 110.421 15 740 44.800 9,000 53.800 594 5,600 59.994 13 560 43.400 6,500 49.900 594 5.425 55.919 12 490 33 600 6.600 40 200 594 4200 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.180 6.300 63.860 11 420 47,600 4,850 52.450 2,160 5.950 60.560 8 300 31,500 6.200 37.700 1.454 3.938 43 102 8 300 30.800 6.300 37.100 1.464 3.850 42.414 B 300 25.900 6,500 32 400 1.454 3238 37.102 8 300 26.040 5,200 31.240 1.464 3255 35.959 B 300 23.100 3.500 25.600 1.454 2.888 30.952 B 300 23.100 2,310 25.410 1.454 2.888 29 762 Lider Equipa N2 J Serra Lider Equipa NI M Pronto Lider Equipa CIS P Paiva Tech Rep Level V (N2) LRibeiro Tech Rep Level IV (N2) M Antunes Tech Rep Level V (CIS) F Franco V Tech Rep Level (N1) M Pacheco Tech Rep Level II (C/S) W Vieira Tech Rep Level III (C/S) M Pinheiro Tech Rep Level IV (N1) JL Carvalho Tech Rep Level III (N2) Nogeira Tech Rep Level 11 (N2) S Andres Tech Rep Level (N2) 1 Sobral import Export Clerk R Ferreira Tech Rep Level I (C/S) P Camara Tech Rep Level 1 (N1) M Antonio Tech Rep Level 1 (N2) E Lemos Tech Rep Level I (C/S) Modesto Tech Rep Level 1 (N2) J Cruz 8 300 23.100 2.310 25.410 1.464 2888 29.762 8 300 23,100 23.100 1.454 2.888 27,452 8 300 23.100 23.100 2.160 2.888 28.148 8 300 18.900 1.890 20,790 1.464 2.383 24.617 B 300 19,600 980 20.580 396 2.450 23.426 20.364 260 16.800 16.800 1.464 2.100 7 260 16.800 16,800 1.454 2.100 20.354 7 280 16.800 16.800 1.464 2.100 20.384 7 260 16.800 16.800 1.454 2.100 20.354 7 260 16.800 16,800 1.464 2.100 20.354 Bookkeeper P Costa 7 260 19.880 2.000 21.880 396 2.485 24.761 Senior Sales Clerk S Jesus 6 230 20.720 4.150 24.870 396 2590 27 856 Warehouse Manager P Santos 6 230 17,920 1,800 19.720 396 2.240 22.356 Clerk (N1) JL. Reis 5 200 18.200 18.200 396 2275 20 871 Clerk (N2) H Castelhano 5 200 18.200 18.200 396 2.275 20.875 R Coutinho 5 200 17.500 17.500 396 2.188 20.084 Clerk (N1) Clerk (N2) CJ Gouveia 5 200 17,500 17.500 396 2.188 20.084 Clerk (CIS) P Santos Silva 5 200 17,360 17.360 396 2,170 19.926