
ãåæãã£ãè±åŽãããŒã¿éãã§çµããããªãïŒææãšæææ±ºå®ã«ç¹ãããå®è·µã®åãå®å šç
ð¡ ãããªç¶æ³ã«å¿åœããã¯ãããŸãããïŒ
ã»Excelã§ã°ã©ããäœã£ãã®ã«ãäžåžãããã§ãäœãèšãããã®ïŒããšè¿ããã ã»R²ãçžé¢ä¿æ°ã®æå³ã¯ããããã§ããã ããäœïŒãã®å ãåºãŠããªã ã»ããŒã¿ã¯æããã®ã«ãæææ±ºå®ããã€ã"æèŠ"ã«é Œã£ãŠãã
ããã²ãšã€ã§ãåœãŠã¯ãŸããªãããã®ææã¯ããªãã®ããã«æžããŸããã
ããŒã«ãç¥ãããšãšã䜿ãããªãããšã¯ãŸã£ããå¥ã®è©±ã§ããExcelãPythonã§æ£åžå³ãæãã人ã¯å¢ããŠããŸãããããããã®åæçµæã䜿ã£ãŠãå®éã«æææ±ºå®ãå€ããããäžåžã圹å¡ã説åŸããããšèšãã人ã¯ã©ããããããã§ããããã
æ¬ææãè§£æåã»å®è·µç·šãã§ã¯ãåãªãç¥èã§çµããããªãããã®å®åçŽçµã«ãªãã¥ã©ã ããçšæããŸããã
ãã®ã¯ãŒã¯ïŒå®è·µè¬åº§ïŒãæã«å ¥ããããšã§ãããªãã¯ãããŒã¿ã§çµç¹ãçµå¶ãåããå§åçãªè§£æåããæã«ããããšãã§ããŸããæ°å€ã®è§£éã«å¯Ÿããäžå®ãæ«ææãè©äŸ¡ã«ç¹ãããªãã¹ãã¬ã¹ã¯å®å šã«è§£æ¶ãããçµç¹å ã§ã®ç¢ºåºããäž»å°æš©ãšå§åçãªåžå ŽäŸ¡å€ã»ææãšããçæ³ã®æªæ¥ãžäžæ°ã«è¿ã¥ãããšããçŽæããŸãã
ð æ¬ææã§æã«å ¥ã4ã€ã®æŠåš
æ¬ææããè³Œå ¥ããã ããšã以äžã®ããã®ãŸãŸäœ¿ãã宿ŠçšããŒã«ãšå®è·µç°å¢ããä»ããæã«å ¥ããããšãã§ããŸãã
ã忢±ç¹å žäžèЧã
ã»ðãå®è·µãå š28çš®ã®å®è·µã«ãªãã¥ã©ã ããŒã¿éžå®ã»è§£éãã¬ãŒã ã»æææ±ºå®ãžã®æ¥ç¶ãŸã§ãå®åã«å¿ èŠãªææ³ãäœç³»åãéã»çœéã»éã»æ¥çµå¹³åã®å®ããŒã¿ïŒ12幎åïŒã䜿ã£ãŠåŸ¹åºè§£åããŸãã
ã»ðãå³å¹ããã³ãã¬ãŒãïŒãã§ãã¯ãªã¹ã 仿¥ããçŸå Žã§äœ¿ããå®åçšãã³ãã¬ãŒãã忢±ããSo What?ãã飿ããŠè¡åã«ç¹ããå®å šæé ãããã«å®è·µã§ããå ±åäœæ¥ã®æ©ã¿ãè§£æ¶ããŸãã
ã»â ïžãææä¿èšŒãæåäºäŸã«åºã¥ãåçŸæ§ã®é«ã解説 å€ãå€ãæ¬äŒŒçžé¢ãšãã£ãã5ã€ã®å€±æãã¿ãŒã³ãã®åé¿æ³ãšãæææ±ºå®ã«å€æãããCCARãã¬ãŒã ãã§ã確å®ã«ææãžç¹ããŸãã
ã»ð¬ãéå®ãã³ãã¥ããã£åå æš©ïŒè³ªåæš© è³Œå ¥è éå®ã®ã³ãã¥ããã£ãžãæ¡å ãçåç¹ã¯çŽæ¥è³ªåããŠè§£æ¶ã§ãããããéäžã§æ«æãããŸããã
ð å š5ç« ã®æ§æ
ã第1ç« ãããŒã¿åéã®æèæ³ ã»äœãéããããç²åºŠïŒæé軞ïŒã®éžã³æ¹ãé 眮èšèšãŸã§ ã»ãéããåã«ä»®èª¬ãæã€ãç¿æ £ãç¿åŸããç¡é§ãªäœæ¥ãå®å šãŒãå
ã第2ç« ãæ£åžå³ãšçžé¢ä¿æ°ã®æ·±èªã¿è¡ ã»R²ã ããçãã§ã¯ãªããåŸãã»æ®å·®ã»æç³»åã®3ç¹èªã¿ ã»å®åã§äžç®çœ®ãããå€å®åºæºè¡šãåé²
ã第3ç« ãåæãããã«æ·±åãããçºå±ææ³ ã»çžé¢è¡åã»ã©ã°åæã»ç§»åå¹³åã«ãããã€ãºé€å» ã»ç«¶åãã©ã€ãã«ã«äžæ©å·®ãã€ããããã®å¿çšææ³
ã第4ç« ã倱æããªãããã®ã5ã€ã®çœ ã ã»èŠãããã®çžé¢ãå€ãå€ã®èŠèœãšããçžé¢ãšå æã®æ··å ã»å®åã§é¥ããããèœãšã穎ã培åºè§£èª¬ããåæã®ç²ŸåºŠã極éãŸã§åäž
ã第5ç« ãåæçµæãæææ±ºå®ã«ç¹ãã ã»CCARãã¬ãŒã ã«ããå ±åè¡ãšä»æ¥çš®ãžã®æšªå±é ã»åãªãåæããäŒç€Ÿãåããææãã«å€ããæçµç«
ð¯ ãããªæ¹ã«èªãã§ã»ãã
ã»ãæè¡ç·šããèªã¿ããæ¬¡ã®ã¹ãããïŒå®è·µïŒããæ¢ããŠããæ¹ ã»è·å Žã§ããŒã¿ã䜿ã£ãŠèª¬åŸåããææ¡ããã瀟å è©äŸ¡ã幎åãåçã«é«ãããæ¹ ã»è³ç£éçšã»æè³å€æã«å®éçãªæ ¹æ ãæã¡èŸŒã¿ãåçŸæ§ã®ããææãåºãããæ¹
â»ã泚æïŒæ¬ææã¯ãæè¡ç·šãïŒæ£åžå³ã®äœãæ¹ã»R²ã®åºç€ïŒã®å 容ãåæãšããŠããŸããæªèªã®æ¹ã¯ã»ããã§ã®ã掻çšãããããããŸãã
èè ã·ã³ããã®ã¡ãã»ãŒãž
ãããŒã¿ã§èªãã人ãã¯ãã©ã®çµç¹ã§ãå§åçã«å°æ°æŽŸã§ããã ãããããæ£ãããåãã身ã«ã€ããç¬éã«çªãæããããšãã§ããŸãã
ããŒã¿ãã£ãã»åæãã£ãã®åãæãåºããªãæ©ã¿ã¯ããã®å®è·µç·šã§ãæå¿æ±ºå®ã«å€ããå šææ³ããæã«ããã°ä»æ¥ã§çµãããŸãã
äŒç€Ÿã®æææ±ºå®ãå·Šå³ããååšãšãªããããªãã®æã§çæ³ã®è©äŸ¡ã»ææã»ãã£ãªã¢ãæŽã¿åã£ãŠãã ããã
äžèšããããã²æ¬ç·šããåãåããã ãããä»ãããã®ãå®è·µã¡ãœããããæã«å ¥ããŠãäžæ°ã«çæ³ã®æªæ¥ãžãšé§ãäžãããŸãããã
ð ãè§£æãã¯ããã¯ãèŠãã
ãã®èšäºãå°ãã§ãåèã«ãªã£ããããã¹ãããããã©ããŒããããã ãããšå€§å€å±ã¿ã«ãªããŸãïŒ
èè
ïŒã·ã³ïœæœåšæèÃãã£ãªã¢ã¢ããã€ã¶ãŒ
ãæèã®æ çµã¿ïŒæœåšæèïŒãã¢ããããŒãããŠè¡ååãççºãããé«åºŠãªããŒã¿è§£æïŒããžãã¯ïŒã§çµç¹ãæè³ã®æææ±ºå®ãåããå®æŠæŽŸã¢ããã€ã¶ãŒãã