How to Use Excel to Calculate Probabilities : Advanced Microsoft Excel

Subscribe Now:

Watch More:

Using Excel to calculate probabilities is something you can do with a spreadsheet and a few basic calculations. Use Excel to calculate probabilities with help from a mechanical engineer in this free video clip.

Expert: Edward Russell
Filmmaker: Patrick Russell

Series Description: Microsoft Excel isn't just for creating basic tables - it can also be a great way to graph information or even perform advanced calculations and analysis. Get tips on advanced Microsoft Excel topics with help from a mechanical engineer in this free video series.

[llstringbean]

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

[FnUnpeeled]

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!

[andycobraaor]

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

[markdadford]

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?

[cheggmi]

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.

[nikad]

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

[neerajkushwaha]

SIR PLEASE TELL ME THE FORMULA FOR ANY EXCEL SHEET TO THE PROBABILITY OF MOST POSIBLE WHICH IS MISSING TO ANY CELL HAVING NO OF DIGITS IN ROWS AS WELL AS IN COLUMNS

[sidehustletrav]

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!

[bigjimstudios]

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 !!

[YuichiC]

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

[cajunphilippine]

Thank you that was an easy way to explain.
💯

[nv.amiraj]

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

[emensonjean]

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

[LEO-qwxi]

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.

[shonnellYouCantHandlethetruth]

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

[zxcm]

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.

[ianhruday]

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?

[scottd]

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

[Joseph-rjxz]

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

[roguethemachine]

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