Summative Assessment – World Happiness

Recreate the below visualisation: 

Note: The visualisations within this assessment are using the Theme: City Park. 

Recreate the visualisation below

In which factors is Japan above average?

What is the MAX value for Healthy Life Expectancy? (2 decimal places)

What is the average GDP per capita for the region of South Asia? (2 decimal places)

With the regions, East Asia, South Asia and Southeast Asia selected, which country has the highest happiness score?

Copy your answer directly from the excel cell.

Again with the regions East Asia, South Asia and Southeast Asia selected, Select the top 10 countries by happiness score. What is the average Healthy Life Expectancy for this selection? (2 decimal places)

Which factors have the highest correlation with Happiness Score? (top 3). 

Of all the factors, which have the highest correlation to each other? (select the 2 factors)

Which country has the highest of both GDP per capita and Healthy Life Expectancy?

Which regions are above the 90th percentile in both Generosity and Perceptions of Corruption? (Select all that apply)

What is the dotted line in the chart below? 

Use the “Key Influencers” visualisation:

Add ‘Happiness Score’ to ‘Analyse’ and the 7 factors to ‘Explain by’. 

Which of the below factors do not appear on the Key influences?

Create a histogram of Happiness score. Change the number of bins to 10. What is the lower bound of the bin that contains the largest number of countries?

Give your answer correct to 2 decimal places.