Excelでの条件付きロジット・モデル・チュートリアル

ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTTAçµ±è¨è§£æã½ããã¦ã¨ã¢ãç¨ãã¦Excelã§æ¡ä»¶ä»ããã¸ããåæ ãã»ããã¢ãããã¦è§£éãããã¨ãæ¯æ´ãã¾ãã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ï¼conditional logit modelï¼ã¯ããã¸ã¹ãã£ãã¯åå¸°ã«ä¼¼ãçµ±è¨ææ³ã§ãã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ã¯ãã»ã¨ãã©ã®å ´åãã³ã³ã¸ã§ã¤ã³ãåæã®ä¸é¨ã¨ãã¦ããã®é²åããå½¢ã§ä½¿ç¨ãããææ³ã§ãããç¹å®ã®ã¿ã¤ãã®ãã¼ã¿ãåæããã¨ãã«ä¾¿å©ã§ãã

ãã®ã¢ãã«ãææ¡ããã®ã¯ãMcFadden (1973) ã§ããåäººãã¨ã«1è¡ã§ã¯ãªããä»£æ¡ã®æ°ã ãè¡ãã§ãã¾ãããããã£ã¦ã ã¢ãã«ãããã®ã¯ãåäººã®ç¹å¾´ã§ã¯ãªãã¦ããããã®ä»£æ¡ã§ãã

äº¤éææ®µãèª¿æ»ãããã¨ããå ´åã4ã¤ã®äº¤éææ®µï¼car / train / air / busï¼ããããåäº¤éææ®µã«ã¯ããããç¹å¾´ï¼price, speedï¼ãããã¾ãããåäººã¯4ã¤ã®äº¤éææ®µã®1ã¤ã ããé¸ã¹ã¾ãã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ã§ã¯ãNäººã®åäººã«ã¤ãã¦ã4ã¤ã®é¸æè¢ã«é¢é£ã¥ãããã4è¡ã§ãN*4è¡ã®ãã¼ã¿ãç¨ãã¾ãã ãã¤ããªå¿çå¤æ°ã¯ãåäººã®é¸æï¼1ï¼ãç¤ºããåäººããã®ãªãã·ã§ã³ãé¸æããªãå ´åã¯ï¼ãç¤ºãã¾ãã.

åäººã®ååã«é¢ããåï¼æã ã®äºä¾ã§ã¯ãåäººãã¨ã«4è¡ï¼ããXLSTATå ã§é¸æãããªããã°ãªãã¾ãããèª¬æå¤æ°ã N * 4 è¡ã«ãªãã¾ãã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ã®ããã®ãã¼ã¿ã»ãã

ä»¥ä¸ã§è°è«ããäºä¾ã¯ããã±ã¼ã·ã§ã³ã«è¡ãããã®äº¤éææ®µãæ¯è¼ãããã¨ããä¼çµ±çãªäºä¾ã§ããåºå ¸ã¯ãGreene, W.H. (2003). Econometric Analysis, 5th edition. Upper Saddle River, NJ: Prentice Hallã§ãã

ãã¼ã¿ã¨çµæãå«ãExcelãã¡ã¤ã«ã¯ããã¡ããã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ãã

ãã¼ã¿ã¯ã210äººã®åäººã§ããããã4ã¨ããï¼air, car, bus, trainï¼ã®é¸æãããã¾ãã æã ã¯ãå½¼ãã®ããããã«ãã±ã¼ã·ã§ã³ã«è¡ãããã«é¸ã¶ã§ãããäº¤éææ®µãè³ªåãã¾ãã

ãã¼ã¿éåã¯ã840è¡ããã¾ããæåã®åã¯åäººãèå¥ãã2çªç®ã®åã¯äº¤éææ®µãã¢ãã«ãããã¤ããªå¤æ°ã§ããããã¦ãååäººãã¨ã«åäº¤éææ®µã«é¢ãã¦ããããã2ã¤ã®éçå¤æ°ãå ¨ä½ã®ã³ã¹ãã¨ç§»åä¸ã®å¾ ã¡æéãããã¾ããæå¾ã«ãäº¤éææ®µã«é¢ããã«ãã´ãªå¤æ°ãæå¾ã®è¡ã«ããã¾ãï¼air, train, bus or carï¼ã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ã®è¨å®

ãã¤ã¢ãã°ã»ããã¯ã¹ãèµ·åããã«ã¯ãXLSTATãèµ·åãã¦ãããã¦ãXLSTAT / XLSTAT-CJTÂ / æ¡ä»¶ä»ããã¸ãã ãé¸æããããXLSTAT-CJTãã¼ã«ãã¼ã®å¯¾å¿ãããã¿ã³ï¼ä¸å³ï¼ãã¯ãªãã¯ãã¦ãã ããã

ãã¿ã³ãã¯ãªãã¯ããã¨ããã¤ã¢ãã°ã»ããã¯ã¹ãç¾ãã¾ãã

Excelã·ã¼ãä¸ã§ãã¼ã¿ãé¸æãã¦ãã ããã

å¿çå¤æ°ã¯ããã¤ããªå¤æ°ã§ããè¢«é¨è ã©ãã«ãåäººã«é¢é£ã¥ããããæ°åã§ãï¼åäººã®ååãä½¿ç¨ãããã¨ãã§ãã¾ãï¼ãæã ã®äºä¾ã§ã¯ã3ã¤ã®äºæ¸¬å¤æ°ãããã¾ãã1ã¤ã®è³ªçå¤æ° - äº¤éææ®µ - ããã³2ã¤ã®éçå¤æ° - å ¨ä½ã³ã¹ãã¨å¾ ã¡æéãå¤æ°ã®ã©ãã«ãé¸æããã®ã§ã**å¤æ°ã©ãã«**ãªãã·ã§ã³ãé¸æããªããã°ãªãã¾ããã

OKãã¿ã³ãã¯ãªãã¯ããã¨ãè¨ç®ãå®è¡ããã¦ãçµæãè¡¨ç¤ºããã¾ãã

æ¡ä»¶ä»ããã¸ããã»ã¢ãã«ã®çµæã®è§£é

ä»¥ä¸ã®è¡¨ã¯ãã¢ãã«ã®åè³ªï¼ã¾ãã¯é©ååº¦ï¼ã®è¤æ°ã®ææ¨ãä¸ãã¾ãããããã®çµæã¯ãRÂ²ã¨ãç·å½¢åå¸°ãANOVAã®åæ£åæè¡¨ã«ä¼¼ã¦ãã¾ããæãéè¦ãªå¤ã¯ãlogæ¯(LR)ã«é¢ããã«ã¤2ä¹ã§ããããã¯ãFisherã®ç·å½¢ã¢ãã«ã®Fæ¤å®ã«ç¸å½ãã¾ãï¼å¤æ°ããã¤ããªå¤æ°ã®å¤åãèª¬æããææãªæ å ±éãæä¾ãããå¦ããè©ä¾¡ãããã¨ãã¾ããæã ã®äºä¾ã§ã¯ããã®ç¢ºçã0.0001ããå°ããã®ã§ãæã ã¯ãå¤æ°ãææãªæ å ±éãæä¾ããã¨çµè«ã¥ãã§ãã¾ãã

ãããã®é©ååº¦çµ±è¨éã¯ãæã ã®ã¢ãã«ããä½ãäºæ¸¬å¤æ°ããªãã¢ãã«ãããææã«åªãã¦ãããã¨ãç¤ºãã¦ãã¾ããä»¥ä¸ã®è¡¨ã¯ããããã®æåã®å°è±¡ãç¢ºèªãã¾ãï¼

på¤ããã¹ã¦ã¨ã¦ãå°ããã3ã¤ã®å¤æ°ã®å½±é¿åº¦ãtype III åæè¡¨ã§ææã§ãã

æå¾ã«ãã¢ãã«ã®ä¿æ°ã¯ãairï¼é£è¡æ©ï¼ãå¥½ã¾ãããã¨ãå¾ ã¡æéãäº¤éææ®µã®é¸æã§ææã«è² ã®å¹æãæã¤ãã¨ãç¤ºãã¦ãã¾ãã

æ®å·®ã®åæãä¾¿å©ã§ãåäººã®é¸æã«é¢ããä»ã®æ å ±ãæä¾ãã¾ãã

ãååããã¯ããã¤ã³ãã¦ã¨ã¢ç·ç ã¸ã

Â

Was this article useful?

Yes
No

Similar articles

A complete add-in for Microsoft Excel