Challenge #376: Unlock Insights from FIFA Women’s World Cup Data!

[JereJussila]

Spoiler

USA domination

[tristank]

GOOOOOOOOOOOOOOAAAAAAAAAAAAAAAAAAALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL

Spoiler

[rohityaman]

Solved!

Spoiler

[sisiralteryx]

Would love to see other solutions that may not have as many filters/formulas as i used. 

[Carolyn]

Completed! Perfect timing since the US's Game 2 was last night. 

I had a rounding difference for Sweden's goals scored. I calculated 1.78 but the answer key has 1.77. Not sure which one is correct, but close enough. 

Spoiler

 

[mgaronson]

Spoiler

 Go the solution by calculating stats by home team and away team and summarizing accordingly and unioning together to create final stats. Saw @benjimoser solution (shoot out!) using the Arrange tool. Never used the arrange tool - a little tough to understand until you see the result! A slick way to do the stats. Will use this data for the FIFA World Cup challenge at work!

[ZacharyRyanTIL]

solved

[Laurap1228]

My solution is attached

[Chan_Baek]

Here is my solution.

Spoiler

Spoiler

[MilindG]

Solution