probability

  1. D

    Monte Carlo VBA Probability Macro

    I am trying to create a Macro/formula that calculates the probability that the value of a property is greater than a "Goal" value (which is an input). I want the value to be calculated a certain number of times, hence the Do While Loop, just like a Monte Carlo Simulation. I am very new to...
  2. F

    Probability - TREND

    Hi, I'm new to the board hoping for some friendly insight.. I'm trying to find a means to calculate a probability of default trend line over a certain period using the TREND function in Excel 10. My issue is the probability figure cannot be less than zero, however I'm not sure how to configure...
  3. S

    Mutually Exclusive Cells

    Hey Guys, I'm currently doing some uni analytics work and I'm trying to make a cell represent the chance of two other cells being mutually exclusive. Is there a way of including the probability of each cell occurring in the formula? The example is Year 1: Low Price: x, 0.4 High Price: y...
  4. A

    Determine Next Number based on Previous Dice Rolls

    Howdy everyone, I have a general question for anyone who is smart in statistics. For a school project I am wanting to see if I can predict, with a probability percentage, what the next dice roll will be based on previous dice rolls. For example: If with a give two set of dice I roll in this...
  5. C

    Help using if functions, rand() & inequalities all in one equation

    I am trying to form an "if" function. Given set probabilities a certain number of magazines are sold. In this situation a randomly generated number (rand()) is checked against a probability range from (0-1.0) generates a given value for those specific ranges (0-.5 is 50, .5-.15 is 75 ... for...
  6. V

    How to calculate a probability of events in excel?

    I would like to run a test 1000 times where there are only two possibilities of the event to occur out of 30 outcomes. Is it possible in excel? For example: I have 30 numbered stones in a bunch from 1 to 30. How many times I randomly pick stone no1 or 2 when I try this 1000 times? Is it...
  7. W

    Probability Distribution Tables?

    Hello, Im trying to find the ability/process to draw a curve and then obtain tabular forms of the probability distribution of that curve for X = 1 to 60 (1 month to 5 years). Once i have those 60 probability distributions i would apply a total revenue figure over that distribution to timephase...
  8. I

    Random Numbers based Upon Probability

    I'm spinning wheels. Here is what I'm attempting I'm trying to use the empirical discrete probability distributions to generate 1000 days of Widget sales and returns. I need to use Nested IF statements to generate the 1000 days of sales. So for 1000 days, generate a number in a column that...
  9. J

    Random Number Generator with flexible probability

    Hello, I am not sure of the proper terminology of what I am looking for but here is a description... I am looking to create a column of 1,000 results with each cell showing one of two numbers (ideally for me would be a "1" and a "-1"). I would like to be able to change what percentage of the...
  10. T

    Predicting next number in a series

    I have a series of numbers that I know the long-term probability for and I would like to predict the next number(s). There are 1320 possible outcomes listed in sheet 2 column e2 to e1321. I have 18370 trials in sheet1 column g2 to g18371, and I would like to predict (or find the most likely)...
  11. S

    Weighted Probabilities with random numbers

    Hi guys, this has been killing me but does anyone know how to incorporate weighted probabilities with random numbers? For example: I need to have a random number between 1-9 and have these probabilities: <tbody> 1 5% 2 10% 3 0% 4 20% 5 30% 6 10% 7 10% 8 10% 9 5% </tbody> Any...
  12. R

    Massive Probability Calcs

    I am creating a spreadsheet with a heavy amount of probability calcs in it. I am aiming to do calculations for card drawing (specifically for MtG). I have wrestled out a hard way to do some of the math, and it turns out putting it into a spread sheet is still difficult. So there are two great...
  13. J

    Probability scenario for the casino card game war.

    Hello all, So here is the scenario: I assume many of you have once in your life played the childhood card game war, where you deal one card for yourself and one for the opposing player and who ever has the highest card wins. Pretty simple right? This game is actually featured in some casinos...
  14. A

    Skewed Random Number Generator

    I am trying to generate 15000 random numbers that have similar charities to the same number of historical data points. The data is approximately from the t distribution, with the only exception being that it has skewness of -.21. Does anybody have any vba code that will accomplish these...
  15. B

    Statistics/BINOMDIST/failure rates??

    Greetings Power Users! XP, Excel 2003 with stats ad in Yes, this is an assignment AND I have the answers BUT I want to know how to get there (not wating your time). Taking online statistics and everyone in class using calculators, I am the only Excel fan. I approach problem as BINOMDIST...
  16. L

    Reverse Poisson?

    Not sure if anyone can help with this. Basically I'm trying to find out how to apply the reverse of the Poisson function in excel. So as of now I have poisson(x value, mean, true-cumulative) and that lets me get the probability for that occurence. Basically I want to know how I can get the...
  17. B

    Can't Solve Math Problem with Excel?

    I'm trying to get all of the possible combinations of 3 that cost less than $4 and their values in a list using an excell formula? Is it possible? There are 7 things at the store and you must buy 3 different ones without spending more than $4. All 7 items are valued differently than their...
  18. M

    Probability

    I am wondering how to take a percentage or fraction or something that represents "probability" and receive a "true" or "false" statement. For example, if I give the probability of 40% how can i have excel generate a true or false statement, or "yes" or "no" I am not quite the mathematics...
  19. T

    Probability of event occurring

    Hi everyone, I am utterly mystified by statistics and so I'm hoping that someone can help me out. I'm trying to find a calculation to show the probability of an event occurring in the current year based on how often it occurred over the previous seven years. No other date is available. I can...
  20. B

    Can you use historical numbers to calculate probability of next value?

    Given the min and max values from historical data. Can excel calculate the probability of the next number?

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