Spreadsheet: 213698d1360614408-probability-of-winning-the-game-with-multiple-variables-copy-of-probabilty-analyser
Sheet: Calculations

Number of Questions Per Day |  | 1 |  | [NAME] | Number of Qs to be asked per day to players
Number of Days to Play the Game |  | 365 |  | [NAME] | Number of days the game will be played or number of days the results to be analysed
Number of Players |  | 100000 |  | [NAME] | Total Number of Players
Number of Answer Choices |  | 3 |  | [NAME] | Total Number of Choices for each question
Number of Correct Answer |  | 1 |  | [NAME] | Number of correct answers from available choices
Number of Correct Answers to Win |  | 10 |  | [NAME] | Total number of correct answers required to win the game and to reset the game
Number of Wrong Answers in a row to [NAME] |  | 3 |  | [NAME] | Number of consecutive wrong answers to reset players correct answers
Number of Correct Answers in a row to [NAME] |  | 5 |  | [NAME] | Number of consecutive correct answers to win a prize during the game
Each answer choice has the same probability of being correct |  | Fixed
Probabilty of a Correct Answer for Each Question |  | 0.3333333333333333 |  | 1/Number of choices | Calculation of the probabilty of a correct answer
Probabilty of a Wrong Answer for Each Question |  | 0.6666666666666666 |  | 1/(Number of Choices - Number of Correct Answer) | Calculation of the probabilty of a wrong answer
Probabilty of Correct Answer 5 Times in a Row |  | 0.004115226337448559 |  | C12 to the power of C8 | Calculation of the probabilty of 5 consecutive correct answer
Probabilty of Correct Answer 10 Times in a Row |  | 1.693508780843028e-05 |  | C12 to the power of C6 | Calculation of the probabilty of 10 consecutive correct answer
Probabilty of Wrong Answer 3 Times in a Row |  | 0.2962962962962963 |  | C13 to the power of C7 | Calculation of the probabilty of 3 consecutive wrong answer
Probabilty of Correct Answer 5 Times in a Row within 365 days - Times |  | 1.502057613168724 |  | Number of days x number of questions per day x C15 | Number of times a player can answer 5 consecutive questions correctly within 365 days
Probabilty of Correct Answer 10 Times in a Row within 365 days - Times |  | 0.006181307050077053 |  | Number of days x number of questions per day x C16 | Number of times a player can answer 10 consecutive questions correctly within 365 days
[NAME] by a Player within 365 days without reset rule |  | 12.16666666666667 |  | (Number of days x number of questions per day) x C12/Number of correct answers to win | [NAME] number of wins by any player by answering 10 questions correctly within 365 days - ignoring reset rule for 3 consecutive wrong answer
[NAME] by a Player within 365 days with reset rule |  | 8.561728395061728 |  | C22 - (C22 X C17) | [NAME] number of wins by any player by answering 10 questions correctly within 365 days - including reset rule for 3 consecutive wrong answer
Possible Number of Wins out of 100000 Players within 365 days with reset rule |  | 8.561699855967078 |  | C23 x (1-C17 / Number of players) | Possible number of wins by answering 10 questions correctly within 365 days taking into account the number of players - including reset rule for 3 consecutive wrong answer
Possible Number of Wins out of 100000 Players within 365 days |  | 8.567881163017155 |  | [NAME] | Possible number of wins by answering 10 questions correctly within 365 days taking into account the number of players and a possibilty of a player answering 10 consecutive questions correctly - including reset rule for 3 consecutive wrong answer
Possible Number of 5 consecutive Correct Answers with [NAME] after any 10 Correct Answer |  | 0.1753126105030825 |  | C15*(Number of days/C25) | Number of times a player can answer 5 consecutive questions correctly within 365 days taking into account the reset rule after a player wins the game after answering any 10 questions correctly