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.
alteryx Community

# 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 #243: Odd Man Out

Alteryx

A solution to last week's challenge can be found hereSource: https://en.wikipedia.org/wiki/Gender

In general, there are slightly more men than women in the world. According to the United Nations, the number of men is rising gradually each year since 1960. However, some statistics show this is not the case in certain countries. In former Soviet republics, for example, women outnumber men. Conversely, there are more men than women in Asia, Arab countries, and Northern Africa, but what about in Latin America?

This Input data for this challenge is an Excel file containing data with the long-term population estimates and projections from 1950 to 2100. Use it to answer the following questions:

1. What was the last year in which there were more men than women in a Latin American country?
2. In what year will the percentage of men in a Latin American country reach the lowest point according to this dataset?
3. Is there any chance that it will be more men than women by 2100? In which Latin American country?

12 - Quasar

My answers differed from the given answers a bit but I am confident in them.

Spoiler

Edit: I dug into the data set a bit and found that Peru and the Dominican Republic had the same population values for women for each year.

Spoiler

Spoiler

11 - Bolide

Slightly different results (and similar to @Blake 's above)

Spoiler

11 - Bolide

Fun challenge! I decided to use a Batch Macro to read in the sheets dynamically, and reported the answers using the reporting tools:

Spoiler
15 - Aurora

My solution. Perfect match with Output.

Spoiler
I feel that it is difficult for a beginner tag.

9 - Comet

I also got slightly different results than the provided solution.

Spoiler
11 - Bolide
Spoiler

Pretty sure this is right, doesn't match the example output though.

8 - Asteroid

Answer 1 Countries different from output but match others who have submitted to date.Results may vary further depending on your Year filter logic, i.e. < 2020 or <= 2020. Year filter can also impact Answer 3. I kept 2020 out of my Answer 3 to match given output.

Spoiler

12 - Quasar

No better way to start a Monday.

My results are in line with @Blake's output.

Spoiler

9 - Comet
Spoiler

As mentioned by others, my answers are slightly different to the Output file! Video solution here: https://www.youtube.com/watch?v=4nZq7dlX_0Q&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=47

Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-243-Odd-Man-Out/td-p/670289