I updated the modeling method. Now I simulate this problem with Monte Carlo. Link is still the same.
Comments on variables are welcomed!
[size=10pt]Current prediction is once the score is below 600, it takes about 10 months to go under 400. Good luck, guys~[/size]
Avg score # of draw min. score 1st draw here is in real the 5th or 6th draw.
380.7073 1.0000 454.6283
378.6770 2.0000 444.0503
376.8362 3.0000 436.6292
375.1845 4.0000 430.8353
373.5203 5.0000 426.2554
371.9667 6.0000 422.0814
370.4656 7.0000 418.4424
368.9880 8.0000 415.0694
367.5321 9.0000 412.0687
366.1085 10.0000 409.1746
364.6911 11.0000 406.5423
363.3290 12.0000 404.0040
361.9846 13.0000 401.6431
360.6232 14.0000 399.4153
359.3356 15.0000 397.2657
I am trying to post a google-doc l-----ink.....but not allowed to...
@ docs.google.com/spreadsheets/d/1o2LU_lsYEykl1UMOkiZF78ds0Q1XTJS1TdfUh8qaA8M/edit?usp=sharing @
The above is its google doc l---ink.
please leave comments so that I can perfect the model and make it close to real.
Data sources are that google spread sheet online[you all know that
].
I have not built a good enough model yet, considering in my model, the # of ppl in the pool will be 0 after a certain time period.
But I can always adjust it, based on your suggestions!
Thanks
Have fun...