Home
Forums
New Posts
Illini Basketball
Illini Football
Sports Talk
Log in
Register
What's new
Menu
Log in
Register
Install the app
Install
Forums
Sports
Illini Basketball
Big Ten Forecasting & Stats
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="danielb927" data-source="post: 1565616" data-attributes="member: 3372"><p>Cool stuff [USER=747212]@Goode-for-3[/USER] -- nice work!</p><p></p><p>I think ROUND(1.2 * RAND(), 0) will actually give you something a bit lower than a 60% shooter. The inner value rounds to 0 for [0, 0.5] and 1 for [0.5, 1.2]. This means the made FT percentage is (1.2 - 0.5) / 1.2, or 7/12, which is 58.3%. Probably won't change the outcome a ton but I'd be interested to see how much it does.</p><p></p><p>You could instead do IF( RAND() < 0.6, 1, 0), and change the 0.6 to refer to a cell if you want to update the FT% on the fly quickly. Just an idea!</p><p></p><p>Even with the slight difference, the result seems pretty reasonable -- the odds of making 28 in a random 32 are 0.07%, while the simulation shows that over the course of ~5x that many shots, your odds would go up by something like 4x. Very cool!</p></blockquote><p></p>
[QUOTE="danielb927, post: 1565616, member: 3372"] Cool stuff [USER=747212]@Goode-for-3[/USER] -- nice work! I think ROUND(1.2 * RAND(), 0) will actually give you something a bit lower than a 60% shooter. The inner value rounds to 0 for [0, 0.5] and 1 for [0.5, 1.2]. This means the made FT percentage is (1.2 - 0.5) / 1.2, or 7/12, which is 58.3%. Probably won't change the outcome a ton but I'd be interested to see how much it does. You could instead do IF( RAND() < 0.6, 1, 0), and change the 0.6 to refer to a cell if you want to update the FT% on the fly quickly. Just an idea! Even with the slight difference, the result seems pretty reasonable -- the odds of making 28 in a random 32 are 0.07%, while the simulation shows that over the course of ~5x that many shots, your odds would go up by something like 4x. Very cool! [/QUOTE]
Verification
Post reply
Forums
Sports
Illini Basketball
Big Ten Forecasting & Stats
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…