Statistical Proof/Debunking of Peak Hours Advantage- RE:'s Needed

[samr]

EST

Time #T Top 3 ROI
Forenoon 295 41.4% 13.8%
Afternoon 333 42.0% 19.9%
Dinner 128 43.8% 19.5%
Evening 6 33.3% -30.6%

Interesting results.

[shejk]

There is something very weird with the results my spreadsheet presents:

Time #T Top 3 ROI

Night 145 37.2% 22.9%
Morning 38 34.2% #DIVISION/0!
Forenoon 22 40.9% #DIVISION/0!
Afternoon 122 27.0% -63.0%
Dinner 168 43.5% 547.3%
Evening 143 41.3% 288.2%

I'm guessing my crazy rois has something to do with me having played at four different limits, anyone know how I can get my true numbers?

btw, this is GMT+1 (CET).

[Newt_Buggs]

If I had my stats on this computer then I would contribute my 1,500 $55s, oh well.

[Slim Pickens]

There were problems with earlier versions of the spreadsheet, specifically with the time and day splits. I fixed those in the later versions, and they seem to work fine now. If you look on the "readMe" tab, it should say "last modified by [username]." If [username] isn't me, dfscot or astarck (I don't know if he changed this) then you need to get a newer version of the spreadsheet from http://mowrmowr.com/poker. I use 2.4 (in it's folder). Astarck added a daily summary tab that takes a little more computer power in version 2.5. Anyway, try getting a modern version, cut-and-paste your stats (check the User Guide for some important details) and see if that fixes your funky splits.

SlimP

[shejk]

Oops, I don't even have a readme-tab.

Thanks a bunch, I'll just dl a new one and try again.

[Slim Pickens]

OK. I figured out how to modify the spreadsheet lookup tab to change your time zone. It's a little bit complicated so back up the Christ out of you spreadsheet before you do this.

1) Back up your file. That's not just a figure of speech.

2) You will have to insert extra rows into the lookup table at the top of the "Lookup" tab. That's now the cells in rows 1 through 6, columns A, B, and C. The rows must be inserted using Insert>Rows command rather than just tacking them onto to bottom because there are a lot of cells in other tabs that will not automatically update to include your new row if it's just added to the bottom. Click on cell A2 and slecet Insert>Rows. A blank row should appear in the middle of the table.

3) Put new time values in the table. Column A is the "begin" time, column B is the "end" time, and column C is the letter corresponding to that time period. For historical reasons, the letters mean this:

N: night = 12AM-4AM
M: morning = 4AM-8AM
F: forenoon = 8AM-12PM
A: afternoon = 12PM-4PM
D: dinner = 4PM-8PM
E: evening = 8PM-12AM

Here's the tricky part. For this experiment, you need to adjust these times to correspond with some standard time zone, say Eastern. As an example, my spreadsheet entries are all in Pacific time. I need to correct all the time periods by making the borders three hours earlier, so my adjusted periods need to mean this:

N: night = 9PM-1AM
M: morning = 1AM-5AM
F: forenoon = 5AM-9AM
A: afternoon = 9AM-1PM
D: dinner = 1PM-5PM
E: evening = 5PM-9PM

The problem is that the chart won't wrap around for that 9PM-1AM block, so it has to be entered in two separate lines. That's why you needed the extra line. In addition, the lines must be in chronological order starting at 12AM, so my final lookup table has to look like this:

Column A / B / C (rows 1 through 7)
12:00 AM / 1:00 AM / N
1:00 AM / 5:00 AM / M
5:00 AM / 9:00 AM / F
9:00 AM / 1:00 PM / A
1:00 PM / 5:00 PM / D
5:00 PM / 9:00 PM / E
9:00 PM / 12:00 AM / N

I hope this works for anyone who's interested. PM or post if it doesn't make sense.

[Slim Pickens]

All times Eastern now.

night: 198, 37.9%, 20.5%
morning: 7, 42.9%, 1.0%
forenoon: 4, 25.0%, -54.5%
afternoon: 132, 34.1%, 11.6%
dinner: 340, 39.4%, 16.0%
evening: 413, 39.0%, 15.1%

[Myst]

Haha, Jess, if you wanted my extensive data, you just had to ask :P

Total Tournaments: 3051

Time #T Top 3 ROI

Night 482 36.7% 7.4%
Morning 317 35.6% 6.7%
Forenoon 131 38.2% 0.8%
Aftrnoon 594 35.2% 3.2%
Dinner 700 36.9% 10.1%
Evening 815 37.7% 13.0%

My highest ROI is at Dinner and Evening, but then again, my sample size is alot higher for both.

[Messy_Jesse]

So far, there are only about 6000 SNGS. I really think that a few more thousand would help out a lot. I know that there are more than 7 people on this forum, and Id appreciate it if youd help contribute your stats. Especially the players who play for a living and could contribute a few thousand. PM your stats if you want, or whatever, but please help out.

-Jess

EDIT: This post has 550 views, and 12 replies. COME ON!!!!

These are for the 11s -

72 37.50% 21.21%
0 #DIV/0! #DIV/0!
15 46.67% 63.64%
22 59.09% 90.08%
0 #DIV/0! #DIV/0!
46 30.43% -11.07%

sorry about the missing ones