The Excel file "Country Data" contains metrics used in a recent happiness index of most countries in the world.The three variables in the dataset are Log GDP per capita (a measure of the average economic output per person in the country), Social Support Rating (a rating between 0 and 1 indicating the availability of publicly funded services to support citizens needing help), and Healthy Life Expectancy (the average number of healthy years a person born today in the country will live).All three variables tend to be positively correlated with happiness; higher numbers are associated with higher average self-reported happiness by citizens of the country.
Import the dataset into RapidMiner, excluding the "Country" column.You should only be importing columns B:D.
1. Build a process that normalizes the data using a 0-1 range transformation, and runs k-means clustering with k=4 on the data set.(Be sure to check the "determine good start values" box, and use a local random seed of 12345.)Show a screenshot of the Process panel.
2. Run the process.Show a screenshot of the centroid table.
3. Based on the centroid table, describe the four types of countries that are revealed by these clustering results.(Describe them in words; do not simply report the numbers in the table.)
4. Add the Cluster Model Visualizer operator to your process.Show a screenshot of the heat map that it produces for your clusters.
A B C E Country Log GDP per capita Social Support Rating Healthy Life Expectancy 2 Afghanistan 7. 519703865 0. 525568426 49. 30782318 3 Albania 9. 25146389 0. 639356136 68. 43516541 4 Algeria 9. 513462067 0. 818189442 64. 42299652 5 Angola 8. 915740967 0. 754615486 45. 09425735 6 Argentina 9. 950943494 0. 926492274 67. 28722382 7 Armenia 8. 968935966 0. 722551048 65. 30075836 B Australia 10. 68032646 0. 95186156 72. 5602417 9 Austria 10. 6913538 0. 928110301 70. 82255554 10 Azerbaijan 9. 730903625 0. 785702765 61. 97584534 11 Bahrain 10. 84478304 0. 852550745 65. 84793091 12 Bangladesh 8. 050835609 0. 601468265 61. 72731018 13 Belarus 9. 725567818 0. 924072623 65. 31598663 14 Belgium 10. 62617779 0. 885208845 71. 3420105 15 Belize 8. 990919113 0. 756932497 58. 84951782 16 Benin 7. 598664761 0. 434388518 50. 58654404 17 Bhutan 8. 96965313 0. 847574413 60. 61640549 18 Bolivia 8. 778190613 0. 828705788 59. 73696899 19 Bosnia and He 9. 1783638 0. 655723631 67. 63831329 20 Botswana 9. 654462814 0. 815656066 55. 25416946 21 Brazil 9. 582796097 0. 906693101 64. 59515381 22 Bulgaria 9. 702789307 0. 885949194 66. 55036163 23 Burkina Faso 7. 357180119 0. 705393493 50. 83040237 24 Burundi 6. 599169254 0. 564678133 48. 61193848 25 Cambodia 8. 0946455 0. 728610277 58. 16891479 26 Cameroon 7. 986923695 0. 646312475 47. 95747757 27 Canada 10. 66470814 0. 939067066 71. 76052856 28 Chad 7. 695847034 0. 751252234 44. 87282562 29 Chile 10. 00948334 0. 827141881 71. 5785675 30 China 9. 501940727 0. 793733716 68. 59844971 31 Colombia 9. 471477509 0. 889900029 63. 84049606 32 Congo (Brazza 8. 68521595 0. 642136157 53. 51810837 33 Congo (Kinsha 6. 613965511 0. 767235577 50. 01415253 34 Costa Rica 9. 580832481 0. 878272951 69. 49661255 35 Croatia 9. 919107437 0. 768363416 67. 59174347 36 Cyprus 10. 48430555 0. 769556105 72. 48823547 37 Czech Republi 10. 30809784 0. 911362588 69. 60412598 38 Denmark 10. 67642689 0. 9597013 70. 70426941 39 Dominican Rep 9. 488246918 0. 893197775 63. 1620636 40 Ecuador 9. 2706213 0. 855889201 66. 94998932 41 Egypt 9. 234282494 0. 729744256 61. 2741127 42 El Salvador 9. 001606941 0. 790755391 63. 901889843 Estonia 10. 21057701 0. 917929649 66. 66893005 44 Ethiopia 7. 333114147 0. 625596821 55. 63551712 45 Finland 10. 55357838 0. 947800577 71. 21165466 46 France 10. 53086185 0. 895719409 71. 97216034 47 Gabon 9. 845918655 0. 755861998 55. 68796539 48 Georgia 8. 902565002 0. 517371595 65. 30636597 49 Germany 10. 69496822 0. 925923228 71. 30358124 50 Ghana 8. 277353287 0. 687448561 53. 54027939 51 Greece 10. 09350872 0. 834824681 70. 67931366 52 Guatemala 8. 886600494 0. 822837472 61. 96589279 53 Guinea 7. 037233829 0. 578859627 50. 16095734 54 Haiti 7. 413352013 0. 56431967 52. 95332336 55 Honduras 8. 470056534 0. 772375524 63. 41060638 56 Hong Kong 10. 8695507 0. 833558202 75. 91391754 57 Hungary 10. 10733318 0. 858733833 66. 59667969 58 India 8. 659319878 0. 61013329 59. 07401276 59 Indonesia 9. 24771595 0. 809478104 60. 31875992 60 Iran 9. 717675209 0. 572406888 65. 53881073 61 Iraq 9. 546689034 0. 684434831 60. 94004059 62 Ireland 10. 83902645 0. 95294255 71. 29930878 63 Israel 10. 36330509 0. 864130199 72. 66603088 64 Italy 10. 39468098 0. 908986509 72. 46585846 65 Ivory Coast 8. 095673561 0. 703991652 45. 04415894 66 Jamaica 9. 043976784 0. 874231517 63. 70193863 67 Japan 10. 4885788 0. 922657192 74. 82469177 68 Jordan 9. 35201931 0. 830443859 64. 18115997 69 Kazakhstan 10. 04227257 0. 931349277 63. 64411926 70 Kenya 7. 97029686 0. 77692306 54. 14321899 71 Kosovo 9. 185945215 0. 805270791 62. 00485611 72 Kuwait 11. 19375273 0. 823017776 65. 09716034 73 Kyrgyzstan 8. 061284065 0. 856584549 62. 41665268 74 Latvia 10. 03790092 0. 879372418 65. 33850098 75 Lebanon 9. 728822708 0. 741707742 69. 59849548 76 Liberia 6. 739804745 0. 637665987 51. 28914261 77 Libya 9. 555549622 0. 867987692 61. 16175079 78 Lithuania 10. 18536758 0. 92852354 65. 67057037 79 Luxembourg 11. 42996979 0. 933604598 72. 53325653 80 Macedonia 9. 446382523 0. 766368151 65. 56458282 81 Madagascar 7. 228696823 0. 646716535 56. 3134613 82 Malawi 6. 660712242 0. 494381636 54. 48933411 83 Malaysia 10. 13670444 0. 817616284 64. 74024281 Madagascar 7. 228696823 0. 646716535 56. 3134613 82 Malawi 6. 660712242 0. 494381636 54. 48933411 83 Malaysia 10. 13670444 0. 817616284 64. 740242 84 Mali 7. 350599766 0. 830189168 49. 19207382 85 Malta 10. 59380574 0. 918764889 70. 77765656 86 Mauritania 8. 231690407 0. 874945939 53. 24209976 87 Mauritius 9. 783063889 0. 784822047 65. 92808533 BB Mexico 9. 707403183 0. 760614276 67. 78440857 89 Moldova 8. 447127342 0. 8399055 61. 26768112 90 Mongolia 9. 346309662 0. 905524373 62. 64930725 91 Montenegro 9. 616769791 0. 73963052 65. 11016846 92 Morocco 8. 906809807 0. 65378499 63. 91926193 93 Myanmar 8. 77971129 0. 752064288 57. 09217834 94 Namibia 9. 15881443 0. 762783587 55. 13398361 95 Nepal 7. 74691391 0. 74761188 60. 75209808 96 Netherlands 10. 74862385 0. 879010439 71. 0919342 97 New Zealand 10. 43199444 0. 98734349 71. 92076111 98 Nicaragua 8. 480530739 0. 826908529 65. 85805511 99 Niger 6. 803243637 0. 713019609 52. 82997131 100 Nigeria 8. 644703865 0. 811647654 45. 24733734 101 Norway 11. 06800938 0. 946833968 70. 52483368 102 Pakistan 8. 464853287 0. 561720133 57. 25551605 103 Palestinian 1 8. 365736961 0. 766101241 62. 83749771 104 Panama 9. 942081451 0. 88261503 67. 68180084 105 Paraguay 9. 065534592 0. 914199054 63. 34424591 106 Peru 9. 358279228 0. 798418343 65. 03024292 107 Philippines 8. 843669891 0. 85358858 59. 46133423 108 Poland 10. 12024021 0. 893090427 66. 95755768 109 Portugal 10. 19528389 0. 866213858 70. 45056152 110 Puerto Rico 10. 54518353 0. 924448133 69. 89974213 111 Romania 9. 896219254 0. 786967337 66. 41331482 112 Russia 10. 012393 0. 924363256 64. 08342743 113 Rwanda 7. 416408062 0. 678143561 54. 64948654 114 Saudi Arabia 10. 81576347 0. 819749713 63. 71783829 115 Senegal 7. 725879669 0. 70153451 57. 57684708 116 Serbia 9. 462955475 0. 81625104 65. 63837433 117 Sierra Leone 7. 374071121 0. 610593736 43. 74033737 118 Singapore 11. 4103278 0. 86643666 76. 04466248 119 Slovakia 10. 21408272 0. 94345367 67. 49668884 120 Slovenia 10. 26922512 0. 901163757 70. 51219177 121 Somalia 5. 991464547 0. 599281073 47. 28276062121 Somalia 5. 991464547 0. 599281073 47. 28276062 122 South Africa 9. 428297997 0. 898096263 50. 14693451 123 South Korea 10. 44602489 0. 768350601 73. 85836792 124 South Sudan 7. 563227654 0. 545118451 48. 62382889 125 Spain 10. 4028635 0. 95647186 73. 37998199 126 Sri Lanka 9. 319309235 0. 862500072 64. 64014435 127 Sudan 8. 264168739 0. 81061554 53. 4222374 128 Sweden 10. 71233368 0. 929459989 71. 74086761 129 Switzerland 10. 91472626 0. 93833375 72. 86914825 130 Syria 8. 536995819 0. 463912874 64. 83573151 131 Taiwan 10. 80982895 0. 885388851 70. 75 132 Tajikistan 7. 869647503 0. 843932509 61. 64696503 133 Tanzania 7. 831086636 0. 79026258 56. 12051773 134 Thailand 9. 637292862 0. 866324544 65. 64533997 135 Togo 7. 241590977 0. 478593409 51. 97360992 136 Tunisia 9. 292293549 0. 60947001 63. 35025787 137 Turkey 9. 864202499 0. 851224601 65. 69591522 138 Turkmenistan 9. 669528961 0. 960158467 58. 44134521 139 Uganda 7. 432150364 0. 821205795 50. 23374176 140 Ukraine 8. 8953619 0. 909439743 63. 52373505 141 United Arab I 11. 14033889 0. 824136674 68. 35640717 142 United Kingdo 10. 56766129 0. 935985744 71. 05130768 143 United States 10. 87796497 0. 903571069 70. 03674316 144 Uruguay 9. 917072296 0. 891493499 68. 11640167 145 Uzbekistan 8. 630271912 0. 968225241 60. 53565598 146 Venezuela 9. 584933816 0. 911086857 64. 58602142 147 Vietnam 8. 637988091 0. 848676682 66. 04872131 148 Yemen 7. 843260288 0. 668683469 54. 08095932 149 Zambia 8. 222695351 0. 706222713 51. 67472458 150 Zimbabwe 7. 430315495 0. 735800326 50. 36258316
