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...
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...
Help me please. I would like to know the possible probability, forecast, and trend. If you are given 2 possible outcome with atleast 1-60 given outcomes. For insctance, if you have 100 ballpens, and the only colors are BLUE and RED. then you want to know the possible color you would pick next...
Would anyone know how to compile the history of the Dow Jones (either from inception or say the past 20 years)
where I could figure out probability of stocks going up two times and then down once AND ALSO three times up and then down once.
Here are the 2 questions and patterns I am looking to...
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...
Hey guys,
I have a spreadsheet with the past frequency of losses in a row before having a winner. What formula can I use to calculate the probability of having a winner after 1,2,3(etc) losses in a row according do this data?
Thanks, appreciate the help!
Hello! I have trouble finding the mean and probabilty when only the standard deviation is given.
I have the correct answer, look below questions.
I think NORM.S.DIST might be the correct formula, but I cant figure out HOW to use this to get the solution.
QUESTION 1) A Top-load washers at a...
Hi there,
I am a high school teacher and am looking at creating an excel sheet that will act as a random number generator. As a start, I would like the code to randomly generate a number from a list of values and record it in column 1. I would then like it to continue recording each trial...
Hi. I would like to ask how can I generate a the cell output to be 1 with probability 20% and to be 2 with probability 80% only by using pure formula in excel? Thankssss
My company has ordered a money machine (a device that looks like a phone booth that blows cash around while you try to catch it) for employee incentives.
I am trying to figure out the probability of someone capturing more than x amount of dollars per attempt.
We are going to be blowing 200...
So I have a small issue with reading and greatly need help with a problem I am having and trying to get it to proof on my College homework.
I get the actual math behind it but trying to get the right formulas in Excel to work has been a major issue.
So the problem goes like this.
You are...
Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing...
Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing...
I have a mortality table for 100 people, and I'm trying to calculate the expected deaths each year for 20 years. This requires me to calculate the probability of one death and multiply by 1, then calculate the probability of two deaths and multiply by 2, and so on up to 100.
The setup of the...
I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the projections were and creating a chart based on the projections and actual's.
now i am being tasked...
hi,
in excel I have
<tbody>
Sex
Probability
Cumulative Prob
M
80%
80%
F
20%
100%
</tbody>
These are in a sheet called probability of Client and run from cells E1 to G3.
In another worksheet i have put the below formula in. Most of the time the result is #n/a with the occasional 'M'...
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...
Hi everyone,
I need an efficient formula that I can copy to about 1000 rows.
The formula calculates the chances of reaching 60 years old based on the person's current age, using the following table (1st column is age, 2nd column is probability):
<30 20%
30-39 15%
40-44 10%
45-49...
Hi,
Is there anyone who can help me figure out the probability of each number on the different A-B-C so that it will be like the answer to the right.
Preferably with VBA.
<colgroup><col span="5"><col span="3"><col><col><col span="3"></colgroup><tbody>
Match
%
%
%
Probability % A...
If a company owns 15 locations across the country. They want to add new systems in each locations. Some locations require more than 1 system. Some of these locations are located in the South, NE, W and Midwest. the systems installed are as below:
South - 10 systems
NE- 1 systems
West - 5...
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.