PDA

View Full Version : Confidence interval upper and lower limit plots


EliteNinja
12-31-2004, 07:41 PM
Anyone have the link to that post where there's an excel chart which plotted BB won vs. Time (or hands played) which had extrapolated 66%, 95% and 99% Confidence Interval upper and lower limits on it?

I wanna make one of those charts.

uuDevil
01-03-2005, 01:28 AM
Link, I think (http://forumserver.twoplustwo.com/showflat.php?Cat=&Board=micro&Number=1213573&Forum =All_Forums&Words=graph&Searchpage=0&Limit=25&Main =1213573&Search=true&where=bodysub&Name=12155&date range=1&newerval=1&newertype=y&olderval=&oldertype =&bodyprev=#Post1213573)

EliteNinja
01-03-2005, 01:48 AM
Thanks!
Could I get a copy of your spreadsheet?

uuDevil
01-03-2005, 02:49 PM
[ QUOTE ]
Could I get a copy of your spreadsheet?

[/ QUOTE ]
Well, I don't have one set up for this specific purpose. If you are very new to spreadsheets, you can get a pretty good idea of how to set one up yourself by looking at

Homer's Streaks Thread (http://forumserver.twoplustwo.com/favlinker.php?Cat=&Entry=9092&F_Board=smallholdem& Thread=445039&partnumber=&postmarker=)

He is doing something different here, so your sheet will have different formulas. You will also be adding series for the confidence intervals. Homer shows how to do the confidence interval calculations in this thread. (http://forumserver.twoplustwo.com/showthreaded.php?Cat=&Number=1342415&page=&view=&s b=5&o=&vc=1)

There is some work involved, but it should be worth it.