| ¥È¥Ã¥×¥Ú¡¼¥¸ | P-WORLD¤È¤Ï | ¤´ÍøÍÑ°ÆÆâ | ²ñ¼Ò°ÆÆâ | |
ÊÖ¿®¸µ¤Îµ»ö | |||
¡Ú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 |
¢£ 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 |
¡Ú84¡Û |
¤ª¤ä¤¸¥×¥í¤µ¤ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤¬¡Ä¡Ê¡°¡°¡¨¡Ë ¡¡ ¤¢¤Þ¤¬¤¨¤ë (2002ǯ03·î03Æü 11»þ19ʬ) |
||
¤³¤ì¤Ï ¡Ú83¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¼«Ê¬¤Ç¤â¤ï¤«¤ê¤½¤¦¤Ê¤Î¤Ç¡¢¤Á¤ç¤Ã¤È¼ºÎ餷¤Þ¤¹¡£ ¤¨¤Ã¤È¡¢¥¨¥é¡¼¤Ï¤Ò¤ç¤Ã¤È¤·¤Æ¡Ø¡ô¡ô¡ô¡ô¡ô¡Ù¢«¤³¤ó¤ÊÅÛ¤¸¤ã¤Ê¤¤¤Ç¤¹¤«¡© ¤³¤ì¤À¤È¤¿¤ó¤Ë¥»¥ë¤ÎÉý¤¬¶¹¤¯¤Æɽ¼¨¤Ç¤¤Ê¤¤¤À¤±¤Ç¤¹¤Î¤Ç¡¢ ¥»¥ë¤ÎÉý¤ò¹¤¯¤¹¤ë¤³¤È¤Ç²ò·è¤Ç¤¤ë¤È»×¤¤¤Þ¤¹¡£ |
|||
¤³¤ÎÅê¹Æ¤ËÂФ¹¤ë ÊÖ¿®¤ò¸«¤ë (1·ï) |
© P-WORLD