ExcelでのSTATIS分析

ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTATçµ±è¨è§£æã½ããã¦ã§ã¢ãç¨ãã¦ãExcelå ã§STATIS ãå®è¡ãã¦è§£éããæ¹æ³ãç¤ºãã¾ãã

STATIS åæãå®è¡ãããã¼ã¿ã»ãã

ãã¼ã¿ã¨çµæã®Excelã·ã¼ãã¯ãä¸ã®ãã¿ã³ãã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ã: ãã¼ã¿ããã¦ã³ãã¼ã ãã¼ã¿ã¯ãAGROCAMPUS OUESTã«ãããã©ã³ã¹ã®ã¬ã³ãã§å®æ½ãããprojective mapping / Nappingç ç©¶ã§ãã8 ç¨®é¡ã®ã¹ã ã¼ã¸ã¼ã24 äººã®è¢«é¨è ï¼ãããªã¹ãï¼ã«ãã£ã¦ãã¼ã¹ãããããã¼ãã«ã¯ãã¹ã®ä¸ã«ç½®ããã¾ãããSTATIS åæã®ããã«åº§æ¨ãåéããã¾ããããããªã¹ãã2ã¤ã®è£½åãé¡ä¼¼ãã¦ããã¨ã¿ãªããã¾ããå¾è ããã¼ãã«ã¯ãã¹ä¸ã§è¿ãã«ç½®ããããããã£ã¦ããããã¯é¡ä¼¼ããåº§æ¨ãæã¡ã¾ããå ã®ãã¡ã¤ã«ã¯ãR SensoMineR ããã±ã¼ã¸ã§å¾ããã¾ãã

ãã®ãã¥ã¼ããªã¢ã«ã®**ç®ç**ã¯ãã¹ã ã¼ã¸ã¼éã®ãªã³ã¯ãèª¿æ»ãã¦å¯è¦åãããã¨ãããã³ãè¢«é¨è å®ã®åæãå¤å®ãããã¨ã§ãã

STATISæ³ã¨ã¯ä½ã?

STATISæ³ã¯ãå®è½åæã§ããä½¿ç¨ããããã«ãã»ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã»ãã¼ã¿åæã§ãã ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ãããã¾ãã¾ãªæ»å®äººãè¢«é¨è ãã¾ãã¯å¯©æ»å¡ã«æç¤ºããã¾ãããã®ææ³ã¯ãã¨ãã«projective mapping / Napping, conventional profilingã¾ãã¯ free choice profilingã§ä½¿ç¨ã§ãã¾ããSTATISã®æå¤§ã®é¢å¿äºã¯ã éå ¸åã®ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ãä¸å¿çãªã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã®éã¿ãããå°ããªéã¿ãæã¤ãã¨ã§ãããããã£ã¦ãåæã¯ éå ¸åã®ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã§ã¯ãªããä¸è¬çãªè¦ç¹ãæãããåæ ãã¾ãã

XLSTATã§ã®STATISåæã®ã»ããã¢ãã

STATISãã¤ã¢ãã°ã»ããã¯ã¹ãæå¹ã«ããã«ã¯ãXLSTATãèµ·åãã¦ãé«åº¦ãªæ©è½ /å®è½ãã¼ã¿åæ/STATISãé¸æãã¦ãã ããã STATISãã¤ã¢ãã°ã»ããã¯ã¹ãç¾ãã¾ãã

ãã¢ã»ãã¡ã¤ã«ã® Excelã·ã¼ãã§ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã«å¯¾å¿ãããã¼ã¿ãé¸æãã¦ãã ããï¼ããã§ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã¯ãè¢«é¨è ã«ãã£ã¦ä¸ããããåº§æ¨ã®éåï¼ã ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã®æ°ã24ã«è¢«é¨è ã«çããè¨å®ãã¦ãã ãããÂ

åã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã¯2ã¤ã®å¤æ°ãæã¤ã®ã§ã**çãã**ãªãã·ã§ã³ãé¸æãã¦ãå¤æ°ã®æ°ãä¸å®ã§ãããã¨ãXLSTATã«ç¥ããããã¨ãã§ãã¾ãã å°ãªãã¨ã1ã¤ã®ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã§å¤æ°ã®æ°ãç°ãªãå ´åã¯ãåã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ã§ã®å¤æ°ã®æ°ãæ ¼ç´ããåãé¸æããå¿ è¦ãããã¾ãã

æå¾ã«ããªãã·ã§ã³**å¤æ°ã©ãã«ã¨ãªãã¸ã§ã¯ãã»ã©ãã«**ï¼æã ã®äºä¾ã§ã¯ã¹ã ã¼ã¸ã¼ï¼ãæå¹ã«ãã¾ãã

ãªãã·ã§ã³ã¿ãã§ã¯ãå°ºåº¦å¹æãé¿ããããã«ã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³ãå ¨ä½çã«ç¸®å°ºãããã¨ãé¸ã³ã¾ãã ãã¹ã¦ã®å¤æ°ã¯åã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³å ã§åãå°ºåº¦ã«ããã®ã§ãå¤æ°ãç¸®å°ºãããã¨ã¯ããã»ã©å¿ è¦ã§ã¯ããã¾ããã

**åºå**ã¿ãã§ã¯ãRVè¡åãããã³ãã³ã³ãã£ã®ã¥ã¬ã¼ã·ã§ã³éã®RVãè¢«é¨è éã®è¿æ¥ã®ææ¨ãæã¤ã³ã³ã»ã³ãµã¹ãè¡¨ç¤ºããããã«é¸ã³ã¾ãã

OKãã¯ãªãã¯ããã¨è¨ç®ãå§ã¾ãã¾ãã ãããããè¡¨ç¤ºããããè»¸ãç¢ºèªãã¦ãã ããããã®äºä¾ã§ã¯ãæåã®2ã¤ã®å åã§è¡¨ç¾ãããå¤åã®ãã¼ã»ã³ãã¼ã¸ãããã»ã©é«ãããã¾ãã (68.43%); çµæã®èª¤è§£éãé¿ããããã«ãæã ã¯ãè»¸ 1 ã¨ 3ã«é¢ãã2ã¤ç®ã®ãã£ã¼ãã§çµæãè£å®ãããã¨ã«ãã¾ããã

STATIS åæã®çµæã®è§£é

ä¸ã®ã°ã©ãã¯STATISã®ä¸»è¦ãªãªãã¸ã§ã¯ãã§ãï¼ãªãã¶ãã¼ã·ã§ã³ã2æ¬¡å ã®ãããã«è¡¨ç¾ãããã¦ãããã¦ãè¿æ¥é¢ä¿ãèå¥ãã¾ãããã¨ãã°ã"Casino_PBC" ã¨ "Innocent_PBC" ã¯è¿ãã¨ã¹ã ã¼ãºã«èªèããã¾ããããããã¯"Casino_SRB"ããã¯ã¨ã¦ãç°ãªãã¾ããç¬¬3æ¬¡å ã§ã¯ã Carrefour_SB ã "Casino_PBC"ã"Innocent_PBC"ã"Immedia_SRB"ã"Casino_SRB"ã¨ã¯å ¨ä½çã«åå¯¾ã§ãããã¨ããããã¾ãã ããæã ã2äººã®ç¹å®ã®è¢«é¨è ï¼ãããªã¹ãï¼ã«èå³ãæã¤ãªããåè¢«é¨è éã®RVä¿æ°ãä¸ããRVè¡åãèª¿ã¹ããã¨ãæç¨ã§ãï¼ãã®ä¿æ°ã¯ã0 ãã 1ã®éã§ãè¢«é¨è ãè¿æ¥ãã¦ããã»ã©å¤§ãããªãã¾ãï¼ãããã§ãæã ã¯ãWe see here that è¢«é¨è 1 ãè¢«é¨è 2ã«ã¨ã¦ããé¡ä¼¼ããæè¦ãæã¡ã¾ãããè¢«é¨è 4ï¼ããã®ä»ã®å¤ãã®è¢«é¨è ã«å¯¾ãã¦ä½ãRVå¤ãæã¤ï¼ããã¯ã¨ã¦ãç°ãªããã¨ããããã¾ãã 1äººã®è¢«é¨è ã®ä»ã®ãã¹ã¦ï¼ããªãã¡ãã³ã³ã»ã³ãµã¹ã«ãã£ã¦åæ ãããå ¨ä½çè¦ç¹ï¼ã«å¯¾ããè¿æ¥é¢ä¿ãè©ä¾¡ãããã¨ãã¨ã¦ãéè¦ããããã¾ããããããã£ã¦ãä¸ã®æ£ã°ã©ãã¯ãè¢«é¨è 4 ã¯ã18 ã 23ã¨ã¯ç°ãªããããªãéå ¸åã®è¢«é¨è ã§ãããã¨ãç¤ºãã¦ãã¾ãã æå¾ã«ãä¸ã®ã°ã©ãã¯ããªãã¸ã§ã¯ããã¨ã®æ®å·®ã§ãããã¯ã©ã®ãªãã¸ã§ã¯ããè¢«é¨è ã«ãã£ã¦åãããã«ä½ç½®ã¥ããããããç¤ºãã¾ããã¹ã ã¼ã¸ã¼ "Innocent_PBC"ã®ããã«ãããã¨ãããªãéã£ã¦ãã¹ã ã¼ã¸ã¼"Carrefour_SB"ã®ããã«ã

Was this article useful?

Yes
No

Similar articles

A complete add-in for Microsoft Excel