Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

# Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## 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

Edit added video walkthrough

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
17 - Castor

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.

9 - Comet

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