カイ2乗検定と Fisherの正確検定チュートリアル

ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTATã½ããã¦ã§ã¢ãç¨ãã¦Excelã®åå²è¡¨ã§ãã«ã¤2ä¹æ¤å®ããã³Fisherã®æ£ç¢ºæ¤å® ãã»ããã¢ãããã¦è§£éãããã¨ãæ¯æ´ãã¾ãã ããããæ¢ãã®çµ±è¨çæ¤å®ãã©ããä¸ç¢ºãã§ãã? ãã¡ãã®ã¬ã¤ããç¢ºèªãã¦ãã ããã

åå²è¡¨ã§ã®ã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å®ãå®è¡ããããã®ãã¼ã¿ã»ãã

ãã®ãã¥ã¼ããªã¢ã«ã§ã¯ããã¼ã±ããã»ã¹ã¿ã³ãã§åéããããããã®æ°éãæ ¼ç´ããåå²è¡¨ãç¨ãã¾ãããã®è¡¨ã¯ã2ã¤ã®éçå¤æ°ãã¯ãã¹éè¨ãã¦ãã¾ãï¼åã«ãããã®ç¨®é¡ï¼3 ã«ãã´ãª: 1, 2, 3) ã¨è¡ã«ãããã®ä¸ã®å¯çè«ã®æç¡ï¼2ã«ãã´ãª: presence(ããï¼, absenceï¼ãªãï¼ï¼ãåã»ã«ã¯ãè¡ã¨åã®ã«ãã´ãªã«å¯¾å¿ããçµã¿åããã§ã®ãããã®æ°éãæ ¼ç´ãã¦ãã¾ãã

Contingency table

ãã¼ã¿ã¨çµæãè¿½å ã®æ å ±ãå«ã Excel ã·ã¼ãã¯ãÂ ãã¡ããã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ããÂ

åå²è¡¨ã§ã®ã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å®ã®å®è¡ã«é¢ãããã®ãã¥ã¼ããªã¢ã«ã®ç®ç

ãã®ãã¥ã¼ããªã¢ã«ã®ç®çã¯ããããã®æ¨æ¬ã§æ¸¬å®ããã2ã¤ã®è³ªçå¤æ°ï¼ãããã®ç¨®é¡ã¨å¯çè«ã®æç¡ï¼ã®éã®é¢ä¿ãæ¤å®ããããã«ãã«ã¤2ä¹æ¤å®ã¨Fisheræ£ç¢º æ¤å®ãä½¿ç¨ãããã¨ã§ãã

Â

åå²è¡¨ã§ã®ã«ã¤2ä¹æ¤å®ã¨Fisherâã®æ£ç¢ºæ¤å®ã®éãã¯ä½ã?

æ¦å¿µçã«ã¯ãã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å®ã¯ãåã å¸°ç¡ä»®èª¬ ãæ¤è¨ãããããã£ã¦ãåãè³ªåã«çãã¾ãã

H0 (å¸°ç¡ä»®èª¬): 2ã¤ã®è³ªçå¤æ°ã¯ç¬ç«ã§ãããæã ã®äºä¾ã§ã¯ãããã¯ãå¯çè«ã®æç¡ã¯ãããã®ç¨®é¡ã¨ã¯ç¬ç«ã§ãããã¨ãæå³ãã¾ããè¨ãæããã¨ãåå¨ãããããã®æ¯çã¯ã3ã¤ã®ç¨®é¡ã§ãã¹ã¦çããã¨ãããã¨ã§ãã

ä¸è¨ã¯ãå¯¾ç«ä»®èª¬ï¼ä¸¡å´ï¼ã®å½é¡ã§ãï¼

Ha (å¯¾ç«ä»®èª¬): 2ã¤ã®å¤æ°ã¯ããä¸æ¹ã«å¾å±ãããæã ã®äºä¾ã§ã¯ãããã¯ãå¯çè«ã®æç¡ããããã®ç¨®é¡ã«å¾å±ãããã¨ãæå³ã¾ããè¨ãæããã¨ã3ã¤ã®ãããã®ç¨®é¡ã®å°ãªãã¨ã1ã¤ããä»ã®ç¨®é¡ã¨ã¯ç°ãªãå¯çè«ã®æ¯çãæã¤ãã¨ã«ãªãã¾ãã

2ã¤ã®æ¤å®ã®éãã¯ãpå¤ãè¨ç®ããæ¹æ³ã«ããã¾ãã

ã«ã¤2ä¹æ¤å®ã¯ãå¸°ç¡ä»®èª¬ãçã§ããå ´åãå®ãã¼ã¿ã¨çè«ãã¼ã¿ã®éã®è·é¢ãåæ ããã«ã¤2ä¹çµ±è¨ã®è¨ç®ã«åºã¥ãã¾ãï¼ããªãã¡ããããã®ç¨®é¡éã§åããããã®åå¨æ¯çãæã¤çè«åº¦æ°ï¼ããã®çµ±è¨éã¯ãpå¤ãçæããããã®ã«ã¤2ä¹çè«åå¸ã§ä½¿ç¨ããã¾ããã«ã¤2ä¹çµ±è¨éãé«ãã»ã©ãpå¤ãä½ããªãã¾ããXLSTATã¯çè«åº¦æ°ã®è¨ç®ãã§ãããã¨ã«æ³¨æãã¦ãã ããï¼ä¸è¨åç §ï¼ã

Fisherã®æ£ç¢ºæ¤å®ã¯ãï¼è¶ å¹¾ä½åå¸ãç¨ãã¦ï¼è¦³å¯ãã¼ã¿ãæã¤ç¢ºçãããã³å¸°ç¡ä»®èª¬ã®ãã¨ã§ãããæ¥µç«¯ãªå¯è½ãªãã¼ã¿ã»ããã®ãã¹ã¦ãå¾ãç¢ºçãè¨ç®ãã¾ãããããã®ç¢ºçã¯ãFisherã®æ£ç¢ºæ¤å® på¤ãè¨ç®ããããã«ä½¿ç¨ããã¾ãã

çè«åº¦æ°ãã5ãããä½ãåº¦æ°ãå«ãå ´åãã¾ãã¯ããã¼ã¿ã»ããã®å¨è¾ºåº¦æ°ï¼è¡ãã¨ã®åè¨ã¾ãã¯åãã¨ã®åè¨ï¼ãã¨ã¦ãç°ãªã£ã¦ããå ´åãFisherâã®æ£ç¢ºæ¤å®ã«é ¼ãã®ãããæ¹æ³ã§ãã

ã«ã¤2ä¹æ¤å®ã¯Fisherã®æ£ç¢ºæ¤å®ãããå¼·åï¼å¸°ç¡ä»®èª¬ãå½ã§ããå ´åããããããæ£å´ããããï¼ã§ãã

Â

Â XLSTATã§ã®åå²è¡¨ã§ã®ã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å®ã®ã»ããã¢ãã

XLSTAT-Pro ãèµ·åããã¨ã**XLSTAT / ç¸é¢ â å±æ§ç¸é¢ã®æ¤å® / åå²è¡¨ã§ã®æ¤å®**ãé¸æãã¾ãã

ä¸è¬ã¿ãã§ã¯ã**åå²è¡¨ãã¼ã¿å½¢å¼**ãé¸æããã¦ãããã¨ãç¢ºèªãã¦ãåå²è¡¨ãã£ã¼ã«ãã§ãã¼ã¿ãé¸æãã¦ãã ããããã¼ã¿ãåç´å½¢å¼ï¼è¡ã«åä½ãåã®å¤æ°ï¼ã§æ§æããã¦ããå ´åãè³ªçå¤æ°ãã¼ã¿å½¢å¼ã®ãªãã·ã§ã³ãæå¹ã«ãã¦ãã ããããã¼ã¿ãåç´å½¢å¼ããåå²è¡¨ã«å¤æãããå ´åã¯ããã¡ãã®ãã¥ã¼ããªã¢ã« ãåç §ãã¦ãã ãããwill guide you.

Â

ãªãã·ã§ã³ã¿ãã§ã¯ãã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å® ãªãã·ã§ã³ãæå¹ã«ãã¦ãã ããã

**åºåã¿ãã§ã¯ãçè«åº¦æ°ã¨æ¯ç / å**ãªãã·ã§ã³ãæå¹ã«ãã¦ãã ããã

OK ãã¿ã³ãã¯ãªãã¯ãããã¨è¨ç®ãå§ã¾ãã¾ããçµæãæ°ããã·ã¼ãã«ç¾ãã¾ãã

Â

XLSTATã«ãããåå²è¡¨ã§ã®ã«ã¤2ä¹æ¤å®ã¨Fisherã®æ£ç¢ºæ¤å®ã®åºåã®è§£é

ã¾ããXLSTATã¯ã«ã¤2ä¹æ¤å®ã«é¢ä¿ããçµæãè¡¨ç¤ºãã¾ããpå¤ (0.033) ã0.05ã®æææ°´æºãããä½ãã§ãããããã£ã¦ãæã ã¯ãå¯çè«ã®æç¡ã¨ãããã®ç¨®é¡ãç¬ç«ã§ããã¨ããå¸°ç¡ä»®èª¬ã 3.3% ã®éèª¤ãªã¹ã¯ã§æ£å´ãã¾ãã

æ¬¡ã«ãFisherã®æ£ç¢ºæ¤å®ã®çµæãè¡¨ç¤ºããã¾ããããã§ã¾ããpå¤(0.044)ã0.05ã®æææ°´æºãããä½ãã§ããFisherã®æ£ç¢ºæ¤å®ãå¸°ç¡ä»®èª¬ã®æ£å´ãå°ãã¾ãã

ã«ã¤2ä¹æ¤å®ã§ããå¾ãpå¤ã®æ¹ããFisherã®æ£ç¢ºæ¤å®ã«é¢ããããããããããã«ä½ããã¨ã«æ³¨æãã¦ãã ãããããã¯ãããããã¨ã§ãã«ã¤2ä¹æ¤å®ãFisherã®æ£ç¢ºæ¤å®ãããå¼·åã ããã§ãã

ããã¦ãçè«åº¦æ°ã®è¡¨ããå¸°ç¡ä»®èª¬ãçã§ãã£ãå ´åã«å¾ãããã§ãããåº¦æ°ãè¡¨ç¤ºãã¾ãã ç°¡åãªè¨ç®ã§ãå¯çè«ãæã¤ãããã®æ¯çãã©ã®ç¨®é¡ã§ãçãããã¨(11.8%)ããããã¾ããæã ã¯ãåº¦æ°ã®1ã¤ã5ãããä½ããã¨ã«æ°ã¥ãã¾ãããããã£ã¦ãæã ã¯ãã«ã¤2ä¹æ¤å®ã®çµæã«é ¼ãããå°ãFisherã®æ£ç¢ºæ¤å®ãã¬ãã¼ããããã¨ãé¸ã³ã¾ãã

**æ¯ç / å**ã®è¡¨ã¯ã3ç¨®é¡ã®ãããã®ããããã§ã®Maggots-Yes ï¼å¯çè«ããï¼ã¨ Maggots-No ï¼å¯çè«ãªãï¼ã®æ¯çãç¤ºãã¾ãããã®æ¤å®ã®çµæã«ããã°ãå°ãªãã¨ãæ¯ç(0.121, 0.104, 0.300) ã®ãã¡ã®1ã¤ãä»ãããææã«ç°ãªãã¨è¨ãã¾ãã

Â

Was this article useful?

Yes
No

Similar articles

A complete add-in for Microsoft Excel