| ¥È¥Ã¥×¥Ú¡¼¥¸ | P-WORLD¤È¤Ï | ¤´ÍøÍÑ°ÆÆâ | ²ñ¼Ò°ÆÆâ | |
¢£ 250·ï¤ÎÅê¹Æ¤¬¤¢¤ê¤Þ¤¹¡£ |
< 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 ¡Ú9¡Û 8 7 6 5 4 3 2 1 > |
¡Ú90¡Û |
¤¢¤Þ¤¬¤¨¤ë (2002ǯ03·î03Æü 18»þ36ʬ) |
||
¤³¤ì¤Ï ¡Ú89¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
³Î¤«¤Ë£°¡¥£°£µ¤Ã¤Æ£±¡¿£²£°¤Ç¤¹¤Í¡Ê´À £×£É£Ú¤µ¤ó¤Î¸À¤¦Ä̤꣱£³£µ°Ê¾å¤Ï ¥¨¥¯¥»¥ë¤ÎǽÎϤòĶ¤¨¤Æ¤¤¤ë¤è¤¦¤Ç¡¦¡¦¡¦ ¤¦¡Á¤ó¤Þ¤µ¤«¤³¤ó¤ÊÍî¤È¤··ê¤¬¤¢¤ë¤È¤Ï ¼«Ê¬¤â£Â£É£Î£Ï£Í£Ä£É£Ó£Ô´Ø¿ô¤ÎÊý¤¬Àµ³Î¤Ç¤¤¤¤¤È »×¤Ã¤Æ¤¿¤ó¤Ç¤¹¤¬ÂçÅö¤ê²ó¿ô¤¬Â礤¤¾ì¹ç¤Ï ¸¡ÄêÅý·×ÎÌÅù¤òÍѤ¤¤¿¤ä¤êÊý¤¸¤ã¤Ê¤¤¤ÈÂÌÌܤߤ¿¤¤¤Ç¤¹¤Í¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú89¡Û |
WIZ (2002ǯ03·î03Æü 17»þ41ʬ) |
||
¤³¤ì¤Ï ¡Ú88¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¤¹¤¤¤Þ¤»¤ó¡¢¤Á¤ç¤Ã¤ÈÎ㤬°¤«¤Ã¤¿¤Ç¤¹¤Í¡£¡£¡£¡Ê´À¡Ë ¤¿¤À¡¢³ÎΨ0.05¤ÏÂçÅö¤¿¤ê³ÎΨ1/20¤Ç¤¹¤è¡£ ¤À¤«¤é500²ó¤ÏÅö¤¿¤é¤Ê¤¤¤È¤¤¤±¤Ê¤¤¤Î¤Ç 135²ó¤ÏµÕ¤ËĶÉÔ¹¬¤Ç¤¹(^^;; ¤È¤³¤í¤¬¡¢500¤È¤¤¤¦¿ô»ú¤òÆþ¤ì¤Æ¤â¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£ ¡Ê134¤¬¸Â³¦ÃͤǤ¹¡Ë ¼ÂºÝ¤Î¥Ñ¥Á¥ó¥³¤Ç¤¢¤êÆÀ¤ë¿ô»ú »î¹Ô²ó¿ô=100000 À®¸ù³ÎΨ=0.0031695 À®¸ù¿ô=316 BINOMDIST(316,100000,0.0031695,TRUE) ¤ò¤ä¤Ã¤Æ¤ß¤Æ²¼¤µ¤¤ ¤³¤ì¤â¥À¥á¤Ç¤¹¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú88¡Û |
¤¢¤Þ¤¬¤¨¤ë (2002ǯ03·î03Æü 14»þ36ʬ) |
||
¤³¤ì¤Ï ¡Ú85¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
ÂçÅö¤ê³ÎΨ£±¡¿£²£°£°¤ò £±£°£°£°£°²óž¤µ¤»¤¿»þ¡¢ ÂçÂÎÂçÅö¤ê²ó¿ô¤Ï£µ£°²óÁ°¸å¤Ë¤Ê¤ê¤Þ¤¹¤è¤Í¡£ ¤â¤·¤½¤ó¤Êµ¡¼ï¤Ç£±£³£µ²ó¤âÅö¤¿¤Ã¤¿¤È¤·¤¿¤é ´Ö°ã¤¤¤Ê¤¯±ó³Ö¤«£´£°Ãûʬ¤Î£±¤Î¹¬±¿¤Ç¤¹¡£ ¤½¤³¤Þ¤ÇÅö¤¿¤ë²ÄǽÀ¤Ï¤Þ¤ºÌµ¤¤¤Î¤Ç¡¢ ¿´ÇÛ¤¹¤ëɬÍפϤʤ¤¤«¤È¡¦¡¦¡¦¡Ê¡°¡°¡¨¡Ë |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (2·ï) |
¡Ú87¡Û |
RE:¤ª¤ä¤¸¥×¥í¤µ¤ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤¬ ¡¡ WIZ (2002ǯ03·î03Æü 14»þ10ʬ) |
||
¤³¤ì¤Ï ¡Ú86¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¤¢¤Þ¤¬¤¨¤ë¤µ¤ó º£µ¤ÉÕ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢¤¢¤Þ¤¬¤¨¤ë¤µ¤ó¤Îºî¤é¤ì¤¿ ¥È¥Ô¤ÇÁ´¤¯Æ±¤¸¤è¤¦¤Ê»ö¤ò¤µ¤ì¤Æ¤Þ¤¹¤Í¡ª º£¤Þ¤ÇÃΤé¤Ê¤«¤Ã¤¿¤Ç¤¹¡Ê´À¡Ë ¤¢¤Î¥·¡¼¥È¤Ê¤é¡¢¿ôÃͤ¬Â礤¯¤Æ¤â¤¤¤±¤Þ¤¹¤Í »È¤ï¤»¤Æĺ¤¤Þ¤¹¡ª ¤È¤³¤í¤Ç¡¢BINOMDIST ´Ø¿ô¤Ç¤Ï¤ä¤Ï¤ê͸ú¿ô»ú¤ÎÈϰϤòĶ¤¨¤Æ ¤·¤Þ¤¦¤è¤¦¤Ç¤¹¡£ nCi(n=10000,i=135) ¤Î·×»»¤Ç¤â COMBIN(10000,134)¤Þ¤Ç¤¬¸Â³¦¤Î¤è¤¦¤Ç¤¹¤«¤é¡£ |
|||
¡Ú86¡Û |
RE:¤ª¤ä¤¸¥×¥í¤µ¤ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤¬ ¡¡ WIZ (2002ǯ03·î03Æü 12»þ33ʬ) |
||
¤³¤ì¤Ï ¡Ú85¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¢¤ÎÅê¹Æ¤Ç¥¿¥¤¥×¥ß¥¹¤¬¤¢¤ê¤Þ¤·¤¿¡£ ¸í¡¡¢ª¡¡BINNOMDIST Àµ¡¡¢ª¡¡BINOMDIST ¤Ç¤·¤¿¡£¼ºÎ餷¤Þ¤·¤¿¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú85¡Û |
RE:¤ª¤ä¤¸¥×¥í¤µ¤ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤¬ ¡¡ WIZ (2002ǯ03·î03Æü 12»þ30ʬ) |
||
¤³¤ì¤Ï ¡Ú84¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¤¢¤Þ¤¬¤¨¤ë¤µ¤ó¡¢¤Ï¤¸¤á¤Þ¤·¤Æ¡£ ¥ì¥¹¡¢¤É¤¦¤â¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ ¤¤¤¨¡¢¤½¤¦¤Ç¤Ï¤Ê¤¤¤ó¤Ç¤¹¡¦¡¦ ¾®¤µ¤ÊÃͤǤÏÌäÂê¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢ »î¹Ô²ó¿ô¡¦À®¸ù¿ô¤¬Â礤¯¤Ê¤ë¤È#NUM! ¤¬ÊÖ¤µ¤ì¤Æ¤·¤Þ¤¦¤Î¤Ç¤¹¡£ ¥»¥ë¤ÎÉý¤ò¹¤¯¤·¤Æ¤â¥À¥á¤Ê¤ó¤Ç¤¹¡£ Î㤨¤Ð¡¢»î¹Ô²ó¿ô¡á10000¡¢À®¸ù³ÎΨ=0.05¤È¤·¤¿¾ì¹ç¡¢ BINNOMDIST(À®¸ù²ó¿ô,10000,0.05,TRUE) ¤Ç¤¹¤¬¡¢ À®¸ù²ó¿ô=134¤Þ¤Ç¤ÏOK¤Ê¤Î¤Ç¤¹¤¬¡¢135°Ê¾å¤Ç¤ÏÁ´¤Æ #NUM! ¤È¤Ê¤Ã¤Æ¤·¤Þ¤·¤Þ¤¹¡£ ¤½¤Î¾¡¢¿§¡¹¤Ê¿ôÃͤò¤ä¤Ã¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¡¢¿ôÃͤ¬Â礤¯¤Ê¤ë¤È ¤³¤Î¥¨¥é¡¼¤¬È¯À¸¤·¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (2·ï) |
¡Ú84¡Û |
¤ª¤ä¤¸¥×¥í¤µ¤ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤¬¡Ä¡Ê¡°¡°¡¨¡Ë ¡¡ ¤¢¤Þ¤¬¤¨¤ë (2002ǯ03·î03Æü 11»þ19ʬ) |
||
¤³¤ì¤Ï ¡Ú83¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¼«Ê¬¤Ç¤â¤ï¤«¤ê¤½¤¦¤Ê¤Î¤Ç¡¢¤Á¤ç¤Ã¤È¼ºÎ餷¤Þ¤¹¡£ ¤¨¤Ã¤È¡¢¥¨¥é¡¼¤Ï¤Ò¤ç¤Ã¤È¤·¤Æ¡Ø¡ô¡ô¡ô¡ô¡ô¡Ù¢«¤³¤ó¤ÊÅÛ¤¸¤ã¤Ê¤¤¤Ç¤¹¤«¡© ¤³¤ì¤À¤È¤¿¤ó¤Ë¥»¥ë¤ÎÉý¤¬¶¹¤¯¤Æɽ¼¨¤Ç¤¤Ê¤¤¤À¤±¤Ç¤¹¤Î¤Ç¡¢ ¥»¥ë¤ÎÉý¤ò¹¤¯¤¹¤ë¤³¤È¤Ç²ò·è¤Ç¤¤ë¤È»×¤¤¤Þ¤¹¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú83¡Û |
¤³¤ì¤òexcel¤Ç·×»»¤Ç¤¤ë¤Ç¤·¤ç¤¦¤«¡© ¡¡ WIZ (2002ǯ03·î03Æü 03»þ41ʬ) |
||
¤³¤ì¤Ï ¡Ú¥È¥Ô¥Ã¥¯¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¤ª¤ä¤¸¥×¥í¤µ¤ó¡¢¤Ï¤¸¤á¤Þ¤·¤Æ¡£ ¤³¤³¤Ï»²¹Í¤Ë¤Ê¤ë¤Î¤Ç¤è¤¯¸«¤µ¤»¤Æ¤¤¤¿¤À¤¤¤Æ¤Þ¤¹¡£ ¤³¤ÎÁ°¡¢¤¢¤Þ¤¬¤¨¤ë¤µ¤ó¤¬¸¡ÄêÅý·×Î̤ʤɤÎÏäò ¤µ¤ì¤Æ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢ÊÙ¶¯ÉÔ¤Ǥ褯ʬ¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£ ¤½¤³¤Ç¡¢¤Á¤ç¤Ã¤È¼ÁÌ䤬¤¢¤ë¤Î¤Ç¤¹¤¬¡¢¡¢ ÂçÅö¤¿¤ê³ÎΨ=P,¥Ç¥¸¥¿¥ë²óž¿ô=n,¤È¤·¤¿»þ¤Ë ÂçÅö¤¿¤ê²ó¿ô¤¬k²ó°Ê²¼¤È¤Ê¤ë³ÎΨ ô[i=0,k]nCi(P)^(n)(1-P)^(n-i)¡¡ ¤òexcel¤Ç·×»»¤·¤¿¤¤¤Î¤Ç¤¹¡£ k²ó¤Ê¤é´Êñ¤Ë·×»»¤Ç¤¤ë¤Î¤Ç¤¹¤¬k²ó¡Ö°Ê²¼¡×¤È¤Ê¤ë¤È ¤É¤¦¤â¤¦¤Þ¤¯¤¤¤¤Þ¤»¤ó¡£ BINOMDIST¡¡¤È¤¤¤¦´Ø¿ô¤¬»È¤¨¤½¤¦¤Ê¤Î¤Ç¤¹¤¬¡¢ ¿ôÃͤ¬Â礤¯¤Ê¤ë¤È¥¨¥é¡¼¤¬½Ð¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ °Ê²¼¡¢EXCEL¤Î¥Ø¥ë¥×¤è¤ê¡¢ ___________________________________________ BINOMDIST(À®¸ù¿ô, »î¹Ô²ó¿ô, À®¸ùΨ, ´Ø¿ô·Á¼°) À®¸ù¿ô »î¹Ô²ó¿ô ¤Ë´Þ¤Þ¤ì¤ëÀ®¸ù¤Î²ó¿ô¤ò»ØÄꤷ¤Þ¤¹¡£ »î¹Ô²ó¿ô ÆÈΩ»î¹Ô¤Î²ó¿ô¤ò»ØÄꤷ¤Þ¤¹¡£ À®¸ùΨ 1 ²ó¤Î»î¹Ô¤¬À®¸ù¤¹¤ë³ÎΨ¤ò»ØÄꤷ¤Þ¤¹¡£ ´Ø¿ô·Á¼° ´Ø¿ô¤Î·Á¼°¤ò¡¢ÏÀÍýÃͤǻØÄꤷ¤Þ¤¹¡£´Ø¿ô·Á¼° ¤Ë TRUE ¤ò»ØÄꤷ¤¿¾ì¹ç¡¢BINOMDIST ´Ø¿ô¤ÎÌá¤êÃͤÏÎßÀÑʬÉÛ´Ø¿ô¤È¤Ê¤ê¡¢Â¿ ¤¤¤È¤¤Ç À®¸ù¿ô ²ó¤ÎÀ®¸ù¤¬ÆÀ¤é¤ì¤ë³ÎΨ¤¬·×»»¤µ¤ì¤Þ¤¹¡£FALSE ¤Î¾ì ¹ç¤Ï¡¢³ÎΨ̩Åٴؿô¤È¤Ê¤ê¡¢À®¸ù¿ô ²ó¤ÎÀ®¸ù¤¬ÆÀ¤é¤ì¤ë³ÎΨ¤¬·×»»¤µ ¤ì¤Þ¤¹¡£ _____________________________________ ²¿¤«Îɤ¤²ò·èºö¤Ï̵¤¤¤Ç¤·¤ç¤¦¤«¡© ¤ä¤Ï¤ê¸¡ÄêÅý·×Î̤Ȥ«¤½¤ÎÊÕ¤òÊÙ¶¯¤·¤Ê¤¤¤È¡¢´Êñ¤Ë¤Ï·×»»¤Ç¤ ¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡© ¼ÁÌä¤Ð¤«¤ê¤Ç¤¹¤¤¤Þ¤»¤óm(_ _)m |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú82¡Û |
¥Ê¥Ã¥¯¥ë (2002ǯ03·î02Æü 21»þ04ʬ) |
||
¤³¤ì¤Ï ¡Ú81¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¤ª¤ä¤¸¥×¥í¤µ¤ó¤³¤ó¤Ð¤ó¤Ï¡ª º£·î¤ÏÌÜɸÆüÅö¤Î18000±ß¤ò¥¯¥ê¥¢¤Ç¤¤Þ¤·¤¿¡£ É÷¼Ù¤ò¤³¤¸¤é¤»¤Æ¤·¤Þ¤Ã¤Æ1½µ´Ö¤Û¤É¥í¥¹¤¬¤¢¤ê¤Þ¤·¤¿¤¬¡¦¡¦¡¦ ·î¡¢5Ëü²óž°Ê¾å¤Ç¤¹¤«¡£¡Ê¤â¤Á¤í¤óÄ̾ï»þ²óž¤Ç¤¹¤è¤Í¡Ë¤Á¤ç¤Ã¤È¡¢´Å¤¯¹Í¤¨¤¹¤®¤À¤Ã¤¿¤Ê¡¼¡£ ¤Ê¤ó¤«¡¢¤³¤ÎÁ°¤Î¥Ñ¥Á¥Þ¥¬¤Ë¡Ö¶ÌÁý¤¨Î¨¡×¤Ê¤ó¤Æ¤Î¤¬ºÜ¤Ã¤Æ¤Þ¤·¤¿¤¬¡¢¤Þ¤À¤è¤¯Æɤó¤Ç¤Ê¤¤¤Î¤Ç¸å¤Ç¤¸¤Ã¤¯¤êÆɤó¤Ç¤ß¤Þ¤¹¡£Ê̤ËÌÜ¿·¤·¤¤¤³¤È¤¸¤ã¤Ê¤¤¤Î¤«¤Ê¡©°ì¸®²°¥¿¥Ê¥«¤µ¤ó¤Ï¤Þ¤¿¸¦µæ¤·¤Æ¤½¤¦¤Ç¤¹¤¬¡¦¡¦¡¦ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
¡Ú81¡Û |
¤ª¤ä¤¸¥×¥í (2002ǯ02·î04Æü 03»þ27ʬ) |
||
¤³¤ì¤Ï ¡Ú80¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
ÃÙ¤¯¤Ê¤ê¤Þ¤·¤¿¡£ ¥Ê¥Ã¥¯¥ë¤µ¤ó¤Î°ì·î¤Î¥Ç¡¼¥¿¤«¤é¡ÊÄã´¹¶â¤È¤·¤Æ¡Ë£±£²¡Á£±£µËüÄøÅ٤γÎΨÉ餱¡¢¤È¿ä¬¤Ç¤¤Þ¤¹¡£ ¤È¤¤¤¦¤³¤È¤Ï¡¢¥Þ¥È¥â¤ËÅö¤Ã¤Æ¤â£²£°ËüÀÚ¤ë·î¼ý»Ù¡£¤½¤ì¤ÇÉÔ¤Ǥ¢¤ì¤Ð¤è¤êÎɤ¤Âæ¤òõ¤¹¤«¡¢²ÔÆ°¤ò¾å¤²¤ë¤«¡¢¤Ë¤Ê¤ê¤Þ¤¹¤Í¡£ ¡Ê£±¡Ë²ÔÆ° ¤¢¤¯¤Þ¤Ç¿Í¤½¤ì¤¾¤ì¤Ç¤¹¤¬¡¢·îÊ¿¶Ñ£³£°Ëü°Ê¾å¤òĹ´ü´Ö³¤±¤Æ¤¤¤ë¿Í¤Ï¡¢¤Û¤È¤ó¤É£µËü²óž¡¿·î¤°¤é¤¤¤ÏºÇÄãÂǤäƤë¤È»×¤¤¤Þ¤¹¡£ ¡Ê£²¡ËÂæ¤Î¥¯¥©¥ê¥Æ¥£ »Å»öÎ̤ò¤Ä¤±¤ì¤Ð¥Ï¥Ã¥¥ê¤¹¤ë¤È»×¤¤¤Þ¤¹¤¬¡¢ºòǯ½©¤Ï¥Ä¥¤¤Æ¤¤¤¿¡¢¤È¤·¤Æ¤â¡¢¤â¤¦¾¯¤·¤¤¤¤Âæ¤òÂǤƤƤ¤¤¿¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡© ¤¿¤À¡¢¼ý»Ù¡¦Âæ¤Î¥¯¥©¥ê¥Æ¥£¤¬Ä㤯¤Æ¤â¥×¥í¤È¤·¤ÆÃѤº¤«¤·¤¤±¾¡¹¤Ï»×¤¤¤Þ¤»¤ó¡£¡Ö¼«Ê¬¤¬É¬ÍפʤÀ¤±¾¡¤Æ¤ë¡×¥Ñ¥Á¥ó¥³¤ò¤¹¤ì¤Ð¤¤¤¤¤ï¤±¤Ç¡¢Â¾¿Í¤ÈÈæ³Ó¤¹¤ëɬÍפϤʤ¤¡¢¤È»×¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (2·ï) |
© P-WORLD