Multiple Correspondence Analysis (MCA) in Excel

ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTATã½ããã¦ã§ã¢ãç¨ãã¦Excelå ã§å¤éã³ã¬ã¹ãã³ãã³ã¹åæãã»ããã¢ãããã¦è§£éãããã¨ãæ¯æ´ãã¾ãã ãããå¿ è¦ã¨ãããæ£ããå¤å¤éãã¼ã¿è§£æãã¼ã«ã§ãããã©ããç¢ºãã§ãªãå ´åã¯ããã¡ãã®ã¬ã¤ããç¢ºèªãã¦ãã ããã

å¤éã³ã¬ã¹ãã³ãã³ã¹åæã¨ã¯?

**å¤éã³ã¬ã¹ãã³ãã³ã¹åæï¼MCAï¼Multiple Correspondence Analysisï¼**ã¯ãè¤æ°ã®è³ªçå¤æ°ã®éã®é¢é£æ§ãèª¿æ»ãããã¨ãå¯è½ããææ³ã§ãã

å¤éã³ã¬ã¹ãã³ãã³ã¹åæã¯ãä¸»æååæãéçå¤æ°ã«ãããã¨ãè³ªçå¤æ°ã«ãã¾ããè³ªçå¤æ°ã®ã«ãã´ãªéããã³ãªãã¶ãã¼ã·ã§ã³éã®è·é¢ãè¦è¦çã«è¦³å¯ã§ããããããå¾ããã¨ãã§ãã¾ãããã®ææ³ã®è©³ç´°ã«ã¤ãã¦ã¯ãMichael Greenacre ããã³ JÃ¶rg Blasiusã«ããææ°ã®æ¸ç±ãæ¨è¦ãã¾ãã

(Amazon.comã§æ³¨æããã«ã¯ãè¡¨ç´ç»åãã¯ãªãã¯ãã¦ãã ããã)

å¤éã³ã¬ã¹ãã³ãã³ã¹åæãå®è¡ãããã¼ã¿ã»ãã

ãã¼ã¿ã¨çµæã®Excelã·ã¼ãã¯ãä¸ã®ãã¿ã³ãã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ãï¼ ãã¼ã¿ããã¦ã³ãã¼ãÂ ãã¼ã¿ã¯ã«ã¼ãã£ã¼ã©ã¼ãå®æ½ããèª¿æ»ã§ãã¯ã«ãã®ä¿®çãããé¡§å®¢28äººã«ã1é±éå¾5ã¤ã®è³ªåããã¦ãã¾ãããã®è³ªåã¯: - ãµã¼ãã¹ã«ã¤ãã¦å ¨ä½çã«æºè¶³ããã¾ãããï¼(Yes/No)

åé¡ã¯è§£æ±ºãããã¨æãã¾ããï¼ (Yes/No/Don't know)
ä¿å¡ã®å¿å¯¾ãã©ã®ããã«è©ä¾¡ããã¾ããï¼ (1 to 5)
åè³ªï¼ä¾¡æ ¼ã®æ¯çã¯æºè¶³ã§ããï¼ (Yes/No)
æã ã®ãµã¼ãã¹ãã¾ããå©ç¨ãªããã¾ããï¼(Yes/No/Don't know)

MCAã®å®è¡ã«ãã£ã¦ãæã ã¯ãã¾ãã¾ãªå¯è½ãªåçã¨è³ªåã®éã®é¢ä¿æ§ãèå¥ãããã®ã§ãã

Â XLSTATã«ããå¤éã³ã¬ã¹ãã³ãã³ã¹åæã®ã»ããã¢ãã

XLSTATãéãã¦ãXLSTATï½**ãã¼ã¿è§£æ**ï½**å¤éã³ã¬ã¹ãã³ãã³ã¹åæ**ã³ãã³ããé¸æãããã "ãã¼ã¿è§£æ"ãã¼ã«ãã¼ï¼ä¸å³ï¼ã®å¯¾å¿ãããã¿ã³ãã¯ãªãã¯ãã¦ãã ããã å¤éã³ã¬ã¹ãã³ãã³ã¹åæãã¤ã¢ãã°ã»ããã¯ã¹ãç¾ãã¾ãã

ãã¼ã¿ã®**å½¢å¼**ã¯ããªãã¶ãã¼ã·ã§ã³/å¤æ°ã§ãããã®ãã£ã¼ã«ãã§åB-Eãé¸æãã¦ãã ããã

**ãªãã¶ãã¼ã·ã§ã³ã»ã©ãã«**ãå¯¾å¿ãããã£ã¼ã«ãã§é¸æãããè¡¨ã®æåã®è¡ã«å¤æ°ã®ååãæ ¼ç´ããã¦ããã®ã§ã**å¤æ°ã©ãã«**ãªãã·ã§ã³ãæå¹ã®ã¾ã¾ã«ãã¾ãã

ãªãã·ã§ã³ã¿ãã§ã¯1/pÂ ãªãã·ã§ã³ããæã ã®ãã£ã«ã¿ãªã³ã°Â é¸æã§ã: åºæå¤ã1/p (ããã§ p ã¯ã¢ã¯ãã£ããªè³ªçå¤æ°ã®æ°)ãããå°ããå åã«å¯¾å¿ããè©³ç´°ãªçµæã¯è¡¨ç¤ºããã¾ããã

**è¿½å ãã¼ã¿ã¿ãã§ã¯: Come backÂ å¤æ°ãè¿½å å¤æ°ã¨ãã¦ä½¿ç¨ãã¾ãããããè¨ç®ã«å½±é¿ãããããªãããã§ã; ãã ãããã®å¤æ°ãã³ã¬ã¹ãã³ãã³ã¹ã»ãããã§ã©ã®ããã«ä½ç½®ã¥ããããããç¥ãããã®ã§ãã ä»¥ä¸ã®åºåããã³ãã£ã¼ã**ãªãã·ã§ãã«çµææå¹ã«ããã¾ããã Â OKãã¯ãªãã¯ããã¨è¨ç®ãå§ã¾ãã¾ãã ããã¦ãçµæãè¡¨ç¤ºããã¾ãã

å¤éã³ã¬ã¹ãã³ãã³ã¹åæã®çµæã®è§£é

1çªç®ã«è¡¨ç¤ºãããçµæã¯ãè¨ç®ã«ä½¿ãããè¡¨ã§ã ï¼å®å ¨åé¢è¡¨ãBurtã®è¡¨ï¼ã

åè¨ã¤ãã¼ã·ã£ã¯2ã«çããã§ããããã¯ãå¤æ°ã¨ã«ãã´ãªã®æ°ã«ã®ã¿ãããå¤æ°éã®é¢ä¿æ§ã«ã¯ããã¾ããããããã£ã¦ãçµ±è¨çãªè§£éã¯ã§ãã¾ããã

æ¬¡ã®è¡¨ã¯ã8åã®éãã«åºæå¤ã¨å¯¾å¿ããã¤ãã¼ã·ã£ã®%ãç¤ºãã¾ãããã ãã CA ï¼2å¤æ°ã®ã¿ã§å®è¡ãããã³ã¬ã¹ãã³ãã³ã¹åæï¼ã¨ã¯ç°ãªããããã§ã®ã¤ãã¼ã·ã£ã® % ã¯ãè¡¨ç¾ã®åè³ªã®æ²è¦³çãªæ¨å®ã§ããè¡¨ç¾ãå®éã«ã©ããããè¿ãããã§ãã ããã¦ãè¡¨ã¯å åç©ºéã«ãããã«ãã´ãªã®åº§æ¨ãè¡¨ç¤ºãã¾ããè¿½å å¤æ°ã«å¯¾å¿ããçµæã¯ãéè²ã§è¡¨ç¤ºããã¾ãã

ãªãã¶ãã¼ã·ã§ã³ã®åº§æ¨ã¯ããã®ä¸ã«è¡¨ç¤ºããã¾ãã

å¯ä¸çããã¹ãå¤ã2ä¹cosããçµæã®è§£éãå©ãã¾ãããããä¸ã§2ã¤ã®ã«ãã´ãªãè¿ãã¦ããè§£éããåã«ããããã®ãããã®è»¸ã¸ã®å¯ä¸çãç¢ºèªãããããããã®2ä¹cosãé«ããã¨ãç¢ºèªããã¹ãã§ãã

ä»¥ä¸ã®3ã¤ã®ãã£ã¼ãã¯ããããããã«ãã´ãªã®ãããããªãã¶ãã¼ã·ã§ã³ã®ããããããã¦ãæåã®2è»¸ä¸ã«ãªãã¶ãã¼ã·ã§ã³ã¨ã«ãã´ãªã®ä¸¡åº§æ¨ãå«ãã§ãããã¤ããããã«å¯¾å¿ãã¾ãã 3ã¤ã®ãã£ã¼ãããé¡§å®¢ãããä»å¨ãæ¥å®¢ããã³ä¾¡æ ¼ã«æºè¶³ããå ´åã ããæ»ã£ã¦ãããã¨ãç¤ºåã§ãã¾ããã¾ãä¿®çãååã§ãªãã£ããã¨ã¨æ¥å®¢ãæª ãã£ããã¨ã®éã«é¢ä¿ããããããªãã¨ã«ãæ°ã¥ãã¾ãã ããã¯ããã«èª¿æ»ãããã¹ãã§ãï¼ æªãæ¥å®¢ãåããã®ã§é¡§å®¢ã¯ååã«æ£ç¢ºãªèª¬æãããªãã£ãã®ããããã¨ãåé¡ãã¾ã ãããã¨ãè¨ãã«æ¥ãäººãä»£çåºã®æªãæ¥å®¢ãåããã®ãï¼

ä»¥ä¸ã®åç»ã¯ããã®ãã¥ã¼ããªã¢ã«ã®å®è¡æ¹æ³ãèª¬æãã¦ãã¾ãã

Was this article useful?

Yes
No

Similar articles

A complete add-in for Microsoft Excel