| ¥È¥Ã¥×¥Ú¡¼¥¸ | P-WORLD¤È¤Ï | ¤´ÍøÍÑ°ÆÆâ | ²ñ¼Ò°ÆÆâ | |
ÊÖ¿®¸µ¤Îµ»ö | |||
¡Ú3¡Û | RE:ÀßÄêȽÊ̤ò¼«Ê¬¤Ç ·ã¿É²¦¢ö ¡Ê2007ǯ12·î11Æü 03»þ57ʬ) |
||
¤Á¡¼¤ä¤ó¡÷¤µ¤ó¡¡¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡ª ¥¨¥¯¥»¥ë£÷¡¡Æþ¤Ã¤Æ¤Þ¤·¤¿¡Ê´î ¤½¤ì¤Ç¿ô¼°¤òÆþÎϤ·¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¥Ê¥ó¥À¥«¤¦¤Þ¤¯¤¤¤¤Þ¤»¤ó¡£ ¤½¤ì¤Ç³Îǧ¤µ¤»¤Æ¤¤¤¿¤À¤¤¿¤¤¤Î¤Ç¤¹¤¬ A1¤Î¥»¥ë¤Ë¡¡=BINOMDIST(C1,D1,1/B1,0) A2¤Î¥»¥ë¤Ë¡¡=BINOMDIST(C1,D1,1/B2,0) ¡¡¡¦ A6¤Î¥»¥ë¤Ë¡¡=BINOMDIST(C1,D1,1/B6,0) A7¤Î¥»¥ë¤Ë¡¡=SUM(A1:A6)¡¡¤È¡¡Æþ¤ì¤Þ¤·¤¿¡£ B1¤«¤éB6¤Þ¤Ç¤ËÆþÎϤ¹¤ë³ÆÀßÄê¤Ë¤ª¤±¤ëÅöÁªÎ¨¤È¤¤¤¦¤Î¤Ï ²¾¤Ë¡¡ÀßÄê1¤¬1/200 ¤Ç¡¡ÀßÄꣶ¤¬1/100¤Îµ¡¼ï¤Ç¤¢¤ì¤Ð¡¡B1¤Ë1/200¤ÈÆþ¤ì¡¢£Â£¶¤Ë1/100 ¤ÈÆþ¤ì¤ì¤ÐÎɤ¤¤Î¤Ç¤·¤ç¤¦¤«¡© ¤¢¤È £Å£±¤Ï¡¡=A1/A7 £Å£²¤Ï =A2/A7 ¡¡¡¦ £Å£¶¤Ï =A6/A7¡¡¤Ç¤¹¤è¤Í¡¼¡© ¤ÇºÇ¸å¤ËÂçÅö¤¿¤ê²ó¿ô¤ò£Ã£±¤ËÆþ¤ì ²óž¿ô¤ò£Ä£±¤ËÆþ¤ì¤ë¤È£Á£±¡Á£Á£¶¤ËÅú¤¨¤¬½Ð¤ë¤Ã¤Æ¸À¤¦¤³¤È¤Ç¤·¤ç¤¦¤«¡© ¤ª¼ê¿ô¤Ç¤¹¤±¤É¥è¥í¥·¥¯¤ª´ê¤¤¤·¤Þ¤¹^^ |
¢£ 28·ï¤ÎÅê¹Æ¤¬¤¢¤ê¤Þ¤¹¡£ |
3 2 1 |
¡Ú4¡Û |
¤Á¡¼¤ä¤ó¡÷ (2007ǯ12·î11Æü 13»þ40ʬ) |
||
¤³¤ì¤Ï ¡Ú3¡Û ¤ËÂФ¹¤ëÊÖ¿®¤Ç¤¹¡£ | |||
¾¯¤·¾å¼ê¤¯¹Ô¤«¤Ê¤«¤Ã¤¿¤ß¤¿¤¤¤Ç¤¹¤Í£÷¡°¡°; ³Îǧ¤·¤¿¤é¡¢£±²Õ½êÄûÀµ¤È£±²Õ½êÊѹ¹¤·¤¿Êý¤¬²ò¤ê°×¤¤¤è¤¦¤Ç¤¹¢ö £Á¤Î¥È¥³¤Ï¡¢¤½¤Î¤Þ¤Þ¤Ç£Ï£Ë¤Ç¤¹¢ö ¡äB1¤«¤éB6¤Þ¤Ç¤ËÆþÎϤ¹¤ë³ÆÀßÄê¤Ë¤ª¤±¤ëÅöÁªÎ¨¤È¤¤¤¦¤Î¤Ï ¡ä²¾¤Ë¡¡ÀßÄê1¤¬1/200 ¤Ç¡¡ÀßÄꣶ¤¬1/100¤Îµ¡¼ï¤Ç¤¢¤ì¤Ð¡¡B1¤Ë1/200¤ÈÆþ¤ì¡¢£Â£¶¤Ë1/100 ¤ÈÆþ¤ì¤ì¤ÐÎɤ¤¤Î¤Ç¤·¤ç¤¦¤«¡© ¡Ø£±/¡Ù¤È¤¤¤¦¤Î¤ÏÉÕ¤±¤Ê¤¯¤ÆÎɤ¤¤Ç¤¹¡£¡ØʬÊì¤À¤±¡ÙÆþÎϤ¹¤ë¤ó¤Ç¤¹¢ö¡¡¼«Ê¬¤â²¾¤Ë¡Ä £Â£±¡Ä£²£°£° £Â£²¡Ä£±£¸£° ¡¡¡¦ £Â£¶¡Ä£±£°£°¡¡¤È£²£°¤Å¤Ä¤Îº¹¤Ç»î¤·¤Þ¤·¤¿¢ö £Å¤Î²Õ½ê¤Ç¤¹¤¬¡Ä¡Ø=A1/A7*100¡Ù*100¤ò²Ã¤¨¤ë¤È¡¢¸«¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¢ö ¢¨¡Ø*¡Ù¤Ï¡Ø¡ß¡Ù¤È¤¤¤¦°ÕÌ£¤Ë¤Ê¤ê¤Þ¤¹¢ö¡¡¡Ö¡à¡×¤Ï¡Ö/¡×¤Ã¤Æ»ö¤Ç¤¹¤Í¢ö ¢¨£Å£±¡Á£Å£¶¤Þ¤Ç¡¢Æ±ÍͤˡÖ*100¡×¤òÉÕ¤±²Ã¤¨¤Æ¤¯¤À¤µ¤¤¢ö ¡ä¤ÇºÇ¸å¤ËÂçÅö¤¿¤ê²ó¿ô¤ò£Ã£±¤ËÆþ¤ì ¡ä²óž¿ô¤ò£Ä£±¤ËÆþ¤ì¤ë¤È£Á£±¡Á£Á£¶¤ËÅú¤¨¤¬½Ð¤ë¤Ã¤Æ¸À¤¦¤³¤È¤Ç¤·¤ç¤¦¤«¡© ¤³¤³¤Ï¡¢¤½¤Î¤Þ¤Þ¤Ç£Ï£Ë¤Ç¤¹¢ö¡¡¼«Ê¬¤Ï¡¢£±£°²óÅöÁª/£²£°£°£°²óž¤ÈÆþÎϤ·¤Æ¤ß¤Þ¤·¤¿¢ö ¤¹¤ë¤È¡Ä£Å¤Î²Õ½ê¤Ë¡Ä £Å£±¡á29.02279 £Å£²¡á27.39238 £Å£³¡á22.15238 £Å£´¡á14.07633 £Å£µ¡á6.040452 £Å£¶¡á1.315666 £Å£±¡Á£Å£¶¤Þ¤Ç¤òÁ´¤Æ¤¹¤È¡¢99.999998¤È¡Ä¤Û¤Ü100¡ó¤Ë¤Ê¤ë¤«¤È»×¤¤¤Þ¤¹¢ö ¢¨É½¼¨¤¬ÀÚ¤ì¤Æ¤¤¤ë²Õ½ê¤Ç»Í¼Î¸ÞÆþ¤·¤Æ¤¤¤ë¤Î¤Ç¡¢¶Ï¤«¤Ë¸íº¹¤Ï½Ð¤Þ¤¹¤¬¡Ä ¡¡ÌäÂê¤Î¤¢¤ë¥ì¥Ù¥ë¤Ç¤Ï¤Ê¤¤¤«¤È»×¤¤¤Þ¤¹¢ö ¤³¤³¤Þ¤Ç¡¢½ÐÍ褿¤é¡Ä£Å¤Î·ë²Ì¤ÎÉôʬ¤Ë¡¢¤½¤Î¤Þ¤Þ¡Ö¡ó¡×¤òÉÕ¤±¤Æ¹Í¤¨¤ì¤Ð£Ï£Ë¤Ç¤¹¢ö ¡ü¸«¤ä¤¹¤¯¤¹¤ë¤¿¤á¤Ë¡¢ÆþÎϤ·¤¿¿ô»ú¤Î¾å¤Ë¡¢²¿¤Î¿ô»ú¤Ê¤Î¤«¤ò¸ÀÍÕ¤ÇÆþÎϤ·¤Æ¤ª¤¯¤È¡¢ ¡¡¤¢¤È¤¢¤È²ò¤ê°×¤¤¤«¤È»×¤¤¤Þ¤¹¢ö Á´ÂΤò¡ØÈÏ°Ï»ØÄê¡Ù¤·¤Æ¡¢²¼¤Î¶ù¤Ã¤³¤Ç¡Ø¥É¥é¥Ã¥¯¡Ù¤·¤¿¤Þ¤Þ¡¢²¼¤Ø°ÜÆ°¡Ä £±¥³¥Þʬ²¼¤Ë²¼¤²¤ì¤ÐºÑ¤ß¤Þ¤¹¢ö ¤¹¤ë¤È¡Ä¡Ø£±¤ÎÃÊ¡Ù¤¬Á´¤Æ¶õÇò¤Ë¤Ê¤ë¤Î¤Ç¡¢¿ô¼°¤ä¿ô»ú¤Î°ÕÌ£¤ò¾å¤Ë½ñ¤±¤Ð£Ï£Ë¤Ç¤¹¢ö £Á£±¡á´Ø¿ô £Â£±¡á³ÎΨ £Ã£±¡áÅöÁª²ó¿ô £Ä£±¡áÅöÁª³ÎΨ £Å£±¡áȽÊÌ·ë²Ì ¤È¤¤¤¦¶ñ¹ç¤Ê¤é²ò¤ê°×¤¤¤«¤È»×¤¤¤Þ¤¹¢ö¡°¡° ¤â¤Ã¤È¾þ¤êÉÕ¤±¤ò¤·¤¿¤¤¤Ê¤é¡Ä¸å¤Ï¼«Ê¬¤Î¹¥¤ß¤Ç¡¢°ÜÆ°¤·¤Æ¤ß¤ë¤Î¤â¥¤¥¤¤Ç¤·¤ç¤¦¢ö ºÇ¸å¤Ë¡Ä¡¡¤É¤Î¥µ¥¤¥È¤Ç¤â¡¢´ðËÜŪ¤ËƱ¤¸¥Ï¥º¤Ç¤¹¤¬¡Ä ¡ØÁ´ÀßÄ꤬¶ÑÅù¤ËÇÛʬ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤ÎȽÊ̡٤Ȥ¤¤¦¤Î¤¬¡¢¥Í¥Ã¥¯¤È¤Ê¤ê¤Þ¤¹¤¬¡¢ ¼ÂºÝ¤Ë¡¢Å¹¤ÎÀßÄêÇÛʬ¤¬Àµ³Î¤ËÇÄ°®½ÐÍè¤ë¥±¡¼¥¹¤¬µ©¤À¤È»×¤¦¤Î¤Ç¡¢ ¤½¤³¤Þ¤Ç¤Î·×»»¤Ï¡¢¼«Ê¬¤â¤·¤Æ¤¤¤Þ¤»¤ó¡£(ȽÊ̤â²Äǽ¤Ç¤¹¤¬¡Ä¹¹¤ËÊ£»¨¤Ë¤Ê¤ê¤Þ¤¹) ¶Ëü¤Ë¸À¤Ã¤Æ¤·¤Þ¤¨¤Ð¡¢ÀßÄꦤ˶ᤱ¤ì¤Ð³¹Ô¡Ä¡¡¡¤Ë¶á¤±¤ì¤Ð¥ä¥á¡Ä¤Ê¤é¤Ð¡¢ £Á¡¦£Â¡¦£Å¤Î£²¡Á£µ¤ò½ü¤¤¤Æ¡¢Ê̤˺îÀ®¤·¤Æ¤·¤Þ¤¦¡Ä¤È¤¤¤¦ÊýË¡¤â¤¢¤ê¤Þ¤¹¢ö ¢¨´ñ¿ô¡¦¶ö¿ôÀßÄê¤Ç¡ÄÆÃħ¤Î¤¢¤ëµ¡¼ï¤Î¾ì¹ç¡¢Á´ÀßÄê¤Ç¤ÎȽÊ̤¬É¬¿Ü¤È¤Ê¤ê¤Þ¤¹¤¬¡Ä ¡¡Î㤨¤Ð¡¢£Å£Ö£Á¹¤ÏÆä˸²Ãø¤Ë¸½¤ì¤Æ¤¤¤Þ¤¹¢ö ¤Ç¤ï¤Ç¤ï¡Á·ë²Ì¤ò¤ªÂÔ¤Á¤·¤Æ¤ª¤ê¤Þ¤¹¢ö(o¡¦¦Ø¡¦o)¥Î |
|||
© P-WORLD