Tableaue Assignment

User Generated

AvgrfuN

Mathematics

Description

1. Extract the attached Excel file called WORLDBANKSBUX2015.xlsx into a Tableau workbook. Exclude all records for which ROLLUP=1. (I.e, Keep only those records for which ROLLUP=0.)

2. Create a plot that depicts the relationship between the log transform of GDP per Capita (on the horizontal axis) and the log transform of Life Expectancy for All (on the vertical axis). Set the size of each plot point to reflect the Population of its country. Include Country Name as detail in the Marks card.

3. In a separate worksheet create two scatter plots (on the same worksheet) that show separately the log-scale relationship between Life Expectancy for Women v GDP per Capita and Life Expectancy for Men v GDP per Capita. Size each scatter point by Population. Include a trend line (with confidence interval) in each plot.

4. On a third worksheet generate a Tree Map that displays GDP per Capita as the tile size. Set the color of the tiles to reflect country Population; edit the Color options to use Red-Blue Diverging palette, centered at 100,000,000. Include CCountry Name as a label.

5. Create a Symbol Map in a separate worksheet that depicts GDP per Capita by the size of a circle and Life Expectancy (for ALL) by the color of the circle. For color use the Green-Gold palette. Create a filter that excludes all countries whose Life Expectancy value is missing or null. Edit the Size of the circles to increase the size at the smallest end of the range of GDP per Capita values.

6. Create a filled map that depicts GDP per Capita by the color of each country. Use the Red-Blue Diverging palette, centered on 20,000. Overlay a Circle that depicts Life Expectancy (ALL) by Size. Create a Filter in the worksheet that excludes all countries that do not have at least 1 Starbucks store.

7. Submit your work in a .twbx file.

Unformatted Attachment Preview

Country_Name Aruba Afghanistan Angola Albania Andorra Arab World United Arab Emirates Argentina Armenia American Samoa Antigua and Barbuda Australia Austria Azerbaijan Burundi Belgium Benin Burkina Faso Bangladesh Bulgaria Bahrain Bahamas, The Bosnia and Herzegovina Belarus Belize Bermuda Bolivia Brazil Barbados Brunei Darussalam Bhutan Botswana Central African Republic Canada Central Europe and the Baltics Switzerland Channel Islands Chile China Cote d'Ivoire Cameroon Congo, Dem. Rep. Congo, Rep. Colombia Comoros Cabo Verde Country_Code ABW AFG AGO ALB AND ARB ARE ARG ARM ASM ATG AUS AUT AZE BDI BEL BEN BFA BGD BGR BHR BHS BIH BLR BLZ BMU BOL BRA BRB BRN BTN BWA CAF CAN CEB CHE CHI CHL CHN CIV CMR COD COG COL COM CPV Year 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 Costa Rica Caribbean small states Cuba Curacao Cayman Islands Cyprus Czech Republic Germany Djibouti Dominica Denmark Dominican Republic Algeria East Asia & Pacific (excluding high income) Early-demographic dividend East Asia & Pacific Europe & Central Asia (excluding high income) Europe & Central Asia Ecuador Egypt, Arab Rep. Euro area Eritrea Spain Estonia Ethiopia European Union Fragile and conflict affected situations Finland Fiji France Faroe Islands Micronesia, Fed. Sts. Gabon United Kingdom Georgia Ghana Gibraltar Guinea Gambia, The Guinea-Bissau Equatorial Guinea Greece Grenada Greenland Guatemala Guam Guyana CRI CSS CUB CUW CYM CYP CZE DEU DJI DMA DNK DOM DZA EAP EAR EAS ECA ECS ECU EGY EMU ERI ESP EST ETH EUU FCS FIN FJI FRA FRO FSM GAB GBR GEO GHA GIB GIN GMB GNB GNQ GRC GRD GRL GTM GUM GUY 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 High income Hong Kong SAR, China Honduras Heavily indebted poor countries (HIPC) Croatia Haiti Hungary IBRD only IDA & IBRD total IDA total IDA blend Indonesia IDA only Isle of Man India Not classified Ireland Iran, Islamic Rep. Iraq Iceland Israel Italy Jamaica Jordan Japan Kazakhstan Kenya Kyrgyz Republic Cambodia Kiribati St. Kitts and Nevis Korea, Rep. Kuwait Latin America & Caribbean (excluding high income) Lao PDR Lebanon Liberia Libya St. Lucia Latin America & Caribbean Least developed countries: UN classification Low income Liechtenstein Sri Lanka Lower middle income Low & middle income Lesotho HIC HKG HND HPC HRV HTI HUN IBD IBT IDA IDB IDN IDX IMN IND INX IRL IRN IRQ ISL ISR ITA JAM JOR JPN KAZ KEN KGZ KHM KIR KNA KOR KWT LAC LAO LBN LBR LBY LCA LCN LDC LIC LIE LKA LMC LMY LSO 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 Late-demographic dividend Lithuania Luxembourg Latvia Macao SAR, China St. Martin (French part) Morocco Monaco Moldova Madagascar Maldives Middle East & North Africa Mexico Marshall Islands Middle income Macedonia, FYR Mali Malta Myanmar Middle East & North Africa (excluding high income) Montenegro Mongolia Northern Mariana Islands Mozambique Mauritania Mauritius Malawi Malaysia North America Namibia New Caledonia Niger Nigeria Nicaragua Netherlands Norway Nepal Nauru New Zealand OECD members Oman Other small states Pakistan Panama Peru Philippines Palau LTE LTU LUX LVA MAC MAF MAR MCO MDA MDG MDV MEA MEX MHL MIC MKD MLI MLT MMR MNA MNE MNG MNP MOZ MRT MUS MWI MYS NAC NAM NCL NER NGA NIC NLD NOR NPL NRU NZL OED OMN OSS PAK PAN PER PHL PLW 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 Papua New Guinea Poland Pre-demographic dividend Puerto Rico Korea, Dem. People’s Rep. Portugal Paraguay West Bank and Gaza Pacific island small states Post-demographic dividend French Polynesia Qatar Romania Russian Federation Rwanda South Asia Saudi Arabia Sudan Senegal Singapore Solomon Islands Sierra Leone El Salvador San Marino Somalia Serbia Sub-Saharan Africa (excluding high income) South Sudan Sub-Saharan Africa Small states Sao Tome and Principe Suriname Slovak Republic Slovenia Sweden Swaziland Sint Maarten (Dutch part) Seychelles Syrian Arab Republic Turks and Caicos Islands Chad East Asia & Pacific (IDA & IBRD countries) Europe & Central Asia (IDA & IBRD countries) Togo Thailand Tajikistan Turkmenistan PNG POL PRE PRI PRK PRT PRY PSE PSS PST PYF QAT ROU RUS RWA SAS SAU SDN SEN SGP SLB SLE SLV SMR SOM SRB SSA SSD SSF SST STP SUR SVK SVN SWE SWZ SXM SYC SYR TCA TCD TEA TEC TGO THA TJK TKM 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 Latin America & the Caribbean (IDA & IBRD countries) Timor-Leste Middle East & North Africa (IDA & IBRD countries) Tonga South Asia (IDA & IBRD) Sub-Saharan Africa (IDA & IBRD countries) Trinidad and Tobago Tunisia Turkey Tuvalu Tanzania Uganda Ukraine Upper middle income Uruguay United States Uzbekistan St. Vincent and the Grenadines Venezuela, RB British Virgin Islands Virgin Islands (U.S.) Vietnam Vanuatu World Samoa Kosovo Yemen, Rep. South Africa Zambia Zimbabwe TLA TLS TMN TON TSA TSS TTO TUN TUR TUV TZA UGA UKR UMC URY USA UZB VCT VEN VGB VIR VNM VUT WLD WSM XKX YEM ZAF ZMB ZWE 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 NY_GDP_PCAP_CD_NUM 584.0259 3695.7937 3954.0228 NY_GNP_PCAP_CD_NUM SP_DYN_LE00_IN_NUM SP_DYN_CBRT_IN_NUM 75.5736 10.044 590 60.7172 33.314 4070 52.6661 44.998 4300 78.0145 13.632 6430.072 39101.7469 13467.1024 3609.6548 11541.855 13566.9054 56554.0388 43665.0095 5500.3104 303.681 40356.875 783.9471 615.5922 1210.1581 6993.4774 22688.8782 22888.1341 4574.0908 5949.1107 4849.9975 7036.5604 42910 12430 4020 70.7141 77.5412 76.3342 74.7971 26.3922 10.592 17.359 13.008 12800 60330 47290 6550 280 44410 870 650 1190 7480 22740 20790 5030 6720 4500 3077.0262 8757.2062 15557.8308 30967.8905 2613.6452 6532.0605 348.3814 43315.7004 12411.0716 80989.8402 3000 10080 14620 38520 2350 6640 360 47250 13158.7066 84540 13653.2264 8069.2119 1420.6269 1244.4294 474.936 1712.1211 6044.5256 727.6464 2954.1195 14320 7940 1490 1350 430 2350 7140 790 3150 76.1002 82.4512 81.8439 70.8488 57.107 81.2878 59.7207 58.9313 72.0012 74.4659 76.8191 75.3968 76.5886 73.6244 70.1924 81.0122 68.7396 74.6759 75.6584 79.0408 69.8329 64.4874 51.4191 82.1376 77.0269 83.1976 80.7517 81.7876 75.9863 51.9198 55.9344 59.0239 62.8677 74.182 63.554 73.3556 16.202 12.7 9.8 17.2 43.497 10.9 35.592 39.53 19.455 9.2 14.205 15.044 8.818 12.5 22.758 9.4 23.591 14.513 12.011 15.691 17.404 24.57 33.435 10.9 9.7158 10.2 9.41 13.048 12.1 36.895 36.233 41.527 36.028 15.483 33.433 21.108 11406.3627 9271.3648 7602.2612 10570 9038.7434 79.5865 73.0302 79.5464 14.524 16.7687 10.089 11.9 23075.1127 17556.9243 41176.8816 1862.1673 7069.5028 53014.6442 6468.4716 4132.7603 6514.6162 3237.1285 9541.1447 7518.7596 22347.204 6205.0622 3547.713 34213.5121 25810 18150 45780 80.3071 79.4732 81.0902 62.2857 11.206 10.5 9 24.721 6760 60270 6240 4820 6476.5279 3369.9634 9793.528 8759.7925 24438.873 6030 3360 37502.7933 25683.8457 17074.9209 645.4638 32047.7492 1546.674 42405.3974 4921.8962 36526.7701 28370 18310 600 34545.2779 1576.792 46630 4810 40530 3016.0112 7388.9841 43929.6908 3764.6409 1361.1139 3560 8010 43700 4120 1470 81.1 73.6767 75.0425 74.1742 69.3208 75.106 72.2134 77.2789 76.1029 71.317 82.0703 64.1009 83.3805 77.1317 64.578 81.1264 61.4418 81.3854 70.2563 82.6707 81.6341 69.2342 64.8903 81.6049 74.8174 61.4917 10.2 20.506 23.692 14.2536 21.3677 13.6716 15.076 12.3511 20.487 27.298 9.6676 33.393 9 10.6 31.906 9.9851 33.5838 10.1 19.688 12 12.4 23.571 29.718 11.9 13.359 32.262 554.0409 474.7166 596.8717 10347.3126 18007.7899 9212.1928 39569.1058 3923.5733 35439.4704 4136.6899 490 450 610 9190 20270 8650 59.1934 60.4677 55.4673 57.9634 81.5878 73.523 3610 71.9565 79.379 66.5075 36.409 41.698 36.647 34.626 8.5 19.019 15.2 26.752 17.183 19.288 4120 40078.0541 42351.0246 2326.1585 877.1028 11579.667 814.5464 12365.626 5541.7751 4489.7837 1315.9925 1917.1997 3336.1067 1010.6779 42046.1047 41100 2090 862.4017 12750 810 12970 5757.0878 4655.5177 1330.2984 2007.2738 3440 984.5957 80.7796 84.278 73.3331 61.2152 77.2756 63.0738 75.961 72.355 69.9854 62.823 60.663 69.0717 63.8912 10.9381 8.2 20.881 36.5857 8.9 24.578 9.4 16.8591 20.6745 32.2073 33.0691 19.579 31.781 1613.1887 1600 68.3486 19.658 60664.1044 4957.5813 4974.0269 50734.4436 35729.3725 30049.1475 4965.9899 4096.0993 34474.1374 10509.9811 1349.9701 1121.0828 1163.1898 1424.4836 16144.9778 27105.0762 28975.4011 8148.6336 2159.423 8046.6329 452.0381 52170 5960 50260 35780 32870 4750 3890 38780 11390 1310 1180 1070 3390 15420 27250 41680 8700.5442 2000 7720 380 81.5024 75.5913 69.5903 82.861 82.0512 83.4902 75.7982 74.2033 83.8437 72 62.1337 70.6512 68.6561 66.1479 14.2 17.084 34.233 12.5 21.3 8 17.23 26.512 7.9 22.66 34.084 27.4 23.776 28.506 8076.1131 8492.7335 971.1153 625.6174 7650 9005.935 952.4207 622.6438 3844.8912 2031.8664 4389.2869 1073.8281 3750 2067.7951 4546.9929 1300 82.1559 74.6979 74.9412 66.5399 79.6286 61.161 71.8263 75.1845 75.164 63.5277 61.7309 82.0732 74.9532 67.4174 69.913 49.9612 8.6 19.559 17.289 26.27 15.397 34.613 20.303 14.933 17.092 32.4811 35.9158 8.7 15.601 23.0309 20.74 28.461 8200.776 14252.4285 101909.8223 13666.5834 75573.4807 8491.2427 15090 71240 14980 64580 2847.2856 3000 1832.4991 401.8576 8395.7852 7350.7343 9143.1285 3385.9041 4831.5324 4834.1367 729.7205 23819.4636 1194.5901 3933.9501 6461.1926 3944.18 16819.9066 528.3126 1158.2565 9252.1107 362.6575 9643.6447 54918.0833 4737.6699 2230 420 7010 8202.261 9830 4550 5008.5084 5100 760 24780 1190 590 1230 9780 340 10440 55197.7445 5260 358.997 2655.158 2095.9665 44292.8847 74505.2465 743.7653 8052.8884 38201.8904 36280.5409 16627.3643 12555.7478 1431.2449 13134.0437 6030.3433 2878.3384 13500.5637 390 2870 1960 48850 93560 730 11850 40020 38080.9787 18080 13713.6857 1430 11730 6110 3520 12180 7260 3850 75.3628 75.1195 82.2293 74.1244 80.7661 79.4707 74.2893 71.6264 65.4828 76.979 73.0536 76.9207 13.0392 10.8 10.7 11.1 11.681 15.4 20.38 8.1 10.566 34.223 20.804 23.3631 18.47 70.8682 75.4953 58.4572 81.9463 66.0421 72.4835 76.3377 69.8213 18.9697 11.257 42.908 10 17.49 24.2588 11.441 23.429 55.3712 63.2028 74.3532 63.7969 74.8752 79.0831 64.9154 77.7732 61.969 53.0489 75.0981 81.7073 82.1 69.9733 38.81 33.002 10.1 38.542 16.789 12.2487 29.414 16.4 49.211 39.125 19.926 10 11.4 20.216 81.4568 80.3248 77.3242 66.6146 66.377 77.7673 74.7807 68.4068 13.27 11.7863 19.322 24.4813 28.845 19.124 19.6 23.316 12565.9876 1517.468 13300 1608.2763 19220.0068 4109.3677 2865.8051 3635.9859 40163.0508 20370 4210 3260 3796.7256 42109.5361 66346.5227 8958.7886 9329.2984 710.3484 1550.8632 20732.8617 2513.8847 908.7256 53629.7375 1922.0414 587.5038 4127.1177 75660 9520 11660 710 1540.6116 23810 2000 980 52740 1910 550 3840 62.7767 78.2049 58.7487 79.5723 70.3379 81.522 73.0256 73.0742 70.1062 80.6451 76.7524 78.7626 74.961 70.9085 64.5245 68.4332 74.4933 63.7107 66.8044 82.5951 68.1462 51.3082 73.0011 426.0099 5237.2553 1590.9621 758.7206 1592.2444 11407.0247 1624.604 8818.9826 16089.7485 20729.8638 50585.2585 3136.9251 5540 1650.3399 820 1651.5504 12244.0367 1700 8860 17570 22250 57770 3130 55.6856 75.4878 58.9733 56.1115 58.9746 67.9926 66.5137 71.2942 77.2122 81.078 82.5512 48.874 28.151 9.7 38.5292 9 14.326 8.3 21.167 32.363 24.2425 10.5319 15.997 11.806 9.3 13.3 31.163 20.8605 19.688 32.645 37.522 9.7 29.298 35.445 17.175 8.2 43.373 9.3 36.742 36.397 36.7402 23.0573 33.532 17.946 10.3 10 11.7 29.372 15390.0406 14680 73.2293 70.0893 17 22.509 777.2487 6583.8225 7942.0314 551.1308 5814.8631 918.6772 6432.6688 880 6545.4755 9140.2978 540 5690 1240 7120 51.8733 74.2223 72.7159 60.1208 74.6012 69.7684 65.7364 44.792 14.2527 14.6251 35.068 10.532 30.225 20.842 8379.7783 1161.7609 3946.3766 4093.7754 1550.8632 1592.2444 17321.8337 3828.0916 10979.5257 2970.028 872.2941 693.8964 2124.6627 8076.6487 15524.8425 56207.0367 2137.5769 6739.6058 36350.8216 2107.0129 2805.8341 10130.1817 4149.3634 3574.4818 1401.9033 5769.7726 1313.8896 1018.6931 8976.8557 2180 4240 1540.6116 1651.5504 17640 3930 12000 5620 910 680 2650 8416.8183 15830 56070 2170 6630 1990 10577.6695 4070 3980 1140 6090 1560 960 75.0559 68.5264 72.4763 72.944 68.4332 58.9746 70.5577 74.976 75.4262 17.2757 37.097 24.16 24.331 20.8605 36.7402 13.979 17.94 16.489 65.4875 59.1791 71.1895 74.8714 77.1382 78.7415 68.4531 73.0524 74.4096 38.535 42.528 10.7 14.2584 14.148 12.4 23.5 15.776 19.268 79.8732 75.7777 72.1574 71.664 73.7649 71.3463 64.0314 57.4409 60.7857 59.1611 10.3 16.941 26.167 19.1573 25.097 17.1 31.889 20.415 39.672 34.521 SP_DYN_CDRT_IN_NUM SP_DYN_LE00_FE_IN_NUM SP_DYN_LE00_MA_IN_NUM 8.667 78.069 73.197 8.034 61.97 59.524 13.424 54.216 51.19 7.463 80.557 75.593 5.7475 1.641 7.55 9.316 72.6531 78.665 80.21 78.719 68.8989 76.471 72.643 71.062 6.087 6.6 9.6 5.7 11.066 9.8 9.244 9.343 5.35 15.3 2.367 6.234 10.69 12.6 5.568 7.4 7.359 6.163 10.65 3.024 6.218 7.536 14.088 7.5 11.8296 8.1 9.05 5.137 7.1 13.323 11.197 10.096 8.308 5.93 7.38 5.344 78.611 84.5 84.2 74.092 59.184 83.9 61.203 60.284 73.316 78 77.781 78.491 79.168 78.9 73.075 84.91 71.276 78.503 78.118 80.938 70.112 66.864 53.409 84.127 80.8399 85.4 82.697 84.725 77.547 52.791 57.136 60.519 64.436 77.835 65.275 75.24 73.709 80.5 79.6 67.76 55.129 78.8 58.309 57.643 70.749 71.1 75.903 72.45 74.132 68.6 67.447 77.3 66.324 71.031 73.316 77.234 69.567 62.224 49.524 80.243 73.4068 81.1 78.899 78.99 74.5 51.09 54.79 57.6 61.374 70.703 61.915 71.561 4.889 7.6471 7.929 8.8 82.066 75.8351 81.629 77.225 70.3607 77.563 6.897 10.5 11.3 8.551 82.55 82.7 83.6 63.959 78.171 76.4 78.7 60.692 9.2 6.087 5.114 7.0819 6.8413 7.2017 10.4033 10.1746 5.119 6.066 10.0654 6.408 9 11.6 7.198 10.2605 8.9629 9.6 6.982 9 7.7 6.149 8.391 9.3 11.533 8.821 83.2 76.882 77.456 76.154 71.2552 77.1802 76.7307 80.8016 78.899 73.566 84.8562 66.31 86.3 82.1 66.592 83.9394 63.1298 84.1 73.353 86 84.4 70.274 65.674 83.5 78.496 62.511 79.1 70.624 72.744 72.3092 67.4979 73.0631 67.9814 74.0067 73.44 69.175 79.4264 61.997 80.6 72.4 62.66 78.4604 59.7636 78.8 67.307 79.5 79 68.244 64.144 79.8 71.314 60.521 9.678 8.58 11.9 10.594 11.2 7.117 8.5 5.339 4.855 8.242 59.679 61.867 57.302 59.353 84.2 76.022 58.731 59.135 53.72 56.64 79.1 71.143 75.569 82.025 68.88 68.516 76.859 64.248 8.6212 6.3 5.015 8.8075 12.9 8.629 13.4 7.2929 7.5783 8.4408 9.4199 7.167 7.9566 83.5168 87.3 75.911 62.761 80.4 65.268 79.7 74.6356 72.0479 64.2951 61.7789 71.206 65.5209 78.2474 81.4 70.878 59.7475 74.3 60.984 72.4 70.2372 68.0617 61.413 59.6181 67.039 62.317 7.306 69.858 66.911 6.4 4.607 5.112 6.6 5.3 10.7 6.914 3.839 10.2 7.48 8.025 5.8 6.038 6.971 83.5 76.711 71.847 84.5 84.1 86 78.248 75.932 87.05 76.9 64.077 74.8 70.75 69.451 79.6 74.525 67.441 81.3 80.1 81.1 73.465 72.557 80.79 67.5 60.283 66.7 66.662 63.002 5.4 2.523 5.9117 6.629 4.547 8.52 5.368 7.257 5.9343 8.0907 8.7214 6.7 6.844 7.6215 7.5677 14.693 85.48 75.899 78.2473 67.973 81.493 62.192 74.753 77.956 78.4662 65.0534 63.3523 83.2 78.389 69.267 71.9614 50.036 78.99 73.554 71.8016 65.175 77.853 60.179 69.039 72.545 72.0274 62.0807 60.193 81 71.681 65.6774 68.0019 49.89 7.4077 14.1 7 14.4 4.816 4.2 5.682 7.6 11.363 6.52 3.761 5.1375 4.814 77.8391 80.6 85.2 79.4 82.947 82.8 75.347 73.0876 69.9 79.4 69.1 78.689 76.3 73.282 75.871 67.046 77.987 74.9622 79.391 67.584 63.994 76.019 71.2619 74.568 7.4378 9.492 10.118 8 8.263 5.4564 10.035 6.087 72.9866 77.854 58.28 84.2 68.16 74.55 78.555 74.22 68.8964 73.249 58.626 79.8 64.025 70.5098 74.226 65.632 11.235 7.861 7.7 7.471 4.983 8.1295 7.033 5.3 8.819 12.704 4.753 8.7 7.8 6.339 56.81 64.743 77.79 64.79 77.283 81.494 67.501 81 62.934 53.411 78.18 83.5 84.2 71.45 54.001 61.736 71.08 62.851 72.582 76.7864 62.453 74.7 61.05 52.704 72.163 80 80.1 68.567 6.87 8.3606 2.666 8.1087 7.339 5.044 5.619 6.773 83.27 83.0428 79.416 67.7108 67.365 80.863 77.48 71.945 79.73 77.7424 75.332 65.6123 65.436 74.819 72.21 65.037 7.649 10.4 9.9241 8.5 9.289 10.5 5.693 3.582 6.1569 9.2993 5.649 1.486 13.2 13 6.833 7.1201 3.418 7.662 5.99 4.8 5.7 13.268 6.833 7.1 11.807 14.6 9.9455 11.352 9.9453 7.9103 6.814 7.461 9.9 9.6 9.3 14.485 4.6 7.5 5.715 64.974 82.2 60.0028 83.549 73.932 84.8 75.246 75.124 72.5905 83.4017 79.066 80.061 78.7 76.64 67.4 69.9 75.886 65.276 68.782 84.9 69.648 51.868 77.659 60.684 74.4 57.5614 75.785 66.915 78.4 70.911 71.122 67.7414 78.04 74.549 77.526 71.4 65.45 61.786 67.0383 73.167 62.22 64.921 80.4 66.716 50.775 68.565 57.362 78.1 60.3434 57.119 60.3451 69.5541 68.584 74.584 80.9 84.1 84.6 48.078 54.089 73 57.6783 55.152 57.6793 66.5675 64.542 68.161 73.7 78.2 80.6 49.632 78.3 76.586 68.4 63.902 13.799 7.0542 10.4031 8.699 8.028 5.568 7.789 52.994 76.1831 77.1864 60.887 78.037 73.362 70.044 50.806 72.374 68.5279 59.391 71.329 66.346 61.634 5.8788 6.809 5.4793 5.985 7.1201 9.9453 9.507 6.593 5.735 78.3781 70.357 74.5431 75.966 69.9 60.3451 74.161 77.392 78.735 71.9 66.783 70.5023 70.066 67.0383 57.6793 67.126 72.675 72.275 6.682 9.324 14.9 7.2248 9.344 8.2 4.9 7.127 5.567 66.937 61.108 76.25 77.2577 80.762 81.2 71.936 75.242 78.626 64.107 57.342 66.37 72.6636 73.687 76.4 65.136 70.967 70.394 8.5 5.847 4.718 7.7401 5.334 7 6.829 12.409 8.671 9.086 83.1 80.577 74.263 73.8209 77.025 73.6 65.443 59.524 62.857 60.67 76.8 71.207 70.152 69.6007 70.66 69.2 62.687 55.457 58.813 57.724 SP_POP_TOTL_NUM SL_TLF_TOTL_IN_NUM SL_TLF_CACT_NE_ZS_NUM SL_TLF_ADVN_ZS_NUM 104341 33736494 9912421 27859305 9969046 2880703 1180401 55.66 73.2 78014 398304960 132336791 9154302 6307782 43417765 19805374 2916950 1507674 62.49 77.06 55537 99923 23789338 12514135 64.94 8633169 4461587 60.72 76.89 9649341 4897777 65.4 10199270 4710618 11274196 5018928 53.31 74.92 10575952 4384085 18110624 8230302 161200886 70684503 7177991 3337799 54.07 74.28 1371855 745392 71.57 386838 226754 3535961 1410263 43.15 9489616 4838699 82.1 359288 169435 65.42 65235 10724705 5299681 205962108 106393674 55.73 82.439 284217 151927 65.06 417542 203934 787386 382487 63.14 2209197 1162191 4546100 2161279 35848610 19748539 65.84 75.746 103257751 49714456 56.2024 78.4875 8282396 4847099 68.89 81.53 163758 81108 17762681 8849426 59.82 74.29 1371220000 804772331 70.69 23108472 8902527 22834522 9976980 76196619 29266577 4995648 2001219 48228697 25038315 69.75 777424 266556 532913 256036 4807852 7204948 11461432 157979 59963 1160985 10546059 81686611 927414 73162 5683483 10528394 39871528 2036552598 3127290269 2281203360 414975737 907424836 16144368 93778172 339519210 46447697 1315407 99873033 509703315 493919601 5479531 892149 66624068 48965 104433 1930175 65128861 3717100 27582821 34228 12091533 1977590 1770526 1175389 10820883 106823 56114 16252429 161797 768514 2300263 3345067 5333393 619334 5325665 42938317 326389 2930945 4816022 12449604 1148755571 1277634842 1263996982 195928435 436291427 7355668 30992654 162708539 23083198 683442 48520089 247234351 180946782 2681750 345499 29956082 592472 33568446 2063073 12988751 5719317 822807 762265 585722 4776561 6331819 74898 325700 61.244 62.9986 73.69 82.78 62.29 59.42 60.17 85.95 83.81 75.62 73.34 62.22 64.85 77.13 78.79 69.9675 69.0193 62.5123 60.0042 65.78 46.87 56.8119 79.0509 78.5298 75.57 76.6845 58.83 62.12 81.28 81.27 57.7002 78.1107 58.94 74.82 56.06 77.52 62.76 67.8 83.77 51.99 76.27 60.36 1182929820 7305700 8960829 724482652 4203604 10711061 9843028 4652578287 6191917218 1539338931 509396383 258162113 1029942548 83167 1309053980 579483253 3881323 4012902 300109088 1870544 4705738 4539051 2211876719 2826610534 614733815 182096605 125748956 432637210 4676835 79360487 36115649 330815 8380100 60730582 2871934 9159302 127141000 17544126 47236259 5956900 15517635 112407 54288 51014947 3935794 603644865 6663967 5851479 4499621 6234955 177206 631058524 956631108 641858608 37403 20966000 2970020158 6168074513 2174645 2195319 26996426 9047136 195258 3870482 25352622 1423293 2360397 65671238 9155963 18409762 2569651 8584155 60.298 61.16 64.92 76.9757 76.58 52.7 73.09 54.76 72.71 57.2747 65.76 86.64 500844101 26668184 2114243 292446434 3363916 2091363 1581809 2328229 94786 305358813 402350657 274427414 8187937 1192432162 2817394214 923394 60.01 41.76 80.27 82.99 64.09 48.97 63.13 91.71 59.56 71.148 77.56 74.25 62.38 62.56 60.3548 72.23 60.2272 61.42 53.82 77.87 2248927194 2904910 569604 1977527 600942 31754 34803322 38307 3554108 24234088 409163 428961724 125890949 52994 5530431984 2079308 17467905 431874 52403669 367449306 622159 2976877 54816 28010691 4182341 1262605 17573607 30723155 356810463 2425561 273000 19896965 181181744 6082035 16939923 5188607 28656282 12475 4595700 1281401703 4199810 29374084 189380513 3969249 31376671 101716359 21288 1259557600 1468256 281552 1015704 371639 68.359 59.16 59.98 60.07 73.7 82.37 79.18 83.22 91.75 42.37 86.38 69.24 12463457 1258378 12210838 201661 146860305 56674293 2544837344 964833 6065101 193306 29610932 117204945 247365 1335718 12115585 1184416 616758 7805829 14584498 181311112 911390 119490 6375352 57140119 2733672 9021466 2760970 16017194 2478046 625485249 2308143 13263190 66349268 1891739 16761635 44757313 59.81 55.38 80.55 54.48 83.83 53.71 61.5 60.37 67.88 62.9811 69.33 75.0955 72.25 64.38 64.98 80.54 85.01 68.68 59.8159 77.0831 45.2 64.12 68.19 63.67 77.12 63.16 7919825 37986412 854646007 3473181 25243917 10358076 6639119 4422143 2358955 1097570905 277690 2481539 19815481 144096870 11629553 1744190704 31557144 38647803 14976994 5535002 587482 7237025 6312478 32960 13908129 7095383 1005477382 11882136 1005570801 38937987 195553 553208 5423801 2063531 9799186 1319011 38824 93419 18734987 34339 14009413 2011274432 452962149 7416802 68657600 8548651 5565284 3501238 18368877 311080460 1193857 15823429 5210143 3315877 1155262 796714 550326090 119182 1773588 9354147 76150461 5821183 672579571 12342424 11063651 4806441 3139341 239447 2785116 2890547 56.16 80.42 40.021 58.6 68.45 45.81 82.2 60.694 76.6885 88.627 54.54 69.14 81.84 80.61 54.02 68.3 76.7 4022077 3055638 392349802 392349802 17404971 67910 220638 2740110 1010862 5230339 428318 51.59 59.64 57.32 72 74.11 76.87 83.39 71.13 4907922 5243231 1132932142 214297312 3464307 40319660 3815577 2474856 69.9675 61.89 68.95 79.2036 614891969 1240977 363027163 106364 1744190704 1005570801 1360092 11273661 78271472 11001 53879957 40144870 45154029 2560411826 3431552 320896618 31298900 109455 31155134 30113 103574 91713300 264603 7355220412 193759 1801800 26916207 55011976.68 16100587 15777451 298402024 295214 116049683 42539 672579571 392349802 677327 4119100 29254041 23202254 17706638 22691303 1352405182 1762230 161562573 13829996 55206 14496763 50857 55261497 119319 3398748011 49911 7967005 20642934 6557573 7592686 60.3673 60.58 51.24 79.59 62.36 66.3749 64.934 62.65 73.54 75.016 63.86 77.41 85.39 33.46 64.18 54.59 SL_TLF_TOTL_FE_ZS 17.49094394 44.59706576 40.82273736 21.65351525 12.11860207 41.03705388 47.53487823 45.58124073 46.53855231 48.79956764 51.6526494 46.05170666 49.39701215 46.92018592 34.52760501 46.56520659 19.85773928 48.36342468 37.71176015 48.86650317 40.72358131 43.9424939 43.10604313 49.71598202 38.8645346 39.92841587 47.72649246 46.91175919 47.1714338 45.32933549 46.36812658 43.95990531 41.45398809 43.87559617 38.10169854 46.92282635 50.13289733 48.2408472 43.37618965 30.67985714 39.88032933 ROLLUP stores 0 3 0 0 0 0 1 1 0 144 0 108 0 0 0 0 22 0 18 0 4 0 0 19 0 0 0 0 5 0 21 0 10 0 0 0 0 0 4 0 102 0 0 5 0 0 0 0 1468 1 0 61 0 0 96 0 2734 0 0 0 0 0 11 0 0 38.19767566 43.273765 38.27645928 44.15807949 44.06272268 46.2512492 34.87954557 47.41525344 40.52026756 19.20094808 43.4778262 31.55926854 43.45289568 44.51605517 45.28353651 38.47865347 22.99809819 45.84661718 46.06411122 48.42737204 46.92427089 45.83444982 40.72868475 48.11809453 33.68750706 47.67754341 40.35211791 46.41297068 45.48229752 50.10558752 48.32986176 47.92010763 46.79737362 41.89120436 43.89187116 35.05714551 44.11866806 35.01750077 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 3 10 28 160 21 31 101 8 132 901 28 7 43.96133168 47.47427617 36.26290899 45.17839505 46.44552601 47.54229836 45.61303673 37.73935078 38.47429883 41.11871897 35.98934897 37.78012042 43.27766613 24.20407024 44.12447576 18.10937122 17.76137774 47.79983407 46.99151165 42.11458286 44.99797301 17.33547365 42.89390128 49.00775593 46.5366907 40.25383214 48.75937119 41.6608945 29.69147823 41.19793145 51.10894565 24.77652134 47.61187982 26.22431041 46.56278353 41.24398886 43.67089111 46.70955794 30.6744666 32.07632452 38.45640593 45.49791313 1 0 0 1 0 0 0 1 1 1 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 1 0 0 1 1 0 16 268 88 73 17 1237 8 4 993 106 29 43.7281825 50.00401837 44.15560891 49.60155715 48.70183162 26.40119832 48.50140419 49.01200884 42.53276538 21.06717755 37.03767597 37.57228375 39.6845879 37.80083794 37.30924027 49.79986783 21.39830125 43.88898995 45.98829993 54.52718131 30.80733459 39.38935531 50.56965762 37.63997911 45.93811713 49.0354294 40.34647251 31.26702651 42.39704681 39.45385547 45.71445483 46.97733043 50.79405294 47.80056545 43.85961987 12.88226076 38.43562811 22.06049658 38.76057955 44.78118632 39.10694326 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 2 9 2 579 234 59 17 24 12 5 89 298 48.96959304 45.08365427 43.42333327 42.69506314 47.82333842 48.77981276 40.08263877 20.20563301 38.67179606 45.41836851 41.47941803 15.02062486 44.34714357 48.63389599 54.51457204 25.7050565 15.10729983 25.30407006 41.07407123 44.21271853 45.14067831 49.53520787 42.73668617 31.07419376 43.54246151 45.67737016 45.67737016 39.3762816 37.91194228 37.43507465 44.91881713 46.0711749 47.4651643 39.45106206 14.53144528 44.95561992 43.41713332 44.56470794 51.27773029 45.09257271 43.31604368 39.25650624 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 53 24 11 18 27 109 102 130 11 3 18 289 41.28071344 32.04319578 21.41017414 42.38933684 25.7050565 45.67737016 42.67421792 26.88769391 31.08437566 47.81280732 48.84621801 48.21187219 42.4181381 44.52046555 45.78736314 40.33692418 41.76719922 40.30062435 45.85406139 48.35797336 43.54042525 39.39938736 27.33265212 25.97606001 44.77195926 46.76728723 48.42638033 1 0 1 0 1 1 0 3 0 0 326 0 0 0 0 1 0 0 13608 0 0 0 0 0 0 25 0 1 0 0 0 0 3 0 0 Column Name Country_Name Country_Code Year NY_GDP_PCAP_CD_NUM NY_GNP_PCAP_CD_NUM SP_DYN_LE00_IN_NUM SP_DYN_CBRT_IN_NUM SP_DYN_CDRT_IN_NUM SP_DYN_LE00_FE_IN_NUM SP_DYN_LE00_MA_IN_NUM SP_POP_TOTL_NUM SL_TLF_TOTL_IN_NUM SL_TLF_CACT_NE_ZS_NUM SL_TLF_ADVN_ZS_NUM SL_TLF_TOTL_FE_ZS ROLLUP stores Label Name of Country 3-Letter Country Code Data Year GDP per capita (current US$) GNI per capita Atlas method (current US$) Life expectancy at birth total (years) Birth rate crude (per 1000 people) Death rate crude (per 1000 people) Life expectancy at birth female (years) Life expectancy at birth male (years) Population total Labor force total Labor force participation rate total (% of total population ages 15+) (national estimate) Labor force with advanced education (% of total working-age population with advanced education) Labor force female (% of total labor force) Is the record a rollup of multiple countries? 1=YES, 0=NO Count of Starbucks Stores
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

Hi NiteshA, kindl...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags