Help CenterExcelでのJohnson変換チュートリアル
ãã®ãã¥ã¼ããªã¢ã«ã¯ãXLSTATçµ±è¨è§£æã½ããã¦ã§ã¢ãç¨ãã¦Excelå ã§ãã¼ã¿ã«Johnson å¤æ ãé©ç¨ããæ¹æ³ã示ãã¾ãã
ãã®ãã¥ã¼ããªã¢ã«ã®ç®ç
å¤ãã®çµ±è¨ææ³ã¯ãå ãã¼ã¿ã¾ãã¯ããã¤ãã®ã¢ã¦ããããã®ããããããæ£è¦åå¸ã«å¾ã£ã¦ãããã¨ãä»®å®ãã¦ãã¾ããããã¤ãã®ç¾è±¡ã¯æ£è¦åå¸ã«å¾ãã¾ãããããã¯ã»ã¨ãã©ã®å ´åã«å½ã¦ã¯ã¾ãã¾ãããæ£è¦æ§ã®æ¡ä»¶ãç·©ãããããã»ã©éè¦ãªææ決å®ã§ã¯ãªãå ´åã«ã¯ãããã常ã«ææ決å®ã®åé¡ã§ããããã§ã¯ããã¾ããããææ決å®ã大ããªå½±é¿ãæã¤å ´åã«ã¯ããããç¾å®ã®åé¡ã«ãªã£ã¦ãã¾ãããã®ãããªå ´åãå¤æãå¿ è¦ã«ãªãã¾ãããã®äºä¾ã§ã¯ãæã ã¯ã Johnson å¤æãç¨ãã¾ãã
å¤æ°å¤æã®ããã®ãã¼ã¿ã»ãã
ãã¼ã¿ã¨çµæã®Excelã·ã¼ãã¯ãä¸ã®ãã¿ã³ãã¯ãªãã¯ãã¦ãã¦ã³ãã¼ãã§ãã¾ã: ãã¼ã¿ããã¦ã³ãã¼ã
ãã¼ã¿ã»ããã¯ã47åã®ããã製é ã§ã®ä¸è¯åã®æ¸¬å®ãæ ¼ç´ãã¦ãã¾ããæã ã¯ãè¤æ°ã®ããã»ã¹å¤æ°ã§å帰ãå®è¡ãããã®ã§ãããå¤æ° Level of waste ãæ£è¦æ§ä»®èª¬ã«éåãã¦ãã¾ããããã¯ãæ£è¦æ§æ¤å®ã¨ãã¹ãã°ã©ã ã®XLSTAT é¢æ°ãç¨ãã¦ç°¡åã«æ¤è¨¼ã§ãã¾ãããã®çµæã¯ä»¥ä¸ã§ãã
ãããã£ã¦ãæã ã¯ãç·å½¢å帰ãå½ã¦ã¯ããåã«ããã®å¤æ°ã®å¤æãè¡ãå¿ è¦ãããã¾ããÂ
XLSTATå ã§ã®Johnsonå¤æã®è¨å®
XLSTATãèµ·åããã¨ã**XLSTAT / ãã¼ã¿æºå / å¤æ°å¤æ**ã³ãã³ããé¸æãã¦ãã ããã
å¤æ°å¤æãã¤ã¢ãã°ã»ããã¯ã¹ãéãã¾ããä¸è¬ã¿ãã§ãå¤æãããå¤æ°ããã¼ã¿ã»ãã£ã¼ã«ãã§é¸æãã¦ãã ããããã¨ãã°ãæã ã¯åBã®å¤æ°Â Level of waste ãé¸æãã¾ããÂ
æãä¸è¬çãªå¤æã¯ã**ä¸åæ¨æºå**ï¼æ¨æºå(n-1)ï¼ã§ãããã ãã**ãã®ä»**ãªãã·ã§ã³ãæå¹ã«ããã¨ãããå¤ãã®å¤æãããã¾ãã
**å¤æã¿ãã§ã¯ãJohnson å¤æãªãã·ã§ã³ãé¸æãã¦ãã ããã** ã¢ã«ãã¡ã 0.05 ã«è¨å®ãã¦ãShapiro-Wilk æ¤å®ãé¸æãã¦ãã ãããÂ
Johnson å¤æã§ã¯ããã¼ã»ã³ã¿ã¤ã«ã«åºã¥ã Chou et al. (1998) ã«ãã£ã¦èª¬æãããã¢ã«ã´ãªãºã ãXLSTATã§ã¯å®è£ ããã¾ããããã®ææ³ã¯ã3ã¨ããã®Johnson åå¸ã®æãè¯ãå½¢ãè¦ã¤ãã¦ããã©ã¡ã¼ã¿ã®è¯ãå¤ãæ¨å®ãããã¨ã®ä¸¡æ¹ãã§ãã¾ããèè ã¯æ£è¦æ§ãè©ä¾¡ããã®ã«Shapiro Wilk æ¤å®ã使ç¨ãã¦ãã¾ãããXLSTAT ã¯ãããã¨åãæ¤å®ãã¾ãã¯Anderson-Darling æ¤å®ã使ç¨ã§ãã¾ãã
OK ãã¯ãªãã¯ããã¨è¨ç®ãå§ã¾ãã¾ãã
Johnson å¤æã®çµæ
**å¤æ°å¤æ**ã¨ããçµæã®ã·ã¼ãã«ãå¤æãã¼ã¿ã®è¡¨ãããã¾ããÂ
ããã§æ£è¦æ§æ¤å®ã¨å¤æããããã¼ã¿ã®ãã¹ãã°ã©ã ã確èªãã¾ãããã4ã¤ã®ãã¹ã¦ã®æ£è¦æ§æ¤å®ã®på¤ã0.05ãããé«ããæã ã¯æ¨æ¬ãæ½åºãããå¤æ°ãæ£è¦åå¸ã«å¾ãã¨ãã帰ç¡ä»®èª¬ãæ£å´ãããã¨ãã§ãã¾ããããã¹ãã°ã©ã ãå¤æãããå¤æ°Level of waste ãæ£è¦åå¸ã«å¾ããã¨ã示ãã¦ãã¾ããÂ
Was this article useful?
- Yes
- No
