probabilities

  1. N

    Statistical Probability Problem Excel

    Hi Everyone This should be rather simple, any help is appreciated thank you :) In column A i have a dates in order in order, in column B i have either if the day was a "win" or a "lose" In Column C i have a formula for current win streak im looking for a formula to determine given the...
  2. M

    How can we use VBA/Macros Excel for solving this interesting simulation question related to probability distribution?

    Imagine that we have 100 pens in our box (each numbered from 1 to 100). We mix them and then randomly draw ten pens and put them aside. Afterwards, we put ten new pens numbered from 101-110 into the box, and then again randomly draw other ten pens and put them aside. We continue doing these...
  3. M

    How can I use simulation tool in Excel for solving the following problem related to probability?

    Trial Number 1 2 3 4 5 ........ 2000000 (two million) Success in nth attempt 12 4 21 5 10 12 Note: Imagine throwing a dice where each outcome has probability of 1/10 (not 1/6 as it is usual for dice). For us "success" means throwing a "3". For each trial (see above) we keep throwing dice until...
  4. E

    Ranking and probabilities about games and league table

    Hello everyone, I need your help to answer these questions on which I have spent a lot of time but am not making any progress... Construct the current League Table - ordered by points (3 for a win, 1 for a draw), goal difference and then goals scored. Produce prices for the upcoming fixtures...
  5. M

    Probability Sequence Until Success

    Suppose I have success rate probabilities based on years of experience and I am looking to generate random simulations indication what year success is achieved. If not in year one, move to year two, and so forth until success. Year Success Rate 1 5% 2 15% 3...
  6. S

    Stats Probability Help

    In the final match a boxer is facing another boxer and is expected to win 48% of the time. In reality they win 80% of the time. What is the probability of that occurring in 10 matches? 2) In the very next match (in a different tournament), the boxer who won the previous match only wins 40% of...
  7. L

    Applying Excel to Statistics

    To whomever is reading this, I have been given a series of questions by my boss in order to try taking statistical problems and using excel functions in order to derive the answers. I am completely new to both the fields of excel and statistics and would like some guidance on how to go about...
  8. B

    Next Full Moon AND Daylight Savings (Kudos/Hall of Fame Opportunity Only)

    Some of you folks could come up with the answer to this far quicker than I could painstakingly do: How many years must pass before theres a Full Moon AND Daylight Savings Clock Adjustment falling on the same date? (This I guess could include both the Fall AND Spring time adjustment dates.)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top