Excel¤Ç¥À¥ß¡¼¥Ç¡¼¥¿¤òÆþÎϤ·¤Æɽ¤òºî¤ë¡ª¡¡ÌòΩ¤ÄRANDARRAY´Ø¿ô¤Î»È¤¤Êý
Excel¤ÎÍøÍÑÃæ¤Ë¡Ö¤È¤ê¤¢¤¨¤ºÅ¬Åö¤Êɽ¤òºî¤ê¤¿¤¤¡×¤È¤¤¤¦¤³¤È¤¬¤¢¤ë¡£
¿ôÃͤÏŬÅö¤Ç¤¤¤¤¤¬¡¢ËÜʪ¤Ã¤Ý¤¯¸«¤»¤ëɬÍפ¬¤¢¤ë¡Ä¡Ä¤È¤¤¤Ã¤¿¥±¡¼¥¹¤À¡£
¤½¤ó¤Ê¤È¤¡¢º£²ó¾Ò²ð¤¹¤ëRANDARRAY´Ø¿ô¤Î»È¤¤Êý¤ò³Ð¤¨¤Æ¤ª¤±¤Ð¡¢¤¤Ã¤ÈÌò¤ËΩ¤Ä¤À¤í¤¦¡£
¡üRANDARRAY´Ø¿ô¤È¤Ï¡© ¤½¤Î»È¤¤Êý¤Ï¡©
Excel¤ò»È¤Ã¤Æ¤¤¤ë¤È¤¡¢¤È¤ê¤¢¤¨¤ºÅ¬Åö¤Êɽ¤¬É¬Íפˤʤ뤳¤È¤Ï¤Ê¤¤¤À¤í¤¦¤«¡£
À°Îó¤ä¹Ê¤ê¹þ¤ßµ¡Ç½¤ò»î¤·¤¿¤¤¤È¤«¡¢Å¬Åö¤Êɽ¤ò¤â¤È¤Ë¤É¤ó¤Ê¥°¥é¥Õ¤¬ºî¤ì¤ë¤«»î¤·¤¿¤¤¤È¤¤¤Ã¤¿¥±¡¼¥¹¤À¡£
¤½¤¦¤¤¤¦¤È¤¡¢Å¬Åö¤Ê¿ôÃͤòÆþÎϤ·¤Æ¥µ¥ó¥×¥ë¤Îɽ¤òºî¤ë¤³¤È¤Ë¤Ê¤ë¤¬¡¢Å¬Åö¤È¤Ï¤¤¤¨É½¤òºî¤ë¤Î¤Ë¤Ï¼ê´Ö¤¬¤«¤«¤ë¡£Â礤¤É½¤Ë¤Ê¤ë¤È¤Ê¤ª¤µ¤é¤À¡£
¤½¤ó¤Ê¤È¤ÊØÍø¤Ê´Ø¿ô¤¬ RANDARRAY´Ø¿ô¤Ç¤¢¤ë¡£»È¤¤Êý¤Ï¼¡¤Î¤È¤ª¤ê¤À¡£
=randarray(¹Ô,Îó,ºÇÂçÃÍ,ºÇ¾®ÃÍ,¼ïÎà)
¤¿¤È¤¨¤Ð¡¢
=randarray(5,6,0,100,true)
¤ÈÆþÎϤ¹¤ì¤Ð¡¢ÆþÎÏ°ÌÃ֤Υ»¥ë¤«¤é5¹Ô¡¢6Îó¤ÎÈϰϤˡ¢0¤«¤é100¤Þ¤Ç¤ÎÍð¿ô¡ÊÀ°¿ô¡Ë¤ò¼«Æ°Åª¤ËÆþÎϤ¹¤ë¡£ºÇ¸å¤Î¼ïÎà¤Ïtrue¤À¤ÈÀ°¿ô¡¢false¤À¤È¾®¿ô¤Ë¤Ê¤ë¡£
=randarray(5,6,0,100,true)¤ÈÆþÎϤ·¤Æ¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¡£
5¹Ô¡¢6Îó¤ÎÈϰϤË0¡Á100¤ÎÍð¿ô¡ÊÀ°¿ô¡Ë¤¬ÆþÎϤµ¤ì¤¿¡£
¤Ê¤ª¡¢¤³¤Î¤Þ¤Þ¤À¤È¡¢¥·¡¼¥È¤¬¹¹¿·¤µ¤ì¤¿¤È¤¡Ê¤É¤³¤«¤Î¥»¥ë¤Ë¿·¤·¤¤¥Ç¡¼¥¿¤¬ÆþÎϤµ¤ì¤¿¤ê¡¢¥Ç¡¼¥¿¤¬ºï½ü¤µ¤ì¤¿¤ê¤·¤¿¤È¤¡Ë¡¢RANDARRAY´Ø¿ô¤òÆþÎϤ·¤¿¥»¥ë¤â¹¹¿·¤µ¤ì¤Æ¿ôÃͤ¬ÊѲ½¤·¤Æ¤·¤Þ¤¦¡£
¤³¤Î¤¿¤á¡¢ºÇ½é¤ËÆÀ¤é¤ì¤¿·ë²Ì¤ò¥¡¼¥×¤¹¤ë¤Ë¤Ï¡¢·ë²Ì¤ò¥³¥Ô¡¼¤·¤Æ¡¢Æ±¤¸ÈϰϤ⤷¤¯¤ÏÊ̤ÎÈϰϤËÃͤÀ¤±Å½¤êÉÕ¤±¤¹¤ëɬÍפ¬¤¢¤ë¡£¼ÂºÝ¤ÎÁàºî¤Ï¼¡¤Î¤è¤¦¤Ë¤Ê¤ë¡£
RANDARRAY´Ø¿ô¤ÇÍð¿ô¤ò¼«Æ°ÆþÎϤ·¤¿ÈϰϤòÁªÂò¤·¡¢¡ÎCtrl¡Ï+¡ÎC¡Ï¤Ç¥¯¥ê¥Ã¥×¥Ü¡¼¥É¤Ë¥³¥Ô¡¼¤¹¤ë¡£
Ê̤Υ»¥ë¤Ë°ÜÆ°¤·¡¢±¦¥¯¥ê¥Ã¥¯¤·¤Æ¥á¥Ë¥å¡¼¤Î¡ÎŽ¤êÉÕ¤±¤Î¥ª¥×¥·¥ç¥ó¡Ï¤Ç¡ÎÃ͡ϤòÁªÂò¤¹¤ë¡£
Íð¿ô¤ÎÃͤÀ¤±¤¬Å½¤êÉÕ¤±¤é¤ì¤ë¡£¤³¤ì¤Ç¿ô»ú¤¬ÊѲ½¤¹¤ë¤³¤È¤Ê¤¯¸ÇÄꤵ¤ì¤ë¡£¤Ê¤ª¡¢¥»¥ë¤Ë¿·¤¿¤Ê¥Ç¡¼¥¿¤¬ÆþÎϤµ¤ì¤¿¤Î¤Ç¡¢ºÇ½é¤ËRANDARRAY´Ø¿ô¤ÇÆþÎϤ·¤¿Íð¿ô¤ÏÊѲ½¤¹¤ë¡£
¤Ê¤ª¡¢RANDARRAY´Ø¿ô¤ò°ú¿ô¤Ê¤·¤ÇÆþÎϤ·¤¿¾ì¹ç¤Ï¡¢¤½¤Î¥»¥ë¤Ë0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¡£¤Þ¤¿¡¢Excel 2016¤Î±Ê³¥é¥¤¥»¥ó¥¹ÈÇ¡¢Excel 2019¤Î±Ê³¥é¥¤¥»¥ó¥¹ÈǤǤÏRANDARRAY´Ø¿ô¤ÏÍøÍѤǤ¤Ê¤¤¤è¤¦¤Ê¤Î¤ÇÃí°Õ¤·¤¿¤¤¡£
¡üGoogle¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ë¤âRANDARRAY´Ø¿ô¤ÏÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡¢¤¿¤À¤·¡Ä¡Ä
RANDARRAY´Ø¿ô¤ÏGoogle¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ë¤âÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡£¤¿¤À¤·¡¢»ØÄê¤Ç¤¤ë°ú¿ô¤Ï¹Ô¤ÈÎó¤Î2¤Ä¤À¤±¤À¡£
=RANDARRAY (¹Ô,Îó)
Excel¤Î¤è¤¦¤Ë¡¢ºÇÂçÃͤäºÇ¾®Ãͤò»ØÄꤹ¤ë¤³¤È¤Ï¤Ç¤¤Ê¤¤¡£¤Ê¤ª¡¢°ú¿ô¤ò¾Êά¤¹¤ë¤È¡¢¤½¤Î¥»¥ë¤Ë0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¤Î¤ÏƱ¤¸¤Ç¤¢¤ë¡£
Google¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ç¡Ö=randarray(5,6)¡×¤ÈÆþÎϤ·¤Æ¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¡£
¸½ºß¤Î¥»¥ë¤«¤é5¹Ô¡¢6Îó¤ÎÈϰϤË0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¡£
°æ¾å·ò¸ì¡Ê¥Õ¥ê¡¼¥é¥ó¥¹¥é¥¤¥¿¡¼¡Ë
¿ôÃͤÏŬÅö¤Ç¤¤¤¤¤¬¡¢ËÜʪ¤Ã¤Ý¤¯¸«¤»¤ëɬÍפ¬¤¢¤ë¡Ä¡Ä¤È¤¤¤Ã¤¿¥±¡¼¥¹¤À¡£
¤½¤ó¤Ê¤È¤¡¢º£²ó¾Ò²ð¤¹¤ëRANDARRAY´Ø¿ô¤Î»È¤¤Êý¤ò³Ð¤¨¤Æ¤ª¤±¤Ð¡¢¤¤Ã¤ÈÌò¤ËΩ¤Ä¤À¤í¤¦¡£
¡üRANDARRAY´Ø¿ô¤È¤Ï¡© ¤½¤Î»È¤¤Êý¤Ï¡©
Excel¤ò»È¤Ã¤Æ¤¤¤ë¤È¤¡¢¤È¤ê¤¢¤¨¤ºÅ¬Åö¤Êɽ¤¬É¬Íפˤʤ뤳¤È¤Ï¤Ê¤¤¤À¤í¤¦¤«¡£
À°Îó¤ä¹Ê¤ê¹þ¤ßµ¡Ç½¤ò»î¤·¤¿¤¤¤È¤«¡¢Å¬Åö¤Êɽ¤ò¤â¤È¤Ë¤É¤ó¤Ê¥°¥é¥Õ¤¬ºî¤ì¤ë¤«»î¤·¤¿¤¤¤È¤¤¤Ã¤¿¥±¡¼¥¹¤À¡£
¤½¤¦¤¤¤¦¤È¤¡¢Å¬Åö¤Ê¿ôÃͤòÆþÎϤ·¤Æ¥µ¥ó¥×¥ë¤Îɽ¤òºî¤ë¤³¤È¤Ë¤Ê¤ë¤¬¡¢Å¬Åö¤È¤Ï¤¤¤¨É½¤òºî¤ë¤Î¤Ë¤Ï¼ê´Ö¤¬¤«¤«¤ë¡£Â礤¤É½¤Ë¤Ê¤ë¤È¤Ê¤ª¤µ¤é¤À¡£
¤½¤ó¤Ê¤È¤ÊØÍø¤Ê´Ø¿ô¤¬ RANDARRAY´Ø¿ô¤Ç¤¢¤ë¡£»È¤¤Êý¤Ï¼¡¤Î¤È¤ª¤ê¤À¡£
=randarray(¹Ô,Îó,ºÇÂçÃÍ,ºÇ¾®ÃÍ,¼ïÎà)
¤¿¤È¤¨¤Ð¡¢
=randarray(5,6,0,100,true)
¤ÈÆþÎϤ¹¤ì¤Ð¡¢ÆþÎÏ°ÌÃ֤Υ»¥ë¤«¤é5¹Ô¡¢6Îó¤ÎÈϰϤˡ¢0¤«¤é100¤Þ¤Ç¤ÎÍð¿ô¡ÊÀ°¿ô¡Ë¤ò¼«Æ°Åª¤ËÆþÎϤ¹¤ë¡£ºÇ¸å¤Î¼ïÎà¤Ïtrue¤À¤ÈÀ°¿ô¡¢false¤À¤È¾®¿ô¤Ë¤Ê¤ë¡£
=randarray(5,6,0,100,true)¤ÈÆþÎϤ·¤Æ¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¡£
5¹Ô¡¢6Îó¤ÎÈϰϤË0¡Á100¤ÎÍð¿ô¡ÊÀ°¿ô¡Ë¤¬ÆþÎϤµ¤ì¤¿¡£
¤Ê¤ª¡¢¤³¤Î¤Þ¤Þ¤À¤È¡¢¥·¡¼¥È¤¬¹¹¿·¤µ¤ì¤¿¤È¤¡Ê¤É¤³¤«¤Î¥»¥ë¤Ë¿·¤·¤¤¥Ç¡¼¥¿¤¬ÆþÎϤµ¤ì¤¿¤ê¡¢¥Ç¡¼¥¿¤¬ºï½ü¤µ¤ì¤¿¤ê¤·¤¿¤È¤¡Ë¡¢RANDARRAY´Ø¿ô¤òÆþÎϤ·¤¿¥»¥ë¤â¹¹¿·¤µ¤ì¤Æ¿ôÃͤ¬ÊѲ½¤·¤Æ¤·¤Þ¤¦¡£
¤³¤Î¤¿¤á¡¢ºÇ½é¤ËÆÀ¤é¤ì¤¿·ë²Ì¤ò¥¡¼¥×¤¹¤ë¤Ë¤Ï¡¢·ë²Ì¤ò¥³¥Ô¡¼¤·¤Æ¡¢Æ±¤¸ÈϰϤ⤷¤¯¤ÏÊ̤ÎÈϰϤËÃͤÀ¤±Å½¤êÉÕ¤±¤¹¤ëɬÍפ¬¤¢¤ë¡£¼ÂºÝ¤ÎÁàºî¤Ï¼¡¤Î¤è¤¦¤Ë¤Ê¤ë¡£
RANDARRAY´Ø¿ô¤ÇÍð¿ô¤ò¼«Æ°ÆþÎϤ·¤¿ÈϰϤòÁªÂò¤·¡¢¡ÎCtrl¡Ï+¡ÎC¡Ï¤Ç¥¯¥ê¥Ã¥×¥Ü¡¼¥É¤Ë¥³¥Ô¡¼¤¹¤ë¡£
Ê̤Υ»¥ë¤Ë°ÜÆ°¤·¡¢±¦¥¯¥ê¥Ã¥¯¤·¤Æ¥á¥Ë¥å¡¼¤Î¡ÎŽ¤êÉÕ¤±¤Î¥ª¥×¥·¥ç¥ó¡Ï¤Ç¡ÎÃ͡ϤòÁªÂò¤¹¤ë¡£
Íð¿ô¤ÎÃͤÀ¤±¤¬Å½¤êÉÕ¤±¤é¤ì¤ë¡£¤³¤ì¤Ç¿ô»ú¤¬ÊѲ½¤¹¤ë¤³¤È¤Ê¤¯¸ÇÄꤵ¤ì¤ë¡£¤Ê¤ª¡¢¥»¥ë¤Ë¿·¤¿¤Ê¥Ç¡¼¥¿¤¬ÆþÎϤµ¤ì¤¿¤Î¤Ç¡¢ºÇ½é¤ËRANDARRAY´Ø¿ô¤ÇÆþÎϤ·¤¿Íð¿ô¤ÏÊѲ½¤¹¤ë¡£
¤Ê¤ª¡¢RANDARRAY´Ø¿ô¤ò°ú¿ô¤Ê¤·¤ÇÆþÎϤ·¤¿¾ì¹ç¤Ï¡¢¤½¤Î¥»¥ë¤Ë0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¡£¤Þ¤¿¡¢Excel 2016¤Î±Ê³¥é¥¤¥»¥ó¥¹ÈÇ¡¢Excel 2019¤Î±Ê³¥é¥¤¥»¥ó¥¹ÈǤǤÏRANDARRAY´Ø¿ô¤ÏÍøÍѤǤ¤Ê¤¤¤è¤¦¤Ê¤Î¤ÇÃí°Õ¤·¤¿¤¤¡£
¡üGoogle¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ë¤âRANDARRAY´Ø¿ô¤ÏÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡¢¤¿¤À¤·¡Ä¡Ä
RANDARRAY´Ø¿ô¤ÏGoogle¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ë¤âÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¡£¤¿¤À¤·¡¢»ØÄê¤Ç¤¤ë°ú¿ô¤Ï¹Ô¤ÈÎó¤Î2¤Ä¤À¤±¤À¡£
=RANDARRAY (¹Ô,Îó)
Excel¤Î¤è¤¦¤Ë¡¢ºÇÂçÃͤäºÇ¾®Ãͤò»ØÄꤹ¤ë¤³¤È¤Ï¤Ç¤¤Ê¤¤¡£¤Ê¤ª¡¢°ú¿ô¤ò¾Êά¤¹¤ë¤È¡¢¤½¤Î¥»¥ë¤Ë0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¤Î¤ÏƱ¤¸¤Ç¤¢¤ë¡£
Google¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤Ç¡Ö=randarray(5,6)¡×¤ÈÆþÎϤ·¤Æ¡ÎEnter¡Ï¥¡¼¤ò²¡¤¹¡£
¸½ºß¤Î¥»¥ë¤«¤é5¹Ô¡¢6Îó¤ÎÈϰϤË0¡Á1¤ÎÍð¿ô¤¬ÆþÎϤµ¤ì¤ë¡£
°æ¾å·ò¸ì¡Ê¥Õ¥ê¡¼¥é¥ó¥¹¥é¥¤¥¿¡¼¡Ë