Help CenterExcelでの線形回帰の影響診断チュートリアル
ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTATã½ããã¦ã§ã¢ãç¨ãã¦Excelå ã§ç·å½¢å帰 ã®å½±é¿è¨ºæãè¨ç®ãã¦è§£éããæ¹æ³ã説æãã¾ãã
å½±é¿è¨ºæã¤ãã®ç·å½¢å帰ã®ããã®ãã¼ã¿ã»ãã
ãã¼ã¿ã¨çµæã®Excelã·ã¼ãã¯ãä¸ã®ãã¿ã³ãã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ã:
ãã¼ã¿ããã¦ã³ãã¼ããã¼ã¿ã¯ãLewis T. and Taylor L.R. (1967). Introduction to Experimental Ecology, New York: Academic Press, Inc.ã§å¾ããã¾ãããå½¼ãã¯237人ã®å ç«¥ããå½¼ãã®æ§å¥ãææ°ã«ããå¹´é½¢ãã¤ã³ãã§ã®èº«é·Â (1 inch = 2.54 cm)ãæ¬ã§ã®ä½é (1 pound = 0.45 kg)ã§è¨è¿°ãã¦ãã¾ãã
ãã®ãã¥ã¼ããªã¢ã«ã®ç®ç
çµ±è¨çã¢ãã«ã«é²ãåã«ããã¾ãã¾ãªå¤æ°ã®æ¥µå¤ï¼å¤ãå¤ï¼ã表ããªãã¶ãã¼ã·ã§ã³ãåæããé¤å¤ããããã«ãããããèå¥ãããã¨ããããããã£ããããªããããã®æé ã¯ããã®ãããªãªãã¶ãã¼ã·ã§ã³ãã©ãã ãã¢ãã«ã®ãã©ã¡ã¼ã¿ã®è¨ç®ã«å½±é¿ãä¸ãããã®ææ¨ãæä¾ãã¾ããããããè©ä¾¡ããããã«ããããã®ãªãã¶ãã¼ã·ã§ã³ã®å½±é¿è¨ºæãè¨ç®ãããã¨ãææ¡ããã¦ãã¾ãã
å½±é¿è¨ºæã¤ãã®ç·å½¢ä¸è¨ã®ã»ããã¢ãã
XLSTATãéãã¦ãXLSTAT / ãã¼ã¿ã»ã¢ããªã³ã°Â / å帰æ©è½ãé¸æãã¾ãã Â
ãã¿ã³ãã¯ãªãã¯ããã¨ãç·å½¢å帰ãã¤ã¢ãã°ã»ããã¯ã¹ãç¾ãã¾ãã
Excelã·ã¼ãã§ãã¼ã¿ãé¸æãã¦ãã ããã å¾å±å¤æ°Â ï¼ã¾ãã¯ã¢ãã«ããå¤æ°ï¼ã¯ãããã§ã¯"Weight"ã§ãã
éç説æå¤æ°ã¯ã"Height" ã¨Â "Age"ã§ãã
å¤æ°ã®åã¿ã¤ãã«ãé¸æãã¦ããã®ã§ã**å¤æ°ã©ãã«**ãªãã·ã§ã³ãæå¹ã«ãã¾ããÂ
注æ: XLSTATãç¨ãã¦Excelå ã§ç·å½¢å帰ãã»ããã¢ããããæ¹æ³ã®è©³ç´°ã«ã¤ãã¦ã¯ããã¥ã¼ããªã¢ã«Excelã§ã®ç·å½¢éå帰ãåç §ãã¦ãã ããã
åºåã¿ãã§ã¯ãäºæ¸¬å¤ã¨å½±é¿è¨ºæãé¸æãã¾ãã
Â
ç·å½¢å帰ã®å½±é¿è¨ºæã®è§£é
è¤æ°ã®ææ¨ãè¨ç®ããã¾ããå½±é¿è¨ºæã®ä¸ã«ãã¦ãæ¯ãããã©ããã¹Â è·é¢ãCookã®DãCovRatioãæ¨æºå DFFitsãæ¨æºåDFBetasãããã¾ãã ãããã®ææ¨ã®å¤§é¨åã¯ã i çªç®ã®ãªãã¶ãã¼ã·ã§ã³ããã®ã¢ãã«ã¨ãªãã®ã¢ãã«ã®éã®å·®(äºæ¸¬å¤ããã©ã¡ã¼ã¿æ¨å®ãåæ£-å ±åæ£è¡åâ¦ã§ã®å·®)ãå®éåãã¾ãã
ããã§ãæã ã¯æ¨æºå DFFits ããã³Â DFBetasã®è§£éã«æ³¨ç®ãã¾ãã
æã ã¯ããã©ã¡ã¼ã¿ã®æ¨å®ã¨äºæ¸¬å¤ã«é¢ãã¦ã179çªç®ã®ãªãã¶ãã¼ã·ã§ã³ã®å¼·ãå½±é¿ã観å¯ãã¾ãã次ã®ãªãã¶ãã¼ã·ã§ã³ã§ãï¼ããå¼±ãï¼å¹æãããã¾ã: 8, 24, 38, 50, 60, 69, 77, 100, 108, 122, 010, 168, 169, 205, 207, 208, 218, 224 , 234ãåä½179 ã¯ã171.5 ãã³ã (77kg)ã§Â 67.5 ã¤ã³ãã測å®ãã¾ããããæã ããã®åä½ã®ç¹å¾´ã§ããã詳細ãè¦ããªãã°ãå½¼ã¯Â 20 æ³ã§ãããããã«åãã¦ãã¤ã³ã¿ãã¥ã¼ãããä»ã®å ç«¥ã¯13æ³ãã14æ³ã®éã§ããå½¼ã®ä½é/身é·ã®æ¯ã¯2.5ã§ãä¸æ¹æ¨æ¬å ¨ä½ã®å¹³åã¯Â 1.65 ã§ãã
ãã¹ã¦ã®ãã©ã¡ã¼ã¿ã®ä¸ã§ãå½¼ã¯Ageã®æ¨å®ã§å¼·ãå½±é¿ãæã¡ã¾ããå®éãå½¼ã®å¹´é½¢ã¯ããã®èº«é·ãããã¯ããã¦ãã¾ãã ä¸è¨ã®è¦³å¯ã«åºã¥ãã¦ããã®åä½ãã¢ãã«ããé¤å¤ãããã¨ãææ¡ãã¾ãã
Was this article useful?
- Yes
- No
