How to Use Excel to Calculate Probabilities : Advanced Microsoft Excel

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • НаукаНаука

Комментарии • 76

  • @llstringbean
    @llstringbean 6 лет назад +7

    You can highlight the range and press f4 to make it static instead of typing in the dollar signs. Love that shortcut key

  • @cheggmi3637
    @cheggmi3637 2 года назад +9

    I would advice for your next video that you should not be switching between the excel sheet and your image, it affects assimilation in a way. The brain tries to interpret what you are explaining at that moment using the sheet, but then at that instance you switch to your image and that does not help. Otherwise, it is a lovely one. Thank you.

    • @Frank-te7tl
      @Frank-te7tl Год назад

      Besides, your image is not that nice>

  • @nikad7659
    @nikad7659 8 лет назад +24

    suggestion we need to see the screen all the time seeing you wont help lol !!! Cheers

  • @bejitafangirl
    @bejitafangirl 6 лет назад +5

    This was really helpful! We are doing something similar in class but the directions were confusing to me so I appreciate how you went through this slowly so that I would try and replcate something similar in the data I was looking at. Thank you!

  • @andycobra49aor
    @andycobra49aor 10 лет назад +5

    Sir;
    You have demonstrated a great idea to do a table to lotto numbers based on the probabilities, let see what happens, I will keep you posted.
    Respectfully; Andy

    • @hmax1591
      @hmax1591 7 лет назад +12

      well, we waited 2 years. what happened?

    • @shubhamghosh2418
      @shubhamghosh2418 7 лет назад

      even am curious :D

    • @CesarGomez-nw4zt
      @CesarGomez-nw4zt 6 лет назад +3

      HE won and don't give shit about RUclips anymore... hahahaha

    • @andrewx6516
      @andrewx6516 5 лет назад

      spoiler alert - everything will be the same

  • @FactFusion379
    @FactFusion379 Год назад

    Ill be damed this guy has more video quality than any 2010

  • @7HeyYewCow7
    @7HeyYewCow7 10 лет назад +4

    Saved my life. Thank you

  • @emensonjean7424
    @emensonjean7424 7 лет назад +4

    how can I use probability to determine how many points a player can on a give game?

  • @bigjimstudios2545
    @bigjimstudios2545 3 года назад

    I have a very subject specific question that I need help with and a lot of variables to go along with it... I don't think it's doable but try if you can and let me know.
    Ingame: 30 players max, hovering around 20-25.
    Goal: 20+ Million RP points.
    Specific season daily game races: equaling 700,800 points
    RP set for each player is 800K, on a 30 person that is 24M - refer to "ingame"
    Caps: 250K each player daily but there is something about 300K I don't understand yet.
    Goal: The probability that a player will meet "a daily" goal to reach 800K... As the 14 day season dwindles down there is less and less but the kicker is the PC (refer to: Specific season daily game races) itself is 30 races @ 300K.
    Tried to include as much info as possible and I'm sure if you want to try there will be some questions.
    Thank you & have a good one !!

  • @musictv2529
    @musictv2529 8 месяцев назад

    Thanks ted

  • @cajunphilippine
    @cajunphilippine Год назад

    Thank you that was an easy way to explain.
    💯

  • @allanpark6046
    @allanpark6046 2 года назад

    Thank you once again

  • @sidehustletrav4793
    @sidehustletrav4793 3 года назад +2

    I’ve just started with probabilities. I work in risk management. Im wondering if you could find out the probability of a fraudulent sale come in for underwriting per year or month. Very helpful in getting my brain going!

  • @shonnellYouCantHandlethetruth
    @shonnellYouCantHandlethetruth 4 года назад +1

    I have an excel program that was given to me that does lotto pick 4 and pick 3 but not working correctly can you please check it for me

  • @cyndibriggs9939
    @cyndibriggs9939 10 лет назад +2

    Very helpful!

  • @maclanphere5674
    @maclanphere5674 4 года назад

    great lighting, Ted!

  • @TheMotoguse
    @TheMotoguse 11 лет назад +6

    This is the first time I had to look at the guy talking instead of just the spreadsheet. Show just the spreadsheet.

  • @Joseph-rj2xz
    @Joseph-rj2xz 4 года назад +1

    hey . how can i predict random numers from 0 to 9 with previous result data ?
    pls help

  • @markdadford2107
    @markdadford2107 Год назад

    So a question. In your video around 0.57 min you mention your table is multiplied by each independent, however your excel formula shows its added? Is that added or multiplied? Second, how would this apply to a scenario where you are looking at a 100 sided die?

  • @Mephistopheles019
    @Mephistopheles019 7 лет назад +2

    What if I added a 3rd die in to the mix, but only wanted to know the probability of rolling a 7 using 2 of them?

    • @MrSunshanmu
      @MrSunshanmu 2 года назад

      What if we removed a die?

  • @davismotomiya29
    @davismotomiya29 2 года назад

    Wealth u(W) = ROOT W, W=10, probability 0.3 to turn to 100, 0.7 to lose everything, wants to avoid risk, how much is he willing to pay? (0,1,2,3)

  • @simfinso858
    @simfinso858 6 лет назад

    Very useful video Thanks for uploading.

  • @ianhruday9584
    @ianhruday9584 7 лет назад +1

    Suppose you rolled 3d6 and wanted to know the distribution of the sum of the two highest/lowest dice? E.g. what are the chances of rolling a 2 if you role 3 dice and discard the lowest number?

    • @Silent.
      @Silent. 2 года назад

      Idk but you'll eventually get it, I believe in you

  • @TheBoundFenrir
    @TheBoundFenrir 8 лет назад +1

    Ok, but what if you're dealing with 2 100-sided die, and you need to know the probability of one being more than the other, but only if both or neither of them exceed two independant threshold values?
    That is to say, for constants Att and Fr,
    P(HIT)=P(X

  • @nv.amiraj
    @nv.amiraj 7 лет назад

    Hi,
    What will be the formula to calculate falling in below winning category if 20 people playing 1 match for prize money of USD100 to be shared between top five rank
    Rank 1- USD 50
    Rank 2- USD 25
    Rank 3 -USD 15
    Rank 4 - USD 5
    Rank 5 - USD 5

  • @mhelmi73
    @mhelmi73 6 лет назад

    Thank you Ted. Benefiting

  • @roguethemachine3928
    @roguethemachine3928 3 года назад

    it all good but what if we dont know the countif values say ur calculating probabilities of things that are all rolling at the same time happening once

  • @vf84tcat1
    @vf84tcat1 3 года назад

    Explain "Two ways of rolling the number two"
    Remember you have an audience who may have less experience than you. Teach them by giving an example of the "two ways of rolling a two"

  • @1o1e12
    @1o1e12 5 лет назад

    great vid thank you

  • @scottd4347
    @scottd4347 Год назад

    can you write a program just like eol software with wheeler
    so you can put keno or lettery number that alredy play
    then find out what number come out 2-4 as a group within 100-1000 game

  • @zxc1423m
    @zxc1423m 4 года назад

    Sir, I'm looking similar set up but not exactly.But I'm wonder it possible choose a group of six numbers each number input selected number or range for all six number than find possibly combination to generated and list out the numbers. Is there any help from you. Thank you.

  • @bvsrasu
    @bvsrasu 4 года назад +1

    This white dude saved my life, thanks

  • @cornerstone910
    @cornerstone910 7 лет назад +1

    I would like to know if I can predict any lottery number using this method? Thanks.

  • @georgebinkley
    @georgebinkley 10 лет назад

    Hi I got a quick question if I use that randbetween say I wanted to use it through 1 through 56 and Say I did not want to use 36 24 10 how would I subtract that from the formula

  • @by2358
    @by2358 2 года назад

    Extremely helpful- thank you! 🙏

  • @premalmedia
    @premalmedia 6 лет назад

    how can we use this distribution to randomly generaate the chances

  • @nicolestrachan4964
    @nicolestrachan4964 6 лет назад

    I have been trying to figure out how to use this with football betting. are the number of outcomes 3 for win, lose or draw?

  • @johannafabre7967
    @johannafabre7967 6 лет назад +3

    How can I do this with 3 dice??

    • @Mephistopheles019
      @Mephistopheles019 6 лет назад

      I would also love to know this. Please let me know if you ever found a solution.

  • @arielasan1
    @arielasan1 7 лет назад

    Thank u!!

  • @LEO-qw7xi
    @LEO-qw7xi 5 лет назад

    i have row with numbers 1,0,1,1,1,0,1,0,0,1,1,1,1 who is even longer if i look in history. is there any whey in excel what can help me find next number according of previous data, maybe there is some macro who can read history data and when it ends continue independently to make numbers according of previous data. Or you know better whey how i can get solution of this problem. hope you can help me. Thank you for your other videos they are really useful.

  • @575hobbit
    @575hobbit 8 лет назад +1

    can this be used for the euro lottery

  • @johnathangreene1947
    @johnathangreene1947 4 года назад

    How does this tie into stock probabilities?

  • @pascaltorvic6246
    @pascaltorvic6246 7 лет назад

    This is nothing to do with lottery, in a lottery the prob to get a number is 1/N for any number; In the exemple in the video, probability makes sens because it's a sum: For example there is only 2 ways to make a "2" , 1+1 and 1+1 whereas 7, we can get with 1+6,6+1,5+2,2+5,3+4,4+3 that's why the probability to get a "7" is the biggest one.

  • @simfinso858
    @simfinso858 6 лет назад +1

    what about no 1 ??

  • @DeepakSharma-dm3dt
    @DeepakSharma-dm3dt 2 года назад

    Can u help me for cards probability in excel

  • @thatkidangel2086
    @thatkidangel2086 6 лет назад

    What is the number of chances??

  • @ancestro2404
    @ancestro2404 3 года назад

    what if you have 3 dices

  • @fouadalyousefi975
    @fouadalyousefi975 8 лет назад

    is there a special formula for probability as a data analysis tool analyzing more than two variables probabilities? (but still "using and gathering a simple formula to achieve a complex probabilities is the most creative") thank you

  • @benyugi3513
    @benyugi3513 2 месяца назад

    Aviator prédication

  • @mrescoe355
    @mrescoe355 4 года назад

    Hay its CV19 time. As such can you formulate ( assume 333M people in US, each person communicates with 10 friends ) accounting for overlaps in the chain, for any given number of CV19 deaths what are the probabilities that a single person will hear about a specific person's death

  • @noelcano8996
    @noelcano8996 5 лет назад

    hit f4 instead of $

  • @RonnaLibre
    @RonnaLibre 8 лет назад

    download??

  • @steal0119
    @steal0119 11 лет назад

    interesting

  • @varee2535
    @varee2535 6 лет назад

    ขอบคุณครับ ถึงแม่ผมจะฟังไม่ออกก็ตาม

  • @yesno8723
    @yesno8723 4 года назад

    too much camera action .

  • @Venom-nk8nd
    @Venom-nk8nd Год назад

    🇵🇬🇵🇬🇵🇬

  • @MrNorthernMan
    @MrNorthernMan 4 года назад

    Need to get your glasses fixed Ted.

  • @eddiemesa4593
    @eddiemesa4593 5 лет назад

    Daddy you koferis are qarestecherkofj

  • @gameeverytime4126
    @gameeverytime4126 3 года назад

    how the f is this guy non indian

  • @SuperSaiyan3985
    @SuperSaiyan3985 6 лет назад

    Bullshit.