Question

I have a web application that prompts users to answer a question when the computer they are using is not recognized. A user complained today saying she is always prompted for the same question. I explained to her that the pool of questions was only 3, so the likelihood of her being prompted for the same question was high, can some of you guru's tell me what the exact probability is?

We have the questions the user has set up (3 questions) stored in a database. When choosing which question to display, the developer who initially wrote the code invokes the TSQL NewID() method which gives him three unique identifiers, he sorts these random guids in ascending order and returns the first question associated with the top most guid.

Is it possible for me to provide the probability of to this person of her question being repeated constantly? She said she has been prompted for the same challenge question 12 times in a row. I just want to prove it mathematically.

Answer 1

Call your three questions A, B, C.

The probability that A gets chosen twelve times in a row is 1/(3^12), or 1 in 531441; similarly for B and C.

The probability that some question gets chosen twelve times in a row is thus 3/(3^12), or 1/(3^11), or 1 in 177147.

Personally, I think this seems like low enough a probability that if you knew for sure it actually happened, I'd be suspicious that your code isn't doing what you think it does. But it's also possible that your user really didn't get this question 12 times in a row and is just misremembering.

Answer 2

I agree with Michael's answr with one reservation. If you application has many users (say a million) there is a very strong chance that at least one of them would see what you describe - even with no bug :)