作者查詢 / Putrid

總覽項目：發文 | 留言 | 暱稱

作者 Putrid 在 PTT [ Office ] 看板的留言(推文), 共13則

限定看板：Office

看板排序：

全部Steam2140Gossiping1616DIABLO1325Little-Games400NBA371LoL173Baseball114C_Chat65Hearthstone50joke50NBA_Film49PC_Shopping48medstudent45PuzzleDragon38mobile-game34ToS33sex27BraveFrontie25Old-Games24Japan_Travel20PushDoll20TaichungBun18GTA17LCD17StrikeShoot14Office13swim13Beauty12SLG11Lakers10Boy-Girl9PokemonGO9TheSims9NBAGAME8Tech_Job6Wargaming6basketballTW5CMU_Talk5Eng-Class5HatePolitics5MLB5PokeMon5CMWang4iOS4Magic4NBAEasyChat4PublicIssue4RayAllen4Sub_GConsole4UTAH-JAZZ4Windows4YOLO4BB_Online3Brand3car3Crusaders3Employee3G-S-WARRIORS3japanavgirls3JP_Entertain3KS94-3203NY-Yankees3StupidClown3Tainan3Tobacco3Badminton2BoardGame2Celtics2Childhood2FantaTennis2FuMouDiscuss2gallantry2Kings2KS98-3022L_TalkandCha2LeBronJames2MobilePay2ncyu_phyedu2Olympics_ISG2OverWatch2RealPlaying2Singapore2sky2TTOA2TWICE2About_Life1Anti-ramp1AskBoard1Baseball_BM1BlizzHeroes1CareerPlan1Cavaliers1chi1ChineseMed1ck56th3321ck59th3061CMU_CM421CourtBasebal1CVS1CY-SPORT1DummyHistory1E-appliance1e-shopping1Ecophilia1FCU_Talk1FishShrimp1FLAT_CLUB1FollowWind1graduate1HardwareSale1hjsh1HSNU_10021HSNU_9901HSNU_J1231hypermall1Jteam1kawaii1KevinGarnett1Key_Mou_Pad1Koei1KOF1KOTDFansClub1KS92-3071L_BoyMeetsGi1L_SecretGard1Linux1LTK1M171Mavericks1media-chaos1MusicStudent1NBA_Fantasy1NCHUS1NCU92Physics1NCYU_Fst_981NSwitch1NTPU-STAT941NTUE-TGD971NTUEE_Lab5541NTUmed911NTUST-EE-B931NTUT_EE490A1PACERS1Physics1popmusic1prozac1RESIT1RPGMaker1Salary1SHORTY1Shu-Lin1ShuangHe1SHUTA1Softball1SongShan1SP1_Baseball1SP2_Baseball1specialman1Storage_Zone1studyabroad1studyteacher1SurvivalGame1SYSOP1Teacher1Tennis1TFG01KONG1TKU_EW94B1TTU-AMath1TY_Research1Warfare1XT1YH33rd3191YoungDotx31YZU_CN99A1<< 收起看板(174)

首頁

上一頁

1

下一頁

尾頁

Re: [算表] EXCEL:給定平均求亂數(整數)

[ Office ]5 留言, 推噓總分: +1

作者: Putrid - 發表於 2008/05/15 05:26(17年前)

2^F→Putrid:我發現錯了只有在c=2.5、3、3.5才會機率不平等06/26 17:37

3^F→Putrid:而這樣的解法無法解決C=3時的問題 A值還是會1/4 1/2 1/406/26 17:38

[算表] EXCEL:給定平均求亂數(整數)

[ Office ]3 留言, 推噓總分: +1

作者: JieJuen - 發表於 2008/05/14 00:33(17年前)

1^F→Putrid:A1=ROUND(C1+RAND()*(ABS(ABS(3-C1)-2)),0)05/13 02:30

2^F→Putrid:B1=C1*2-A105/13 02:30

3^F→Putrid:有人可以幫我檢驗這樣ok嗎05/13 02:31

4^F→Putrid:這樣的話是設定a取較大的值05/13 02:33

5^F→Putrid:我發現錯了只有在c=2.5、3、3.5才會機率不平等06/26 17:37

6^F→Putrid:而這樣的解法無法解決C=3時的問題 A值還是會1/4 1/2 1/406/26 17:38

8^F推Putrid:感謝 :D05/14 13:03

[請問] EXCEL高手

[ Office ]7 留言, 推噓總分: +1

作者: fongliao - 發表於 2008/05/13 00:40(17年前)

3^F→Putrid:A1=ROUND(C1+RAND()*(ABS(ABS(3-C1)-2)),0)05/13 02:30

4^F→Putrid:B1=C1*2-A105/13 02:30

5^F→Putrid:有人可以幫我檢驗這樣ok嗎05/13 02:31

6^F→Putrid:這樣的話是設定a取較大的值05/13 02:33

首頁

上一頁

1

下一頁

尾頁