Challenge #243: Odd Man Out

[p-g]

I got the same answer as you.

[apurvag95]

Solution is attached

Answer to Question 1 - Bolivia, Costa Rica, Ecuador, Panama, Paraguay, Peru, Republica Dominicana

Answer to Question 2 -  El Salvador (2035)

Answer to Question 3 - Bolivia, Ecuador, Cuba, Guatemala, Honduras, Paraguay, Peru

[OllieClarke]

Spoiler

I interpreted Question 1 as the greatest year in the past (<2020) that had male numbers above female
I really don't see how Question 2 can be different though...

Like others I didn't get the same output as the solution, which I think is due to interpretation of the questions. As far as I can tell my solution works for my interpretation of the question (as I'd hope!), but I'm curious to see if and how people have got to the same output...

Spoiler

[ehughes]

A wise person once said  "If you have to repeat something more than 3 times, use a macro". Thus I did not use a macro... 

Spoiler

 

[LHolmes]

A good lesson in investigating data and doing some engineering. Showing the solution before and after the fix. Both solutions differ from the the stated.

Spoiler

[ngindam]

Just don't understand how census data is in floats.

My answers didn't match the output data 😕

[mike_w]

having looked through @jasperlch solution at least for question 1, I understand now where the discrepancy comes from, and why so many people posted a different solution: 

Question 1 asks for the "last year in which there were more men than women in a Latin American country"; you have to add "before it switches to more women", something like that. For example, Peru has more men then women in 2015, but that stays the same in 2020; but for Costa Rica as well as República Dominicana / Dominican Republic, 2015 shows more men, but in 2020 they both have more women. So, in that sense, 2015 is "the last year in which there were more men than women in a Latin American country" .

Tricky..

[balajilolla]

Spoiler

SOlution Attached

[Kenda]

Spoiler

[JP_SDAK]

My answers differed from solution as well- but seemed to match everyone else's.  1st question is different. 

Spoiler