Тёмный
No video :(

How to Use Excel to Calculate Probabilities : Advanced Microsoft Excel 

eHowTech
Подписаться 503 тыс.
Просмотров 613 тыс.
50% 1

Опубликовано:

 

24 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 76   
@llstringbean
@llstringbean 6 лет назад
You can highlight the range and press f4 to make it static instead of typing in the dollar signs. Love that shortcut key
@eugenevanwyk3626
@eugenevanwyk3626 5 лет назад
Its called absolute cell referencing
@nikad7659
@nikad7659 8 лет назад
suggestion we need to see the screen all the time seeing you wont help lol !!! Cheers
@bejitafangirl
@bejitafangirl 6 лет назад
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!
@cheggmi3637
@cheggmi3637 2 года назад
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>
@7HeyYewCow7
@7HeyYewCow7 10 лет назад
Saved my life. Thank you
@musictv2529
@musictv2529 8 месяцев назад
Thanks ted
@allanpark6046
@allanpark6046 2 года назад
Thank you once again
@cajunphilippine
@cajunphilippine Год назад
Thank you that was an easy way to explain. 💯
@FactFusion379
@FactFusion379 Год назад
Ill be damed this guy has more video quality than any 2010
@andycobra49aor
@andycobra49aor 10 лет назад
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 лет назад
well, we waited 2 years. what happened?
@shubhamghosh2418
@shubhamghosh2418 7 лет назад
even am curious :D
@CesarGomez-nw4zt
@CesarGomez-nw4zt 6 лет назад
HE won and don't give shit about RU-vid anymore... hahahaha
@andrewx6516
@andrewx6516 5 лет назад
spoiler alert - everything will be the same
@emensonjean7424
@emensonjean7424 7 лет назад
how can I use probability to determine how many points a player can on a give game?
@cyndibriggs9939
@cyndibriggs9939 10 лет назад
Very helpful!
@maclanphere5674
@maclanphere5674 4 года назад
great lighting, Ted!
@simfinso858
@simfinso858 6 лет назад
Very useful video Thanks for uploading.
@shonnellYouCantHandlethetruth
@shonnellYouCantHandlethetruth 4 года назад
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
@mhelmi73
@mhelmi73 6 лет назад
Thank you Ted. Benefiting
@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?
@Joseph-rj2xz
@Joseph-rj2xz 4 года назад
hey . how can i predict random numers from 0 to 9 with previous result data ? pls help
@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 !!
@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
@1o1e12
@1o1e12 5 лет назад
great vid thank you
@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.
@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)
@sidehustletrav4793
@sidehustletrav4793 3 года назад
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!
@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
@arielasan1
@arielasan1 7 лет назад
Thank u!!
@Mephistopheles019
@Mephistopheles019 7 лет назад
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?
@by2358
@by2358 2 года назад
Extremely helpful- thank you! 🙏
@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
@TheMotoguse
@TheMotoguse 11 лет назад
This is the first time I had to look at the guy talking instead of just the spreadsheet. Show just the spreadsheet.
@johnathangreene1947
@johnathangreene1947 4 года назад
How does this tie into stock probabilities?
@ianhruday9584
@ianhruday9584 7 лет назад
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
@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.
@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
@DeepakSharma-dm3dt
@DeepakSharma-dm3dt 2 года назад
Can u help me for cards probability in excel
@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?
@TheBoundFenrir
@TheBoundFenrir 8 лет назад
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
@cornerstone910
@cornerstone910 7 лет назад
I would like to know if I can predict any lottery number using this method? Thanks.
@hmax1591
@hmax1591 7 лет назад
no.
@575hobbit
@575hobbit 8 лет назад
can this be used for the euro lottery
@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"
@simfinso858
@simfinso858 6 лет назад
what about no 1 ??
@johannafabre7967
@johannafabre7967 6 лет назад
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.
@benyugi3513
@benyugi3513 2 месяца назад
Aviator prédication
@bvsrasu
@bvsrasu 4 года назад
This white dude saved my life, thanks
@thatkidangel2086
@thatkidangel2086 6 лет назад
What is the number of chances??
@ancestro2404
@ancestro2404 3 года назад
what if you have 3 dices
@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.
@RonnaLibre
@RonnaLibre 8 лет назад
download??
@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
@steal0119
@steal0119 11 лет назад
interesting
@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 $
@varee2535
@varee2535 6 лет назад
ขอบคุณครับ ถึงแม่ผมจะฟังไม่ออกก็ตาม
@yesno8723
@yesno8723 4 года назад
too much camera action .
@MrNorthernMan
@MrNorthernMan 4 года назад
Need to get your glasses fixed Ted.
@Venom-nk8nd
@Venom-nk8nd Год назад
🇵🇬🇵🇬🇵🇬
@eddiemesa4593
@eddiemesa4593 5 лет назад
Daddy you koferis are qarestecherkofj
@gameeverytime4126
@gameeverytime4126 3 года назад
how the f is this guy non indian
@SuperSaiyan3985
@SuperSaiyan3985 6 лет назад
Bullshit.
Далее
Master Data Analysis on Excel in Just 10 Minutes
11:32
Excel Formulas and Functions Tutorial
12:29
Просмотров 3,1 млн
Top 10 Most Important Excel Formulas - Made Easy!
27:19
Excel for Beginners - The Complete Course
54:55
Просмотров 6 млн
Excel Formulas and Functions | Full Course
52:40
Просмотров 1,3 млн
Computing the Binomial Distribution with Excel
3:34
Просмотров 223 тыс.