Reply to thread

Message: [QUOTE="Four Dogs, post: 839659, member: 2668"] Thank you Jurn. I'm not really doing anything but compiling the data that you all are supplying. The formula for the expected frequency of AA, or any pair for that matter, is simple. There are 1326 different combinations of starting hands and 6 different ways to make any one pair, so 1326 [SIZE=5][SIZE=2]÷ 6 = 221. Which is to say 1 out of every 221 hands is AA specifically, or KK, or whatever pair you're looking for. So to find the expected number of times AA would be dealt is simply a matter of dividing the number of hands you've played by the magic number, 221. We then compair that number to the actual times that our contributer was dealt that hand. The difference between the expected value and the reported value is the deviation. The smaller the deviation, the better. [/SIZE][/SIZE] I put the whole thing together on an excel spreadsheet. It has 2 sheets. Sheet 2 is the ugly, raw data, page with all the names, dates and numbers. Sheet 1 is the one you see above with the different site graphics and pretty colors. I just use the snipping tool that comes with Windows Vista to highlight the portion of the table that I want to publish and save it as a JPEG then just attach the image to the post (see manage attachments below). When someone makes a new contribution I can usually update the table in less than 3 or 4 minutes. It takes a little longer when someone adds data from a new site as I have to add a new column on my raw data worksheet, then hunt around for a suitable image which I must then resize to fit on the published table. [SIZE=5][SIZE=2][/SIZE][/SIZE] [/QUOTE]

Verification

Search

Reply to thread

About CardsChat

Our Community

Our Site

Follow us