IS335 UC Irvine Business information system DBMS and SQL Questions

User Generated

XevfYYY

Business Finance

IS335

UC Irvine

Description

the exam has

2 short essay questions

1 excel questions

1 question of your choice

bonus question

Unformatted Attachment Preview

Introduction to DBMS and SQL https://www.w3schools.com/sql/default.asp Data Analytics at a Glance! 11/19/19 2 Database Management System (DBMS) ■ Collection of interrelated data ■ Set of programs to access the data ■ DBMS contains information about a particular enterprise ■ DBMS provides an environment that is both convenient and efficient to use. ■ Database Applications: ★ Banking: all transactions ★ ★ ★ ★ ★ Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions ■ Databases touch all aspects of our lives 11/19/19 3 Application Architectures §Two-tier architecture: E.g. client programs using ODBC/JDBC to communicate with a database §Three-tier architecture: E.g. web-based applications, and applications built using “middleware” 11/19/19 4 A Sample Relational Database 11/19/19 5 The Dangers in a Relational Database • It looks very easy to use a RDBMS – learning about normalization, SQL, etc. make for instant “experts.” – lack of experience with major production systems can create catastrophic project failures. • Testing cycles are getting shorter – newer development tools make software development quicker, usually systems testing gets shortened. • Recent college grads... – least experienced developers usually have more training with relational database technology. – veteran developers are busy with older projects. 6 Sharing Knowledge and Success • The Language of Oracle: SQL – Structured Query Language, English like query language – keywords: select, from, where, and order by – Example query: select city, temperature from weather where temperature > 80 order by temperature; • Examples of relational databases – stock tables in newspaper – sports scores – 100 year example in book 7 Relational Model Attributes ■ Example of tabular data in the relational model Customerid customername 192-83-7465 Johnson 019-28-3746 Smith 192-83-7465 Johnson 321-12-3123 Jones 019-28-3746 Smith 11/19/19 customerstreet customercity accountnumber Alma Palo Alto A-101 North Rye A-215 Alma Palo Alto A-201 Main Harrison A-217 North Rye A-201 8 Data Definition Language (DDL) ■ Specification notation for defining the database schema ★ E.g. create table account ( account-number char(10), balance integer) ■ DDL compiler generates a set of tables stored in a data dictionary ■ Data dictionary contains metadata (i.e., data about data) ★ database schema ★ Data storage and definition language ✔ language in which the storage structure and access methods used by the database system are specified ✔ Usually an extension of the data definition language 11/19/19 9 Data Manipulation Language (DML) ■ Language for accessing and manipulating the data organized by the appropriate data model ★ DML also known as query language ■ Two classes of languages ★ Procedural – user specifies what data is required and how to get those data ★ Nonprocedural – user specifies what data is required without specifying how to get those data ■ SQL is the most widely used query language 11/19/19 10 SQL ■ SQL: widely used non-procedural language ★ E.g. find the name of the customer with customer-id 192-83-7465 select customer.customer-name from customer where customer.customer-id = ‘192-83-7465’ ★ E.g. find the balances of all accounts held by the customer with customer-id 192-83-7465 select account.balance from depositor, account where depositor.customer-id = ‘192-83-7465’ and depositor.account-number = account.account-number ■ Application programs generally access databases through one of ★ Language extensions to allow embedded SQL ★ Application program interface (e.g. ODBC/JDBC) which allow SQL queries to be sent to a database 11/19/19 11 Database Users ■ Users are differentiated by the way they expect to interact with the system ■ Application programmers – interact with system through DML calls ■ Sophisticated users – form requests in a database query language ■ Specialized users – write specialized database applications that do not fit into the traditional data processing framework ■ Naïve users – invoke one of the permanent application programs that have been written previously ★ E.g. people accessing database over the web, bank tellers, clerical staff 11/19/19 12 Database Administrator ■ Coordinates all the activities of the database system; the database administrator has a good understanding of the enterprise’s information resources and needs. ■ Database administrator's duties include: ★ Schema definition ★ Storage structure and access method definition ★ Schema and physical organization modification ★ Granting user authority to access the database ★ Specifying integrity constraints ★ Acting as liaison with users ★ Monitoring performance and responding to changes in requirements 11/19/19 13 Transaction Management ■ A transaction is a collection of operations that performs a single logical function in a database application ■ Transaction-management component ensures that the database remains in a consistent (correct) state despite system failures (e.g., power failures and operating system crashes) and transaction failures. ■ Concurrency-control manager controls the interaction among the concurrent transactions, to ensure the consistency of the database. 11/19/19 14 Comparing SQL and NoSQL 11/19/19 15 Country String Afghanistan Akrotiri Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Ashmore and Cartier Islands Australia Austria Azerbaijan Bahamas The Bahrain Baker Island Bangladesh Barbados Bassas da India Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory British Virgin Islands Brunei Bulgaria Burkina Faso Burma Burundi Area(sq km) Birth rate(births/1000 population) double double 647500 47.02 123 28748 15.08 2381740 17.13 199 23.13 468 9 1246700 44.64 102 14.26 14000000 443 17.26 2766890 16.9 29800 11.76 193 11.26 5 7686850 12.26 83870 8.81 86600 20.4 13940 17.87 665 18.1 1 144000 30.01 431 12.83 0 207600 10.83 30528 10.48 22966 29.34 112620 41.99 53 11.6 47000 34.03 1098580 23.76 51129 12.49 600370 23.33 59 8511965 16.83 60 153 14.96 5770 19.01 110910 9.66 274200 44.17 678500 18.11 27830 39.66 Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Clipperton Island Cocos (Keeling) Islands Colombia Comoros Congo Democratic Republic of the Congo Republic of the Cook Islands Costa Rica Cote d'Ivoire Croatia Cuba Cyprus Czech Republic Denmark Dhekelia Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Europa Island #European Union Falkland Islands (Islas Malvinas) Faroe Islands Fiji Finland France 181040 475440 9984670 4033 262 622984 1284000 756950 9596960 135 6 14 1138910 2170 2345410 342000 240 51100 322460 56542 110860 9250 78866 43094 131 23000 754 48730 15007 283560 1001450 21040 28051 121320 45226 1127127 28 3976372 12173 1399 18270 338145 547030 27.08 34.67 10.84 25.33 12.92 35.17 45.98 15.44 13.14 20.82 37.52 44.38 27.88 18.6 35.51 9.57 12.03 12.57 9.07 11.36 39.98 15.73 23.28 27.19 22.67 23.32 27.04 36.18 38.62 9.91 38.61 10.1 13.97 22.73 10.5 12.15 French Guiana French Polynesia French Southern and Antarctic Lands Gabon Gambia The Gaza Strip Georgia Germany Ghana Gibraltar Glorioso Islands Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard Island and McDonald Islands Holy See (Vatican City) Honduras Hong Kong Howland Island Hungary Iceland India Indonesia Iran Iraq Ireland Israel Italy Jamaica Jan Mayen Japan Jarvis Island Jersey Johnston Atoll Jordan 91000 4167 7829 267667 11300 360 69700 357021 239460 7 5 131940 2166086 344 1780 549 108890 78 245857 36120 214970 27750 412 0 112090 1092 2 93030 103000 3287590 1919440 1648000 437072 70280 20770 301230 10991 373 377835 5 116 3 92300 20.7 16.93 36.24 39.86 40.03 10.25 8.33 23.97 10.87 9.72 15.93 22.3 15.42 19.03 34.11 9.01 42.03 37.65 18.45 36.59 30.38 7.23 9.76 13.73 22.32 20.71 16.83 32.5 14.47 18.21 8.89 16.56 9.47 9.66 21.76 Juan de Nova Island Kazakhstan Kenya Kingman Reef Kiribati Korea North Korea South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Man Isle of Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Federated States of Midway Islands Moldova Monaco Mongolia Montserrat Morocco Mozambique Namibia Nauru 4 2717300 582650 1 811 120540 98480 17820 198500 236800 64589 10400 30355 111370 1759540 160 65200 2586 25 25333 587040 118480 329750 300 1240000 316 572 181 1100 1030700 2040 374 1972550 702 6 33843 2 1564116 102 446550 801590 825418 21 15.78 40.13 30.86 16.09 10.08 21.88 22.48 35.99 9.04 18.88 26.53 44.22 26.82 10.41 8.62 12.06 8.04 12 41.66 43.95 23.07 35.43 46.77 10.17 11.18 33.52 14.14 41.43 15.62 41.58 21.01 25.11 15.27 9.26 21.52 17.56 22.29 35.79 25.16 25.14 Navassa Island Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palmyra Atoll Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda Saint Helena Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia and Montenegro Seychelles 5 140800 41526 960 19060 268680 129494 1267000 923768 260 35 477 324220 212460 803940 458 12 78200 462840 406750 1285220 300000 47 312685 92391 9104 11437 2517 237500 17075200 26338 410 261 616 242 389 2944 61 1001 1960582 196190 102350 455 31.45 11.14 15 18.49 13.9 24.88 48.3 40.65 19.51 11.67 36.73 30.42 18.37 19.96 29.95 29.43 20.87 25.31 10.78 10.82 13.93 15.54 19.26 10.7 9.8 40.6 12.33 18.12 20.05 13.83 16.34 15.95 10.18 40.8 29.56 35.21 12.12 16.22 Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands Spain Spratly Islands Sri Lanka Sudan Suriname Svalbard Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Togo Tokelau Tonga Trinidad and Tobago Tromelin Island Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States Uruguay Uzbekistan Vanuatu Venezuela Vietnam Virgin Islands 71740 693 48845 20273 28450 637657 1219912 3903 504782 5 65610 2505810 163270 62049 17363 449964 41290 185180 35980 143100 945087 514000 56785 10 748 5128 1 163610 780580 488100 430 26 236040 603700 82880 244820 9631418 176220 447400 12200 912050 329560 352 42.84 9.49 10.62 8.95 30.74 45.62 18.48 10.1 15.63 35.17 18.39 27.72 10.36 9.77 28.29 12.64 32.58 38.16 15.7 33.48 25.18 12.81 15.5 16.83 27.68 22.23 21.91 47.39 10.49 18.78 10.78 14.14 14.09 26.22 23.06 18.91 17.07 14.2 Wake Island Wallis and Futuna West Bank Western Sahara Yemen Zambia Zimbabwe 7 274 5860 266000 527970 752614 390580 32.37 43.07 41.38 29.74 Current account balance Death rate(deaths/1000 population) Debt - external double double double 20.75 8000000000 -504000000 11900000000 5.12 4.6 3.33 6.07 25.9 5.43 1410000000 21900000000 5.44 7.56 8.16 6.57 231000000 1.577E+11 905000000 285000000 7.44 9.7 9.86 8.97 4.08 3.087E+11 15500000000 1832000000 308500000 6215000000 216600000 8.4 9.17 19970000000 668000000 -1119000000 11400000000 -115000000 -159900000 273000000 -2100000000 337000000 14.15 10.22 6.04 13.76 7.63 12.94 7.64 8.44 29.36 600000000 28300000000 1362000000 1600000000 160000000 245000000 5439000000 3000000000 531000000 8000000000 6.15 2.198E+11 682900000 -471700000 -185000000 -59500000 4.42 3.42 14.26 18.86 12.15 17.43 36100000 0 16100000000 1300000000 6752000000 1133000000 -37880000 5473000000 -240400000 -38300000000 -3283000000 -2899000000 586100000 10450000000 8800000 -316200000 -149100000 28200000000 -93760000 8.97 15.4 7.73 6.62 4.81 20.27 16.41 5.76 6.94 2400000000 8460000000 5.7E+11 325000000 70000000 881400000 1100000000 44600000000 2.333E+11 266000000 5.59 8.4 14.43 14.82 -980300000 -421500000 -1925000000 -185100000 -619900000 -5730000000 6529000000 4.33 14.94 11.38 7.19 7.64 10.54 10.43 38700000000 232000000 11600000000 5000000000 141000000 5962000000 11810000000 26400000000 12090000000 7327000000 36280000000 21700000000 330200000 2185000000 30320000000 -1706000000 762200000 261100000 2113000000 -880500000 -578600000 -144900000 -1169000000 -464400000 19.39 6.81 7.35 6.3 4.24 5.26 5.85 12 13.53 13.21 15.06 366000000 161500000 7745000000 16810000000 33750000000 4792000000 248000000 311000000 8373000000 2900000000 10.1 11390000000 -305000000 8.69 5.65 9.79 9.08 64000000 188100000 30000000000 4.85 4.63 1200000000 11.72 11.81 3.87 9.09 10.55 10.84 9.18 3804000000 476000000 108000000 1800000000 67230000000 25000000 196000000 -129400000 -27630000 10.15 7.77 7.17 6.06 4.41 6.81 9.95 15.38 16.53 8.32 12.34 258300000 14850000000 6.87 5.98 5365000000 4.176E+11 -7941000000 -570000000 4897000000 7338000000 2100000000 -560000000 -2881000000 211900000 -21100000000 -830700000 13.19 6.68 8.28 6.25 5.55 5.49 7.85 6.18 10.3 5.37 57000000000 3073000000 1.172E+11 1.415E+11 13400000000 1.25E+11 11000000000 74460000000 9.139E+11 5964000000 1.702E+11 8.95 196800000 -16400000 -632900000 73590000000 83870000 -8000000000 -1381000000 -308300000 7396000000 5969000000 3250000000 941500000 1200000000 1200000000 9.19 203200000 2.63 7320000000 -39020000 -459200000 26780000000 12040000000 -87920000 -80760000 -1251000000 -2389000000 -108300000 9895000000 -1600000000 -311000000 -281900000 -55500000 11810000000 -241000000 284100000 -4113000000 -148400000 765400000 -101200000 234300000 9.46 14.65 26030000000 6792000000 8.37 7.05 6.26 2.42 7.13 11.83 13.7 6.24 25.03 17.87 3.48 7.06 10.92 8.41 4.23 8.73 11.35 23.39 5.06 7.24 19.05 8 11.26 4.88 6.44 12.44 6.83 7.9 4.73 4.87 10000000 12000000000 1.6E+11 15020000000 1970000000 2490000000 7368000000 15840000000 735000000 2100000000 4069000000 0 10010000000 12.79 12.71 7.03 7.17 5.64 20.99 18.36 6.82 1400000000 18000000000 1191000000 8900000 17070000000 966000000 1136000000 33300000 2700000000 1863000000 4600000000 3129000000 53360000000 281000000 3300000000 130000000 86500000 180000000 2500000000 1780000000 1.499E+11 53100000 19900000000 -3647000000 -843100000 5228000000 9.47 8.68 6.41 5.65 7.53 4.49 21.33 17.18 2700000000 1350000000 79000000 47340000000 4573000000 1600000000 30550000000 418000 30520000000 2674000000 1400000000 2.3 9.45 3.86 8.45 6.85 0 4814000000 33970000000 0 -469600000 29150000 -36110000 -30000000 3600000000 6.54 7.37 4.53 6.26 5.47 8780000000 2463000000 3239000000 29790000000 55600000000 -3831000000 -8120000000 10.01 10.43 7.86 4.61 5.48 11.74 14.52 16.32 6.43 8.47 5.12 6.7 6 6.54 8.07 6.68 2.62 10.6 10.49 6.34 99150000000 2.747E+11 5187000000 -3631000000 46040000000 -212500000 -31500000 51500000000 -518800000 -3008000000 -98420000 18620000000 24590000000 1.696E+11 1300000000 171000000 214000000 167200000 197000000 318000000 34350000000 3476000000 12970000000 218100000 -2480000000 20.61 4.16 9.43 10.22 3.98 16.97 21.32 1500000000 19400000000 19540000000 14650000000 180400000 3000000000 27010000000 -30890000000 9.63 7.711E+11 -587300000 -763600000 6.49 9.16 7.16 10850000000 21000000000 321000000 -82400000 24080000000 40950000000 1100000000 21160000000 -52000000 -327400000 6736000000 -125600000 25.26 10.36 8.48 4.88 6.38 8.39 16.71 7.02 11.8 320000000 66500000000 1548000000 5.35 9.37 8800000000 -1400000000 -51640000 71850000 -15300000000 114000000 -590800000 4584000000 6300000000 -33460000000 -6.465E+11 181800000 461900000 14590000000 -2061000000 5.09 5.96 8.78 4.28 7.22 12.8 16.42 4.26 10.18 8.25 9.06 7.95 7.9 4.9 6.2 6.26 4000000000 55500000000 888000000 7321000000 50590000000 1400000000 0 63400000 2940000000 14710000000 16900000000 2400000000 3865000000 16370000000 5900000000 4.71E+12 1.4E+12 12800000000 4351000000 83700000 33290000000 16550000000 369900000 -181400000 -230300000 3.99 108000000 8.53 20.23 24.66 5400000000 5353000000 4086000000 Electricity - consumption(kWh) Electricity - production(kWh) Exports GDP double double double double 652200000 540000000 446000000 21500000000 6760000000 23610000000 120900000 1587000000 42600000 5680000000 552400000 17460000000 25760000000 32160000000 2.123E+11 130000000 30000000 500000000 58000000 1900000000 1707000000 12760000000 23170000000 2600000 112000000 103000000 81650000000 5797000000 751200000 110800000 689000000 750000000 81390000000 33780000000 4.835E+11 6492000000 850000000 13650000000 807700000 128000000 1940000000 1.956E+11 55090000000 17370000000 1596000000 6379000000 2.103E+11 86890000000 6.117E+11 58490000000 1.027E+11 2.559E+11 17550000000 3168000000 30010000000 1716000000 636000000 5295000000 6860000000 8205000000 13010000000 15300000000 744000000 16450000000 800000000 34300000000 78820000000 108800000 565200000 598000000 312900000 3848000000 8318000000 1890000000 30000000000 11470000000 70500000000 76580000000 2.557E+11 3.162E+11 117000000 401400000 1778000000 285200000 720900000 8338000000 643000000 879000000 2330000000 2001000000 154000000 2900000000 4132000000 1986000000 22330000000 10040000000 1700000000 26210000000 930000000 2940000000 15050000000 3.519E+11 33740000 2286000000 32710000000 335700000 3484000000 137800000 7478000000 206000000 3.39E+11 95000000000 36280000 2458000000 43070000000 361000000 5068000000 132000000 2.757E+11 4569000000 1.492E+12 25300000 2498000000 7700000000 6842000000 9134000000 61630000000 418600000 15740000000 2137000000 74300000000 31840000 4001000000 100600000 3321000000 4.873E+11 40060000 382100000 98580000 89400000 41800000000 1.63E+12 122000000 2311000000 26990000000 3571000000 2445000000 30170000000 5.489E+11 3.156E+11 1.023E+12 43080000 61110000 600000000 410800000 1200000 1391000000 106000000 172000000 4248000000 96130000 365000000 15660000000 48600000000 29200000000 1.691E+11 1.91E+12 5.831E+11 7.262E+12 41140000000 22170000 4168000000 573600000 25110000 5733000000 2976000000 15200000000 13400000000 602000000 55330000000 31630000000 44870000000 15500000000 2.811E+11 23840000 28000000 441000000 6086000000 1417000000 42740000000 348000000 2224000000 2324000000 27000000 9100000 105000000 6614000000 6184000000 37970000000 4759000000 5124000000 24780000000 12510000000 7845000000 50330000000 14410000000 2104000000 33920000000 4000000000 49300000 4540000000 71750000000 66510000000 1.722E+11 36380000000 73060000000 1.744E+11 167400000 63620000 8912000000 180000000 68410000 9583000000 75580000000 75580000000 4450000000 24820000 229400000 6358000000 1998000000 81270000000 81270000000 4158000000 26690000 246600000 8301000000 2149000000 155000000 39000000 5446000000 8000000 7560000000 11000000000 3249000000 2771000000 64440000 5701000000 562800000 619000000 384000000 55680000000 370000000 49510000000 3.163E+11 32350000000 1270000000 4154000000 19230000000 54890000000 2.661E+12 17720000 204600000 697500000 78580000000 4.147E+11 2.888E+12 1.109E+12 19060000 82000000 220000000 408000000 750000000 609000000 71590000000 61040000000 5.286E+11 4.19E+11 1.165E+13 75000000 1000000000 5173000000 1.512E+11 1.737E+12 427900000 353400000 460100000 380000000 1080000000 83990000 1161000000 90310000 6811000000 5.195E+11 6137000000 96760000 6732000000 5.6E+11 6922000000 104000000 47420000000 227900000 138600000 1079000000 776600000 5760000000 795200000 51150000 751400000 574700000 155000000 244000000 1551000000 4580000000 3710000000 7966000000 114400000 2799000000 205000000 768000000 909400000 14450000000 8.933E+11 2.362E+12 3010000000 48270000000 136000000 769000000 47220000000 15500000000 2.264E+11 245000000 388000000 1100000000 149000000 46000000 440000000 1160000000 140000000 3513000000 835000000 38000000 3200000000 6608000000 2911000000 59470000000 2590000000 855000000 709200000 19500000000 55000000 54000000 1008000000 808000000 570200000 2899000000 618000000 338100000 12050000000 3771000000 38450000000 3626000000 35510000000 1457000000 18790000000 2.681E+11 2.345E+11 35990000000 7692000000 5.101E+11 92350000000 1.199E+11 33700000000 21780000000 38300000000 2.939E+11 5849000000 34070000000 8271000000 5.472E+11 1.102E+11 1.29E+11 32600000000 22880000000 42670000000 2.616E+11 6289000000 54620000000 1.493E+11 2902000000 9373000000 69180000000 3.319E+12 69860000000 8.274E+11 38790000000 5.167E+11 10100000000 89800000000 1.038E+11 1.264E+11 34410000000 1.29E+11 3.364E+11 1.609E+12 1679000000 11130000000 9.71E+11 1.044E+12 630100000 7094000000 5.388E+11 3.745E+12 3600000000 7307000000 3200000000 25500000000 62210000000 4337000000 66820000000 18470000000 1.184E+11 4475000000 2589000000 34680000000 6510000 31260000000 2.936E+11 30160000000 10210000000 3036000000 5829000000 8591000000 308000000 454600000 19430000000 7000000 35000000 79000000 33620000000 1200000000 30880000000 3.225E+11 2.506E+11 9.251E+11 32430000000 27420000000 48000000000 11720000000 646700000 8495000000 3560000000 365500000 11280000000 4547000000 3569000000 26530000000 8066000000 1783000000 18830000000 314000000 484500000 5892000000 488800000 1079000000 2903000000 20890000000 18650000000 37480000000 2470000000 825000000 17930000000 8880000000 45230000000 2511000000 13400000000 27270000000 1719000000 2580000000 9100000000 6273000000 1629000000 14400000000 840200000 868200000 14560000000 1088000000 503400000 7410000000 75330000000 1.235E+11 2.293E+11 124400000 90000000 1250000000 700000000 915000000 11000000000 2150000000 2625000000 7223000000 2113000000 9000000 115000000 1178000000 250000000 6117000000 190200000 541000000 5534000000 1836000000 2012000000 15680000000 3440000 466800000 2.036E+11 1.824E+11 1.006E+12 192000000 22000000 277000000 10170000000 5735000000 1772000000 7216000000 781400000 1012000000 68400000000 115700000 651000000 2000000000 1095000000 176900000 1707000000 1.897E+11 178600000 4605000000 3876000000 1030000000 2209000000 1674000 14240000000 5046000000 1920000000 27900000 2692000000 1800000 13910000000 8859000000 1167000000 30000000 853000000 700000 9754000000 689400000 1356000000 640000 8581000000 870000000 5332000000 29000000 1.346E+11 23380000000 14760000000 60000000 2005000000 1.007E+11 934300000 1471000000 35710000000 2318000000 327600000 18430000000 2790000 1.074E+11 9792000000 52660000000 2054000000 568000000 39530000000 90610000000 2.931E+11 4.811E+11 1005000000 1579000000 2450000000 1581000000 448000000 3158000000 38390000000 19850000000 92510000000 2553000000 750000000 12340000000 266200000 280000000 9716000000 19850000000 33990000000 1.257E+11 3000000 137200 7600000 1500000 900000000 1.259E+11 76640000000 1.83E+11 9896000000 13140000000 38090000000 75270000000 15070000000 3.473E+11 18000000 174000000 4473000000 1561000000 2469000000 20220000000 46050000000 4873000000 5699000000 20570000000 1679000000 2437000000 11990000000 48360000000 2936000000 29930000000 22880000000 12300000000 1.553E+11 52860000000 38630000000 4.306E+11 1.174E+11 42150000000 20540000000 9046000000 1084000000 57500000000 8.943E+11 195000000 4650000 98440000 251300000 40060000 84820000 113500000 1.338E+11 43280000000 22090000000 9727000000 1166000000 56530000000 9.15E+11 166700000 5000000 105800000 270300000 43080000 91200000 122000000 15810000 1.285E+11 1615000000 32330000000 202800000 17000000 1.382E+11 1737000000 31640000000 218000000 75980000000 4.63E+11 37680000000 1.887E+11 46900000000 68950000000 15000000000 19490000000 214000000 4570000000 23540000000 1.715E+11 1.625E+11 1.408E+12 69780000 10430000000 17000000 18000000 70000000 339000000 66000000 866000000 10000000 48300000 38000000 342000000 14000000 1000000000 940000000 6700000 214000000 1.13E+11 3.102E+11 1374000000 18360000000 3245000000 26270000000 256200000 626000000 237400000 32000000000 28890000000 11800000000 29760000 223500000 1.894E+11 255300000 49000000 3335000000 35330000000 1.74E+11 1.209E+11 31150000000 29240000000 78890000000 12490000000 14970000000 39410000000 32000000 74000000 800000000 240300000 79000000 4597000000 2.026E+11 41970000000 4.914E+11 2.184E+11 2.29E+11 6228000000 2400000000 1845000000 6697000000 2581000000 1984000000 1173000000 1.381E+11 54530000000 24320000000 1.474E+11 14410000000 2566000000 1.061E+11 451200000 23060000 5341000000 10050000000 1.179E+11 8908000000 4650000 1401000000 1.32E+11 36510000000 3.374E+11 3.66E+12 5878000000 46660000000 45030000 89300000000 32060000000 962600000 1.725E+11 9.376E+11 5306000000 80580000000 3395000000 76190000000 495000000 1885000000 402000000 900100000 6018000000 1.428E+11 1.217E+11 2.554E+11 63470000000 1.307E+11 2.519E+11 26150000000 6086000000 60440000000 1.585E+11 1.705E+11 5.762E+11 15080000000 1130000000 7950000000 2727000000 1248000000 23710000000 1.189E+11 87910000000 5.248E+11 108800000 663100000 8684000000 98000 1500000 24790000 27000000 244000000 5743000000 6671000000 11480000000 10720000000 9926000000 70880000000 1.397E+11 69460000000 5.087E+11 11410000000 4000000000 27600000000 5000000 169200000 216000000 1000000 12200000 1775000000 621700000 39390000000 1.8E+11 32910000000 2.991E+11 45120000000 69480000000 63670000000 3.959E+11 3.472E+11 1.782E+12 3.839E+12 7.95E+11 1.175E+13 8536000000 2200000000 49270000000 47700000000 3700000000 47590000000 48420000 26600000 580000000 89700000000 35840000000 1.452E+11 34480000000 23720000000 2.272E+11 1035000000 2500000000 250000 205000000 83700000 2827000000 5345000000 11220000000 90000000 3040000000 8167000000 8839000000 60000000 1800000000 4468000000 16250000000 1548000000 9409000000 1409000000 24370000000 GDP - per capita GDP - real growth rate(%) HIV/AIDS - adult prevalence rate(%) double double double 800 7.5 0.01 4900 6600 8000 26800 2100 7500 5.6 6.1 2 11.7 2.8 3.9 11000 12400 4600 28000 3 8.3 9 -1.5 0.7 0.1 30700 31300 3800 17700 19200 3.5 1.9 9.8 3 5.6 0.1 0.3 0.1 3 0.2 2000 16400 4.9 2.3 0.1 1.5 6800 30600 6500 1200 36000 1400 2600 6500 9200 6.4 2.6 3.5 5 2 5.3 3.7 5 3.5 0.3 0.2 2.4 1.9 0.1 0.1 0.1 37.3 8100 5.1 0.7 38500 23600 8200 1200 1700 600 1 3.2 5.3 4.8 -1.3 3 0.1 0.1 4.2 1.2 6 0.1 2000 1900 31500 1400 32300 1100 1600 10700 5600 5.4 4.9 2.4 5 1.7 0.5 38 5.8 9.1 2.6 6.9 0.3 0.04 6600 700 700 800 5000 9600 1500 11200 3000 7135 16800 32200 3.6 2 7.5 3.7 7.1 3.9 -1 3.7 3 2.6 3.7 2.1 0.7 0.12 4.2 4.9 1300 5500 6300 400 3700 4200 4900 2700 900 14300 800 3.5 -1 1.7 1 5.8 4.5 1.8 20 2.5 6 11.6 2.9 26900 25000 22000 5900 29000 28700 2.4 10 3.6 3 2.1 13.5 4.8 0.3 0.1 0.6 7 0.1 0.1 0.1 0.1 0.2 1.7 0.3 0.1 0.7 3.4 2.7 1.1 4.4 0.1 0.1 0.4 8300 17500 5900 1800 600 3100 28700 2300 27900 1.9 6 4.5 9.5 1.7 5.4 8.1 1.2 21300 20000 5000 7900 21000 4200 40000 2100 700 3800 1500 3.7 1.8 2.5 0.2 2.6 3 1 2.6 1.9 -3.5 1.1 2800 34200 4.2 7.9 1.8 0.1 14900 31900 3100 3500 7700 3500 31900 20800 27700 4100 3.9 1.8 6.2 4.9 6.3 52.3 5.1 3.9 1.3 1.9 0.1 0.2 0.9 0.1 0.1 0.1 0.1 0.1 0.5 1.2 29400 2.9 0.1 5.1 0.1 0.1 0.1 3.1 3.2 10 2.5 5.6 40000 4500 7800 1100 9.1 2.2 800 1400 19200 21300 1700 1900 11500 5000 3200 900 6700 25000 12500 58900 19400 7100 800 600 9700 3900 900 18200 28500 1600 14400 1800 12800 2600 9600 2000 1.5 1 4.6 6.8 6 6 7.6 4 3.3 21.8 4.9 11 6.6 2.3 15.6 1.3 5.5 4 7.1 2.3 4 1 1900 27000 1900 3400 4200 1200 7300 5000 0.2 6.7 0.1 0.12 0.1 0.1 0.6 0.1 28.9 5.9 0.3 0.1 0.2 0.1 1.7 14.2 0.4 0.1 1.9 0.2 1 3 4.7 0.6 0.1 4.1 1 0.3 6.8 0.9 10.6 -1 4.4 8.2 4.8 0.2 0.1 0.1 12.2 21.3 1500 29500 11400 15000 23200 2300 900 1000 3600 3 1.2 0.5 0.5 0.2 4.8 4 3.5 6.2 -0.3 0.1 0.2 1.2 5.4 12500 40000 13100 2200 9000 3.3 1.2 6.1 1 0.1 0.1 0.1 6900 2200 4800 5600 5000 6 0.9 2.8 4.5 5.9 0.9 0.6 0.5 0.5 0.1 12000 17900 17700 23200 6000 7700 9800 1300 2500 8800 5400 7000 2900 5600 34600 1200 12000 1700 2400 7800 5.6 1.1 2.7 8.7 2.5 8.1 6.7 0.9 0.1 0.4 0.09 0.1 1.1 5.1 -1.9 3.3 0.7 5 7.5 6 5 3.2 6.5 1.5 0.01 0.8 0.2 600 27800 14500 19600 1700 600 11100 6 8.1 5.3 3.9 5.8 2.8 3.5 1 21.5 23300 2.6 0.7 4000 1900 4300 5.2 6.4 4.2 5100 28400 33800 3400 25300 1100 700 8100 1600 1000 2300 10500 2.5 3.6 1.8 2.3 6 10.5 5.8 6.1 3 0.1 2.3 1.7 0 38.8 0.1 0.4 0.1 7100 7400 5700 11500 1100 1500 6300 25200 29600 40100 14500 1800 2900 5800 2700 17200 5.1 8.2 7.5 4.9 3 5 12 5.7 3.2 4.4 10.2 4.4 1.1 16.8 7.7 2 1.5 5.7 7 0.2 0.1 0.1 0.1 8.8 1.5 4.1 3.2 0.1 0.1 0.1 4.1 1.4 0.18 0.2 0.6 0.3 0.1 0.7 0.4 3800 800 6 800 900 1900 1.9 4.6 -8.2 0.1 16.5 24.6 HIV/AIDS - deaths HIV/AIDS - people living with HIV/AIDS Highways(km) Imports double double double double 21000 3759000000 500 9100 21000 240000 18000 2076000000 104000 15250000000 185 123000000 269 1077000000 51429 4896000000 105 80900000 1500 200 130000 2600 250 692000000 215471 22060000000 8431 1300000000 800 841000000 100 100 200 200 14000 10000 1400 5600 600 811603 98100000000 200000 1.012E+11 28030 3622000000 2693 1630000000 3459 5870000000 650 200 13000 2500 207486 10030000000 1600 1039000000 1000 100 5800 15000 10000 3600 68000 100 33000 100 4900 900 350000 79990 13570000000 149028 2.35E+11 2872 579900000 6787 934500000 450 5523000000 4007 196000000 60282 1595000000 21846 5200000000 10217 2255000000 15000 660000 1724929 61000000000 200 346 300000 330000 250000 177 187000000 2525 5200000000 37077 12230000000 12506 866300000 28200 1754000000 14480 138200000 200 100 29000 20000 25000 15000 49000 1500 225 170000 560000 56000 775 23000 18000 1400 44000 260000 200000 26000 840000 12323 3129000000 34300 1979000000 1408800 2.561E+11 1100 387300000 785 457400000 23810 136000000 33400 500700000 79605 22530000000 1765222 5.524E+11 240 15 112998 880 157000 12800 320 35303 50400 28344 60858 13943 127204 71847 3600 190000 100000 9700 1100000 90000 900 47000 10 200 10 100 12000 570000 200 3300 1000 2500 5000 690 9100 7900 88000 1700 700 2200 370 6300 200 120000 21000 12000 29000 5900 60000 7800 1500000 2890 665000000 780 98200000 12600 8093000000 3800 167000000 43197 7650000000 64000 19210000000 10029 5968000000 2880 1167000000 4010 622000000 55944 7318000000 33297 2104000000 600 1500 120000 4634810 1.123E+12 440 53000000 463 466000000 3440 835000000 78197 45170000000 893100 4.197E+11 200 100 1000 15340000000 88000000 933000000 749300000 50700000 7842000000 3360000000 16700000000 5296000000 415200000 68190000000 63450000000 817 2590 625000000 1341000000 1225000000 180900000 1900000000 1806000000 7.167E+11 3699000000 1743000000 3000 600 48000 6800 8464 2700 200 1000 30000 3000 43000 350000 20229 230735 46176 29 100 9100 100 5800 78000 9000 1200 1100 24000 140000 17000 11000 280000 30500 4400 7970 4160 641500000 104000000 650100000 1085000000 4100 200 63000 2600 13603 1831 3332000000 2.759E+11 100 100 310000 2400 800 100 100 1000 900 2800 220 5100000 110000 31000 500 2800 3000 140000 22000 159568 13004 2525989 342700 167157 45550 95736 16903 479688 18700 58680000000 3307000000 89330000000 45070000000 31300000000 9900000000 60650000000 36840000000 3.293E+11 3624000000 500 12000 1171647 4.018E+11 117000 54280000000 445000000 1040 208000000 947 1700000000 977 462000000 14118 7770000000 577 500 600 7301 7600000000 200 150000 16500 1200000 200 8300 200 200 500 200 29000 7200 3900 1700 7600 2800 320000 100000 10000 200 100 1300 500 100 7500 84000 2000 12000 100 200 140000 900000 52000 100 140000 500 100 9500 700 5000 160000 300 5500 200 500 110000 16000 15000 1300000 210000 82980 13070000000 63942 4190000000 670 31200 86990 4450 18500 21716 60472 7300 5940 10600 83200 250 77148 5210 341 8684 49827 28400 65877 83000000 2100000000 2.142E+11 11120000000 775100000 579500000 5970000000 8162000000 730900000 5051000000 7224000000 917300000 11020000000 16300000000 2760000000 2677000000 1147000000 521100000 99300000000 392000000 15100 927000000 2222 3407000000 800 65 54000000 2105 2000000000 7660 860000000 2000 2245000000 93 141300000 329532 1.908E+11 240 149000000 12719 1830000000 50 49256 1000000000 227 17000000 57694 15630000000 30400 972900000 42237 1473000000 30 19800000 3100 100 61000 19000 200 4800 310000 1400 6400 70000 3600000 100 200 4900 2100 1300 74000 600 600 4200 500 16000 16000 15000 82000 9000 100 1000 14000 22000 7397 350 9000 22000 6500 860000 250000 3 12 3500 100 44000 10000 13223 116500 600 5432 92382 18712 10100 194394 234 80 362 91852 34965 257683 61 1419000000 2.527E+11 2233000000 1007000000 19770000000 2020000000 400000000 17140000000 2380000 17900000 11643 19600 29500 78230 202124 6 364697 17135 25328 1230 1214 198755 537289 12000 198 320 1210 114 829 790 220 320 152044 14576 45290 373 7164000000 1353000000 3330000000 9600000000 37500000000 45960000000 6373000000 14010000000 99000000 81610000000 52100000000 29100000000 6150000000 2500000000 28430000000 92910000000 260000000 42000000 195000000 267000000 106000000 174000000 113000000 41000000 36210000000 2128000000 9538000000 393400000 11000 200 100 100 170000 4100 200 280 11300 264000000 3130 1.552E+11 42970 29670000000 20250 16070000000 1360 67000000 22100 344000000 275971 39420000000 370000 43000 5300000 1000 140000 664852 2.22E+11 200 23000 500 0 17000 100 100 200 3500 400000 5200 0 220000 3600 13000 500 11650 11900 4492 7265000000 3496000000 604000000 100 160000 58000 10000 200 1600000 570000 110000 1900 29000 200 1000 100 200 78000 20000 530000 360000 500 14000 500 500 51000 950000 6000 11000 4100 9000 110000 220000 3107 1140000000 213237 97970000000 71212 1.211E+11 45697 5042000000 37299 1.654E+11 27767 1300000000 88200 1972000000 57403 80840000000 7520 824900000 323000 680 86000000 8320 4650000000 18997 354421 24000 121 8 27000 169679 1088 392931 6393603 8983 81600 1070 96155 93300 1257 11520000000 94500000000 2850000000 175600000 79000000 1306000000 31450000000 45660000000 4.394E+11 1.476E+12 2071000000 2820000000 138000000 14980000000 26310000000 89000 170000 12000 920000 1800000 120 4500 6200 67000 91440 18338 300000 1500000000 3734000000 1519000000 1599000000 Industrial production growth rate(%) Infant mortality rate(deaths/1000 live births) double double 163.07 3.1 6 1 3.1 21.52 31 9.27 4.05 191.19 21.03 6 12 15 19.46 15.18 23.28 5.89 1.9 3.3 4 2 4.69 4.66 81.74 25.21 17.27 6.5 -3.2 62.6 12.5 4 3.5 4.6 8.3 9.3 5.7 5.5 4.4 13.37 4.68 25.69 85 8.53 100.44 53.11 21.05 54.58 6 29.61 5 5.2 14 18 18.05 12.61 20.55 97.57 67.24 69.29 22 4.2 2 3 5 7.8 17.1 4 -2 0 1 3.1 15 2.7 1.4 -0.3 4.7 1.7 3 -10 2 8.5 10 2.5 0.7 30 71.48 68.26 4.75 47.77 8.19 91 93.82 8.8 24.18 20.97 74.93 92.87 92.41 9.95 90.83 6.84 6.33 7.18 3.93 4.56 5 6.7 104.13 14.15 32.38 47.41 23.66 32.59 25.1 85.13 74.87 7.87 95.32 2.4 5.2 8 6.24 12.62 3.57 4.26 2 1.7 12.07 8.44 1.6 3 2.2 3.8 4.1 0.7 4.1 3.2 2.6 7.1 53.64 72.02 22.93 18.59 4.16 51.43 5.13 5.53 15.82 14.62 8.6 6.94 35.93 4.71 90.37 107.17 33.26 73.45 7.7 1 29.32 2.97 9.6 8.8 7.4 10.5 3.5 7 4.5 0.7 -2 8.57 3.31 56.29 35.6 41.58 50.25 5.39 7.03 5.94 12.36 6.6 3.26 5.24 5 17.35 10.6 2.6 29.21 61.47 0.7 48.52 24.04 7.05 9.95 35.64 85.22 9.55 24.52 84.23 128.87 24.6 4.7 6.89 4.81 4.39 10.09 76.83 103.32 17.7 56.52 116.79 3.89 5.93 29.45 7.09 70.89 15.03 62.4 20.91 30.21 10.1 -5 6 9.7 8.5 15.5 12 2.9 0 3 1.4 10.2 4.4 3.2 2 8 3.8 17 4.1 3.4 40.42 5.43 53.79 7.35 41.62 130.79 48.98 9.95 8.7 0.8 -0.6 5.9 4.4 1.8 5.2 -1.2 13.1 5.4 0 5.2 5 10 1.1 10 4 6.4 7 -8.9 -0.9 2.8 6 2.8 4.7 1.7 66.98 5.04 10.03 7.72 5.85 29.11 121.69 98.8 7.11 3.7 19.51 72.44 14.84 20.47 51.45 25.63 31.94 23.51 8.51 5.05 8.24 18.61 7.78 26.43 15.39 91.23 19 14.49 13.53 7.54 14.78 27.71 5.73 43.11 13.24 55.51 12.89 15.53 5.5 143.64 2.29 7.41 4.45 21.29 116.7 61.81 3 4.42 7.1 8.5 6.5 14.35 62.5 23.57 3.7 5.5 4.7 7 12.2 8.2 8.4 8.5 69.27 2.77 4.39 29.53 6.4 110.76 98.54 20.48 66.61 8.6 7.2 12.62 24.31 4.4 16.5 22 24.77 41.04 73.08 15.67 20.03 67.83 20.34 14.51 5.16 6.5 11.95 71.1 55.16 22.2 25.95 8.03 11.1 5.1 3.9 5.6 16.5 4 0.9 4.4 22 6.2 1 12.3 16 19.62 3 6.9 -7.8 61.5 88.29 67.69 Inflation rate (consumer prices)(%) Internet hosts Internet users double double double 10.3 1000 3.2 3.1 455 897 30000 500000 4.3 43.8 2.3 4144 17 24500 41000 3000 0.4 6.1 3.5 3.2 1665 742358 2206 923 10000 4100000 150000 24000 2.3 1.8 4.6 1.2 2.1 2847763 387006 586 302 1334 9472000 3730000 300000 84000 195700 6 -0.5 1 204 243000 100000 17.4 1.9 2.9 2.8 3.3 3 4.9 1.1 7 5308 166799 2613 879 5161 985 7080 6994 1920 1391900 3400000 30000 70000 34500 15000 270000 100000 60000 7.6 3163349 14300000 6409 53421 442 3 22 4000 35000 630000 48000 28000 14000 2.5 0.3 6.1 2.4 17.2 8.5 3.1 1 1.9 1.5 2.8 3.6 8 2.4 4.1 818 479 3210081 118 5.9 3.5 14 1.8 3.2 11.5 1.4 2.5 3.1 2.4 3.2 1.4 115158 11 153 46 6 8 202429 160421 30000 60000 16110000 20400 9909 5000 15000 3575000 94000000 10826 3795 29644 1529 5901 295677 1219925 2732200 5000 50000 15000 3600 800000 90000 1014000 120000 210000 2700000 2756000 2 1 55 4 2 9.5 5.4 8.5 10 3 2.4 702 681 64197 6500 12500 500000 3188 3401 4084 3 1047 82142 9 569700 2700000 550000 1800 9500 444000 75000 2.1 3.6 5.1 1.6 0.7 2.3 22000414 206032067 493 1219173 2396761 25000 55000 2650000 21900000 1.5 1.5 1.5 7 2.2 5.5 1.6 13 1.5 2.9 1.6 2.8 0 7.2 4.9 18 4 4.5 22 7 -0.3 5123 93 568 5160 2686119 407 208977 2642 18 20360 380 2 613 9 1944 591993 383071 122175 86871 62036 5269 3200 35000 35000 25000 60000 150500 39000000 170000 6200 1718400 20000 15000 20000 50000 400000 40000 19000 125000 80000 168600 3212800 7 4 4.2 6.1 15.5 25.4 2.2 0 2.3 12.4 162228 437516 1437511 1480 1600000 195000 18481000 8000000 4300000 25000 1260000 2000000 18500000 600000 -0.1 12962065 57200000 3160 457000 5.3 3.2 6.9 9 21984 8325 2.5 250000 400000 2000 3.6 2.3 3.2 12.3 6 2 5.3 15 2.9 1 1.1 2.4 2 0.4 7.5 12 1.3 1 4.5 2.9 3.6 2 3.9 7 4.5 694206 3437 12299 937 51758 6998 119 14 67 3727 67769 28214 89 3738 773 18 107971 532 187 7156 29220000 567000 152000 15000 936000 400000 21000 1000 160000 20000 695700 165000 120000 100000 70500 36000 8692100 15000 25000 120000 6 1400 40000 10000 150000 5.4 1 1333406 10033000 6000 11.5 1.9 11 2.6 2.1 12.8 4.2 -3.6 11984 533 1000 150000 16000 220000 3627 3249 3164 800000 50000 65000 300 25 3985 2.9 1.4 2.1 -0.6 2.4 9.3 3 16.5 1 917 4518226 119 4449 474395 7094 134 1142 80000 8500000 2000 60000 2110000 90000 15000 750000 700 1.2 1 0.2 4.8 3.4 593850 726 15124 2288000 180000 1500000 2 4.2 5.1 3.8 5.5 7129 389 9243 65868 38440 120000 75000 120000 2850000 3500000 3.4 2.1 6.5 3 804915 346078 9.6 11.5 7 3.2 1.7 3 2.1 -0.4 4 3.3 14 0.8 0.8 8.8 5 50807 560874 1495 51 41 8970000 3600000 600000 126000 150000 4000000 6000000 25000 500 10000 13000 4 8225 1763 1069 15931 672 20207 264 7000 4000 14300 15000 1500000 225000 847000 11700 221 1 1.7 7.5 3.3 10 4.5 277 484825 89592 45491 398 4 288633 8000 2310000 1375800 750000 2200 89000 3100000 3.2 1056950 9789000 5.8 9 23 1882 18 200000 300000 20000 5.4 0.7 0.9 2.1 1.7 8 5.4 2.8 1 1401 945221 667275 11 2777085 69 5534 103700 82 27000 5125000 2556000 220000 13800000 4100 250000 6971500 210000 10.3 3.3 18906 8003 2900 138000 4.1 9.3 9 4 5 3.5 12 3.2 1.4 2.5 7.6 3 3.1 22.4 9.5 2.2 281 355215 524 630000 5500000 8000 2692 94345 56283 3398708 115311958 87630 1040 512 35301 340 1300 125000 3800000 1110200 25000000 159000000 400000 492000 7500 1274400 3500000 30000 900 145000 2.2 12.2 18.3 133 138 1880 4501 100000 68200 500000 Investment (gross fixed)(% of GDP) double 18.4 26.2 Labor force Life expectancy at birth(years) double double 11800000 42.9 1090000 9910000 14000 33000 5410000 6049 77.24 73 75.84 83.51 36.61 77.11 30000 15040000 1400000 41500 71.9 75.91 71.55 79.14 10350000 3450000 5090000 156000 370000 80.39 78.92 63.35 65.54 74.23 23.5 65490000 128500 62.08 71.41 21.8 19.1 33.6 19.3 4305000 4750000 90000 25.5 3800000 1026000 264000 68.72 78.62 67.49 50.51 77.79 54.39 65.5 72.85 33.87 19.8 89000000 71.69 18.6 29.1 10.2 10.7 12770 158000 3398000 5000000 27010000 2990000 76.27 74.8 72.03 43.92 56.22 43.5 34.5 18.3 19.8 25.3 22.6 65.1 12.8 37470 10.4 20.9 16.1 19.4 19.2 7000000 6680000 17370000 19820 24.7 23.9 6200000 46 760800000 15.8 20700000 144500 14510000 25.8 19.2 11.3 28.6 11.2 17.9 29 19.8 8000 1810000 6700000 1710000 4550000 95025 5250000 2870000 282000 25000 18.9 20.6 15.8 16.6 50.8 26.3 28.2 17.8 4530000 20710000 2750000 660000 19.5 215000000 1100 24250 137000 18.3 2660000 19.2 27700000 58.87 47.84 80.1 70.45 79.95 41.01 47.94 76.58 72.27 71.72 61.96 49.35 48.97 76.84 48.62 74.45 77.23 77.65 76.02 77.62 43.1 74.65 67.26 65.9 76.21 71 71.22 55.56 52.16 71.77 48.83 78.2 79.21 69.53 78.35 79.6 58800 70000 77.09 75.9 650000 400000 725000 2100000 42630000 10240000 14800 55.75 55.2 71.79 75.88 78.65 56 79.67 4400000 24500 42300 125900 60000 3680000 32290 3000000 480000 418000 3600000 79.09 69.65 64.53 77.9 78.4 65.14 80.3 49.86 46.97 65.5 52.92 2470000 3540000 65.6 81.39 22.8 4170000 23.8 158100 23.8 482200000 16.6 111500000 31.3 23000000 6700000 23.8 1920000 17.6 2680000 19.3 24270000 32 1140000 72.4 80.19 64.35 69.57 69.96 68.7 77.56 79.32 79.68 76.29 21.8 25.3 18.5 17.6 19.7 27 14.9 21 34.5 24.1 22.7 24 11.6 66970000 81.15 52790 79.24 1410000 78.24 23.9 14.7 28.7 8 17 26.1 26 39.6 9.9 21.9 19.8 17.5 14.7 10.7 21.7 26.4 22.5 19.4 17.1 22.4 47 19.6 7950000 11400000 66.55 47.99 7870 9600000 22900000 1420000 2700000 2600000 1170000 2600000 838000 61.71 71.37 75.82 77.03 68.16 55.08 71.05 72.63 36.68 47.69 76.5 79.55 73.97 78.74 82.03 73.73 56.95 36.97 72.24 64.06 45.09 78.86 78.34 70.01 79.04 52.73 72.38 61.39 75.19 69.75 1590000 29000 1630000 293700 231500 855000 7300000 4500000 10490000 88000 3930000 160000 39690 28700 165900 786000 560000 48800 34730000 1360000 30540 1488000 4521 11020000 9200000 840000 65.18 79.57 64.52 78.71 70.66 40.32 43.93 62.73 19.9 22.4 28 18 17.5 13.5 16.4 25 13.6 18.1 17.8 17 18.4 22.3 22.9 23.3 19.1 20 31.5 17.2 20.1 14.4 39.5 10000000 7530000 89000 79400 2050000 1930000 70000 55670000 59.8 78.81 75.83 74.04 78.66 70.33 42.13 46.74 1345 6006 2380000 920000 45430000 9845 75.88 79.4 73.13 63 70.14 1320000 3320000 2660000 11000000 35860000 15 17020000 5480000 1300000 140000 309900 9660000 71830000 4600000 3500 18170 43800 3261 67000 90000 18500 6620000 4650000 3200000 30900 71.94 64.93 74.89 69.53 69.91 74.41 77.53 77.62 73.67 73.95 71.35 67.1 46.96 77.76 72.15 73.61 78.46 73.62 70.72 81.62 66.99 75.46 56.75 74.73 71.82 16.7 1369000 2180000 2200000 870000 26840 3700000 16630000 42.52 81.62 74.5 76.14 72.66 48.09 43.27 25.4 19330000 79.52 22.4 16 7260000 11000000 104000 73.17 58.54 68.96 23.6 15.8 20.4 16.3 18 22 16.2 22.5 19.1 383200 4460000 3770000 5120000 10220000 3187000 19000000 36430000 1740000 35.65 80.4 80.39 70.03 77.26 64.56 45.24 71.57 52.64 19.4 33910 590000 69.53 68.91 3550000 25300000 2320000 4848 7000 12410000 21110000 2360000 29780000 147400000 1560000 14640000 74.89 72.36 61.39 74.51 68.01 51.59 66.85 75.24 78.38 77.71 76.13 64.19 62.49 74.31 70.61 78.91 27.4 24 24.9 24.5 17.3 29 22.4 18.8 20.8 16.2 15.7 9.6 12.9 36.6 12250000 42980000 48900 16.1 41.4 9.9 364000 12000 5980000 4630000 4230000 73.08 61.75 39.7 36.67 Military expenditures - dollar figure Military expenditures - percent of GDP(%) double double 188400000 2.6 56500000 2480000000 1.49 3.2 183580000 10.6 4300000000 135000000 1.3 6.5 1665000000 1497000000 121000000 2.7 0.9 2.6 628900000 6.3 995300000 1.8 176100000 3999000000 18000000 96500000 4030000 13700000 132200000 234300000 338500000 1.4 1.3 2 2.4 0.11 1.8 1.6 4.5 3.9 11000000000 1.8 290700000 356000000 64200000 39000000 38700000 5.1 2.6 1.3 2.1 6 112000000 221100000 9801700000 14100000 3 1.6 1.1 1.5 15500000 101300000 3420000000 67490000000 1 2.1 3.8 4.3 3300000000 11600000 93500000 126500000 3.4 3 1.5 2.8 64200000 180200000 620000000 572300000 384000000 2170000000 3271600000 0.4 1.2 2.39 1.8 3.8 2.02 1.5 28600000 4.4 180000000 4400000 655000000 2440000000 157000000 126200000 151000000 155000000 337100000 1.1 2.2 3.4 1.1 2.5 13.4 2 4.6 36000000 1800000000 45238100000 2.2 2 2.6 184800000 1000000 2 0.3 23000000 35063000000 49200000 0.59 1.5 0.6 5890000000 4.3 201900000 0.8 56700000 8900000 6500000 26000000 1.7 3.1 0.9 0.9 100600000 1.4 1080000000 1.75 16970000000 1300000000 4300000000 1300000000 700000000 9110000000 28182800000 31200000 2.5 3 3.3 45841000000 1 1460000000 14.6 0.9 8.7 1.8 0.4 221800000 177100000 0.9 1.3 5217400000 16180000000 2584500000 19200000 10700000 87000000 540600000 32300000 1500000 1300000000 2.8 5.3 1.4 0.5 1.2 3.1 2.3 0.2 3.9 230800000 231600000 1.9 0.9 200000000 44600000 11100000 1690000000 41100000 22400000 31100000 6 1.2 0.7 2.03 5.5 0.4 0.7 20800000 12500000 1.7 0.2 6043000000 0.9 8700000 0.4 23100000 2.2 2305600000 117300000 168400000 5 2.2 3.1 99200000 9408000000 1.5 1.6 1147000000 32800000 33300000 544600000 1 0.7 1.1 0.8 4033500000 252990000 3848000000 1.9 11.4 4.9 147000000 16900000 53100000 829300000 805500000 1.1 1.4 0.9 1.4 1 3500000000 3497800000 1.71 2.3 723000000 10 985000000 2.47 50100000 3.2 700000 700000 18000000000 107300000 654000000 12300000 0.8 10 1.5 1.8 13200000 4470000000 406000000 370000000 1.7 4.9 1.89 1.7 18900000 3172000000 0.9 1.5 9906500000 1.2 514800000 587000000 7500000 2.6 3 0.7 40500000 5729000000 2548000000 858000000 7574000000 35400000 20600000 1775000000 35500000 1.4 1.7 1 5.9 2.6 3.9 0.2 1.8 1.9 66700000 0.6 356000000 12155000000 90000000 1.5 5.3 3.4 170300000 617900000 1600000000 42836500000 3.707E+11 257500000 200000000 2.2 1.4 3.1 2.4 3.3 2 2 1687000000 650000000 1.5 2.5 885500000 106800000 217000000 7.8 1.8 4.3 Natural gas - consumption(cu m) Natural gas - exports(cu m) Natural gas - imports(cu m) double double double 220000000 0 0 30000000 22320000000 0 57980000000 0 0 530000000 0 0 31100000000 1400000000 6050000000 0 0 1400000000 23330000000 7810000000 6720000000 9744000000 403000000 0 0 6033000000 1000000000 32700000000 0 0 9900000000 29170000 0 0 0 0 18800000000 15500000000 0 0 18500000000 15400000000 1150000000 300000000 2900000000 0 0 300000000 9590000000 0 3640000000 1350000000 5804000000 9000000000 0 0 5800000000 1569000000 8424000000 0 0 55800000000 0 91520000000 0 8730000000 6517000000 29180000000 0 0 5337000000 0 5700000000 0 0 0 0 0 1350000000 2840000000 600000000 0 0 0 0 1080000000 0 9892000000 5280000000 1000000 3100000000 9521000000 0 160000000 21200000000 0 0 0 0 20000000 0 0 1270000000 0 1270000000 4.677E+11 78100000000 2.978E+11 4557000000 42010000000 0 1725000000 4567000000 40260000000 80000000 0 0 1160000000 99550000000 0 7731000000 1100000000 85020000000 2021000000 0 2018000000 680900000 0 680900000 13370000000 4000000 9587000000 22750000000 55300000000 72400000000 2350000000 4199000000 10000000 71180000000 0 39700000000 3400000000 0 0 0 61000000 0 0 4920000000 0 3384000000 0 54780000000 80420000000 0 77730000000 290000000 0 0 14300000000 11010000000 8696000000 20920000000 8700000000 2016000000 0 0 0 21110000000 0 2000000000 1700000000 0 1700000000 5410000000 770000000 0 2760000000 865000000 0 0 2760000000 867000000 31250000000 22410000000 0 55100000000 0 7850000000 2050000000 0 2050000000 50000000 60000000 0 0 0 0 49720000000 49280000000 20780000000 6504000000 0 0 7850000000 7830000000 0 4100000000 6340000000 23400000000 50500000000 7430000000 0 0 0 0 110000000 0 0 910000000 25000000 0 0 0 0 13850000000 2542000000 630000000 15860000000 41000000 0 0 18200000000 8782000000 2553000000 630000000 0 18500000000 4.058E+11 0 1.71E+11 5400000000 32700000000 56400000000 50000000 602000000 0 0 0 0 0 0 2500000000 6800000000 1040000000 0 0 0 2500000000 6600000000 1040000000 1800000000 0 0 17960000000 0 17260000000 949000000 3093000000 5840000000 6640000000 1300000000 0 0 0 410000000 0 968000000 3093000000 0 6300000000 1250000000 23930000000 0 5200000000 13760000000 11790000000 0 3830000000 15940000000 9600000000 0 0 43500000000 1580000000 15750000000 0 79860000000 33700000000 92850000000 6.409E+11 64500000 45200000000 5800000000 7190000000 15750000000 11160000000 0 17900000000 60400000000 0 2700000000 1.141E+11 65000000 0 29400000000 1300000000 0 0 0 0 0 0 0 Natural gas - production(cu m) Natural gas - proved reserves(cu m) Oil - consumption(bbl/day) double double double 220000000 49980000000 3500 30000000 80300000000 3316000000 4.739E+12 7500 209000 3800 530000000 79570000000 31000 3600 486000 5700 6500 37150000000 0 7.68E+11 33080000000 1731000000 5720000000 2.407E+12 24900000000 62300000000 32700000000 46000000000 796500 262400 140000 23000 40000 9900000000 29170000 1.503E+11 70790000 71000 10900 250000000 0 608800000 8440000000 0 7.272E+11 5950000000 2.217E+11 10350000000 4000000 3.15E+11 3724000000 9980000000 2.46E+12 285000 595100 5000 11500 4000 1020 49000 20000 16000 2199000 420 13000 94000 8000 60950 2750 0 1.658E+11 55220000000 1.691E+12 1180000000 35000000000 99050000000 2.23E+12 5700000000 1.32E+11 0 1.048E+11 495500000 1350000000 1760000000 600000000 14870000000 34360000000 42620000000 160000000 8380000000 3057000000 81980000000 7200 22000 2200000 2000 2400 2400 1500 240000 4956000 252000 700 14000 5000 450 37000 32000 89000 163000 49000 175700 218000 11300 600 129000 160000000 21200000000 1.065E+11 1.264E+12 20000000 68530000000 0 12460000000 2.426E+11 3.256E+12 0 1898000000 12860000000 129000 562000 39000 2000 6000 24000 23000 14540000 200 4500 5700 211400 2026000 6500 4750 80000000 60000000 21000000000 35000000 66470000000 2.93E+11 11890000000 254900000 1543000000 13000 1900 31500 2891000 38000 42000 405700 3700 1000 13000 20000 61000 8600 2500 11000 11000 29000 257000 3231000000 50450000000 140700 16300 2130000 1183000 1400000 383000 174400 260000 1866000 66000 22750000000 77600000000 79000000000 2350000000 815000000 10000000 15490000000 5.424E+11 2.549E+12 2.67E+13 3.149E+12 9911000000 20810000000 2.097E+11 2519000000 20020000000 5290000 290000000 3256000000 103000 11600000000 0 8700000000 16000000 1.8E+12 1.548E+12 0 6180000000 1.321E+12 0 0 0 53660000000 2.23E+12 189400 57000 190 85000 2070000 293000 20000 2750 44000 107000 1500 3100 216000 72000 50650 11190 22000 13000 5400 460000 3200 4000 20000 13500 24000 21000 47300000000 4.2E+11 1752000 0 24000 50000000 60000000 11000 400 167000 8500 13000 1000 665400000 63710000000 31150000000 77750000000 1.693E+12 6504000000 58940000000 15680000000 4.007E+12 54600000000 13770000000 23400000000 1.716E+12 8.297E+11 6.956E+11 110000000 3.855E+11 910000000 2500000 2.451E+11 1.076E+11 5471000000 0 0 32400000000 1.544E+11 12600000000 5.786E+11 1.111E+11 4.7E+13 28320000000 56400000000 50000000 602000000 1.441E+13 6.339E+12 24070000000 16000 895300 72000 8750 132700 25770 5000 275000 20 171100 54000 365000 40520 15000 25000 161000 338000 424100 339800 190000 30000 18000 253800 2310000 5300 200 710 2400 600 1250 1000 700 1550000 31000 64000 4000 1800000000 2832000000 14160000000 6500 700000 82000 53300 1250 4000 460000 516000000 254900000 1497000 99110000000 0 75000 70000 14000 0 190000000 0 0 0 5840000000 750000000 50000000 18730000000 7504000000 2.407E+11 38230000000 11330000000 3.682E+11 25000000000 5.89E+11 2250000000 312000000 58570000000 77160000000 8685000000 1.43E+12 19600000000 44400000000 1.059E+11 5.481E+11 0 63100000000 5.607E+11 6.06E+12 7.149E+11 5.195E+12 29400000000 1300000000 4.19E+12 1.926E+11 9.373E+11 3500 328600 290400 240000 988000 20000 17000 785000 10000 1000 24000 87000 619500 63000 0 8750 303000 310000 1692000 19650000 41500 142000 600 500000 185000 66000 0 4.8E+11 1800 78000 11000 23000 Oil - exports(bbl/day) Oil - imports(bbl/day) Oil - production(bbl/day) Oil - proved reserves(bbl) double double double double 0 0 0 5500 2000 1200000 0 185500000 11870000000 980000 22880000000 0 755000 0 0 523400 35470 530800 262000 29000 14500 450000 360000 1042000 537500 20670 312800 0 44000 3664000000 85690000 589000000 3581 1271 28450000 1254000 36000 0 0 700 0 0 39000 0 0 1788000 199000 3356 49230 2900000000 0 204000 603 0 17550 0 126000000 4105000 458800000 13900000000 1255000000 8100000 3200000000 1370000 987000 0 427800 221500 2414000 0 94000 3110000 0 0 0 200000 18500 3392000 192300 195000 531100 0 24000 227000 0 0 29300 21000 77900 300 7419 346200 129900 0 0 0 26670 332100 387000 5322000 15690000 101000 409600 318300 2281000 80000000 1.789E+11 150000000 17740000000 1700000000 1538000000 93500000 220000000 93600000 532000000 17250000 1230000000 523000 740000 0 350000 0 5100 0 4408000000 2700000000 2648000 0 0 0 0 34920 28210000000 563500000 214000 144300000 0 0 264900 0 12990 2135000 84720 468300 3104 2000 74100 7000 0 5992 0 0 0 0 25000 2022000000 395800000 8255000 4500000 263000000 0 0 0 0 0 0 47180 0 136600 15470 41190 0 780000 971000 3962000 2250000 0 80 79460 0 110700000 5700000000 4900000000 1.308E+11 1.125E+11 0 1920000 586600000 518100 2500000 1490000 27450 370500 456600 2158000 93360 5449000 17330 29290000 0 100000 40 445000 178600 890000 630100 1970000 634 47000 11500 2263000 50700 230200 1200000 0 0 0 0 2319000 2000 0 0 0 0 0 1518000 4594 0 0 0 0 0 785000 0 0 0 26000000000 96500000000 38000000000 0 3200000000 0 0 0 1863000 205000 3460000 18000000000 0 497 11000 542 0 1000 0 0 0 300000000 0 0 1418000 2284000 30220 738 119700 27950 3466000 721000 88870 49000 0 312000 53000 28830 413700 357300 6110000 7920000 0 0 46200 0 0 42160 0 0 2356000 0 3310000 775000 61000 0 46200 0 95500 26000 17180 0 0 790000 0 128000 8420000 0 0 0 0 0 0 0 0 9021000 0 15000 0 88060000 89620000 34000000000 9859000000 5500000000 325500000 170000000 408800000 152000000 116400000 16000000000 1055000000 69000000000 0 2.617E+11 38750000 0 0 1000 20 0 0 196200 135100 275000 1370 203700 10420 285000 2500000 1498000 2100000 0 7840000 1582000 7099 10500000 0 1644 0 345000 12000 1600000000 99000000 553100 289500 0 0 0 525000 500 250 0 225000 0 0 140000 46110 4500000 616500 0 1084000 72580 48000 162500 0 0 72000 2335000 1957000 7800000 0 143300 0 2600000 359400 0 2500000000 2900000 0 600000000 990000000 1700000000 288400000 273000000 395000000 97800000000 25410000000 22450000000 297000000 78000000000 650000000 370300 0 417500 0 0 4000000000 Population Public debt(% of GDP) Railways(km) Reserves of foreign exchange & gold double double double double 29928987 3563112 32531853 57881 70549 11190786 13254 447 3973 1206000000 43550000000 2761 800000000 118 34091 845 19470000000 555000000 20090437 8184691 7911974 301790 688345 17.4 64.2 18.9 43802 6021 2957 35140000000 12730000000 875000000 144319628 279254 43 2706 3000000000 96.2 5523 3518 578 770200000 14450000000 111100000 839300000 8.6 3519 1021 888 1214000000 2000000000 5700000000 52 29412 52940000000 41.9 4294 622 3955 7526000000 474900000 590000000 76890000 68722 39537943 2982904 71566 10300483 10364388 279457 7460025 65365 2232291 8857870 4025476 1640115 186112794 22643 372361 7450349 13925313 42909464 6370609 37.4 63.8 2141000000 13607069 16380005 32805041 418224 44270 3799897 9826419 15980912 1306313812 361 628 42954279 671247 60085804 3039126 21388 4016173 17298040 4495904 11346670 780133 10241138 5432335 476703 69029 8950034 1040880 13363593 77505756 6704932 535881 4561599 1332893 73053286 457030418 2967 46962 893354 5223442 60656178 69.1 602 1008 48909 997500000 687500000 36270000000 112700000 12.8 31.4 6585 70058 652700000 16020000000 6.099E+11 51.8 3304 11940000000 5138 894 40420000 58 74.8 41.7 74.9 33.5 42.5 950 660 2726 4226 9520 3002 1736000000 1950000000 8563000000 738600000 941600000 32780000000 37980000000 100 61.1 1743 426000000 49.2 102.7 41.7 966 5063 283 5.4 306 958 681 1436000000 14030000000 1888000000 235200000 30870000 1503000000 923100000 222293 46.8 67.7 597 5851 32175 11170000000 70760000000 195506 270485 1389201 1593256 1376289 4677401 82431390 21029853 27884 29.3 814 268600000 113100000 65.8 1612 46039 953 231400000 96840000000 1267000000 10668354 56375 89502 448713 168564 14655189 65228 9467866 1416027 765283 8121622 112 2571 7300000000 32 886 3084000000 837 201700000 187 280600000 80640000 74.1 2.1 699 1464000000 1.236E+11 58.3 35.9 59.7 56.2 27 7937 14800000000 935000000 1.26E+11 35820000000 29870000000 921 6975204 6898686 10006835 296737 1080264388 241973879 68017860 26074906 4015676 6276883 58103033 2731832 31.2 104.5 105.6 146.1 63140 6458 7203 1963 3312 640 19507 272 127417244 164.3 23705 6.646E+11 90812 361 5759732 85.8 505 5457000000 4152000000 28480000000 61500000000 1400000000 15185844 33829590 103092 22912177 48422644 2335648 5146281 6217141 2290237 3826018 1867035 3482211 5765563 33717 3596617 468571 449198 2045262 18040341 12158924 23953136 349106 12291529 398534 75049 59071 432900 3086859 1230602 193633 106202903 108105 4455421 32409 2791272 9341 32725847 19406703 2030692 13048 13.7 74.3 21.3 29.6 13601 2778 5214 3125 470 11.8 177.9 2303 401 14350000000 1500000000 1.991E+11 7333000000 498700000 193100000 1650000000 16300000000 402200000 490 8.8 24180000000 25.2 1998 274 4610000000 20 699 732 797 2418 928000000 500300000 160500000 55270000000 228.3 45.4 729 2865000000 61 29.2 1676000000 23.5 19510 60670000000 63.4 1138 390000000 70.2 1907 3123 2382 15140000000 1206000000 360000000 38.5 27676547 16407491 219958 216494 4035461 5465100 11665937 128771988 2166 1828 80362 4593041 3001583 162419946 20303 3039150 5545268 6347884 27925628 87857473 46 38635144 10566212 3916632 863051 776948 22329977 143420309 8440820 7460 38958 166312 7012 117534 177287 28880 187410 26417599 11126832 10829175 81188 55.8 59 2808 21440000000 22.1 69.5 3898 6 4805000000 670000000 20 3557 14710000000 33.1 10.3 71.4 4077 69.2 59.3 39.2 44.1 74.2 355 49.9 61.5 8163 441 3462 897 23852 2850 96 4144000000 12580000000 1076000000 635800000 1164000000 12700000000 16050000000 41880000000 12300000000 3351000000 23.6 28.2 11385 87157 16210000000 1.245E+11 210900000 50 75 55.2 80 122.8 1392 906 4380 29780000 23620000000 820000000 3550000000 70940000 6017643 4425720 5431363 2011070 538032 8591629 44344136 102.5 46.6 31.5 3661 1201 1.128E+11 14910000000 8493000000 45.9 22298 11680000000 40341462 53.2 14268 19700000000 20064776 40187486 438144 2701 1173900 9001774 7489370 18448752 22894384 7163506 36766356 65444371 5681519 1405 112422 1088644 104.3 79.7 1449 5995 2475000000 1652000000 301 11481 4533 2711 2508 482 3690 4071 568 320500000 19990000000 69580000000 5000000000 2.465E+11 145300000 2175000000 48300000000 267400000 10074951 69660559 4952081 20556 11636 27269482 47425336 2563212 60441457 295734134 3415920 26851195 205754 25375281 83535576 108708 59.2 74.3 2152 8671 2440 3509000000 37100000000 3034000000 73.9 24.7 17.6 39.6 65 1241 22473 41.5 17186 228464 2073 3950 1200000000 11330000000 18640000000 48730000000 85940000000 2362000000 1603000000 43.1 65.9 682 2600 25750000000 6510000000 51.6 57.2 32 32.4 5 47.6 54.4 2927000000 16025 2385615 273008 20727063 11261795 12746990 46.4 127.5 52.3 2173 3077 5300000000 345000000 57000000 Telephones - main lines in use Telephones - mobile cellular double double 33100 15000 255000 2199600 15000 35000 96300 6200 0 38000 8009400 562600 37100 1100000 1447310 2377 23500 130000 1800 10815000 3881000 923800 131700 185800 14347000 7094500 870000 121800 443100 740000 134000 1365000 140000 3071300 5120400 33300 66500 56000 25200 600100 938000 142400 1118000 8135500 60400 236200 37873 22000 1401500 1050000 435000 38810000 46373300 11700 90000 2868200 65400 357300 23900 8000 137000 2597500 227000 66500 64000 38200 6500000 114400 53000 35400 110900 19950900 71700 38000 9000 11800 3467000 263000000 380000 1077000 13221800 53300 17000 13000 65000 6445700 269000000 287 8768100 13200 10000 7000 6200 1132000 328000 1825000 574400 86228 3626000 3610100 6186200 2000 1000000 330000 1500 528047 1236000 2553000 17900 143178 9708700 4785300 9500 23700 901800 23000 9400 2120400 1549000 8735700 752600 9600 38100 475000 435000 2394400 5797500 1149800 41500 238763162 2400 23000 102000 2548000 33905400 314644700 0 30700 109900 4700000 41683100 881000 97800 51000 52500 138200 90000 38400 38400 95729 650500 54350000 302300 24512 300000 100000 320000 522300 64800000 799900 9797 5205100 26000 33500 210000 84134 846000 55000 26200 10600 80400 130000 8936200 16747 7600 323500 32600 1577100 31500 111500 1300 87300 140000 322500 3801300 326500 7241400 3666400 190700 48917000 7750000 14571100 675000 1955000 3006000 26596000 444400 6862800 279100 26154400 11700000 3376500 20000 3400000 6334000 55918000 1400000 71149000 86658600 73900 61400 622600 1325300 2081900 328400 1027000 1590800 4500 1100000 22877000 486900 394800 61900 653900 678800 28600 7000 750000 19900 824200 355400 174600 560000 59600 85000 4571600 28700 56600 208300 51000 4500 172000 31500 348200 10000 15958700 10100 500 706900 33700 142300 1219200 83700 127400 1900 33591800 1420000 53100 55200 1219600 775100 92000 2000 100000 11400 2169900 473000 364000 365300 279500 135100 11124100 41900 250000 290000 600 319900 300000 462400 21700 28125000 1800 338200 19300 404400 70 7332800 428900 223700 1500 371800 10004000 81000 52000 1765000 171600 22400 853100 1100 2532 21000 3343000 233900 3982800 6700 50400 12500000 81000 80000 2599000 202800 24000 3149500 400 0 3000 4163400 464900 2624800 1000 386900 62000 273200 1839200 3310900 1 12300000 4278800 1329500 184500 300000 4300000 35500000 23200 2200 23500 51100 4800 27300 11800 20600 7000 3502600 228800 2611700 21700 834000 15000 1770300 2908800 15201000 17401000 9341400 1211111 376500 489800 6900000 17608800 134000 0 5000 14300 0 10000 2700 16800 4800 7238200 575900 3634600 54500 24000 1896100 1294700 812300 6600 100000 4844000 67000 3521800 3678800 1739100 1000 35000 16860000 17567500 37506700 881400 900000 79800 931600 650000 168100 46200 6579200 5419000 2099300 13355000 242100 149100 6617400 60600 300 11200 325100 88000 7949000 6172000 400000 25089600 47600 891200 26500000 220000 0 9000 361900 1163800 18916700 374000 5700 700 61000 10833300 1135800 34898000 181599900 946500 1717100 6500 2841800 4402000 69400 1899900 27887500 52000 1700 0 776200 4200000 2972300 49677000 158722000 652000 320800 7800 6463600 2742000 41000 1900 301600 542200 88400 300900 0 480000 0 411100 241000 379100 Total fertility rate(children born/woman) Unemployment rate(%) double double 6.75 2.04 1.92 3.25 1.29 6.27 1.73 14.8 25.4 6 0 2.26 2.19 1.32 1.79 11 14.8 30 0.6 1.76 1.36 2.44 2.2 2.63 5.1 4.4 1.2 10.2 15 3.13 1.65 40 10.7 1.39 1.64 3.68 5.86 1.89 4.81 2.94 1.71 2.85 2 12 12.9 1.93 11.5 1.72 2.3 1.38 6.23 2.01 5.81 3 3.2 12.7 8 5 9.2 44 23.8 5.2 3.44 4.47 1.61 3.48 1.9 4.5 6.32 2.02 1.72 2.56 5.09 6.54 3.54 2.28 4.58 1.39 1.66 1.83 1.2 1.74 2.5 30 7 21 4.1 8 8.5 9.8 60 13.6 20 13 6.6 13 13.8 2.5 3.2 10.6 6.2 5.4 1.96 2.86 3.61 2.72 2.88 3.16 4.62 5.61 1.39 5.33 50 23 17 50 11.1 10.9 6.3 30 1.48 9.5 2.2 2.75 1.73 1.85 1 7.6 8.9 10.1 9.6 3.01 2.04 22 11.8 4.77 5.38 5.91 1.41 1.39 3.02 1.65 21 50 17 10.6 20 2 1.33 2.41 2.37 1.91 2.6 4.53 1.38 5.83 4.93 2.05 5.02 10 10 12.5 27.8 15 7.5 0.5 3.87 0.91 28.5 6.7 1.32 1.92 2.78 2.44 1.82 4.28 1.87 2.44 1.28 1.95 5.9 3.1 9.2 9.2 11.2 25 4.3 10.7 8.6 15 1.39 4.7 1.57 0.9 2.71 15 1.89 4.96 8 40 4.2 2.15 1.26 2.97 2.7 4.77 1.26 1.92 3.35 6.09 3.34 1.51 1.19 1.79 0.93 1.57 5.66 5.98 3.07 5.02 6.5 1.5 1.65 3.93 1.79 5.94 1.96 5.89 2.45 3.25 2 1.81 1.76 2.26 1.78 2.73 4.7 3.18 3.19 3.6 2.2 18 5.7 8.8 18 45 85 30 1.3 8 4.5 4.7 37.7 3 5.3 7 0.6 30.9 27.2 20 10.8 38 3.2 16 8 22 6.7 6 12.1 21 35 90 4.19 1.66 2 2.31 1.79 2.81 6.75 5.53 47 6 15.6 19 4.2 7.8 0 1.27 1.78 5.84 4.14 2.46 4.3 15 8.3 2.3 2.45 3.96 3.93 2.56 3.16 12.6 1.39 1.47 1.91 2.87 2.47 1.36 1.27 5.49 1.54 2.33 2.21 2.03 1.85 3.01 1.33 5.71 4.05 4.75 1.67 1.75 19.5 6.5 12 2.7 36 6.3 8.3 15.1 9.6 11.7 14 4.5 20 9.8 15 2.6 25 48 30 5.72 1.05 1.32 1.24 4.04 6.84 2.24 3.4 13.1 6.4 26.2 1.28 10.4 1.85 4.85 2.34 7.8 18.7 17 3.7 1.66 1.42 3.5 1.57 4.05 5.06 1.88 4.61 34 5.6 3.4 20 4.5 40 3 1.75 13.3 10.4 1.75 1.94 3.41 3.08 3 6.74 1.4 2.94 1.66 2.08 1.91 2.94 2.77 2.26 1.94 2.19 13.8 9.3 60 10 1.5 3.5 2.4 4.8 5.5 13 0.6 17.1 1.9 9.3 4.4 27.2 6.67 5.47 3.54 35 50 70 Business Analytics IS 335 Fall 2019 Dr. Anil K. Sahai Business Analytics IS 335 Fall 2019 Dr. Anil K. Sahai Data Analytics Overview • What is Data Analytics? • Developing Actionable Decisions/Recommendations based on Insights Generated from Historical Data! • Combination of Computer Technology, Management Science and Statistics Data Analytics: Collect, Analyze, Visualize and Act! • Data: Collection of Facts • Structured, Unstructured and Semi-Structured • Preprocessing, Consolidation, Cleaning, Transformation & Reduction Regression Visual Analytics Dashboard: Data Visualization Explore and Communicate thru Charts, Graphs, Illustrations, etc. Data Warehousing • Integrated Subject-Oriented Database designed to support DSS • Non-Volatile Data Data Mining • DM Extracts Patterns from Data • Association, Prediction, Cluster and Sequential • Prediction, Association and Segmentation DM Taxonomy Comparing CRISP and SEMMA Classification: Confusion Matrix • Part of Machine Learning Family • Supervised Learning Cluster Analysis • Natural Groupings • Unsupervised Learning • No Output/Target Variable • Also known as Segmentation in Marketing Association Rule Mining: Market Basket Analysis • Part of Machine Learning Family • Unsupervised Learning Text Analytics and Text Mining • Text Mining • Extracting Knowledge from Unstructured Data • Text Analytics • Information Retrieval and Text Mining • Corpus • Large structured set of text • Concepts • Features from collection of Documents • Stemming • Roots/Origins of Words Text Mining Process Sentiment Analysis Internet Search Engine and Web Mining Database Management System (DBMS) • • • • • Collection of interrelated data Set of programs to access the data DBMS contains information about a particular enterprise DBMS provides an environment that is both convenient and efficient to use. Database Applications: • • • • • • Banking: all transactions Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions • Databases touch all aspects of our lives 12/5/19 18 SQL • SQL: widely used non-procedural language • E.g. find the name of the customer with customer-id 192-83-7465 select customer.customer-name from customer where customer.customer-id = ‘192-83-7465’ • E.g. find the balances of all accounts held by the customer with customer-id 192-837465 select account.balance from depositor, account where depositor.customer-id = ‘192-83-7465’ and depositor.account-number = account.account-number • Application programs generally access databases through one of • Language extensions to allow embedded SQL • Application program interface (e.g. ODBC/JDBC) which allow SQL queries to be sent to a database 12/5/19 19 Comparing SQL and NoSQL 12/5/19 20 Instructions • This exam is not designed to test how much you remember - but rather designed to see how much do you understand; and more so, how well can you research and find answers to problems! • This is an Open Book, Open Notes, Open Internet and Open Mind Take Home exam. But you cannot talk, call, message or email to anyone regarding this exam after you have downloaded/looked at the exam. I trust all of you. You all are awesome and you will not disappoint me in any ways! • The exam has 2 Short essay/paragraph Questions (15 Points each] 1 Excel/Tableau Question [50 Points] • 1 Question of your choice [20 Points] o 1 Bonus Question (Optional] [20 Points] o Total: 120 Points out of 100! • Expected Time to Finish this Exam: 3 Hours o Submit Question with your Answers in a pdf file! Only Canvas submissions will be accepted. No word document submissions! Helpful Hints • No "cut" and "paste" from any source! Again, I repeat: No "cut" and "paste" from any source! Any "cut and pasted" content will not receive any • If you find a question ambiguous, please write you assumption, and answer the question. You will be given full credit for your answers based on all and any reasonable assumptions that you made! • Enjoy writing this exam! • Good luck! Short essay/paragraph Questions (15 Points each] Question 1: [15 Points] [Guide: Total 2 Pages in Double Space] • Explain the differences between SQL and NoSQL? • Why NoSQL was introduced? • What was your contribution in your term project? Would your team members agree with your own assessment? Question 2:[15 Points] [Guide: Total 2 Pages in Double Space] • What are the challenges of Text Mining? • How do you create a corpus? (Hint: Research about WordNet] • How can Dr. Sahai use Sentiment Analysis to improve the delivery of his lectures in IS 335? • How do companies use Search Optimization Engine (SOE) to better/maximize their marketing and adverting campaigns? Excel Tableau Question Question: [50 Points) Please refer to IS 335 Fall 2019 Final Exam.xlsx 1 • Excel O A: Sort the data based on GDPs • Select bottom 10 Countries Determine the correlation (and its measure R-square) of GDP of these countries with the corresponding • Electricity Consumption • HIV Deaths • Fertility Rate · Life Expectancy at Birth · Plot the scatter graphs for the above with trend lines o B: Sort the data based on number of Internet Users • Select Middle 10 Countries Determine the correlation (and its measure R-square) of Internet users in these countries with the corresponding • GDP • Military Expenditure • Life Expectancy • Natural Gas Consumption • Plot the scatter graphs for the above with trend lines o Submit the 10 graphs with corresponding R-Square Values Tableau o Repeat the same exercise for Tableau o Create a dashboard each for A and B with the graphs generated o Submit the two dashboards • Analyze and provide a summary of some interesting findings of your choice! Note: You only need to submit images of graphs and dashboards in your pdf document. No need to submit Excel or Tableau files! Question of your Choice Question: [20 Points] [Guide: You choose, this is your question! • From all the topics covered in class, pick a topic, frame a question and provide your answer! • Grade your own answer out of 20 points and a letter grade! Bonus Question Question: [20 Points] [Guide: Total 2 Pages in Double Space] You have graduated from UNLV and are very excited to practice what you have learned in your IS335 class. Lo and behold, you run into Dr. Sahai at a bar. He shares with you his new startup - an on-line Market Exchange to buy/sell/rent/barter home maintenance/repair tools/equipments/gadgets which people use sparingly; and majority of the time they keep "rotting" in garage or a shed, e.g., chainsaw, toolsets, hammer, lawn mower, ladders, and likes. Dr. Sahai is now a conga player, and has forgotten anything and everything about Data Analytics. The company is about to be launched and he is concerned that in today's Al and Data Analytics intensive market, he may not be able to compete with traditional marketing and business development techniques. Knowing that you took IS 335, he offers you to lead head business analytics in the company. You agree to join for a 50% share in the company. He has asked you to develop a plan of action for the next 6 months. Suggest a name for this company - bring some humor here! :-) • Use your learnings from the class, and outline a data analytics plan (bullet lists with 1-2 liner descriptions are fine!] • What advantages around the following you can you bring for the company. Briefly explain how! o Customer Acquisition and Retention o Advertising o Marketing o Market Exchange Design
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

Hello again,Attached please find the completed work for this exam. Please let me know if you have any questions or if you feel any changes need to be made, otherwise I look forward to working with you again in the future.Thank you!

FINAL EXAM

2
Final Exam

Explain the difference between SQL and NoSQL.
The main differences between SQL and NoSQL lie in the fact that a SQL database is
relational while NoSQL databases are instead considered to be a distributed management
system. This means that while a SQL database will utilize tables for its structure based upon
the relationships between different variables, but NoSQL databases do not require these and
utilize document-oriented storage (Shinde & Santoshalakshmi, 2019). SQL databases also
need pre-determined schema in order to place documents and other forms of data into various
categories that can later be aggregated and examined to find patterns by using structured
queries. In contrast to this, NoSQL databases will make use of a dynamic schema for
categorization and has no specific language that must be used when querying the database.
Because SQL databases require schemas and other items related to the data they contain to be
determined before the database is created, they sometimes will need to be adjusted when new
data points are added based upon whether or not the new data easily fits into the existing
categories. A final point to be made regarding the differences between these two forms of
database is the fact that SQL is the best type to use when the data must be as accurate as
possible, whereas the NoSQL database is most often utilized when it is more important to
retrieve the information quickly but its validity is of less concern (Foote, 2018).
Why was NoSQL introduced?
When computing first began to gain popularity outside of professional atmospheres, SQL
was a reasonable method to utilize to build a database management system, since many
transactions that needed to be performed on the data could be done so with the use of

FINAL EXAM

3

relational tables. However, the...


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags