World Happiness Report Dataset Instructions

Dataset Overview

This dataset contains happiness levels and related factors (economic, social, health) for over 150 countries across multiple years (2015-2019). Excellent for creating comparative visualizations and time-series analyses.

Dataset Files

  • 2015.xlsx: 2015 happiness data
  • 2016.xlsx: 2016 happiness data
  • 2017.xlsx: 2017 happiness data
  • 2018.xlsx: 2018 happiness data
  • 2019.xlsx: 2019 happiness data

Variables Description

Each year’s dataset includes:

  • Happiness Metrics: Happiness score, rank
  • Economic Factors: GDP per capita
  • Social Factors: Social support, freedom, generosity
  • Health: Healthy life expectancy
  • Trust: Perceptions of corruption
  • Geography: Country, region

Use Cases

This dataset is suitable for:

  • Comparing happiness levels across countries and regions
  • Analyzing trends over time (2015-2019)
  • Understanding factors that contribute to happiness
  • Creating comparative visualizations
  • Building interactive dashboards

Excel Analysis Tips

  • Combine multiple years’ data using Power Query
  • Create charts comparing countries and regions
  • Use pivot tables for multi-year analysis
  • Create time series visualizations
  • Build dashboards with multiple chart types
  • Use conditional formatting for ranking visualization