This project consists of performing data analysis on a large set of NHL (hockey) data from seasons going back to 2006-2007.
An example of the master sheet can be found here: [url removed, login to view] .
I have also formatted the excel sheet into all 30 teams individual seasons and results. An example can be seen here:
[url removed, login to view]
My goal is to test various amounts of tests that I will decide, such as how does a team perform after having a 3, 4, 5 game win streak against an opponent that has had a 3, 4, 5 game losing streak, etc.
I would like to have a separate tab on this excel sheet that would let me change parameters of the streaks. So for example:
Home team winning streak: X
Away team losing streak: Y
Away team winning streak: Z
Home Team losing streak P
And the results would be the W-L of each team. Eventually I would like to do more detailed results involving the odds for the event, but this will be a nice place to start.
I have quite a bit of things i want to test, so there will be more work available. Because of this I want to work with someone who is easy to communicate with and is available throughout the week. For now we will start with this task and move forward if the initial task is a success.
General knowledge of sports / hockey / sports betting is a huge plus, as I will have to explain less :).
Thanks and please feel free to ask me any questions.