probability

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

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

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

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

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

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

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

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

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

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)...

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

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

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

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

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

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

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

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

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

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