Note that the data are given as 3 categories (Thriving, Struggling and Suffering). If you picked a country for which one of the categories is missing data (ie it has - instead of the data), please find another country. For easy interpretation, we will construct an index that combines the data in all 3 categories using this formula: LS = 8.5*%thriving+5*%struggling+2.5*%suffering. ~ For example, for Albania, we have the following data Geography Thriving Struggling Suffering N Size Albania 2015 Gender Male 19% 61% 20% 379- Albania 2015 Gender Female 22% 59% 19% 528+ We want to calculate the average happiness for Male and Female LS Male = 8.5*0.19+5*0.61+2.5*0.2=5.165+ LS Female - 8.5*0.22+5*0.59+2.5*0.19=5.295+ Below is an example of a Table and a bar chart. For each of the three categories (age, gender, education) make either a table or a bar chart that will contain data for both countries (write country names instead of country A and B), however, you need to have at least one bar chart and at least one table in your report+life satisfaction age+ Country Ap Country By 15-29- 3.54 4 140 OHNW 30-49+ 3.74 50+ 3.3+ 4.34+ 15-29 30-49 50+ Country A Country B 2. Present your data on life satisfaction (LS) for each category (either as a table or as a bar graph) and write a short observation for the following three categories: ~ a. Age: Younger or older people (which category is the happiest?)+ b. Those with different education levels (which category is the happiest?)+ c. Married or Single?~ 3. Write a one paragraph reflection on the similarities and differences for these two countries. ~ 4. Which of the above variables are most likely and which are least likely to suffer from reverse causality problem?C D F G H B E Life Evaluation Index Suffering N Size 2 Geography Time Demographic Demographic Value Thriving Struggling 2015 Aggregate Aggregate 21% 60% 19% 907 3 Albania 4 Albania 2015 Gender Male 19% 61% 20% 379 5 Albania 2015 Gender Female 22% 59% 19% 528 6 Albania 2015 Age 15-29 33% 60% 7% 269 2015 Age 30-49 13% 56% 31% 245 7 Albania 8 Albania 2015 Age 50+ 15% 64% 21% 393 9 Albania 2015 Education Elementary school or les 16% 59% 25% 431 2015 Education Less than tertiary educa 20% 65% 15% 340 10 Albania 11 Albania 2015 Education Tertiary complete 44% 53% 3% 136 12 Albania 2015 Employment Not full-time for an emple 19% 61% 20% 770 13 Albania 2015 Employment Full-time for an employe 29% 57% 13% 137 14 Albania 2015 Life evaluation Thriving 100% 189 15 Albania 2015 Life evaluation Struggling 100% 556 16 Albania 2015 Life evaluation Suffering 100% 162 17 Albania 2015 Leadership approval Approve 25% 62% 12% 519 18 Albania 2015 Leadership approval Disapprove 12% 59% 28% 326 19 Albania 2015 Leadership approval (DK) 20 Albania 2015 Leadership approval (Refused) 21 Albania 2015 Urban / Rural Urban 28% 58% 14% 405 22 Albania 2015 Urban / Rural Rural 15% 62% 23% 502 23 Albania 2015 Marital status Married 15% 60% 26% 588 24 Albania 2015 Marital status Not Married 31% 61% 7% 318 25 Albania 2015 Marital status DK/Refused 26 Albania 2014 Aggregate Aggregate 21% 62% 17% 880 27 Albania 2014 Gender Male 16% 66% 18% 339 28 Albania 2014 Gender Female 26% 57% 17% 541 29 Albania 2014 Age 15-29 32% 59% 10% 284 30 Albania 2014 Age 30-49 19% 62% 19% 235 31 Albania 2014 Age 50+ 12% 64% 24% 361 32 Albania 2014 Education Elementary school or les 21% 59% 19% 425 33 Albania 2014 Education Less than tertiary educa 15% 57% 18% 327 34 Albania 2014 Education Tertiary complete 33% 60% 7% 35 Albania 128 2014 Household income Poorest 20% 17% 54% 29% 146 life Evaluation Index Sheet1C H B D E F G 4147 Burkina Faso 2013 Leadership approval Approve 5% 82% 14% 558 4148 Burkina Faso 2013 Leadership approval Disapprove 1% 85% 14% 422 4149 Burkina Faso 2013 Leadership approval (DK) 4150 Burkina Faso 2013 Leadership approval (Refused) 4151 Burkina Faso 2013 Urban / Rural Urban 2% 86% 12% 151 4152 Burkina Faso 2013 Urban / Rural Rural 3% 82% 15% 849 4153 Burkina Faso 2013 Marital status Married 4% 33% 13% 600 4154 Burkina Faso 2013 Marital status Not Married 2% 81% 17% 400 4155 Burkina Faso 2012 Aggregate Aggregate 7% 79% 14% 996 4156 Burkina Faso 2012 Gender Male 7% 80% 13% 514 4157 Burkina Faso 2012 Gender Female 6% 79% 15% 482 4158 Burkina Faso 2012 Age 15-29 8% 83% 9% 419 4159 Burkina Faso 2012 Age 30-49 6% 76% 18% 387 4160 Burkina Faso 2012 Age 50+ 5% 76% 19% 190 4161 Burkina Faso 2012 Education Elementary school or les 6% 79% 15% 850 4162 Burkina Faso 2012 Education Less than tertiary educa 18% 81% 1% 134 4163 Burkina Faso 2012 Education Tertiary complete 4164 Burkina Faso 2012 Household income Poorest 20% 6% 81% 13% 164 4165 Burkina Faso 2012 Household income Second 20% 5% 82% 13% 176 4166 Burkina Faso 2012 Household income Middle 20% 4% 76% 19% 171 4167 Burkina Faso 2012 Household income Fourth 20% 7% 80% 13% 207 4168 Burkina Faso 2012 Household income Richest 20% 14% 76% 10% 278 4169 Burkina Faso 2012 Employment Not full-time for an emple 6% 80% 14% 919 4170 Burkina Faso 2012 Employment Full-time for an employe * 4171 Burkina Faso 2012 Life evaluation Thriving * 4172 Burkina Faso 2012 Life evaluation Struggling 100% 788 4173 Burkina Faso 2012 Life evaluation Suffering 100% 122 4174 Burkina Faso 2012 Leadership approval Approve 8% 77% 15% 641 4175 Burkina Faso 2012 Leadership approval Disapprove 4% 84% 12% 349 4176 Burkina Faso 2012 Leadership approval ( DK) 4177 Burkina Faso 2012 Leadership approval (Refused) 4178 Burkina Faso 2012 Urban / Rural Urban 15% 83% 2% 126 4179 Burkina Faso 2012 Urban / Rural Rural 6% 79% 15% 870 4180 Burkina Faso 2012 Marital status Married 3% 77% 17% 604 4181 Burkina Faso 2012 Marital status Not Married 9% 83% 8% 392 4182 Burkina Faso 2011 Aggregate Aggregate 11% 81% 7% 999 life Evaluation Index Sheet1B C F H A D E G 6898 Cote d'Ivoire 2014 Education Less than tertiary educa 4% 90% 6% 383 6899 Cote d'Ivoire 2014 Education Tertiary complete 175 6900 Cote d'Ivoire 2014 Household income Poorest 20% 3% 87% 10% 6901 Cote d'Ivoire 2014 Household income Second 20% 1% 83% 16% 159 6902 Cote d'Ivoire 2014 Household income Middle 20% 2% 88% 10% 182 6903 Cote d'Ivoire 2014 Household income Fourth 20% 3% 93% 4% 214 6904 Cote d'Ivoire 2014 Household income Richest 20% 13% 85% 3% 258 6905 Cote d'Ivoire 2014 Employment Not full-time for an empl 4% 87% 9% 822 6906 Cote d'Ivoire 2014 Employment Full-time for an employe 6% 88% 6% 166 6907 Cote d'Ivoire 2014 Life evaluation Thriving 6908 Cote d'Ivoire 2014 Life evaluation Struggling 100% 860 6909 Cote d'Ivoire 2014 Life evaluation Suffering 6910 Cote d'Ivoire 2014 Leadership approval Approve 5% 90% 5% 565 6911 Cote d'Ivoire 2014 Leadership approval Disapprove 4% 83% 13% 394 6912 Cote d'Ivoire 2014 Leadership approval (DK) 6913 Cote d'lvoire 2014 Leadership approval (Refused) 6914 Cote d'Ivoire 2014 Urban / Rural Urban 7% 83% 10% 224 6915 Cote d'lvoire 2014 Urban / Rural Rural 4% 88% 8% 764 6916 Cote d'lvoire 2014 Marital status Married 3% 90% 7% 199 6917 Cote d'Ivoire 2014 Marital status Not Married 5% 86% 9% 785 6918 Cote d'Ivoire 2014 Marital status DK/Refused 6919 Cote d'Ivoire 2013 Aggregate Aggregate 8% 83% 10% 992 6920 Cote d'ivoire 2013 Gender Male 8% 83% 9% 566 6921 Cote d'Ivoire 2013 Gender Female 7% 82% 10% 426 6922 Cote d'Ivoire 2013 Age 15-29 8% 83% 9% 449 6923 Cote d'lvoire 2013 Age 30-49 7% 83% 10% 421 6924 Cote d'Ivoire 2013 Age 50+ 8% 82% 10% 121 6925 Cote d'ivoire 2013 Age DK/Refused 6926 Cote d'ivoire 2013 Education Elementary school or les 7% 82% 11% 501 6927 Cote d'ivoire 2013 Education Less than tertiary educa 10% 84% 6% 464 6928 Cote d'ivoire 2013 Education Tertiary complete 6929 Cote d'Ivoire 2013 Household income Poorest 20% 12% 82% 5% 152 6930 Cote d'ivoire 2013 Household income Second 20% 4% 80% 16% 192 6931 Cote d'Ivoire 2013 Household income Middle 20% 4% 86% 10% 162 6932 Cote d'ivoire 2013 Household income Fourth 20% 10% 81% 9% 215 6933 Cote d'Ivoire 2013 Household income Richest 20% 8% 83% 8% 271 life Evaluation Index Sheet1