|
|
#41
04-10-2005, 10:59 PM
|
|||
|
|||
Re: \"How many hands do I need to play...\"
ok, i must be computer illerate. once I have the numbers plugged in, how do i get excel to perform the operation? (for someone whos uses comps as much as I do i cant believe i can not find out how, lol)
|
|
#42
04-28-2005, 08:45 AM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
[ QUOTE ]
ev - normsinv[(1-c)/2]*sd*[1/sqrt(n)] l = ev + normsinv[(1-c)/2]*sd*[1/sqrt(n)] [/ QUOTE ] I'm trying to crunch these numbers. Can someone tell me what "normsinv" is?
|
|
#43
04-28-2005, 09:05 AM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
[ QUOTE ]
I'm trying to crunch these numbers. Can someone tell me what "normsinv" is? [/ QUOTE ] An Excel statistic function fully explained in the help section of said program.
|
|
#44
04-28-2005, 09:12 AM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
[ QUOTE ]
[ QUOTE ] I'm trying to crunch these numbers. Can someone tell me what "normsinv" is? [/ QUOTE ] An Excel statistic function fully explained in the help section of said program. [/ QUOTE ] So I guess I can't do this with my calculator???
|
|
#45
04-28-2005, 09:26 AM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
[ QUOTE ]
[ QUOTE ] [ QUOTE ] I'm trying to crunch these numbers. Can someone tell me what "normsinv" is? [/ QUOTE ] An Excel statistic function fully explained in the help section of said program. [/ QUOTE ] So I guess I can't do this with my calculator??? [/ QUOTE ] Nope. But you could go look it up in a z-score table. If your confidence interval is 95%, you take (1-0.95)/2, or 0.025, subtract it from 1 to get .975, and then look for .975 in the table. In this case, it is 1.96.
|
|
#46
04-28-2005, 09:46 AM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
I'm not sure if this is new (don't remember seeing it before) but PT also offers SD/100 hands. So would this equation work as well?
BB/100 hands +/- NORMSINV((1-confidence)/2) * SD/100 * 1/SQRT(hands/100)
|
|
#47
04-28-2005, 01:22 PM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
A monkey in the zoo thanks YOU! for this thread.
|
|
#49
05-26-2005, 12:47 PM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
btw, I uploaded the spreadsheet to an htm. http://e.sixbit.org/howmanyhands.htm
according to my numbers at $1/2: hours (PT) 7.38 wr/hr (PT) in $ 12.33 sd/hr (PT) in $ 14.1601 confidence (PT) 0.95 I'm 95% confident that my wr is between $22.54612576/hr and $2.113874238/hr. That doesn't seem right with such a small sample. Is it?
|
|
#50
07-19-2005, 09:49 PM
|
|||
|
|||
|
Re: \"How many hands do I need to play...\"
I think that is because your SD is no where near accurate after 7 hours. You have been running well with a low SD so far. Your SD will probably rise.
|
 |
|
|
Linear Mode
