| CARVIEW |
?yExcel?Ŋw?ԃf?[?^???́z?ƊE?ɂ???ď??C???ɍ??????邩?H?i?????l?̍??̌???j?F?₳???????????v?i????????ҁj
???????牞?p?܂ŃX?e?b?v?A?b?v???Ȃ???w??ł????w?₳?????f?[?^???́x?V???[?Y?i????????ҁj?̑?11??B????m???p?????g???b?N????Ɏ??g?݂܂??B?܂??A?????l?̍??????肷????@?ɂ??ĉ?????܂??B
???̋L???͉??????ł??B????o?^?i?????j????ƑS?Ă????????????܂??B
?A?ځF
?w?Љ?l1?N??????w?ԁA?₳???????????v?i????????ҁj?x
?@???̘A?ڂ́A?f?[?^?????܂??܂Ȋp?x???番?͂??A???̔w??ɂ???L?v?ȏ??????o?????@???w?ԁw?Љ?l1?N??????w?ԁA?₳?????f?[?^???́x?V???[?Y?́u?L?q???v?Ɖ?A???͕??v?u?m?????z???v?u???????v?i??Ԑ???ҁj?v?ɑ????u???????v?i??????????j?v?ł??B
?@???̘A?ڂł́A?ϑ????ꂽ?f?[?^????ɁA???ςɍ??????邩?ǂ????A???U?ɍ??????邩?ǂ????Ȃǂ??ᖡ???邽?߂ɁA??????????s?????@??K?p???̗??ӓ_?Ȃǂ???????܂??B?g?߂Ɏg????\?v?Z?\?t?g?E?F?A?iMicrosoft Excel??Google?X?v???b?h?V?[?g?j???g???Ȃ????̓I?Ɏ???????Ă????܂??B
?@?K?v?ɉ????āAPython?̃v???O?????Ȃǂł̍쐬??ɂ??G??邱?Ƃɂ??܂????A???w?Ȃǂ̑O??m???͓??ɖ₢?܂???B???̗͂??Ă??ЂƂ??C?y?ɓǂݐi?߂Ă????????B
?H?R???M?ҏЉ?F IT?n???C?^?[?̖T??A????܂Ŕ??u?t?Ƃ??ē???ŏ??E?v???O???~???O?֘A?̎??Ƃ??A?ꋴ???AI?֘A?̎??Ƃ?S???B???Ȃ?O???甯???u???[?`???Ă??ċ????搶?????̂??Ă????̂?????ǁA???u???Ă???Ƃ????????̃O???[?w?A?[?ɂȂ??Ă????̂ŁA???͂???N?g???Ǝv???????B?ŋ߁A?????????ȂƊ????Ă??邱?Ƃ́A???܂?Ă??̕??ǂ????Ă??H?ׂ??Ȃ??????[?????H?ׂ???悤?ɂȂ??????ƁB???g???ɂ̓????????????Ȃ??h?B
?@?f?[?^???͂̏??????牞?p?܂ŏ??????X?e?b?v?A?b?v???Ȃ???w??ł????A?ڂ̐??????v?i????????ҁj?A??11??ł??B?O???܂ł͕?W?c?̕??z?????炩?̕ꐔ?i?p?????[?^?[?j?Ō??܂?ꍇ?̌???A?܂?p?????g???b?N????̕??@????????Ă??܂????B
?@????́A??W?c?ɓ???̕ꐔ?????肵?Ȃ??i?ł??Ȃ??j?ꍇ?̌?????@?ɂ??ĉ?????܂??B???̂悤?Ȍ?????m???p?????g???b?N?????ƌĂт܂??B????͏??ʂ???ɂ????????l?̍??̌????????グ?܂??B
?????l?̍??̌???Ƃ́H
?@?????l?̍??̌???Ƃ??ẮA?E?B???R?N?\???̏??ʘa???????}???E?z?C?b?g?j?[??U?????????p?ł??܂??B?v?Z?̎菇?͈قȂ?܂????A?????̌???͎????I?ɓ??????̂ł??B????̓}???E?z?C?b?g?j?[??U????ɂ??A?????l?̍??????肵?܂??B?ȉ??A?P??U?????ƌĂт܂??B
?@?????l?̍??̌???́A??W?c?̐??K???͑O??Ƃ??܂??A???z???????`?ł???ƍl??????ꍇ?̌???ł??B??W?c?̕??z?̌`???قȂ?ꍇ?́A?????l?̍??ł͂Ȃ??A???z?̃Y???????肵?Ă??邱?ƂɂȂ?܂??B?????l?̍??̌???͐}1?̂悤?ȃC???[?W?ł??B
?}1?@?ƊE?ɂ???ď??C???ɍ??͂??邩?H?????l?̍??̌???ł́A???ʂ???Ɍ??蓝?v??z?????߁A?W?????K???z?̗????m???܂??͕Б??m???????߂?Ƃ悢?B????́A?Η????????u?????l?͈قȂ?v?Ƃ???̂ŁA??????????s???B
?@??ɂ???āA?A???????ƑΗ??????̊m?F????n?߂܂??B
- ?A???????iH0?j?F ?????l?͓?????
- ?Η??????iH1?j?F ?????l?͓??????Ȃ?
?@???̗?ł́A???z?̌`???????ł???Ƃ????O??Ȃ̂ŁA??̂悤?ȋA???????ƑΗ??????ɂȂ?܂????A?O?q?????悤?ɁA???z?̌`???قȂ?ꍇ?́A?A???????́u???z?͓????ł???v?A?Η????????u???z?ɂ̓Y????????v?Ȃǂ̂悤?ɕ\????܂??B
?????l?̍??????肵?Ă݂悤 ?` ?}???E?z?C?b?g?j?[??U????
?@?c?O?Ȃ???Excel?ɂ?U??????s??????????܂???B???̂??߁A?ȉ??̂悤?Ȏ菇?ɏ]????P?l???v?Z????K?v??????܂??B???ꂼ??̌Q?̃T???v???T?C?Y??n1, n2?Ƃ???ƁA
- 2?Q?̃T???v?????܂Ƃ߂ď??ʂ?t????
- ?e?Q?̏??ʂ̘a?????߂?iW1,W2?Ƃ???j
- U1??W1?|n1(n1?{1)/2?̒l?????߂?
- U2??W2?|n2(n2?{1)/2?̒l?????߂?
- U1??U2?̏????????ɂ??āA?ȉ??̌v?Z???s???i?????ł́AU1???????????Ƃ???j
- ???q?̒l?Ƃ??āAU1 ?| (n1?{n2)/2 ?{ 0.5?̒l?????߂?
- ???蓝?v??z????̕??q?^????ŋ??߂?
- z?ɑ???W?????K???z?̗????m???????߂?
?ƂȂ?܂??B???????A??̎菇?͓????ʂ??Ȃ??ꍇ?̂??̂ł??B?????ʂ?????ꍇ?ɂ??Ă͌?q???܂??B
?@???q?̒l??0.5????????̂́A???U?l??A???l?Ƃ??Ĉ??????߂̕?i?A???l??j?ł??B
?@?ł́A??????????_?E?????[?h????Excel?t?@?C?????J???Ď????Ă݂Ă????????B?mU????n???[?N?V?[?g??\?????āA?}2?̂悤?ɑ??삵?܂??BGoogle?X?v???b?h?V?[?g?̃T???v??????????????J?????Ƃ??ł??܂??B???j???[????m?t?@?C???n?|?m?R?s?[???쐬?n??I?????AGoogle?h???C?u?ɃR?s?[???Ă??g???????????B??????@?͐}?̌?ɉӏ??????ɂ??Ă????܂??B??̎菇?ƏƂ炵???킹?đ??삵?Ă݂Ă????????B
?}2?@?????l?̍??????肷??B???C??ɂ́A2?̋ƊE?ł̊e??Ƃ̏??C???????͂???Ă???i????????????ɂ????????z?ƂȂ??Ă???j?BE???2?Q?̃f?[?^???܂Ƃ߁AG??őS?̂ł̏??ʂ?t????i??ʂł͕\?????ȗ????Ă??邪?AE??`G???43?s?ڂ܂Œl?????Ԃ??ƂɂȂ?j?B?????āA?Z??J4??J5?Ŋe?Q?̏??ʂ̘a?????߁AL???U?̒l?????߂?B????ɁAU??n?̒l????ɁA?Z??J7?ŕ??q?̒l???A?Z??J8?ŕ???̒l?????߁A?Z??J9??z?̒l?????߂?Bz?̒l????????A?Z??J10?ŕW?????K???z?̗????m???????߂???B??̓I?ȑ?????@?͈ȉ??̉ӏ????????Q?ƁB
?@???ʂ́AP??0.190?ƂȂ?A?A???????͊??p?ł??܂???ł????B?܂?u?????l?ɍ???????Ƃ͌????Ȃ??i???z?̌`???قȂ?ꍇ?ɂ́u???z?ɃY????????Ƃ͌????Ȃ??v?j?v?Ƃ??????ƂɂȂ?܂??B?Z??B25??C25?ŋ??߂??????l??????ƁA?ƊEA?̏??C????26??4000?~?ŋƊEB?̏??C????30??9500?~?ƁA?ƊEB?̕????悳?????ł????A???ꂾ???ł͉??Ƃ??????Ȃ??Ƃ??????Ƃł??ˁB
?@??̓I?ȑ?????@?͈ȉ??̒ʂ?ł??B
- ?Z??E4?Ɂu=VSTACK(B4:B23,C4:C23)?v?Ɠ??͂???i2?Q?̃f?[?^??1?ɂ܂Ƃ߂?j
- F??̌Q?͎??Ƃœ??͂???i?????g???ċ??߂邱?Ƃ??ł??Ȃ??͂Ȃ????A?R?s?[?????????ȒP?j?B
- ?Z??G4?Ɂu=RANK.AVG(E4:E43,E4:E43,1)?v?Ɠ??͂???i???ʂ????߂???j
- ?Z??J4?Ɂu=SUMIF(F4:F43,I4,G4#)?v?Ɠ??͂???iA?Q?̏??ʘaW1?????߂???j
- ?Z??J5?Ɂu=SUMIF(F4:F43,I5,G4#)?v?Ɠ??͂???iB?Q?̏??ʘaW2?????߂???j
- ?Z??K4?Ɂu=COUNT(B4:B23)?v?Ɠ??͂???in1?̒l?????߂???j
- ?Z??K5?Ɂu=COUNT(C4:C23)?v?Ɠ??͂???in2?̒l?????߂???j
- ?Z??L4?Ɂu=J4-K4*(K4+1)/2?v?Ɠ??͂???iU1??W1?|n1(n1?{1)/2?̒l?????߂???j
- ?Z??L5?Ɂu=J5-K5*(K5+1)/2?v?Ɠ??͂???iU2??W2?|n2(n2?{1)/2?̒l?????߂???j
- ?Z??J7?Ɂu=L4-(K4*K5)/2+0.5?v?Ɠ??͂???i???q?̒l?????߂???j
- ?Z??J8?Ɂu=SQRT(K4*K5*(K4+K5+1)/12)?v?Ɠ??͂???i????̒l?????߂???j
- ?Z??J9?Ɂu=J7/J8?v?Ɠ??͂???i???蓝?v??z?̒l?????߂???j
- ?Z??J10?Ɂu=(1-NORM.S.DIST(ABS(J9),TRUE))*2?v?Ɠ??͂???i?????m???????߂???j
?@Google ?X?v???b?h?V?[?g?ł́A?z?????g???ꍇ?Ɏ??S?̂?ARRAYFORMULA???̈????Ɏw?肷??K?v??????܂??B?܂??uG4#?v?Ƃ??????X?s???@?\?œ???ꂽ?͈͂̎w?肪?ł??Ȃ??̂ŁA?uG4:G43?v?̂悤?ɃZ???͈͂??w?肷??K?v??????܂??B?܂??AGoogle ?X?v???b?h?V?[?g??NORM.S.DIST???͗ݐϕ??z???̒l?????߂邽?߂̂??̂Ȃ̂ŁA???̌`?????w?肷?邽?߂̑?2?????͕s?v?ł??B?܂?A?Z??J10?ɂ́u=(1-NORM.S.DIST(ABS(J9)))*2?v?Ɠ??͂??܂??B?ڍׂɂ??ẮAGoogle?X?v???b?h?V?[?g?ł̍쐬????Q?Ƃ??Ă????????B
?????ʂ?????ꍇ?̕???s??
?@U????ł́A?????ʂɕ??ς̏??ʂ?^???܂??B?Ⴆ?A3?ʂ̒l??2????A???̂??ꂼ???3?ʂ?4?ʂ̕??ςł???3.5?Ƃ??????ʂ?^???A????5?ʂƂ??܂??B?܂?A1, 2, 3.5, 3.5 ,5, ...?Ƃ??????ʂɂȂ?܂??B????ɂ??ẮARANK.AVG?????g???ΊȒP?ɋ??߂??܂??i??̗?ɂ͓????ʂ͂???܂??A??͂?RANK.AVG?????g???Ă??܂??j?B?]???āA???ʂ̋??ߕ??͏?Ō??????@?ƑS???????ł??B
?@???????A???蓝?v?ʂ????߂?ۂ̕???ɓ?????l??????K?v??????܂??B??̂??߂̎??͈ȉ??̒ʂ?ł??BN?͑S?̂̃T???v???T?C?Y?i?܂?n1?{n2?j?ŁAti??i?Ԗڂ̓????ʂ̌??ł??B
?@?Ⴆ?A???ʂ?1, 2, 3.5, 3.5, 5, 7, 7, 7, 9?ł???A2?̓????ʂ?3?̓????ʂ?????̂ŁAt1??2,t2??3???i1?j???ɓ??Ă͂߂܂??B???????AExcel?ł??̌v?Z???s???̂́A???Ȃ?ʓ|?ł??B?ꉞ?A?T???v???t?@?C???́mU????i?????ʁj?n???[?N?V?[?g?Ɍv?Z??Ǝ菇?̐??????܂߂Ă????܂??????A????Excel?ɂ??????K?v?͂???܂???B?????ƕ֗??ȕ??@?????ɏЉ?܂??B
?}???E?z?C?b?g?j?[??U?????Python???g???ƊȒP?ɂł???I
?@??Ō????悤?ɁAExcel???g????U??????s?????߂ɂ́A???Ȃ蒷???菇?ޕK?v??????܂????B?܂??A?????ʂ?????ꍇ?̕????]?I?Ȃ܂łɖʓ|?ł??B???ۂɂ́APython?ȂǂŃv???O???~???O???s?????????͂邩?ɊȒP?ł??B?u?v???O???~???O?v?Ƃ????????ŁA??????ƌh??????l?????邩??????܂??A???p???郂?W???[?????w?肵?A?f?[?^?????????āA????̂??߂̊????Ăяo???????ł??B??̗?ł???A?ȉ??̂悤?ȃR?[?h?ɂȂ?܂??B
from scipy.stats import mannwhitneyu
# ?f?[?^?i?????ʂ??Ȃ??f?[?^?j
x = [224000, 359000, 150000, 199000, 307000,
366000, 189000, 244000, 348000, 158000,
240000, 157000, 284000, 303000, 306000,
429000, 243000, 333000, 194000, 450000]
y = [229000, 349000, 180000, 363000, 249000,
396000, 321000, 376000, 487000, 241000,
232000, 299000, 389000, 215000, 320000,
600000, 260000, 346000, 271000, 237000]
# ?}???E?z?C?b?g?j?[??U????
u, p = mannwhitneyu(x, y, alternative='two-sided')
# ???ʂ̕\??
print(f"P={p:.3f}") # P=0.190?Ƃ??????ʂ???????
scipy.stats???W???[????mannwhitneyu???𗘗p????Bx??y???w?肵?A????????̏ꍇ??alternative??????'two-sided'???w?肷??B?Б?????̏ꍇ??'less'??'greater'???w?肷??悢?B????ł́A?T???v???T?C?Y?????????i8?ȉ??j?A?????ʂ??Ȃ??ꍇ?ɂ́A?A????????s???Ȃ????A????ȊO?̏ꍇ?͘A????????s???A?????ʂ?????ꍇ?̕???s????B
?@??̃R?[?h?????????ɂ???܂??B?????N???J????Python?̃v???O???????\???????̂ŁA?ŏ??̃R?[?h?Z?????N???b?N???A?mShift?n?{?mEnter?n?L?[???????ăv???O?????????s????ƁAP=0.190?Ƃ??????ʂ??\??????܂??B
?@?????ʂ?????f?[?^?ł̗??2?Ԗڂ̃R?[?h?Z???ɓ??͂??Ă???܂??B?f?[?^???قȂ邾???ŁAmannwhitneyu???̎w??͑S???????ł??B?????ʂ?????ꍇ?̕???????I?ɍs????̂ŁAExcel???g???????͂邩?Ƀ??N?ł??ˁB
?????l?̍??????肷??ۂ̓K?ȃT???v???T?C?Y?́H
?@?{???Ȃ?A?T???v???????W????O?Ɍ??ʗʂȂǂ????ς?A?T???v???T?C?Y?????߂Ă????̂??X?W?ł????A???̘A?ڂł͌???̕??@?𗝉????邱?Ƃ????C???ɂ??b?????Ă???̂ŁA?????????̕??@???ɉ?????܂????i?Ƃ??????Ƃ͉??x?????b?????Ă??܂??ˁj?B
?@?????l?̍??̌???ł́A??W?c?̕??z?????肵?Ă??Ȃ??̂ŁA?T???v???T?C?Y?????߂邽?߂̌??܂?????????????܂???B??ʂɁAt????ł̃T???v???T?C?Y?̋??ߕ??𗘗p???A???ʗʂ????ēK?p??????@???悭?g???܂??B??6???ŏЉ??G*Power?ł????̕??@???g???Ă??܂??B?܂??A???p??????Ă݂܂??傤?i?}3?j?B?菇?͉?ʂ̌?ɉӏ??????ŋL???Ă????܂??B
?}3?@G*Power?ɂ??AU????ɕK?v?ȃT???v???T?C?Y?????߂??e?Q?ł??炩???ߌ??ς????????ςƕW????????ɁA???ʗ?d???v?Z???Ad??0.625?Ƃ????i???傫?߂̌??ʗʁj?B?L?Ӑ???????0.05?A???o??1?|????0.8?ŁA????????Ƃ????ꍇ?̗?Ōv?Z????B???ʂ͊e?Q44?ƂȂ????B
?@G*Power?ł̑???菇?͈ȉ??̒ʂ?ł??B????̕??@?Ȃǂ??ȉ??̂悤?ɑI?????܂??B
- ?mTest family?n?̃??X?g????ut tests?v??I??????
- ?mStatistical test?n?̃??X?g????uMeans: Wilcoxon-Mann-Whitney test (two groups)?v??I??????
- ?mType of power analysis?n?̃??X?g????uCompute required sample size - given ??, power, and effect size?v??I??????
?@???j???[?o?[????mTests?n?|?mMeans?n?|?mTwo independent groups: Wilcoxon (non-parametric)?n??I?????Ă??????ݒ?ɂȂ?܂??B
?@??L?̎w?肪?ł?????A?ȉ??̂悤?ɑ??삵?܂??B
- ?mTail(s)?n???X?g????mTwo?n??I??????
- ?mDetermine =>?n?{?^?????N???b?N????
- ?E???ɕ\?????ꂽ?p?l???Łmn1=n2?n?I?v?V??????I??????
- ?mMean group 1?n?{?b?N?X?ɁA?z?肳???A?Q?̕??ςƂ???270000????͂???
- ?mMean group 2?n?{?b?N?X?ɁA?z?肳???B?Q?̕??ςƂ???320000????͂???
- ?mSD ?? group 1?n?{?b?N?X?ɁA?z?肳???A?Q?̕W?????Ƃ???80000????͂???
- ?mSD ?? group 2?n?{?b?N?X?ɁA?z?肳???B?Q?̕W?????Ƃ???80000????͂???
- ?mCalculate and transfer to main window?n?{?^?????N???b?N????i?????̃E?C???h?E?́mEffect size d?n?{?b?N?X?ɁA???ʗʂƂ???0.6250000?Ƃ????l???\???????j
- ?m?? err prob?n?{?b?N?X??0.05?Ɠ??͂???
- ?mPower (1-?? err prob)?n?{?b?N?X??0.8?Ɠ??͂???
- ?mCalculate?n?{?^?????N???b?N????
?@?ȏ?̑?????s???ƁmSample size group 1?n?ƁmSample size group 1?n?Ƃ??āA44?Ƃ????l???\??????܂??B????̎???͂????????T???v???T?C?Y???????߂????悤?ł??B?{???ł???A44?????x?̃T???v?????̂??Č??肷?ׂ??ł????B
?@G*Power?ł́AARE?i?Q?ߑ??Ό????j?ƌĂ?????s???Č??ʗʂ????߁At????̃T???v???T?C?Y?̋??ߕ???K?p???Ă??܂??BARE?ɂ??Ă͂??Ȃ????b?ɂȂ?̂ŁA?ڍׂɂ??Ă͐G??܂??AU????̏ꍇ??ARE??3/?? ≈ 0.955?Ƃ??Acohen's d??
???|???Č??ʗʂ????܂??B
?@?Q?l?Ƃ??āAG*Power?Ɠ??????ʂ邽?߂?Python?v???O????????ŏЉ???????N??ɍ쐬???Ă???܂??B3?Ԗڂ̃R?[?h?Z?????N???b?N???A?mShift?n?{?mEnter?n?L?[???????ăv???O?????????s?????n=44?Ƃ??????ʂ??\??????܂??B
?@????́A?}???E?z?C?b?g?j?[??U????ɂ??A2?Q?̕??z?̃Y???????肷????@????????܂????B???z???????`?̏ꍇ?́A?????l?̍??̌???ƂȂ?܂??B
?@????́A???z?̍L????̍??????肵?܂??B??̓I?ɂ̓m???p?????g???b?N????̈?ł???A???T???E?u???b?h???C????Ȃǂɂ??Č??Ă????܂??B?ǂ??????y???݂ɁI
?u?₳???????????v?i????????ҁj?v
AI?E?f?[?^?T?C?G???X?̊w?т?????????
???S?Ҍ????A?f?[?^???́EAI?E?@?B?w?K?EPython?̕????@?@??IT??Deep Insider?Ŋw?ڂ?
Copyright© Digital Advantage Corp. All Rights Reserved.
?A?C?e?B???f?B?A????̂??m?点
??IT eBook
???ڂ̃e?[?}
?ҏW??????̂??m?点
RSS?ɂ???
?A?C?e?B???f?B?AID?ɂ???
???[???}?K?W???o?^
??IT?̃??[???}?K?W???́A ???????A???ׂĖ????ł??B???Ѓ??[???}?K?W???????w?ǂ????????B
ITmedia?̓A?C?e?B???f?B?A??????Ђ̓o?^???W?ł??B
???f?B?A?ꗗ | ????SNS | ?L???ē? | ???₢???킹 | ?v???C?o?V?[?|???V?[ | RSS | ?^?c??? | ?̗p??? | ??????