consulting report on a data set findings

User Generated

novnzbg

Business Finance

Description

we are required to write a consulting report on a data set and the findings we derived from it. attached is the data set bar charts, histograms, scatterplots and PivotTable. please make sure to follow the instructions in the paper outline.

Unformatted Attachment Preview

Row Labels Afghanistan Albania Algeria Angola Antigua and Barbuda Argentina Armenia Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bhutan Bolivia (Plurinational State of) Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Burkina Faso Burundi Côte d'Ivoire Cabo Verde Cambodia Cameroon Canada Central African Republic Chad Chile China Colombia Comoros Congo Cook Islands Costa Rica Croatia Cuba Cyprus Sum of Life expectancy Sum of Adult Mortality 931.1 4305 1202.5 721 1177.9 1731 784.3 5257 1200.9 2040 1202.5 1696 1174.4 1878 1309 1011 1303.7 1052 1131.7 1843 1188.6 2433 1211.6 1046 1108.8 2262 1189.7 1242 1118.5 3500 1290.9 1123 1108.3 2488 921.1 4310 1058.6 3684 1083.3 2840 1215.5 1039 896.8 7170 1174.1 2411 1223.8 1073 1165.6 2008 890.3 4040 888.6 4665 806.2 6677 1160.3 1859 1029.5 3142 864.3 4718 1307 1034 776.2 5329 806.2 3644 1271.2 1018 1188.2 1180 1172.6 1988 985.3 3855 944.7 5164 1257.5 1217.9 1247.6 1274.8 1110 1424 921 866 Czechia Democratic People's Republic of Korea Democratic Republic of the Congo Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Gambia Georgia Germany Ghana Greece Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hungary Iceland India Indonesia Iran (Islamic Republic of) Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan 1228.3 1107.1 891 1268.1 972.1 1149 2573 4246 1057 4395 1157.5 1195.6 1144 1147.9 885 971 1199.1 945.8 1099.4 1291.4 1315.5 995.9 951.4 1176.1 1298.8 973.8 1299.5 1172.7 1147.7 896.2 885.9 1050.2 957.9 1167.9 1181.2 1319.1 1046.7 1080.9 1181.7 1125.7 1282.4 1300.8 1315 1188.7 1320.6 1167.8 1068.2 919.7 1042.4 1181.5 1105.3 2296 2114 2730 2481 4470 4938 2715 4569 2000 1102 1170 3527 3994 1839 1140 2881 1178 2460 2099 4158 2533 3263 2693 2272 2353 790 2345 2665 1712 2188 1159 952 867 2260 914 1829 3713 5577 2071 1332 2779 Lao People's Democratic Republic Latvia Lebanon Lesotho Liberia Libya Lithuania Luxembourg Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Mauritania Mauritius Mexico Micronesia (Federated States of) Monaco Mongolia Montenegro Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria Niue Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Republic of Korea 998.1 1179.7 1187.2 780.5 920.4 1159.8 1164.9 1292.5 1003.9 798.3 1180.1 1208.6 879 1285.8 3155 2589 1045 8801 3951 2235 1876 1081 3661 6791 1897 1331 3234 972 1004.8 1163.4 1211.5 1091.2 2559 2617 1777 2465 1054.2 1192 1154.5 854.3 1027.2 966.4 3554 1484 1523 3620 2469 5011 1063.7 1298.1 1301.4 1175.2 911.7 821.7 2356 986 1144 2598 3719 3976 1308.7 1197.5 1032 1060 1084 2464 1223.8 986.9 1169.8 1178.6 1081.2 1210.4 1279.9 1232.5 1287.8 1854 4265 2239 1959 3487 1721 942 1206 1219 Republic of Moldova Romania Russian Federation Rwanda Saint Kitts and Nevis Saint Lucia Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Sudan Spain Sri Lanka Sudan Suriname Swaziland Sweden Switzerland Syrian Arab Republic Tajikistan Thailand The former Yugoslav republic of Macedonia Timor-Leste Togo Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Tuvalu Uganda Ukraine United Arab Emirates United Kingdom of Great Britain and Northern Ireland United Republic of Tanzania United States of America 1119.7 1184.8 1084.2 949 3365 2497 3593 3949 1177.6 1175.6 1177.9 2340 2433 2137 1042.6 1175.5 1001.1 1183.3 1158 737.8 1303.6 1196 1275.7 1083.4 853.1 920 862 1313.1 1174.4 989.2 1121.3 821.2 1320.3 1317.3 1133.6 1066.5 1169.3 1185.8 1036.1 906.6 1160.5 1137.1 1189.7 1182.6 1033.9 2639 834 2787 2087 2579 5725 992 1889 1223 2241 5068 6604 5541 1018 2310 3845 2656 5424 947 892 2234 2841 2566 973 2726 4981 2074 2614 300 1574 3437 891.3 1119 1211.2 1292.7 896.1 1249 4803 3292 1073 1126 4871 931 Uruguay Uzbekistan Vanuatu Venezuela (Bolivarian Republic of) Viet Nam Yemen Zambia Zimbabwe Grand Total 1217.2 1088.5 1142.2 1174.2 1196.4 1021.8 862.5 807.8 202690.6 1919 2957 2206 2608 2025 3389 5669 7398 482524 Sum of infant deaths Sum of Alcohol Sum of percentage expenditure Sum of Hepatitis B Sum of Measles 1252 0.23 559.3617611 1033 37796 11 77.58 3092.145451 1568 854 325 6.1 3778.963851 936 31102 1340 86.11 1633.604294 632 56981 0 119.24 16025.36362 1474 0 162 119.5 12368.6237 1138 32 16 55.54 2096.1187 1401 4388 16 152.33 85315.62356 1401 1663 0 183.54 78855.02701 1297 1236 97 14.88 2098.379951 829 9571 0 154.07 0 1254 0 0 29.02 9633.394234 1570 107 2458 0.15 517.1355442 1009 74399 0 123.1 6225.231923 1261 0 9 202.46 5264.743285 1423 397 4 165.64 38278.92251 1192 1305 0 93.79 5853.495837 1516 0 400 15 703.8713027 876 17870 11 4.18 2156.225119 1506 1284 172 48.18 0 1326 122 0 66.08 3447.319346 860 5107 32 70.05 5348.271534 1397 3806 1092 108.2 6251.129523 1539 1526 0 5.68 20430.07176 1566 117 15 162.98 5611.923264 1512 24485 716 63.62 832.7293012 811 81468 372 61.55 245.3679644 1120 21592 984 42.56 0 959 27332 0 51.72 3018.127798 1129 2 268 22.29 540.7449756 796 30093 879 62.12 711.396799 845 47668 32 120.8 75105.26354 375 2072 264 18.47 654.4886898 298 11191 718 6.17 516.437128 239 75004 32 104.67 12408.653 772 17 4718 62.73 1177.340206 1287 1053727 222 66.29 8266.242867 1264 152 27 2.02 763.703322 994 1002 126 32.6 0 457 16346 0 0.01 0 98 0 16 58.87 15557.7464 1269 3 0 186.72 18605.70127 866 379 16 62.86 5833.021729 1540 0 0 153.91 14922.67824 1482 31 0 159 3752 0 23 0 103 118 900 41 48 101 0 3004 0 0 47 32 48 19 40 645 3 0 210 493 73 9 272 74 9 0 21867 2419 403 499 0 15 32 16 46 64 114 1054 0 8 60 195.39 45 21.36 160.62 11.46 0.01 90.46 57.11 2.83 40.39 110.13 9.12 135.22 16.12 21.94 143.29 186.07 118.16 32.02 84.35 174.43 19.03 132.05 132.65 34.03 2.47 33.9 111.09 82.29 45.63 171.41 111.99 29.13 1.03 0.24 2.02 189.81 37.46 124 54.36 105.61 7.76 99.62 24.03 6.61 0.32 34.01 0 0 0 85013.37271 1581.41517 11.41955507 5770.863954 1750.496819 0 5465.106517 8842.744609 102.9771101 13753.20013 519.7137469 2226.509402 46229.04752 60024.10519 4177.244458 0 1592.411424 62414.24417 1235.985953 28147.94913 5821.459677 5344.432768 254.2605271 351.3863146 3004.240287 578.0672029 3073.850164 6029.297284 79865.52494 531.8819375 1340.293049 0 1930.619032 77877.00168 23480.57323 46994.20247 2147.991203 62768.80527 4377.592548 3248.494537 986.4874295 1234.017654 27517.45569 0 1362 1155 462 702 96 1042 1249 1547 1377 18 1210 1042 577 1582 820 634 1526 1236 1239 945 1423 1432 958 528 525 1323 122 1521 420 1177 1564 1038 521 1559 1528 1081 1552 1557 1044 1203 1571 1369 367 3561 782763 252 1822 0 368 332 17108 2 4712 2800 56 63174 800 45 42586 5597 660 20768 23955 54716 398 0 0 24352 5301 0 1151 0 33 0 743267 259919 45252 55270 2792 2223 31382 3 110013 424 19951 42302 0 246 18506 170 0 16 72 171 35 0 0 559 594 53 0 895 0 0 125 0 634 0 0 25 0 342 1193 906 46 0 466 16 0 49 845 8571 0 0 16 5887 0 18 170 51 189 979 36 3 0 34 52.58 132.96 26.78 31.3 48.87 0.15 189.49 178.83 12.3 13.79 7.36 21.11 6.57 106.95 0.01 0.2 43.6 76.71 32.18 0.01 35.31 36.18 7.78 18.99 5.27 70.66 0.01 2.85 132.7 146.66 53.95 1.37 129.7 0.01 99.75 8.02 0.39 93.18 8.71 82.91 64.18 67.66 149.98 183.17 16.22 132.83 0 8489.683069 5328.767122 1313.902606 404.3473068 2881.199825 16252.06148 130841.2215 692.0505051 413.5953033 3982.16045 10023.99714 783.6988317 18902.90857 871.8783173 507.250354 6755.832389 7445.239933 0 0 2022.053824 7280.797184 1647.834533 592.5464244 205.1930182 5758.881271 15.60659587 642.5930284 60890.99276 46754.36448 2938.606522 305.5898978 1367.108405 0 74541.02269 6198.573125 417.9262497 344.6906308 9119.545859 1205.927706 3676.65111 6673.259193 1432.905133 4970.916296 25838.35273 39469.68008 0 784 1423 1128 952 393 1541 1516 1478 887 1254 1536 1566 873 1047 8 634 1539 1511 1207 99 1559 485 1396 1018 851 518 87 850 241 1123 1470 424 472 99 1581 875 99 1180 912 1068 1088 994 1558 1402 1521 1522 8844 53 4723 4267 11285 8757 239 18 153219 120951 23250 2526 13173 35 0 13055 869 176 140 0 33268 10 41488 75760 14632 11553 0 74617 4031 1519 0 247474 826463 0 101 174 61477 0 4 37598 0 6 114315 759 116 1540 56775 16 45 267 332 0 0 0 0 0 0 138 357 16 0 441 0 0 0 0 798 779 444 26 64 1034 0 42 0 0 128 171 194 0 38 227 0 0 52 431 105 0 1435 81 16 58 1524 419 143.18 134.53 166.92 84.54 8.54 172.67 91.65 40.56 0.01 62.87 1.12 4.64 130.24 93.02 47.32 28.2 157.1 161.32 12.01 0.15 113.83 150.36 31.44 21.87 74.76 66.95 103.9 155.07 12.07 4.96 91.97 27.88 3.53 14.21 17.51 90.67 19.66 21.32 39.82 0.01 120.76 110.54 26.25 178.1 53.74 128.69 0 6824.586148 5217.345201 323.061655 0 0 0 4073.552288 0 837.0415073 13416.10241 343.7828196 7435.915809 7469.28675 465.6892575 37321.14814 0 24901.35272 1792.438649 0 9861.754296 131.857231 37322.88294 956.0576143 1563.175083 8135.904525 4449.59541 71010.61046 156828.966 628.7917701 276.4350793 6420.159414 0 339.0003724 379.2896655 5180.949487 8949.037953 5867.860168 4054.674841 3004.511801 78.28120317 763.0737336 2710.837283 30187.70544 0 0 0 1520 1469 1385 1344 97 1250 1209 879 69 1083 1549 1037 1089 1579 751 1534 1577 1258 126 1064 31 1480 1178 796 938 1216 296 1026 1182 1552 919 608 613 1208 769 1548 1393 1362 9 888 874 1502 1029 1302 6254 21851 25863 8094 0 0 0 9 0 0 12149 51980 1181 11 10782 1372 4 97 0 87905 24096 5052 7198 22727 49728 0 786 303 6360 4731 3331 68991 1196 1361 8520 4 0 531 84367 242 0 198314 86323 1210 11452 53577 2090 9 351 0 150 467 630 535 425 89033 92.59 24.13 12.1 111.3 46.31 0.71 33.59 67.23 12630.25 9949.42271 709.9752042 4517.211934 0 0 0 1434.40651 325.8283433 2168982.306 1509 1339 898 1060 1138 891 768 1129 193043 0 3335 334 2640 67727 44179 105021 14768 7108762 Sum of BMI Sum of under-five deaths Sum of Polio Sum of Total expenditure Sum of Diphtheria 248.3 1721 774 132.04 837 785.1 15 1570 95.13 1569 779.9 376 1468 69.06 1470 288.3 2122 738 58.79 763 614.8 0 1551 71.87 1573 879.7 182 1494 103.69 1478 715.3 16 1426 72.92 1398 893.8 22 1388 132.55 1390 772.6 0 1376 70.73 1388 701.5 115 1213 85.19 1317 846.1 0 1520 100.59 1532 826.5 0 1568 57.11 1569 206 3225 1400 42.82 1484 735.6 0 1285 91.83 1439 875.9 14 1438 92.88 1475 814.3 16 1564 89.43 1557 602.8 0 1528 75.59 1523 313.8 628 1083 69.54 1087 281.3 15 1430 80.19 1502 717.1 224 1307 84.39 1398 783.4 0 1253 131.13 1256 515.9 50 1539 82.66 1533 753 1236 1573 120.29 1567 475.5 0 1560 42.3 1549 872 16 1508 108.54 1504 248 1279 1104 90.57 1237 245 569 1386 106.34 1372 341.2 1389 1055 85.85 1103 390 0 1350 71.33 1264 245.8 328 1187 86.11 1153 377.9 1379 1160 70.79 1111 893.8 32 1365 105.78 1457 273.4 392 661 60.59 679 261.1 1250 526 65.69 429 889.4 35 1338 103.67 1421 348.9 5600 1499 73.77 1493 792.7 262 1348 95.1 1267 292.1 32 1085 72.48 1071 334.8 187 839 44.8 884 82.8 0 98 3.58 98 747.6 16 1119 129.3 1276 837.7 0 1528 110.56 1526 791.4 16 1579 96.43 1503 850.6 0 1568 101.4 1568 891.4 410 253.4 893.2 420 58.4 770.3 693 788.2 725.2 285.7 242.5 906.9 236.8 809 836.8 831.7 461.1 324.8 763.9 831.9 347.6 938.9 643.4 647.1 279.5 310.9 582.1 628.4 635.9 910.9 817.2 236.7 319.3 778.1 777.5 859 879.8 898.4 726.8 409.7 848 722.5 249 1110.9 953.7 561.8 0 205 5176 0 30 0 125 140 1082 46 64 143 0 4616 0 0 55 48 91 20 52 957 7 0 258 774 117 16 397 91 14 0 29000 2986 475 608 0 16 37 16 64 64 129 1578 0 16 66 1568 1572 890 1408 1198 96 1210 1260 1547 1316 590 1405 1508 818 1554 1555 1572 916 1484 1299 1517 1263 1463 1522 1143 839 1196 1404 861 1526 1583 1436 1114 995 1572 890 1378 1508 1538 1434 1536 1554 1560 1123 1204 1571 1534 105.75 53.38 117.34 106.06 5.58 70.22 88.2 80.19 106.55 43.94 52.03 85.31 73.52 58.46 129.21 98.34 47.63 79.63 109.96 61.1 64.93 135.58 92.83 98.91 60.14 88.06 91.26 92.75 122.21 116.53 128.19 65.38 39.95 94.35 53.23 115.93 112.18 131.66 77.16 97.09 131.72 60.29 70.03 85.92 42.14 91.78 1570 1332 670 1408 1202 96 1331 1427 1547 1395 479 1316 1506 739 1467 1572 1569 872 1416 1336 1438 1182 1546 1530 1369 766 1044 1411 768 1530 1584 1436 1073 1158 1574 1052 1378 1424 1516 1429 1540 1552 1543 1128 1199 1576 1545 229.8 820.9 885.4 403.8 319.8 877.4 787.7 765.2 236.3 268.5 466.7 308.7 275.4 1058.9 81.6 359.6 415.7 822.7 1042.4 636.7 807.8 777.9 258.3 274 451.6 87.3 242.8 863.5 906 682.9 261.8 316 77.3 813 716.5 293 83.3 789 652.6 632.4 717.9 307 859.7 698.1 1050.4 371.9 236 0 16 101 236 40 0 0 818 940 66 0 1544 0 0 191 0 744 0 0 31 0 398 1716 1231 61 0 610 16 0 59 1691 13633 0 0 16 7376 0 27 220 59 242 1261 43 6 0 41 941 1521 1140 1087 951 1544 1421 1569 959 1425 1542 1566 1000 1431 79 1009 1544 1521 1318 99 1561 843 1551 1104 1131 1256 87 1106 1549 1426 1411 847 661 99 1489 1576 1027 99 1355 1001 1247 1325 1251 1548 1544 1534 1460 51.66 94.97 100.06 114.11 102.66 55.92 98.21 113.21 70.66 99.88 56.23 123.55 97.84 128.95 17.24 59.03 67.87 91.11 165.84 4.3 77.71 111.29 81.64 89.59 30.19 110.98 4.65 88.34 107.12 133.14 100.96 98.66 55.66 7.2 136.29 43.15 43.56 9.27 115.83 81.94 101.68 73.9 58.58 95.69 119.29 39.02 88.68 984 1520 1128 1271 651 1544 1508 1583 980 1338 1543 1566 1072 1429 79 962 1541 1520 1310 99 1558 845 1555 1025 1158 1336 87 1179 1549 1130 1470 837 629 99 1407 1580 1134 99 1280 1094 1434 1296 1266 1580 1552 1435 1537 702.5 836 853.1 236 5.2 633.5 671.9 1006.5 333.6 885 295.1 834.2 454.5 292.9 414.5 829.1 835.2 626.8 299 610.4 938.7 276.4 802.5 408 900 823 757 529.8 345.5 846.5 232.8 287.9 1007.1 603.7 772.1 902.6 609.9 79.3 248.4 814.3 860.9 886.2 277.1 935.2 17 52 309 513 0 0 0 0 0 0 160 586 17 0 670 0 2 0 0 1289 1117 692 30 76 1546 0 59 0 0 153 204 226 0 48 343 0 4 59 516 129 0 2222 95 16 65 2291 492 1519 1516 1561 1416 96 1358 1566 916 69 1449 1549 1207 1514 1576 1148 1538 1575 1523 1404 477 1045 220 1548 1574 1156 1252 1424 1573 1526 1037 1413 1573 1528 885 1075 1230 1223 1563 1293 1529 9 1047 1303 1521 1486 1334 1314 104.35 79.17 93.35 95.26 6.14 103.84 72.24 79.88 6.5 98.79 58.87 74.07 92.98 57.03 138.27 55.32 110.64 132.83 94.01 124.59 8.13 128.05 56.57 85.43 99.94 109.63 148.99 91.31 59.2 84.72 56.36 113.04 24.7 78.65 78.09 77.99 90.79 84.27 42.43 16.61 128.13 101.66 45.55 128.01 70.52 237.95 1165 1520 1554 1430 96 1341 1573 1007 69 1522 1550 1253 1493 1576 1154 1539 1578 1520 1206 469 1123 235 1548 1575 1158 1321 1340 1573 1513 775 1428 1571 1518 899 1189 1125 1064 1563 1292 1542 9 1038 1120 1514 1486 1195 1522 846.8 556.9 708.1 871.8 179 535.8 279.2 402.2 111284.9 12 411 0 172 584 826 838 653 123501 1508 1577 1059 1195 1519 1074 1030 1210 240964 131.25 84.57 58.93 74.98 89.66 75.08 87.36 92.38 16104.37 1426 1575 945 1096 1468 1162 1188 1203 240304 Sum of HIV/AIDS 1.6 1.6 1.6 37.9 2 1.6 1.6 1.6 1.6 1.6 1.9 1.6 1.6 4.1 1.6 1.6 6.9 27.3 5.7 2.5 1.6 264.4 1.6 1.6 1.6 29.4 49.4 75 8.5 16.4 99.4 1.6 143.7 69.4 1.6 1.6 1.6 4.5 79.8 0.1 1.6 1.6 1.6 1.6 Sum of GDP Sum of Population Sum of thinness 1-19 years Sum of thinness 5-9 years 5440.246808 159556157 265.3 249.3 33915.62686 11150586 25.9 27.2 45565.65428 346397239 97.5 95.6 31602.28872 162353587 99.1 106.7 156148.8917 54.8 54 111977.2017 321939272 17.2 15.2 31999.78108 16242634 32.6 33.8 554201.0408 73392158 10.7 10 541239.6209 103598078 27.7 31 52847.16491 34517928 46.4 47.1 40.8 40.3 179059.9587 97.7 95.2 7096.983696 687762622 220.4 229.3 192273.5765 63.3 62.7 60984.40557 101949869 35.4 37.4 270644.896 46144681 13.8 13.7 62928.19479 2726286 56.9 55.8 8978.687488 63087663 132 130.2 21663.79113 7881359 275.5 286.8 20.8 19 35920.41638 31791889 44.5 44.1 71972.5669 17021878 119 125 98290.5887 1410049140 48.8 48.2 315916.9296 99.2 90.8 79023.70914 84654783 34.1 34.5 6565.952549 98299117 118.7 111.7 2205.045141 62647147 128.3 128.2 107.8 107.1 32376.65663 4681604 128.2 127.6 7459.150049 114335479 162.3 174.1 12496.25607 159476671 104.8 105.7 470126.5204 181824861 8.1 7 5808.894478 32264738 113.7 113.4 7756.667105 65825473 114.3 112.7 99237.50982 234748223 14.2 14.6 37524.85052 5148993 74.2 64.4 53146.57197 508278922 36.8 33.2 10086.14935 8515211 116.4 114.6 135.8 130 0.1 0.1 63315.63658 36948791 31.4 30.5 144908.5555 18556358 27.9 27.5 50886.95815 55.1 52.3 222382.168 6244390 14.5 16 1.6 1.6 29.1 1.6 52.5 0.1 22.7 3.1 1.6 4.6 82.2 19.4 1.6 43.6 1.6 1.6 1.6 128 37.5 1.6 1.6 36.6 1.6 1.6 6 35.1 77.1 17 43.8 13.1 1.6 1.6 4.1 3.2 1.6 1.6 1.6 1.6 1.6 19.8 1.6 1.6 1.6 140.2 1.6 1.6 1.8 529078.5267 14367.99793 722.75665 56151.98698 32085.63949 71178283 139369473 40285.35409 126438.5726 3112.744276 133446.9272 4239.535199 47161.80302 404298.3961 423448.8221 82868.09902 46893224 8908245 24863032 12669579 703212172 10403282 55889317 441307730 16116837 34532.49391 389403.9856 13350.01761 263267.7739 100152.2762 37853.35158 4471.436766 6147.438889 28542.09499 6949.76205 22748.60932 136218.2693 482552.0465 13406.72081 26705.86853 162438 620117559 184556522 24803335 42510.69045 541364.3521 301767.6163 339756.5179 40152.74351 398280.7166 29162.07881 64649.38663 11468.32109 18804.67865 510630.0534 68161302 10145859 94942520 68044783 15710131 7910996 61642523 45318185 25678436 2978842 6743483055 1864884151 297165453 57596713 445806 442300623 24004946 1558145 78321211 133448759 269228602 574719 31.9 87 130.3 18.6 93.5 2.7 55.5 22.1 50 28.9 106.5 129.3 33.2 134.1 65.5 14.4 10 110.7 121.4 44 17.9 122.4 13 62.7 21.4 122.3 120 90.9 67.9 38.4 30.7 15.3 433.6 54.7 124.3 86.4 4.8 18.3 8.2 30.1 29 62.2 39 134.4 2.5 52.5 53.7 33 87.2 127.3 15 91.2 2.6 54 20.3 49.2 27.6 105.6 128.3 34.2 103.6 60.7 12.9 9.6 108.4 120.1 46.3 17.7 121.2 11.7 62.9 21.4 122 118.1 87.5 68.1 37.4 30.6 14.4 447.1 63.1 127.3 82.6 3.5 17.6 8.4 27.8 24.7 61.9 40.7 132.6 2.2 50.5 54.6 3.2 1.6 1.6 367.5 36.5 1.6 1.6 1.6 8.4 266.9 1.6 1.6 29.2 1.6 0.1 19 1.7 1.6 1.6 0.1 1.6 1.6 1.6 182.2 7.6 218.3 0.1 2.5 1.6 1.6 3.6 18.6 77.3 0.1 1.6 1.6 1.6 0.1 2 18.7 2.2 4.7 1.6 1.6 1.6 1.6 1.6 127229.1983 75139.07806 12712.36817 3940.507969 55177.94371 144119.338 852112.2039 5024.661273 3800.064672 78479.02387 61092.75139 8488.194722 161836.7671 3617.752354 10160.79374 84793.27718 82869.29291 31755.00836 74824.22844 30982.26301 5841.091809 9858.949718 48681.65611 136.18321 6325.255487 559435.5168 236408.8769 15326.46354 4156.519056 21762.23804 438959.1509 121940.978 10657.77683 1932.12237 86684.30224 11371.46425 31734.46937 46856.69667 22354.17771 108681.0176 185578.0085 651975.1057 18793003 39825672 19208441 44623082 30819394 4244422 175204279 107204209 184466493 53348 92503886 3595879 20196579 10613326 441364243 32599531 5274691 329466463 187675935 416251232 16408434 234140089 156411270 31997551 179851503 1134032049 41830917 1104447389 292 31280350 77015136 52785290 269669147 596246405 256851994 16515606 100.4 38.5 76.3 115 125.4 89.6 47 15.2 125.9 113.9 137.8 227.1 113.2 12 0.1 103.7 119.5 27.7 3.4 102.1 38.9 75.5 113.1 124.2 86.9 47.5 14.6 124.5 111.8 134.5 228.6 101.6 11.4 0.1 109.1 118.6 26.7 3.3 36.5 34.2 103.3 60.9 210.1 171.2 0.1 274.1 16.4 5 31.5 144.4 166.7 0.1 12.2 112.4 241.4 0.1 33.3 22.5 35.2 19.5 16 35.3 11.5 79.3 24.6 38.2 35 101 59.5 214.8 171.3 0.1 282.7 15.4 4.8 30 142.6 165.9 0.1 11.2 109.2 248.2 0.1 32.3 21.8 33.9 19.5 155.1 37.8 8.6 73.4 16.3 1.6 1.6 4.2 70.8 0.1 2.4 4.5 1.6 0.1 15.5 1.6 8.5 1.6 1.6 24.3 1.6 1.6 1.6 1.6 13.4 295.9 59.1 1.6 1.6 4 12.2 527.1 1.6 1.6 1.6 4.1 6.2 1.6 1.6 61.8 1.6 10 1.6 1.6 1.6 0.1 122.4 8.6 1.6 1.6 116.4 1.6 68143.04087 104722.1977 4800.288274 147301530 956193370 59768105 33945.93038 2103042 11565.52251 171024.8471 4393.778658 58792.67852 103940.8384 4344.088981 524641.6945 1741663 183056.71 12830.59813 892.4200354 77910.8327 8737.869045 273495.3558 16641.76303 19084.76725 76499.46915 34641.4534 469359.8502 917805.9936 8699.486191 5373.467604 55916.50723 8827.370389 5075.265473 31704.88298 123867.9694 48705.30381 63742.68355 40185.78464 3542.13589 6736.775942 25236.69326 353765.8718 86621483 57732478 984701 53380233 6420465 5264707 467421431.4 60013234 424685666 173517 288744242 3054666 7316849 88237893 94611869 107863117 76021680 498728152 7363130 59552729 425437 12418130 52391891 536021645 42168803 1819 248649394 160078932 48.4 50.7 39.1 106.1 3.7 69.6 58.6 3.2 51.2 56.1 41.7 106.5 3.6 70.1 57.8 2.7 106.2 117.7 129.5 38.3 94.5 122.9 34 21.5 28.3 19.9 116.3 146.8 104.9 117.9 127.8 38.8 100.8 113.6 33.1 22.8 28.7 20.2 113.3 177.2 9.6 245.2 8 245.9 56.2 103.6 21.6 8.6 103.2 60.9 136.7 38.9 168.4 125.9 1.6 98.2 102.5 80.2 53.4 0.2 100.2 41.2 82.9 12 118.8 11.7 55.3 106.1 20.9 6.3 100.1 61.6 139.2 39.3 187.1 123.8 1.6 104.1 101.4 77.6 53.8 0.1 100.1 42.8 79.5 8.1 117.7 9.7 1.6 3.3 1.6 1.6 2.3 1.6 190.9 372.2 5118.3 115081.358 10417.47774 32003.92829 38348338 14458107 1969539 12988.98945 6575.6831 18633064.59 100163943 128341489 29154215524 25.6 50.3 25.1 26.4 238.8 221.3 110.1 112.2 14054.5 24.7 50.8 23.9 25 250 220 108.2 111.8 14143.4 Sum of Income composition of resources Sum of Schooling 6.646 131.4 11.358 194.2 11.118 203.4 7.334 128.7 7.818 141.5 12.706 264.1 11.174 188.6 14.69 320.6 13.798 246.2 11.243 181.6 11.807 198.8 12.927 225.8 8.286 139.1 12.327 238.3 11.892 236 14.044 268.6 11.103 199.3 7.009 141.6 2.942 163.6 10.14 223.4 7.206 195.6 10.086 194.2 11.363 226.6 13.43 225.7 12.074 219.6 3.675 86.5 5.246 119.7 9.12 7.871 7.52 14.275 5.368 5.066 12.821 10.564 10.91 5.194 8.453 195.2 158 142.5 254 99.8 97.4 238.4 183 195.7 159.3 161.4 11.791 12.625 11.874 13.329 205.4 222.2 235.1 216.3 14.398 6.695 0.721 10.96 11.182 10.362 10.407 8.579 4.085 13.173 5.538 11.236 13.967 13.929 10.47 6.723 10.847 14.312 8.414 13.477 3.731 9.351 5.836 4.067 9.917 7.393 9.442 12.869 14.165 8.792 10.263 11.44 10.136 14.264 13.971 13.729 11.354 14.025 11.664 11.921 7.954 5.82 12.632 9.953 275.1 76 12.7 203.9 208.2 190.3 202.5 133.2 78.8 255 108.8 226.9 276.7 254.4 198.6 130 202.8 265.6 152.2 255 243.3 157.8 114.8 132.6 172.6 135.2 174.2 241.9 290.5 159.7 185.8 202.5 158.5 282.5 251.4 254.9 196.4 239.6 211.8 224.4 159.5 187.1 219.6 197.4 8.25 12.68 7.515 7.309 6.231 11.853 12.907 14.05 7.307 6.57 11.986 10.218 5.843 12.979 7.569 11.562 11.662 9.389 10.593 9.34 9.368 5.773 7.812 9.413 147.7 249.1 219.9 170.5 157.9 236.7 257.6 218.2 149.3 163.7 201 192 102.9 228.9 0 117.1 216.5 197.2 166.4 7.91 14.396 14.259 9.656 4.77 5.878 202.7 171.5 164.6 127.8 133.2 184.8 9.6 166.9 272.9 301.9 177.8 64.3 144 14.903 11.448 8.014 0.779 11.972 7.459 10.499 11.252 10.407 13.011 12.88 13.254 279.5 195.6 107.5 14.2 204.4 136.7 194.7 212.9 184.7 244 255 205.6 12.202 12.195 6.683 0.749 10.636 10.516 10.855 8.452 12.522 6.921 11.867 11.053 5.789 13.87 12.853 13.767 7.684 10.065 2.107 13.609 11.603 7.056 7.697 8.251 14.29 14.577 9.889 9.341 11.115 7.292 8.282 7.135 11.181 12.054 11.082 11.253 3.386 7.125 11.465 13.113 222.8 219.9 148.6 13.4 203.3 210.9 202.3 15.1 164.1 212.6 114 216.5 206.5 131.7 223.7 229.6 263.6 138.2 206.3 24.5 261.7 211.5 102 189.2 165.6 253.9 246.3 175.7 170.9 200.8 198.1 171.2 170.4 227.5 197.3 224.9 202.8 157.3 0 169.5 233.7 205 12.25 9.648 5.88 11.629 10.033 7.608 7.975 7.026 1738.944 243.7 186.3 169.1 204.6 184.2 136.1 179.4 157.2 33280 Paper Outline: You are to “pretend” and put yourself into the following context. You are an outside Business Analytics consultant hired by a company that has a goal of improving their current quantitative analysis processes. They provide you with a basic data set, that needs “cleaning up” by preprocessing, filtering examples with missing attributes, replacing attributes, randomly selecting 1,000 examples from a larger data set, when applicable. You are to write up a professional report discussing your findings. Thus, you will have eight parts: 1. Title page 2. Introduction, company information, consulting firm information. Your story, your interest. 3. Data Understanding, what the data set represents and used for. 4. Data Preparation, how the data set was “cleaned up,” file preparation, missing data removal. 5. Discussion of data dictionary. Include URL of data location. 6. Discussion of correlation matrix, explain any “interesting” correlations. 7. Discussion of scatter plots, and why you selected the specific variables to use. 8. Discussion of PivotTables, and why you selected the specific variables to use. 9. Discussion of bar charts, and why you selected the specific variables to use. 10. Discussion of histograms, and why you selected the specific variables to use. Use the tasks listed above as headings for each section of your report. The final report should be at least 1000 word. YOU ARE TO USE 1.15 LINE SPACING FOR YOUR MS WORD DOCUMENT.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Yo, what's up? �...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags