2019: Week 4
Welcome to week four and in my opinion, I'm three weeks too late for using basketball data. Both Jonathan and I are basketball fans but we have some questions that need solving. Therefore, this week is about using Prep to answer questions using the profile pane (of course you can build a viz if you want to). This is the Profile Pane: The input data comes from ESPN and the way they capture the three major stats on each team's schedule. Hi Points = Most points scored by a single player during the game Hi Rebounds = Most times a player has recovered possession after a missed shot Hi Assists = Most times a player has passed the ball to another player who then scored. This data copies in to Excel really badly... We have given you data just about Carl's favourite team, the San Antonio Spurs. You will obviously need to clean-up the data, but can then use some other functions in Prep Builder to help you answer the following questions. 1. In games won by the...