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.
SUBMIT YOUR IDEA
7th challenge completed.
Spoiler
So the first two questions are fairly self explanatory, just selecting the relevant data from the tables, summing and calculating the averages before isolating the 2 answers from the data of the rest of the league.
The 3rd question was just using the Pearson function that I did not know existed before this challenge - every day's a school day!
The 4th question I again started by selecting the relevant data and sorting it by the 2015 rank of the teams. Then using the summarize tool twice to count the number of players in each position by team and then summing the amount of home runs and wins by team. I used the cross tab tool to alter the data to view the position count by team easier. I then used the join tool to combine the two tables and again using the select tool to eliminate the duplicate Fantasy Team column. Then I used the data cleansing tool to turn the [Null] entries into 0's even though the solution doesn't require this.
The 3rd question was just using the Pearson function that I did not know existed before this challenge - every day's a school day!
The 4th question I again started by selecting the relevant data and sorting it by the 2015 rank of the teams. Then using the summarize tool twice to count the number of players in each position by team and then summing the amount of home runs and wins by team. I used the cross tab tool to alter the data to view the position count by team easier. I then used the join tool to combine the two tables and again using the select tool to eliminate the duplicate Fantasy Team column. Then I used the data cleansing tool to turn the [Null] entries into 0's even though the solution doesn't require this.
