![]() ![]() To calculate the ages, I used this DATEDIF formula, but be careful with that function – it can give incorrect results in some Player Height in Feet Finally, are the players from a snowy region? Most of Canada gets snow and ice in winter, but what about the USA players? Are they all from the northern states?īefore doing any player data analysis, a few calculations were needed in the rosters.įirst, the rosters had each player’s date of birth, so what formula could you use to get each player’s age?.You’d expect the players to be in top physical condition, so what does the height and weight data show? Did the bigger team win, or is there an advantage to being smaller?.Are there differences among the teams? Did a team with younger players do better? What age range is represented in the hockey teams.The team rosters don’t show skill rating, or past performance stats, so what could I use for player data analysis? If you’d like to do your own analysis, you can find the hockey team rosters here: ![]() The rosters have player names, height, date of birth, etc., but are set up slightly differently, so there was some cleanup work to do, before starting. And of course, I used my favourite Excel tool – pivot tables. Instead, here is my rudimentary player data analysis, based on the team rosters. Since I’m not a hockey expert, or a master statistician, I’ll leave the in-depth game analysis to someone else. ![]() So here I am, saying congratulations to Team USA! We made a friendly wager, and the fans of the losing team promised to write a hockey data post, congratulating the winning team. Meanwhile, David Napoli was confident that Team USA would win this time. They had won the previous 4 gold medals, and seemed like a sure bet. Last week on Twitter, Science_Goddess and I were cheering for Team Canada. Is there anything in the player data that shows why the USA team won? The team rosters were available online, so I used those for a hockey player data analysis, in Excel pivot tables. They beat our Canadian team, in a hard-fought game that went into overtime, and ended with a shootout. Congratulations to the USA Women’s Hockey team, who won the Olympic gold medal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |