taller 1 ahora
DESCRIPTION
taller hoja numero 1TRANSCRIPT
Siglas
G Género
I Ingresos
E
H
EC Estado Civil
B Bonificación
4. Si I < 1200 y EC = 3 y G=2 Entonces B=220G I E H EC b b22 1240 4 2 1 0 01 1027 4 5 1 0 01 771 3 5 2 200 02 1203 3 0 1 0 01 1454 2 2 1 200 01 878 3 0 2 200 01 542 4 2 3 0 01 505 1 2 2 200 02 1060 5 5 2 0 02 822 2 0 1 0 02 601 3 1 3 0 01 826 3 1 1 200 02 999 3 0 2 0 02 816 2 4 1 0 02 1139 2 5 1 0 02 598 1 1 3 0 01 1364 1 0 2 200 02 1082 3 1 1 0 02 659 1 2 3 0 01 956 3 1 1 200 01 1373 3 0 2 200 02 1412 1 5 2 0 02 642 4 5 2 0 01 991 4 1 3 0 01 1253 5 4 2 0 01 743 4 4 2 0 02 904 4 3 1 0 02 1156 4 0 1 0 02 1016 3 0 3 0 02 1190 5 5 3 0 01 712 1 2 2 200 0
La presente base de datos, representa los empleados de una
empresa transnacional, la cual tiene su sede de coordinacion a
nivel latinoamerica en barranquilla
Nombre de la variable
Nivel de educación
Número de hijos
1 766 2 4 2 200 02 1481 4 2 1 0 02 1167 3 1 1 0 02 747 5 3 3 0 01 892 4 5 1 0 02 1309 4 0 3 0 02 567 4 4 3 0 02 840 2 1 2 0 02 604 3 2 3 0 01 1494 1 0 2 200 01 1045 2 5 1 200 01 942 1 1 1 200 01 972 5 1 1 0 02 976 3 1 2 0 01 1392 5 3 2 0 01 1426 5 1 1 0 02 632 4 3 2 0 01 1064 5 4 2 0 01 720 4 0 3 0 01 602 2 1 1 200 01 1449 2 2 2 200 02 1018 4 1 1 0 02 1422 1 3 1 0 01 526 5 0 2 0 02 534 4 5 3 0 01 994 5 4 1 0 01 1274 5 0 2 0 01 923 5 0 3 0 01 1179 1 3 1 200 01 502 5 0 3 0 01 1478 3 3 2 200 01 766 3 0 1 200 02 1426 4 5 1 0 01 802 2 3 3 200 02 1063 2 4 2 0 01 1431 5 3 2 0 02 1275 4 3 3 0 02 1001 2 1 1 0 02 806 3 2 3 0 01 631 5 3 3 0 02 1227 1 4 1 0 02 984 1 1 1 0 01 1033 4 2 2 0 02 503 4 0 1 0 01 1125 2 0 2 200 02 865 5 0 3 0 01 1248 5 3 3 0 02 1116 5 2 3 0 0
1 770 4 0 3 0 02 537 4 2 2 0 02 554 2 2 2 0 01 1070 4 4 1 0 02 1374 5 0 3 0 02 899 5 0 3 0 02 1252 2 3 1 0 01 1401 1 3 1 200 02 1376 1 2 1 0 01 827 4 1 3 0 01 830 4 2 1 0 01 760 5 4 1 0 01 870 1 5 3 200 01 650 4 0 1 0 01 1003 2 0 3 200 01 577 3 2 2 200 02 784 1 2 2 0 02 1147 2 1 2 0 02 843 1 5 3 0 02 757 1 0 3 0 01 965 3 3 3 200 01 1428 1 4 2 200 02 1244 3 0 1 0 02 725 5 3 1 0 01 1329 2 4 1 200 01 1085 3 3 2 200 01 1187 3 0 1 200 01 977 3 0 1 200 01 522 3 1 1 200 01 637 5 5 3 0 02 1454 4 1 1 0 02 951 4 1 3 0 01 681 1 5 1 200 02 911 1 2 1 0 01 1320 1 2 2 200 01 841 2 2 3 200 02 995 5 5 2 0 01 1466 3 1 2 200 01 1496 3 4 1 200 01 1138 2 1 2 200 01 1096 5 1 2 0 02 1281 2 2 1 0 01 1494 3 1 2 200 01 728 4 1 1 0 01 1480 3 2 3 200 01 1077 3 0 1 200 02 1039 4 3 3 0 01 1247 4 3 2 0 0
2 943 1 1 2 0 01 1184 5 3 2 0 01 698 2 5 3 200 02 711 2 5 2 0 01 561 3 5 1 200 02 761 4 5 1 0 02 1281 5 0 2 0 01 1081 5 1 1 0 02 943 1 0 2 0 01 1101 1 5 3 200 01 871 1 0 1 200 01 1282 2 3 2 200 02 754 2 5 3 0 02 839 1 0 3 0 01 517 1 3 2 200 02 1049 3 5 3 0 02 685 1 4 2 0 02 1423 5 2 1 0 01 1289 3 5 2 200 02 713 3 3 2 0 01 940 2 4 1 200 01 736 5 1 3 0 01 679 1 1 3 200 02 1016 5 1 3 0 02 729 5 4 1 0 02 524 1 1 2 0 02 1091 4 3 3 0 01 606 1 3 1 200 02 1311 3 4 3 0 01 579 5 4 2 0 02 1464 3 4 1 0 02 633 4 3 3 0 01 1061 4 0 1 0 01 629 2 1 2 200 01 719 3 2 1 200 01 1170 5 2 3 0 02 876 5 4 2 0 01 910 2 2 1 200 01 1446 2 4 2 200 02 994 2 2 1 0 01 1199 4 0 3 0 01 1404 2 1 3 200 01 939 5 0 2 0 01 774 1 1 2 200 01 1278 1 2 1 200 01 1130 3 3 2 200 02 1004 4 1 2 0 01 1120 2 3 1 200 0
1 879 2 2 1 200 01 1235 2 0 3 200 01 795 1 1 1 200 02 522 5 3 1 0 01 1458 2 2 1 200 01 1135 1 4 3 200 02 788 2 5 2 0 02 1353 4 4 1 0 01 1120 4 3 1 0 02 742 3 4 1 0 02 1122 5 0 3 0 01 1232 5 2 3 0 01 1397 3 1 3 200 01 1132 4 2 1 0 01 667 3 2 2 200 02 1365 5 1 1 0 01 1308 1 3 3 200 02 931 5 1 2 0 01 1336 1 2 1 200 01 1297 5 1 2 0 02 957 1 5 3 0 02 701 3 3 2 0 02 1173 5 1 1 0 02 672 5 2 1 0 01 772 4 3 1 0 02 965 5 5 3 0 02 897 1 2 2 0 02 682 3 3 1 0 01 635 5 4 1 0 01 1088 1 4 3 200 01 1171 1 3 1 200 02 961 5 0 2 0 02 701 1 3 3 0 01 1058 3 0 3 200 02 695 2 5 3 0 01 1029 2 3 1 200 01 810 4 4 2 0 02 1248 1 4 3 0 02 631 3 0 3 0 02 591 3 0 3 0 02 1500 2 0 1 0 01 712 2 4 2 200 01 924 3 3 3 200 01 1166 2 2 1 200 02 518 1 0 2 0 01 691 5 1 2 0 01 1001 5 0 1 0 3002 1358 3 5 1 0 0
2 686 3 1 1 0 02 1381 1 0 2 0 02 1075 4 4 3 0 01 511 4 4 3 0 01 1441 2 2 1 200 02 873 3 5 3 0 02 973 5 5 3 0 01 945 5 5 3 0 02 968 4 5 3 0 01 1209 4 3 1 0 01 1092 1 1 3 200 01 1112 3 2 2 200 01 816 3 0 1 200 01 990 3 5 1 200 02 737 1 0 1 0 02 1399 5 0 2 0 01 1054 4 3 1 0 02 957 1 3 1 0 02 713 5 1 3 0 02 917 5 4 2 0 01 753 3 1 3 200 02 951 4 4 1 0 01 904 3 3 3 200 01 537 2 3 2 200 01 1169 2 1 2 200 02 744 2 3 2 0 01 652 5 4 2 0 01 507 3 5 1 200 01 1032 5 2 2 0 01 578 1 5 3 200 02 1386 4 0 2 0 01 1198 5 4 1 0 02 642 4 2 3 0 01 695 4 3 1 0 02 944 4 3 3 0 02 1246 4 3 1 0 01 1438 3 1 1 200 02 1140 3 5 1 0 02 514 2 1 1 0 01 813 2 5 1 200 01 1465 2 4 1 200 01 1106 5 0 1 0 3002 816 4 3 2 0 02 1204 1 1 2 0 02 1014 1 3 1 0 01 857 5 3 2 0 02 1410 4 4 1 0 01 507 5 5 3 0 0
1 751 2 3 3 200 02 1102 3 2 1 0 02 517 5 2 2 0 02 516 3 4 1 0 01 1411 2 0 1 200 02 797 4 5 2 0 02 1222 5 3 3 0 01 964 3 3 2 200 01 1454 1 0 3 200 02 664 1 3 2 0 01 1244 4 0 1 0 02 960 3 5 1 0 01 989 1 1 2 200 01 919 5 3 1 0 02 1175 4 1 3 0 02 581 1 0 2 0 01 887 3 1 3 200 02 560 3 2 1 0 01 1475 5 3 2 0 02 595 3 2 2 0 01 832 1 2 1 200 02 1008 1 2 1 0 02 975 1 0 2 0 02 698 4 0 3 0 01 1119 1 3 3 200 01 1015 1 5 1 200 02 1300 1 3 2 0 02 1119 1 5 3 0 02 1366 4 5 3 0 01 985 4 4 1 0 02 772 1 0 1 0 01 1106 5 5 2 0 02 600 1 5 2 0 01 897 3 3 3 200 01 1296 5 1 3 0 02 856 2 4 3 0 01 662 3 2 2 200 01 634 2 5 1 200 01 1055 2 0 2 200 01 552 5 3 1 0 02 1478 5 1 3 0 01 770 4 4 2 0 01 1307 3 0 3 200 02 828 1 4 2 0 01 815 5 5 1 0 02 766 5 0 1 0 3002 769 1 2 2 0 01 1298 5 2 3 0 0
1 984 2 4 3 200 01 855 4 5 1 0 02 1385 5 1 1 0 02 1486 4 1 3 0 01 1360 5 5 2 0 01 1216 2 2 2 200 02 785 3 4 1 0 02 883 4 3 2 0 02 577 3 1 2 0 02 1238 5 2 2 0 02 657 3 4 2 0 02 587 2 5 1 0 02 585 1 3 3 0 02 727 1 4 1 0 01 825 3 0 2 200 01 844 3 3 1 200 01 548 5 4 3 0 02 605 2 3 1 0 02 1101 1 0 3 0 01 583 4 5 2 0 02 815 3 1 2 0 01 670 5 3 3 0 02 1346 5 5 2 0 01 1319 4 5 1 0 02 1018 3 1 1 0 01 1457 1 2 2 200 02 783 4 2 1 0 01 673 5 0 3 0 01 1037 5 4 1 0 02 1283 3 0 3 0 01 1042 1 0 3 200 02 1245 3 0 1 0 02 514 3 3 1 0 01 1091 2 1 2 200 01 1280 5 4 2 0 01 1011 5 5 3 0 01 1103 2 4 3 200 01 1224 5 5 3 0 01 890 5 2 1 0 01 1476 2 3 1 200 02 766 1 4 1 0 02 866 3 2 2 0 01 1170 3 5 1 200 02 1188 4 3 2 0 01 1067 4 2 1 0 02 585 5 5 2 0 02 1276 2 5 2 0 01 607 4 5 3 0 0
2 1219 1 2 2 0 01 1456 5 4 1 0 02 1287 1 2 3 0 01 1037 5 1 3 0 01 1487 5 3 2 0 02 938 3 1 3 0 02 622 1 0 3 0 01 1463 3 3 3 200 02 1406 2 5 2 0 02 1393 1 3 3 0 01 1000 5 5 2 0 02 1108 5 5 3 0 01 1015 2 5 3 200 02 568 5 0 1 0 3001 573 4 0 3 0 02 1310 4 0 2 0 02 1285 2 3 1 0 01 845 1 3 2 200 02 1105 4 0 1 0 01 1137 3 2 3 200 01 742 4 4 1 0 02 671 2 1 2 0 01 716 5 5 2 0 01 1241 3 0 2 200 02 1209 1 2 2 0 02 1066 5 2 3 0 01 970 4 1 2 0 01 574 2 0 3 200 02 541 2 0 3 0 02 601 4 0 1 0 02 599 4 0 3 0 01 898 5 2 3 0 02 952 3 5 2 0 01 1231 3 4 3 200 02 993 5 1 3 0 02 1233 3 0 3 0 02 1245 2 2 1 0 02 968 5 5 1 0 01 552 1 5 1 200 02 1136 2 0 2 0 01 1177 4 4 3 0 02 637 5 4 2 0 02 945 4 4 2 0 01 1221 3 2 1 200 02 663 3 3 3 0 01 1220 5 2 1 0 01 1283 1 0 1 200 02 614 2 0 3 0 0
2 958 1 2 2 0 01 643 2 4 2 200 01 711 5 0 1 0 3001 1003 1 0 2 200 02 512 4 2 1 0 01 565 4 5 3 0 02 1316 1 5 2 0 01 1399 5 5 2 0 02 582 3 1 3 0 01 1250 4 2 3 0 01 887 2 4 3 200 01 585 3 1 2 200 02 536 2 3 1 0 02 1396 5 2 2 0 02 1199 5 2 2 0 02 1158 2 1 1 0 01 742 1 4 3 200 02 1022 3 1 2 0 01 1372 3 1 2 200 02 688 1 5 1 0 01 909 4 0 1 0 01 914 2 5 3 200 01 581 5 3 3 0 01 1317 1 1 1 200 01 760 1 1 1 200 01 1249 2 2 3 200 02 898 3 1 3 0 01 1129 1 5 1 200 01 786 5 1 1 0 02 1219 2 4 2 0 01 1047 5 2 1 0 01 1407 3 3 3 200 01 554 2 2 3 200 01 1304 4 3 1 0 02 577 5 3 3 0 02 1063 3 3 3 0 02 1270 1 3 1 0 01 739 2 0 2 200 01 856 4 1 3 0 01 829 5 2 1 0 02 1426 1 5 1 0 02 789 1 0 2 0 02 1364 5 5 3 0 02 1254 5 3 3 0 01 1416 1 0 3 200 02 1426 5 2 1 0 01 1204 1 0 2 200 01 932 3 5 2 200 0
1 931 4 5 3 0 01 1347 3 3 2 200 02 751 1 4 1 0 02 1093 4 1 3 0 02 1427 5 5 2 0 02 1427 4 2 1 0 01 626 5 0 1 0 3001 1153 5 1 1 0 02 844 5 5 2 0 01 901 4 4 1 0 02 1228 5 3 1 0 02 800 5 5 2 0 02 1057 3 3 2 0 01 1361 4 0 2 0 01 1304 2 2 1 200 02 656 5 1 3 0 02 1206 1 4 3 0 01 790 2 2 3 200 02 753 1 5 3 0 01 671 4 5 1 0 01 736 5 4 2 0 01 1297 3 5 2 200 02 707 5 4 2 0 02 591 4 3 2 0 01 737 4 5 2 0 02 910 3 1 1 0 02 1204 2 4 3 0 01 1002 5 5 1 0 01 1221 1 3 3 200 01 1177 2 4 2 200 02 1467 2 2 3 0 01 675 2 3 1 200 02 515 1 3 2 0 01 914 1 4 1 200 01 887 1 3 3 200 02 595 4 0 1 0 02 909 4 1 2 0 02 1170 3 4 3 0 01 659 3 1 1 200 01 1232 5 0 2 0 02 1059 1 4 3 0 02 1061 4 2 3 0 02 1152 2 0 3 0 02 614 5 5 1 0 02 515 2 1 3 0 01 783 4 5 1 0 01 627 2 3 1 200 02 630 3 0 3 0 0
2 941 4 2 3 0 02 560 4 5 1 0 02 1283 3 1 3 0 02 1272 5 0 2 0 02 846 2 0 3 0 02 1340 1 0 3 0 01 943 4 4 1 0 02 827 2 5 2 0 02 1034 4 4 3 0 02 544 5 1 2 0 02 835 2 4 1 0 01 551 1 1 2 200 01 1493 2 5 1 200 02 1375 2 0 3 0 02 561 3 3 1 0 02 1125 3 4 2 0 01 1380 5 5 3 0 02 570 2 0 3 0 02 1203 2 0 2 0 01 1270 2 3 2 200 01 1272 4 4 1 0 02 806 4 4 3 0 02 979 5 0 2 0 02 1294 4 2 2 0 02 976 3 3 2 0 02 1229 2 5 3 0 0
Opciones de respuesta
Binomial 1. Mujer ; 2. Hombre
Discreta (Mínimo=500 ; Máximo=1500)
Multinomial
Discreta (Mínimo=0 ; Máximo=5)
Multinomial 1. Casado ; 2. Soltero ; 3. Otro
Bonificación
4. Si I < 1200 y EC = 3 y G=2 Entonces B=220b3 b40 0
450 0450 0
0 00 00 00 00 00 00 00 2200 00 00 00 00 2200 00 00 220
450 00 00 00 00 00 00 00 00 00 220
450 2200 0
Tipo de variable
1.Técnico Laboral ; 2 Técnico Profesional; 3. Tecnólogo; 4.Profesional; 5. Post- grado
Es una nueva variable que toma los valores asignados por la validación en la prueba lógica, con base en la utilización de los operadores.
0 00 00 00 2200 00 00 2200 00 2200 00 00 00 00 00 00 00 00 00 00 00 00 0
450 00 00 2200 00 00 00 00 00 00 00 00 00 00 00 00 00 2200 00 00 00 00 00 00 2200 00 220
0 00 00 00 00 00 2200 00 00 00 00 00 0
450 00 00 00 00 00 00 2200 2200 00 00 00 00 00 0
450 00 00 00 00 00 2200 00 00 00 00 00 0
450 0450 0450 0
0 00 00 00 00 00 2200 0
450 00 00 0
450 00 00 0
450 00 0
450 00 00 00 00 2200 2200 00 220
450 00 0
450 00 00 00 00 00 2200 00 0
450 2200 00 00 00 00 2200 00 00 00 00 00 00 00 00 00 0
450 00 00 0
450 00 00 0
0 00 00 00 00 00 00 00 00 00 00 2200 00 00 00 00 00 00 00 00 00 2200 0
450 00 00 00 2200 00 00 0
450 00 00 00 2200 00 220
450 00 00 00 2200 2200 0
450 00 00 00 00 00 00 0
0 0450 0
0 2200 00 00 2200 2200 00 2200 00 00 00 00 00 0
450 00 00 00 2200 00 00 00 00 00 0
450 00 0
450 0450 0
0 00 00 00 2200 00 2200 00 00 00 0
450 00 00 00 00 00 00 00 0
450 0
0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 2200 00 00 00 00 00 00 00 0
450 2200 0
450 00 00 2200 00 00 00 00 00 00 00 220
450 00 00 00 00 00 0
450 00 00 00 0
450 0450 0
0 00 00 00 00 00 00 00 00 00 00 00 00 2200 00 00 00 00 00 2200 00 00 00 00 0
450 00 00 00 00 00 0
450 00 00 00 0
450 00 00 00 00 00 00 00 00 00 0
450 00 00 00 0
450 00 00 00 00 00 2200 2200 00 00 00 00 2200 00 00 00 00 00 00 00 0
450 0450 0
0 00 00 00 2200 00 00 2200 00 2200 00 00 00 2200 00 0
450 00 00 00 00 00 00 00 2200 0
450 00 220
0 00 00 00 00 00 00 00 00 220
450 00 00 00 00 00 00 00 0
450 00 00 00 00 00 00 00 00 00 2200 00 00 00 00 00 00 00 220
450 2200 00 00 00 00 00 00 00 00 00 00 00 0
0 00 00 00 2200 00 00 00 00 0
450 00 00 00 00 0
450 00 2200 0
450 00 2200 00 00 00 00 00 0
450 00 00 00 00 00 00 00 00 00 00 00 00 2200 00 00 2200 2200 220
450 00 2200 0
450 00 220
450 2200 00 0
450 00 2200 00 00 00 2200 00 00 00 0
450 00 00 00 00 2200 00 00 00 2200 00 00 00 0
1. Si G= 1 y E < 4 Entonces B= 200
2. Si E=5 y H=0 y EC=1 Entonces B = 300
3. H> 3 y E= 2 ó E=3 Entonces B= 450
4. Si I < 1200 y EC = 3 y G=2 Entonces B=220