JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,676
- Office Version
- 365
- Platform
- Windows
I'm not sure of the correct terminology for explaining my question, so please bear with me.
Suppose I have a random event with a binary outcome (win/lose) and I have a set of data showing how many times win streaks of various lengths occurred. Here's the data for 668 "games".
The 0-win streak occurred 59 times, the 1-win streak 36 times, etc. The third line is the expected number of times each streak should have occurred based on the total number of games played (668) and wins (479) yielding a winning % of 71.7%.
I would like to calculate a 4th line showing the probability of each tally given the total number of games played and the current win%. For example, what are the odds that there would be 59 0-win streaks, 36 1-win streaks, 30 2-win streaks, etc.?
In the data above, the 1-win streak is 2.2 occurrences short and the 3-win streak is 2.1 occurrences short. These are almost equal in the absolute differences, but I would think that the probability for the 1-win streak based on 36 occurrences would be greater, possibly much greater, than for the 3-win streak with half as many occurrences. I would think that the variability would be inversely proportional to the number of occurrences. I would like to find a way to quantify that so I can determine the likelihood of each tally.
Can someone help me with the correct formula? I think it has something to do with normal distributions and the distance from the mean, but my statistics skills are not up to the task.
Thanks...
Suppose I have a random event with a binary outcome (win/lose) and I have a set of data showing how many times win streaks of various lengths occurred. Here's the data for 668 "games".
Code:
[FONT=courier new] #Wins 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Tally 59 36 30 18 12 4 7 4 5 6 2 0 3 1 2
Exp 53.5 38.3 27.5 19.7 14.1 10.1 7.3 5.2 3.7 2.7 1.9 1.4 1.0 0.7 0.5
[/FONT]
I would like to calculate a 4th line showing the probability of each tally given the total number of games played and the current win%. For example, what are the odds that there would be 59 0-win streaks, 36 1-win streaks, 30 2-win streaks, etc.?
In the data above, the 1-win streak is 2.2 occurrences short and the 3-win streak is 2.1 occurrences short. These are almost equal in the absolute differences, but I would think that the probability for the 1-win streak based on 36 occurrences would be greater, possibly much greater, than for the 3-win streak with half as many occurrences. I would think that the variability would be inversely proportional to the number of occurrences. I would like to find a way to quantify that so I can determine the likelihood of each tally.
Can someone help me with the correct formula? I think it has something to do with normal distributions and the distance from the mean, but my statistics skills are not up to the task.
Thanks...
Last edited: