tag:blogger.com,1999:blog-6677554266716906155.post830410186590922605..comments2010-01-20T15:38:58.211-08:00Comments on We're Not Really Nerds, We Swear: We MAY not be nerds...Taranhttp://www.blogger.com/profile/10621378833811799287noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6677554266716906155.post-48752461911990440722008-08-26T10:29:00.000-07:002008-08-26T10:29:00.000-07:00You are NERDS.You are NERDS.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6677554266716906155.post-1203738339853345062008-08-23T02:35:00.000-07:002008-08-23T02:35:00.000-07:00Yeah, somewhat...I didn't feel like doing the stat...Yeah, somewhat...I didn't feel like doing the stat analysis so I just gave you the raw data. I figure I used a large enough sample that the real curve won't be far off from that.Taranhttps://www.blogger.com/profile/10621378833811799287noreply@blogger.comtag:blogger.com,1999:blog-6677554266716906155.post-71865600762755921042008-08-22T17:07:00.000-07:002008-08-22T17:07:00.000-07:00i don't totally understand how distribution relate...i don't totally understand how distribution relates to probability... isn't the distribution likely to be somewhat different on every 65k group?Lord Bolthttps://www.blogger.com/profile/00184600007061498559noreply@blogger.comtag:blogger.com,1999:blog-6677554266716906155.post-68671705269632543342008-08-22T16:49:00.000-07:002008-08-22T16:49:00.000-07:00Update: Angela's chance of rolling a 67 (total of ...Update: Angela's chance of rolling a 67 (total of all 6 die rolls) or less: 19.45%.<BR/><BR/>Bethany's chance of rolling an 81 or higher: 15.59%. The rest of us were between those.<BR/><BR/>This was obviously much less statistically significant, since I only had 11,000 mutually exclusive random groups of 6 rolls to work with, but the most common total was 75 at 5.81%.Taranhttps://www.blogger.com/profile/10621378833811799287noreply@blogger.comtag:blogger.com,1999:blog-6677554266716906155.post-81746541342546249502008-08-22T16:05:00.000-07:002008-08-22T16:05:00.000-07:00John, if you're interested on how to do this in ex...John, if you're interested on how to do this in excel:<BR/><BR/>Do 4 columns of rand() functions down to the bottom of the sheet. Copy and paste special values once all the functions are there.<BR/><BR/>Then do 4 columns to the right using the function =roundup(A1*6,0), where A1 is the first random value entry. Copy that all the way down. Lets assume you used columns E:H for this.<BR/><BR/>Then to the right of that use the function =small(E1:H1,1) which returns the smallest value in your group of four rolls.<BR/><BR/>Then to the right of that do a sum of the four rolls less the smallest value, and you've got yourself a gigantic list of 4d6 rolls where you keep the top 3.Taranhttps://www.blogger.com/profile/10621378833811799287noreply@blogger.comtag:blogger.com,1999:blog-6677554266716906155.post-41243281924360782012008-08-22T16:00:00.000-07:002008-08-22T16:00:00.000-07:00Actually, I have. I ran a bunch of random dice ro...Actually, I have. I ran a bunch of random dice rolls in excel. I ran roughly 130,000 groups (actually 2 65k groups) of 4 random rolls, summed them and subtracted the lowest number. I got an average of 12.251. Seems like that's statistically significant enough to call 12.25 the average. But the distribution said differently. Here was the distribution on the second group of 65k:<BR/><BR/>3 - 0.06%<BR/>4 - 0.28<BR/>5 - 0.71<BR/>6 - 1.63<BR/>7 - 3.03<BR/>8 - 4.85<BR/>9 - 6.98<BR/>10 - 9.29<BR/>11 - 11.43<BR/>12 - 12.77<BR/>13 - 13.53<BR/>14 - 12.33<BR/>15 - 10.16<BR/>16 - 7.17<BR/>17 - 4.10<BR/>18 - 1.66 <BR/><BR/>You actually have a better chance to get a 13 than a 12. The bell curve is shifted to the right and is much steeper on the right side as well. I haven't crunched any of the stats on this (like, what were the chances of Angela rolling as low as she did), but I have the data.Taranhttps://www.blogger.com/profile/10621378833811799287noreply@blogger.com