Analysis of National Alcohol Consumption and Happiness Scores
The study conducted a comparison between national alcohol consumption and happiness scores to determine if countries with higher alcohol consumption are also the happiest. Data from two separate datasets focusing on alcohol consumption and happiness scores of 145 countries were analyzed. The research utilized information on total liters of alcohol consumed and happiness scores to draw conclusions. Additionally, background information on happiness scores and the methodology behind the happiness data collection process were provided. The findings shed light on potential correlations between alcohol consumption and happiness levels in different countries.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
National Alcohol Consumption & Happiness Scores Noah Wilson DSCI 101 MWF
Data Overview Used two separate datasets Main objective was comparing the summaries of each to draw a conclusion Are the countries that consume the most alcohol the happiest or vice versa?
Happiness Data Data imported from Wikipedia Originally from the United Nations databases Annual report released in March 156 countries 8 Fields Country Score GDP per Capita Social Support Healthy Life Expectancy Freedom to Make Life Choices Generosity Perceptions of Corruption
Background on Happiness Score Around 1000 citizens from each country are asked to score how happy they are in their respective nation on a scale of 1-10 All other fields are calculated by UN statisticians and political experts to back up/explain the scores of each country GDP, life expectancy, social support, freedom, generosity, and absence of corruption most relevant factors Generally conceived to be directly proportional Much scrutiny around the report since it has inaccuracies and potential tampering Countries in civil war(Somalia, Libya) rank higher than stable nations
International Alcohol Consumption Data Obtained from Kaggle Csv 194 lines of data Also taken from United Nations databases 5 total fields Country Beer Servings Spirit Servings Wine Servings Total Liters of Alcohol Consumed
Cleaning of Both Sets Despite both sets coming from the UN, had different number of countries Alcohol set 194 Happiness 156 Sorted both and deleted any not on both lists Got down to 145 identical Neither set had any difficulties aside from the sizes In order to get the easiest and cleanest results to compare the two sets I only used the Total Liters of Alcohol and the Happiness Score
Happiness Score of Countries Row Labels Count of Score 30 Separate Findings, Happiness 1 Finland 7.769 3-3.5 8 2 Denmark 7.6 25 3.5-4 7 3 Norway 7.554 4-4.5 18 Top 6 have been interchanged since 2010 4 Iceland 20 7.494 United States is 18 and rarely is higher than 15 4.5-5 21 Number of Scores Average is 5.42 5 Netherlands 7.488 5-5.5 22 15 Close to normal distribution 6 Sweden Total 5.5-6 20 7.343 10 6-6.5 26 7 New Zealand 7.307 6.5-7 8 8 Canada 7.278 5 7-7.5 12 9Austria 7.246 7.5-8 3 0 3-3.5 3.5-4 4-4.5 4.5-5 7.228 5-5.5 5.5-6 6-6.5 6.5-7 7-7.5 7.5-8 10 Australia Grand Total 145 Range of Happiness Scores Awarded
Total Liters of Pure Alcohol Consumed Belarus 14.4 Findings for Alcohol Dataset 50 Row Labels Count of Total Liters of Pure Alcohol Lithuania 12.9 45 0-2 43 Czech Republic 40 11.8 Values are per Capita 2-4 22 35 France Number Of Countries 11.8 Average 5.01 Liters per Capita = 1 1/3 gallon 4-6 18 45 % countries drink less than 4 Liters in a year per capita Russian Federation 30 11.5 Some countries it is illegal to drink at all 6-8 23 25 Total Different drinking ages a factor Ireland 11.4 20 8-10 16 USA above average with 8.7 liters per capita which is 34 Luxembourg 15 11.4 10-12 21 10 Slovakia 11.4 12-14 1 5 Germany 11.3 14-16 1 0 0-2 2-4 4-6 6-8 8-10 10-12 12-14 14-16 Grand Total Number Of Liters Hungary 11.3 145
Comparison Each of the top 10 happiest countries are above average in their alcohol consumption with 5 of them being above 10 Liters Each of the countries that consume the 10 highest levels of alcohol are above average except for Belarus, the number one 4 were in the top 20
Conclusion Not enough evidence to answer my question but enough to suggest a correlation If more time I would like to see if drinking age had a significant effect on the average and use more of the fields involving the happiness score Any questions?
