ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý]¦h¶µ¦¡­¼¿n©Mªº¤½¦¡¼gªk¡Ci=1~1025¡A£U(P^i)*(1-P)^i

[µo°Ý]¦h¶µ¦¡­¼¿n©Mªº¤½¦¡¼gªk¡Ci=1~1025¡A£U(P^i)*(1-P)^i

¦h¶µ¦¡­¼¿n©Mªº¤½¦¡¼gªk¡Ci=1~1025¡A£U(P^i)*(1-P)^i

©Ò¨D
¿é¥X¯x°}¡G­n°µ¥X¿é¤J p & i§Y¥i±o¨ì¼Æ¦r¡C­n¦p¦ó¼g¤½¦¡¡C

½d¨Ò
-6¦¸¤è¥Ü¨Ò¡G¬O¤@¨B¨Bªº°µ¦¨ªº¥[Á`¡A±o¨ìªº¼Æ¦r¬O0.524263

¦h¶µ¦¡­¼¿n©M.zip (42.44 KB)

¦^´_ 1# Baracuda
µLªk¤U¸üÀɮסA¥i§_´y­z¤@¤U­ì©ldata»P¹ïÀ³µ²ªG¦ì©óÀx¦s®æ¤§ª¬ªp¡A©ÎºI¨úµe­±¥H¨Ñ§@¾Ç²ß°Ñ¦Ò¡H

TOP

¦^´_ 1# Baracuda

B2=SUMPRODUCT(B$1*(B$1-1)/2*$A2^ROW(INDIRECT("A1:A"&B$1)),(1-$A2)^(B$1-ROW(INDIRECT("A1:A"&B$1))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

B1027=COMBIN(1025,C1027)
D1027=$A$3^C1027
E1027=(1-$A$3)^(1025-C1027)

Multi.png (11.21 KB)

Multi.png

TOP

Hsieh ª©¥D¡AÁÂÁ¡C³o­Ó¥i¥H Work¡C
«á¨Ó¦³§ï¦¨¦h¶µ¦¡­¼¿n¡C

TOP

µo²{ N ¤£¯à¤Ó¤£¡A¤£µM·|¦³ Num¿ù»~°T®§¡C

¤½¦¡¤Óªø¡A¤£¯à¶W¹L81892­Ó¦r¤¸¡C
i=1~1025¡A£U1025Ci*(P^i)*(1-P)^i
1025Ci¬O«ü¤½¦¡Combin(1025,i)

ÁÂÁª©¥D¡C
¤½¦¡©|¦b¬ã¨s¤¤¡C

000000.png (21.61 KB)

¿ù»~°T®§

000000.png

¦h¶µ¦¡­¼¿n©M.zip (99.12 KB)

¤G¶µ®i¶}¦¡

TOP

¦^´_ 6# Baracuda
§Ú¨S²z¸Ñ¿ùªº¸Ü , §A¯u¥¿­nªº¤½¦¡¬O¤£¬O
k=1025
¨Ï¥ÎªÌ¿é¤JP®É , ¨D i=1~k¡A£UCombin(k,i)*(P^i)*(1-P)^(k-i) ªº­È?

­Y¬Oªº¸Ü , ¤W¦¡¤Sµ¥¦P©ó
(1-P)^k*£UCombin(k,i)*(P/(1-P))^i     ,  (i=1~k)
°²³]¨Ï¥ÎªÌ¦bA1¦ì¸m¿é¤JP , ¦bB1¿é¤Jk
C1¨D¨ä­È¥i¼g°µ  =POWER(1-A1,B1)*SERIESSUM(A1/(1-A1),1,1,COMBIN(B1,ROW(INDIRECT("A1:A"&B1))))
·íµMB1ª½±µ´«±`¼Æ¤]¥i¥H

¥HA1=1E-6, B1 = 1025¬°¨Ò , ¸Ó¦¡ºâ¥Xµª®×¬°0.001023951

TOP

¦^´_ 7# stillfish00
§ó¥¿¤@¤U­n¥Î ctrl+shift+enter  ¼Æ²Õ¤½¦¡
A1=1E-6, B1 = 1025¬°¨Ò , ¸Ó¦¡ºâ¥Xµª®×¬°0.001024475

TOP

¦^´_ 8# stillfish00
­A²Â¤F , ¶¤@¤j°é®Ú¥»¥i¥H¤Æ²¦¨ =1-POWER(1-A1,B1)

TOP

stillfish00 ÁÂÁ¡C
§ÚÁÙ¦b¬ã¨s¤¤ª©¥Dªº¤º®e¡A§A´N¤w¸g¼g¨Ó¤F¡C
§Aªº³¡¤À¦^Âk¨ì³Ì°ò¥»ªº¼Æ¾Ç³¡¤À¡A§óª½±µ¡C
«ä¦Òªº¤º®e³Ó©ó¤½¦¡ªº¼¶¼g¡C

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD