We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #285: Around the world

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.image_285.PNG

 

This data set provides information that includes rankings and scorings of countries based on happiness, economy, health, family, freedom, generosity, etc. The countries are also categorized into 10 regions.

For this challenge, your goal is to find for each region:
- The country ranking the best for happiness
- And the country with the highest-scoring for Health (Life Expectancy)


Then create two reports (tables) to showcase your findings. Each report must include the country, region, and rank or scoring.

 

*The start file was updated to correct an error on 9/14/2021.

Aaron_Harter
11 - Bolide

great challenge!

Spoiler
0.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler
I think the answer provided may have the healthiest countries a little backwards...


Kenda_0-1631538179755.png

 

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
But the sample output is strange.
Is the lower value of Life Expectancy higher score?

AkimasaKajitani_0-1631538343664.png

 

AkimasaKajitani_1-1631538365759.png


Blake
12 - Quasar

Demonstrated 2 methods for finding the first in the list. 

 

Spoiler
Summarize and Sample

WC285.png
DaisukeTsuchiya
12 - Quasar

The results of 2nd Output becomes different. 

Spoiler

キャプチャ.JPG


キャプチャ2.JPG

2nd Outputs shows worst10 not top10. It should be below.  

キャプチャ3.JPG

 

clmc9601
12 - Quasar

Thanks for the challenge!

Seems to me that finding lowest "Health" score is not necessarily the "highest-scoring". See spoiler for more details.

Spoiler
@AYXAcademy this column according to the Kaggle dataset is how Health contributes to Happiness. That could be good or bad. Furthermore, if it were a health score, wouldn't higher be better? Looks like the answers were calculated sorting by Health ascending.
Screen Shot 2021-09-13 at 7.25.51 AM.png
Spoiler
Screen Shot 2021-09-13 at 7.25.40 AM.png

 

RolandSchubert
15 - Aurora
15 - Aurora

My solution

 

Spoiler
285.jpg
DeanWest
9 - Comet

Happy to start off the week with this challenge!

 

Spoiler
challenge_285_solution_DeanWest-snippet.png

 

JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png