How to Simulate the Super Bowl in Excel

Поділитися
Вставка
  • Опубліковано 30 лис 2024

КОМЕНТАРІ • 15

  • @delt19
    @delt19 3 роки тому +5

    I see the R studio icon down there. You should show some of you R work on here.

  • @mattleto2995
    @mattleto2995 3 роки тому

    Hey! Awesome vid man. I guess my question would be what goes into deciding the amount for adjusted weight in results tab?

  • @davidgarcia-wb1yn
    @davidgarcia-wb1yn 2 роки тому

    Thanks man, would like to ask what does the weight of the adjusted statistics mean? does it mean how much you trust the game will go as the adjusted stats imply? As in, "I do think the defense will be able to contain the rival offense, so, as the adjusted rating supports this hypothesis (with a low value) I give this number a higher weight than the unadjusted rating".

  • @Ass4ss1n2
    @Ass4ss1n2 3 роки тому

    how can you manage homefield advantage? thanks

  • @kingdom216
    @kingdom216 2 роки тому

    If we have it set up in a home and away set up, what is different?

  • @jcgo6703
    @jcgo6703 3 роки тому

    Im curious in how would you this with college hoops, there the adjustment is the most important factor

  • @aussieniner2749
    @aussieniner2749 3 роки тому

    I recently built this model. Normal lines seem realistic but totals are all over the shop? Anyone else have this issue?

  • @liam3.20
    @liam3.20 2 роки тому

    does this work in google sheets as well?

  • @j.d.mikula2853
    @j.d.mikula2853 3 роки тому

    I have an NHL model but it projects negative goals and unrealistically high goal totals. Do you know how to fix this/keep a specific range for the goal simulations?

    • @brandongdula4328
      @brandongdula4328 3 роки тому +1

      You can set minimum and maximum parameters. This should work if you wanted your results to be between 0 and 6, for example: =MAX(MIN(NORM.INV(RAND(),mean,standard_deviation),6),0)

  • @edwardgale8999
    @edwardgale8999 2 роки тому

    did anyone build this and obtain negative numbers?

  • @ravikiran2959
    @ravikiran2959 3 роки тому

    Hi Riley, Do u give suggestions for esports data analysis ? I have dropped you a mail for some support. Thank You. Cheers.

  • @donramo9201
    @donramo9201 3 роки тому

    👌🏽

  • @bobdakila
    @bobdakila 3 роки тому

    Can i have your email or discord name. I just want to chat with you.