probability

Hello, I was recommended to this forum by a friend who spoke very highly of it, so I hope I've landed in the right place! I am looking to put together an excel sheet to predict the scores, win probability and cover probability of american football. I would like to do this for other sports as...

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

<colgroup><col><col span="6"></colgroup><tbody> 1.1 The average number of deer seen per hour 3.6. Calculate the probability of observing 0, 1, 2, …. 10+ below Number of Deer Seen 1 2 3 4 5 6 7 8 9 10+ How would i solve this on excel? </tbody>

What I am looking for is impossible permutation combination I have been on this for sometime and cant seems to wrap a Excel vba around it. here goes. I have 5 columns each have a list of names( max limit of names per column is 50) First column a list of fruits Second column a list of...

Hi, I can calculate the probability of the mean occurring using the NORM.DIST function, ie 50% probability of being the mean, 28% probability of being the mean +1,etc. What I need to get though is what mean value (mean +1, mean +1.1 etc) is for a given probability %. For example at...

Hi, I have the following formula working out a random Yes / No based on some probability. In B23 I have the following code (it sits in a table) =IF(A23="","",INDEX($A$2:$A$3,COUNTIF($C$2:$C$3,"<="&RAND())+1)) However as more data gets added below A23, it recalculates. What I'm looking for...

Hi everyone, total noob here. I hope don't miss anything, in that case i apologize. I have this task: assign a random probability to a table of items. For example: i have a table composed by 10 elements Item 1 Item 2 Item 3 Item 4 .. Item 10 To each one i should assign a probability, aka, a...

There are 3 balls in a bag, one red, two blue. Therefore, there is a 33.33% (Cell A1) chance of picking the red ball, and a 66.66% (Cell A2) of picking a blue ball. Would there be a formula to calculate the probability in a 'Best of X' race? So for instance, what would be the probability of...

Hi All, I am looking for assistance for a mathematical formula to be able to turn my assessed win betting prices (win %) into place betting probabilities. The below should explain the equation a little further. <tbody> W% 2nd % 3rd % Horse 1 35 Horse 2 15 Horse 3 13 Horse 4 10...

I am looking for a VBA led output for 2nd, 3rd, 4th, etc, (Generalization to digits beyond the first). The refrence link is : Benford's law - Wikipedia Essentially the formula to code is below the text "And the probability that d (d = 0, 1, ..., 9) is encountered as the n-th (n > 1) digit is"...

<colgroup><col><col><col span="22"></colgroup><tbody> Hi, Need your help in obtaining the last updated cell in excel. Here I am grading salesman over 3 - 7 weeks (only 3 weeks shown here). Can we work out a formula that will give me result of the last updated week. I have given the expected...

Hi Guys I am trying and struggling to create a nested IF statement for risk assessment that works this way: The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low...

Hi everyone, I have written a code for Monty Hall problem from scratch. I really didn't read anybody else's because it was making everything more confusing. Results are correct. If you switch you win more; however, my code seems a little redundant. I am trying to shorten it and if you are...

First of I'm not sure if this is the place for such a question I have a set of 8 Players (could be any number from 2 players to 8 players in the group) I would like an excel formula to workout the percentage chance of each player to score the most points. I have managed to workout on Excel...

Here is what i have and have wrote these formulas all the way to the 9th horse winning. Yea 3078 combinations and don't look forward to doing the remaining combinations. I'm Hoping someone could help me by sharing some code that would calculate this for me without writing another 3762 formulas...

Good day any help I can attain will be awesome. Issue: Based on two cells I would like to know the probability that the next input will meet the desired result. Example Months Yield (The expected yield in 5months is 10%) 5 10% 1 3% (The current...

Hi Everyone, I hope you can help me in this problem. I have a set of observed data and created an empirical cumulative distribution using excel. I want to use this CDF to find probabilities like P(x<X) or P(X1 < x < X2 ). The way I created the CDF is arrange the data in ascending order and...

Hello, I hope you can all bare with me as I do not know the proper statistical terms. Goal: I have 30% of my data (both numerical and text). How can I use statistics (probability) to estimate the remaining data? Info: The table below is a simple example of my real data set. Instead of 9...

I'm curious if there are any modern solutions related to creating a probability scale in Excel? Peltier provides a solution that has been around for quite some time (Simulated Probability Chart Example). With the changes in Excel that have been made, are there any other solutions out there that...

Hi, could you please help me with a function that returns 0 70% of the time and 1 30% of the time?