Hey man looking to join the patreon. Curious as to when I join and download your models does the finished model load up from the download or do you need to import the data yourself?
G'day lad 😃 Yes, the model is completely automatic. At the start of the video, I brought in the stats using a Power Query. This grabs the most up to date stats from Hockey Reference, and brings them in live to Excel. All you have to do is go into the 'Data' tab, and select the "Refresh All" button to update the file. I highly recommend you join lad, it's worth it 💪 And, once you're a member, you can ask me any questions you like about sports modelling and I'll get back to you ASAP 🔥
Although I'm not into hockey, I always find your models very interesting and inspiring. Question: wouldn't the Poisson distribution be more suitable for predicting Hockey scoring? Thanks. Cheers
G’day lad, thanks for watching 🙏 Yes, you’re right. However, Hockey is split into three different parts, with the last two (Extra Time and Shootout), ending when a particular team takes the lead. That’s why I had to use the BINOM.INV function to simulate the time of the goals scored, which POISSON.DIST doesn’t have the power to do by itself.
Hi lad, excellent idea 🔥 I've recently been thinking about how to do something like this. Ordinal logistic regression may be the solution. In the short term I may make a video/model on this 💪
Hello buddy! I bought a Patreon subscription yesterday. But for some reason, when updating data, “#value!” pops up almost everywhere. What could be the problem and how to fix this problem?
Hi lad, welcome 🔥 Great to have you! Usually these errors happen due to an accident in deleting a cell/formula while using the model. My first recommendation would be to re-download the file from the Patreon post. If the error is still there, please send a screenshot to me through the Discord. Of course, if you’re having trouble with this, or anything else, please don’t hesitate to send me a message through Patreon 💪 Let’s get your error fixed as fast as possible 🥇
G'day lad 🔥 Yep! All you have to do to update the stats is go into the 'Data' tab and select "Refresh All". This will update the model's connection with the internet, and bring in the most up to date stats!
Hi lad, the Hockey data is from this link: www.hockey-reference.com/leagues/NHL_2024_standings.html I brought it into Excel using a Power Query, so that all I have to do is refresh the file and the stats update. This is all included as part of the Patreon Membership, check it out here: www.patreon.com/posts/99755288