Predict the NBA In-Season Tournament... With Excel! | Part 1

[@kirrillywaring613]

Excellent! Love this channel!

[@AchillaPaul]

Very good to see.

[@James-mt6so]

Alright Ladz, is it possible to model the att & def for each quarter? I wanna see which teams have a tendency to start strongly & vice versus, which teams get come out the traps slowly.

[@excel_ladz]

Hi lad, it is possible to do that, but you would have to collect the 4 quarter data from every team. So instead of considering a team's strength in an entire game, you would have to play 4 separate quarters, and a team would perform according to their strength in a specific quarter of that season. The sum of these quarters would be the final score, and then overtime can be played accordingly. I hope that helps lad 👍

[@basiliszag]

Great stuff. It was good to finally see someone simulating without assuming normal distributions. Will you put content exclusive to your patreon?

[@excel_ladz]

Thanks lad 🔥 While any models I'll ever build will be eventually published on KZbin, the Patreon has "explainer" videos on top. These kinds of videos cover how to use the models efficiently, the theory behind them, as well as an explanation of certain concepts (e.g. proper way to use simulations for analysis). The Discord chat (as part of the Patreon) is great for 1-on-1 chats, so I highly recommend it lad 💪

[@basiliszag]

@@excel_ladz great thanks for your response

[@FP_LLKV]

finished, great explinations. how do you do simulations if not changing something like a formula, it only changes if i change something, like you do? cannot seem to find it

[@TheWJDes]

When is part 2 dripping?

[@excel_ladz]

It's dropped lad 🔥

[@FP_LLKV]

Will you make an nfl one?

[@excel_ladz]

G'day lad, it'll definitely be a priority before the start of the NFL Season 💪

[@locomoco453]

How do you get the percentage for 2PA Poss and 3PA Poss?

[@excel_ladz]

Hi lad, the 2PA Poss represents the proportion of shots taken by the player that are two pointers. As a result, the 3PA Poss is the proportion of shots taken by the player that are three pointers. The 2PA, 3PA and the FT PA should always add up to 1, or 100% 👍

[@bobnicholson6350]

Hello again...gr8 video one question...at28:18 how did u format .075 for wins...using formula I get 3?? any help? Thanks

[@excel_ladz]

Thanks for watching lad 👍 Make sure you divide your win figure (e.g. 3) by 4 to get the win percentage (i.e. 75% for 3 games won). This is because each team plays 4 games in the tournament 💪

[@FP_LLKV]

Part 2 ?