| CARVIEW |
?m?f?[?^???́nF???z ?` 2?̔_?@?ʼnʕ??̓??x?????肵?Ă???̂͂ǂ???H?F?₳?????m?????z
?f?[?^???͂̏???????w??ł????A?ځi?m?????z?ҁj?̑?9??BF???z?͕??U?̔?Ɋ֘A???镪?z?ł??B2?̕?W?c??????o???ꂽ?T???v??????Ɂu???ꂼ??̕?W?c?̕??U?ɈႢ??????̂??v?ׂ?ꍇ?ȂǂɎg???܂??BF???z?̊m???ϐ??Ǝ??R?x?̋??ߕ?????????A???̊m?????x????ݐϕ??z???ɂ??ĉ?????܂??B
???̋L???͉??????ł??B????o?^?i?????j????ƑS?Ă????????????܂??B
?A?ځF
?w?Љ?l1?N??????w?ԁA?₳?????m?????z?x
?@???̘A?ڂ́A?f?[?^?????܂??܂Ȋp?x???番?͂??A???̔w??ɂ???L?v?ȏ??????o?????@???w???w?Љ?l1?N??????w?ԁA?₳?????f?[?^???́x?A?ځi?L?q???v?Ɖ?A???͕ҁj?̑??҂ŁA?m?????z?ɏœ_?ĂĂ??܂??B
?@???̊m?????z?҂ł́A???????v?̊?b?ƂȂ邳?܂??܂Ȋm?????z?̓????≞?p?????????܂??B?g?߂Ɏg????\?v?Z?\?t?g?iMicrosoft Excel??Google?X?v???b?h?V?[?g?j???g???Ȃ????̓I?Ɏ???????Ă????܂??B
?@?K?v?ɉ????āAPython?̃v???O?????ł̍쐬??ɂ??G??邱?Ƃɂ??܂??B
?@???w?Ȃǂ̑O??m???͓??ɖ₢?܂???B???w?E???Z?̋??ȏ????x???̐??????o?ꂷ?邩??????܂??A?K?v?ɉ????Đ?????t????????̂ł??S?z?Ȃ??B???̗͂??Ă??ЂƂ??C?y?ɓǂݐi?߂Ă????????B
?M?ҏЉ?F IT?n???C?^?[?̖T??A???u?t?Ƃ??ē???ŏ??E?v???O???~???O?֘A?̎??Ƃ??A?ꋴ???AI?֘A?̎??Ƃ?S???B??̌????͐S??????????Ă??܂?99??Œ??f?B?S?x?@?\?????߂邽?߂ɐ??j???n?߂???A????ɏ?B?????B?܂??A???^?[?????C?_?[?Ƃ??ĉ??\?N?Ԃ肩?ɑ?^?o?C?N?ɂ܂???????A??͂?̗͕s????Ɋ??B??????b???邽?߂ɍŋ߂͎l?҂ޓ??X?B?????S?^?]?Ȃ̂ŁA???t??`?????ɔ???????邱?Ƃ??????i???蔲???L?P???A???????x????ĂˁI?j?B
?@?f?[?^???͂̏??????牞?p?܂ŏ??????X?e?b?v?A?b?v???Ȃ???w??ł????A?ڂ̊m?????z?ҁA??9??ł??B?O???́A???ϒl?Ɋ֘A???镪?z?Ƃ??āAt???z?????グ?܂????B????͕??U?̔?Ɋ֘A????F???z?ɂ??āA???̓?????Ӗ?????{??????????????A?m?????x???^?ݐϕ??z???̋??ߕ??A???p??Ȃǂ????Ă????܂??B
?ʕ??̓??x?????肷??_?@?͂ǂ???H ?` F???z?̗??p
?@?u???x?̍????ʕ??v?ƌ????A?F????͉????v???????ׂ?ł??傤???B?M?҂͋???Ȃǂ̂Ԃǂ????v???????ׂ܂??B??ʂɁA????̓??x??18?`20?Ƃ????Ă???A?ʕ??̒??ł͂??Ȃ荂?????ł??B?ʕ?????Ă?ɓ??????ẮA???x?Ȃǂ̕i???????????ƁA?`???ǂ????ƁA???ʂ??傫?????ƂȂǁA?l?????ׂ?????????????????܂????A?i???????肵?Ă??邱?Ƃ??d?v???Ǝv???܂??B
?@?}1?́A?قȂ?2?̔_?@?ň?Ă??Ԃǂ??̖???T???v??????????o???ē??x?????߂??C???[?W?ł??i???????A?ˋ?̗?ł??j?B?T???v???̒l??????ƁA?_?@B?̕??????x?̕??U?????????i???i???????肵?Ă???j?悤?Ɏv???܂??B???̂悤?ɁA?_?@A?Ɣ_?@B?ł͕??U???قȂ?̂??i?_?@B?????U?????????̂??j?Ƃ????????Ƃ??A????̖??ӎ??ł??B?v????ɁA???U???r???????Ƃ????킯?ł??B
?}1?@2?̔_?@?ň?Ă??u?h?E?̓??x?ɕꕪ?U?̈Ⴂ?͂???̂??H?}???ɂ͋L???Ă??Ȃ????A?_?@A?̕s?Ε??U??s12??0.64?A?_?@B?̕s?Ε??U??s22??0.13?ƂȂ??Ă???B???̌??ʂ???A?u?_?@A?????_?@B?̕ꕪ?U???????????i???????肵?Ă???v?ƌ????????????A?ʂ????Ăǂ??Ȃ̂??B?????m?邽?߂ɂ?F???z?̒m?????K?v?ƂȂ?B
?@???U???r????ɂ́A???U?̔?????߂܂??B???i?????Z?j????Ȃ??Ĕ?i????Z?j?Ȃ?ł????A?Ǝv????????????Ǝv???܂??B????́A???U????悳?ꂽ?l??????ł??B??????Ƃ????Ⴆ?b?????Ă݂܂??傤?B
?@??悵???l?ōł??g?߂Ȃ??͖̂ʐςł??ˁB?????Ȃǂ̍L?????C???[?W????̂ɁA?悭?u?????h?[???????v?ƕ\?????邱?Ƃ?????܂??B?Ⴆ?A?????s????s?ɂ??鏺?a?L?O?????̖ʐς͖?1.8km2?i???J????Ă???ꏊ?͖?1.69km2?j?ŁA?????h?[???̖ʐς͖?0.047km2?ł??B?]???āA???a?L?O?????̖ʐς́A?????h?[????1.8/0.047??38.298???Ƃ??????ƂɂȂ?܂??B????́A??i????Z?j???g?????v?Z?ł??ˁB?ʐς??r????̂ɁA?????????1.8?|0.047??1.753km2???A?ȂǂƂ?????r?͂??܂???B????Ɠ????l?????ł??B
?@???U?̔?Ɋւ??镪?z??F???z?ƌĂ?܂??B?????ŁAF???z?̊m???ϐ??͂ǂ̂悤?Ȃ??̂??A?Ƃ????Ƃ??납??o?????A???̌?AF???z?̊m?????x???Ɨݐϕ??z???????????Ă????܂??傤?B
???U?̔?Ɋւ??镪?z ?` F???z?̊m???ϐ?
?@?????͌?ɂ??āAF???z?̊m???ϐ????ǂ̂悤?ɒ?`????邩???????Ă????܂??B?قȂ?2?̐??K??W?c????Ɨ??ɃT???v???????o?????Ƃ??l???Ă݂܂??傤?B?Ⴆ?A?_?@A?ň?Ă?ꂽ?Ԃǂ??̓??x???ꕽ????1?A?ꕪ?U??12?̐??K???z?ɏ]???A?_?@B?ň?Ă?ꂽ?Ԃǂ??̓??x???ꕽ????2?A?ꕪ?U??22?̐??K???z?ɏ]???Ƃ??????ꍇ?ł??B
?@???̂Ƃ??A???ꂼ??̕?W?c????T???v???????o???ăJ?C???l??12,??22?????߂?ƁA?m???ϐ?F?́A
?ƒ?`????܂??Bk1,k2?͂??ꂼ??̎??R?x?ł??B???̊m???ϐ??????R?x?ik1,k2?j??F???zF(k1,k2)?ɏ]???܂??B???o?????T???v???T?C?Y??n1?An2?̏ꍇ?Ak1??n1?|1,k2??n2?|1?ł??ˁB
?@?i1?j????????ƁAF?l?̓J?C???l?????R?x?Ŋ??????l?̔?ɂȂ??Ă??邱?Ƃ???????܂??B?J?C??敪?z?͂??̘A?ڂ???7???Ō????ʂ?A???U?Ɋւ??镪?z?ł??B???̂??Ƃ???AF???z?͕??U?̔?Ɋւ??镪?z?ł??邱?Ƃ???????܂??B
?@????ɁA???ꂼ??̃T???v?????狁?߂??s?Ε??U??s1?As2?ł???Ƃ???ƁA?i1?j???͈ȉ??̂悤?ɕό`?ł??܂??B
?@?i1?j?????i2?j???ɕό`????菇?ɂ??ẮA??̃R?????ʼn?????܂??Bs12/??12??s22/??22?́A?s?Ε??U?ƕꕪ?U?Ƃ̔?ł??ˁB?܂?A?T???v?????琄?肳?ꂽ?ꕪ?U?ƁA?ꕪ?U?Ƃ̈Ⴂ??\???܂??B?i2?j???͂????̔?ƂȂ??Ă??܂??B
?@???????A???ꂾ???ł̓C???[?W???N???Ȃ??Ǝv????̂ŁA?i2?j???ɋ?̓I?Ȑ??l????????Ă͂߂ĈӖ????l???Ă݂܂??傤?B??W?cA?ƕ?W?cB?̕ꕪ?U?????ꂼ????12??0.3, ??22??0.2?Ɖ??肷??ƁA
- ?P?[?X1?F s12??0.3, s22??0.4?̏ꍇ?i??W?cA?ɔ?ׂāA??W?cB?̃T???v?????狁?߂??s?Ε??U???ꕪ?U?ɑ??đ傫???ꍇ?j?́A
- ?P?[?X2?F s12??0.3, s22??0.2?̏ꍇ?i????????A?ꕪ?U?ƕs?Ε??U?????????ꍇ?j?́A
- ?P?[?X3?F s12??0.6, s22??0.2?̏ꍇ?i??W?cA?ɔ?ׂāA??W?cB?̃T???v?????狁?߂??s?Ε??U???ꕪ?U?ɑ??ď??????ꍇ?j?́A
?ƂȂ?܂??B
?@??W?c???琔?????̃T???v???????o?????ꍇ?́A?s?Ε??U?͕ꕪ?U?ɋ߂??Ȃ?܂??B???̏ꍇ?A???R?̂??ƂȂ???P?[?X2?ɋ߂??Ȃ?͂??ł??B
?@?Ƃ????킯?ŁAF???z?̊m?????x???͎??R?x???傫???Ȃ??F??1.0?̕ӂ?ɎR?????邱?Ƃ??z??????܂??i????ɂ??Ă͌?q???܂??j?B??W?cA?ɔ?ׂāA??W?cB?̕s?Ε??U???傫???ꍇ??F?l?????????Ȃ?A??W?cB?̕s?Ε??U?????????ꍇ??F?l???傫???Ȃ邱?Ƃ???????܂??B
?@?ł́A????F???z?̊m?????x???̒l?????߂āA???????Ă݂܂??傤?B
F???z???Ăǂ?Ȋ????̕??z?i1?j ?` ?m?????x???????????Ă݂悤
?@F???z?̊m?????x??f(x;k1,k2)?Ɨݐϕ??z??F(x;k1,k2)?͈ȉ??̎??ŕ\????܂??i?m???ϐ?x?Ǝ??R?xk1,k2??;?ŋ???ĕ\?L???Ă??܂??j?B??ɂ???āA?????̎????o????K?v?͑S??????܂???BExcel??F.DIST?????g???ΊȒP?ɓ????????߂???̂ŁA?y???X???[???Ă????????B
?@???????Ak1,k2?͎??R?x?AIz?͐????????ꂽ?s???S?x?[?^???ŁA
?ł??B?Ȃ??A?ڂ???肻???Ȑ????ł??ˁB??̃R?????ł??̒?`?ʂ?Ɍv?Z????????Љ?܂????AExcel??F.DIST?????g????F???z?̊m?????x???Ɨݐϕ??z???????????Ă݂܂??傤?B
?@F.DIST?????g???āAx??0.0?`6.0?ɑ???m?????x???̒l?????߁A?O???t??`???Ă݂܂??BF???z?̕ꐔ?͎??R?x?݂̂ł??B?܂?A???R?x?????܂?AF???z?̌`?????܂?܂??B
?@??ɁAF.DIST???̌`???????Ă????܂??傤?B
?}2?@F.DIST???Ɏw?肷?????F.DIST???ɂ́A?m???ϐ??̒l?iF?l?j?Ɓu???R?x1?v?u???R?x2?v???w?肷??i???u???R?x??1?v?u???R?x??2?v?Ƃ????Ӗ??ł͂Ȃ??A?u1?Ԗڂ̎??R?x?v?u2?Ԗڂ̎??R?x?v?Ƃ????Ӗ??ł??j?B???`???ɂ??Ă͂???܂Ō??Ă??????Ɠ??l?AFALSE???w?肷??Ίm?????x???̒l???ATRUE???w?肷??Ηݐϕ??z???̒l?????߂???B
?@?}3???A????̎??R?x?ɑ???F???z?̊m?????x???̒l?????߂ăO???t??`??????ł??i?ݐϕ??z???ɂ??Ă͎??̍??Ŏ?舵???܂??j?B?쐬?̎菇?͐}?̌?ɋL???Ă????܂??B
?}3?@F???z?̊m?????x???̗????R?x1??4, 5, 6, 10?Ƃ??A?????ɑΉ????鎩?R?x2??6, 8, 10, 20?Ƃ??āAx??0.0?`6.0?܂ł̊m?????x???̒l?????߁A?O???t??`???Ă݂??Bx?ƕ\?L????Ă???A???̒l???m???ϐ??iF?l?j?ł??邱?Ƃɒ??ӁBB?`E???͂??ꂼ??̎??R?x?ɑ???m?????x???̒l?B?O???t?쐬?̎菇?͌?̉ӏ????????Q?ƁB
?@?m?????x???̒l?????߂邽?߂̎菇?͈ȉ??̒ʂ?ł??B?????ɂ??Ă͒P?ɐ܂???O???t??`???????Ȃ̂ŁA???̓??͂ɂ̂ݏœ_?Ă邱?Ƃɂ??܂??B?O???t?쐬?̎菇?ɂ??Ă̓T???v???t?@?C?????Ɍf?ڂ??Ă????܂??B
?@?T???v???t?@?C??????????????_?E?????[?h???A?mF???z?n???[?N?V?[?g???J???Ď????Ă݂Ă????????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
?? Excel?ł̑?????@
- ?Z??B6??=F.DIST(A6:A66,B4:E4,B5:E5,FALSE)?Ɠ??͂???
- ?Â??o?[?W??????Excel?ŃX?s???@?\???g???Ȃ??ꍇ?́A???ʂ????߂???Z???͈́i?Z??B6?`E66?j?????炩???ߑI?????Ă????A??????͂?????A???͂̏I?????ɁmCtrl?n?{?mShift?n?{?mEnter?n?L?[??????
?? Google?X?v???b?h?V?[?g?ł̑?????@
- ?Z??B6??=ARRAYFORMULA(F.DIST(A6:A66,B4:E4,B5:E5,FALSE))?Ɠ??͂???
?? ?O???t?̍쐬???@
- ?T???v???t?@?C?????Ɍf?ڂ??Ă????܂??i?^?C?g???⎲?̏????Ȃǂׂ̍????ݒ?͏ȗ??j
?@F???z?̑?i?m???ϐ?????蓾??l?͈̔́j??0?`???ł??B?}3?ł́A???̂?????0.0?`6.0?͈̔͂??O???t?????Ă??܂??B?O???t?????āA?܂??C?t???̂?F???z?̊m?????x???????E?Ώ̂łȂ????Ƃł??傤?B?܂??A???R?x???傫???Ȃ?ƁA?R?̍ł??????Ȃ?ʒu??x??1.0?́i?܂?F?l??1.0?ł???j?ʒu?ɋ߂Â??Ă??????Ƃ???????܂??B
?@F???z?̊??Ғl?i???ρj??k2/(k2?|2)?ł??B?]???āA???m?ɂ͎??R?x2???傫???Ȃ?ƎR?̍ł??????Ȃ?ʒu??x??1.0?ɋ߂Â??Ƃ??????ƂɂȂ?܂??B???????A?O???t?????E?Ώ̂ł͂Ȃ??A?R?????Ɋ???Ă??āA?E???ɐ????L????`?ɂȂ??Ă???̂ŁA???ۂɂ͎R?̍ł??????Ȃ?ʒu?͏??????ɂ???܂??B
?@???Ȃ݂Ɏ??R?x1???傫???Ȃ?ƎR?̒??S?t?߂??????Ȃ?A???????L????܂??B?}3?ł???????x??????܂????A?T???v???t?@?C???Ŏ??R?x1?⎩?R?x2??傫???ς??Ă݂?Ƃ??̂??Ƃ???????̂ŁA???낢??Ǝ????Ă݂ĉ??????B
F???z???Ăǂ?Ȋ????̕??z?i2?j ?` ?ݐϕ??z???????????Ă݂悤
?@?????āA?ݐϕ??z???ł??B??????́A???R?x(10, 20)?Ax??0.0?`4.0?̗Ⴞ???????Ă????܂??i?}4?j?B?m?????x???ŃO???t??x???ň͂܂ꂽ?͈̖͂ʐς??ݐϕ??z???̒l?ɂȂ邱?Ƃ????????߂ɁA?m?????x?????????č쐬???A???????O???t??ɏ????????Ă???܂??B?mF???z?ݐρn???[?N?V?[?g???J???āA?}?̌?̎菇?Ŏ????Ă݂Ă????????B?O???t?쐬?̎菇?ɂ??Ă̓T???v???t?@?C?????Ɍf?ڂ??Ă??????ƂƂ??܂??B
?}4?@F???z?̗ݐϕ??z???̗???̃O???t???m?????x???̃O???t?B?O???t??x???ň͂܂ꂽ?͈̖͂ʐρi???̗?ł͓h??Ԃ????????ȊO?̖ʐρj???ݐϕ??z???̒l?ɂȂ?B?h??Ԃ????????͉E???m???ɓ?????B???̃O???t?͗ݐϕ??z???̒l???v???b?g???????́B?Ⴆ?Ax??2.0?ɑ???ݐϕ??z???̒l??0.9102?ƂȂ?B?E???m????1?|0.9102??0.0898?B
?@?m?????x???̒l?????߂???@?͊??Ɍ????ʂ?ł????Ax??2.0?`4.0?͈̔͂?h??Ԃ??ĕ\?????邽?߂Ɏg???̂ŁA?????ċL???Ă????܂??B
?? Excel?ł̑?????@
- ?m?????x???̒l?????߂?
- ?Z??B4??=F.DIST(A4:A44,10,20,FALSE)?Ɠ??͂???
- ?Â??o?[?W??????Excel?ŃX?s???@?\???g???Ȃ??ꍇ?́A???ʂ????߂???Z???͈́i?Z??B4?`B44?j?????炩???ߑI?????Ă????A??????͂?????A???͂̏I?????ɁmCtrl?n?{?mShift?n?{?mEnter?n?L?[??????
- ?Z??B4??=F.DIST(A4:A44,10,20,FALSE)?Ɠ??͂???
- ?ݐϕ??z???̒l?????߂?
- ?Z??C4??=F.DIST(A4:A44,10,20,TRUE)?Ɠ??͂???
- ?Â??o?[?W??????Excel?ŃX?s???@?\???g???Ȃ??ꍇ?́A???ʂ????߂???Z???͈́i?Z??C4?`C44?j?????炩???ߑI?????Ă????A??????͂?????A???͂̏I?????ɁmCtrl?n?{?mShift?n?{?mEnter?n?L?[??????
- ?Z??C4??=F.DIST(A4:A44,10,20,TRUE)?Ɠ??͂???
- ?E???m????h??Ԃ????߂̊m?????x???̒l?????߂?
- ?Z??D4??=IF(A4:A44<2,#N/A,B4:B44)?Ɠ??͂???
- ?Â??o?[?W??????Excel?ŃX?s???@?\???g???Ȃ??ꍇ?́A???ʂ????߂???Z???͈́i?Z??D4?`D44?j?????炩???ߑI?????Ă????A??????͂?????A???͂̏I?????ɁmCtrl?n?{?mShift?n?{?mEnter?n?L?[??????
- ?Z??D4?`D44?ɂ͂??炩???ߏ????t????????ݒ肵?A?l??#N/A?̃Z???̕????F?𔒂ɂ??Č????Ȃ????Ă???܂??i????̓T???v???t?@?C?????Q?Ɓj
- ?Z??D4??=IF(A4:A44<2,#N/A,B4:B44)?Ɠ??͂???
?? Google?X?v???b?h?V?[?g?ł̑?????@
- ?m?????x???̒l?????߂?
- ?Z??B4??=ARRAYFORMULA(F.DIST(A4:A44,10,20,FALSE))?Ɠ??͂???
- ?ݐϕ??z???̒l?????߂?
- ?Z??C4??=ARRAYFORMULA(F.DIST(A4:A44,10,20,TRUE))?Ɠ??͂???
- ?E???m????h??Ԃ????߂̊m?????x???̒l?????߂?
- ?Z??D4??=ARRAYFORMULA(IF(A4:A44<2,#N/A,B4:B44))?Ɠ??͂???
- ?Z??D4?`D44?ɂ͂??炩???ߏ????t????????ݒ肵?A?l??#N/A?̃Z???̕????F?𔒂ɂ??Č????Ȃ????Ă???܂??i????̓T???v???t?@?C?????Q?Ɓj
?? ?O???t?̍쐬???@
- ?T???v???t?@?C?????Ɍf?ڂ??Ă????܂??i?^?C?g???⎲?̏????Ȃǂׂ̍????ݒ?͏ȗ??j
?_?@?̈Ⴂ?ɂ?蓜?x?̂???͈قȂ?̂??H
?@???āA?`???̂??b?̑????ł??B?_?@A?Ɣ_?@B?Ƃŕꕪ?U?ɈႢ?????邩?ǂ????i?_?@B?̕ꕪ?U?̕??????????̂??j??m?肽???Ƃ??????Ƃł????B?܂??i2?j?????Čf???܂??B
?@???̎??????F?l?????߂????̂ł????A?????????ꕪ?U?????????Ă??܂???B?????ŁA?ꕪ?U?????????Ɖ??肵?܂??傤?B???ꂪ?ے?ł???Εꕪ?U?ɈႢ?????邱?ƂɂȂ?܂??ˁB?܂?A?i2?j??????12????22?ł?????̂Ƃ??܂??B????ƁA
?ƂȂ?܂??B?s?Ε??U?̔䂪???̂܂?F?l?ɂȂ?Ƃ????킯?ł??B
?@s12????s22?̒l???傫?????F?l?????????Ȃ?A?ݐϊm???????????Ȃ?܂??B?t?ɁAs12????s22?̒l???????????F?l???傫???Ȃ?A?E???m???????????Ȃ?܂??B?O?҂͊m?????x???̃O???t?ŁA?????̒l?????????Ȃ????ꍇ?ɓ?????A??҂͑傫???Ȃ????ꍇ?ɓ?????܂??i?}5?j?B
?}5?@F?l?̑召?Ɨݐϊm???A?E???m???s?Ε??U?̔?iF?l?j?????????Ȃ?ƁA?ݐϊm???????????Ȃ?B?t?ɕs?Ε??U?̔䂪?傫???Ȃ?ƁA?E???m???????????Ȃ?B?s?Ε??U?̔䂪1?ɋ߂??Ɨݐϊm???̓O???t?̔????̖ʐς?0.5?ɋ߂??Ȃ?B
?@?ł́A?ȉ??̕\1?Ɏ????T???v???Ŋm?F???Ă݂܂??傤?B?ꕪ?U?????????Ɖ??肷??ƁA?s?Ε??U?̔?A?܂?F?l???ɒ[?ɏ??????Ȃ?i?ݐϊm???????????Ȃ?j???Ƃ͂Ȃ??͂??ł??B?t?ɁAF?l???ɒ[?ɑ傫???Ȃ?i?E???m???????????Ȃ?j???Ƃ??Ȃ??͂??ł??B?c?c???A???????????m???̏????Ȃ??Ƃ??N???????̂ł???A?ꕪ?U?????????Ƃ???????????i???j?ĂȂ???Ȃ?܂???ˁB
| ?_?@ | ?T???v?? |
|---|---|
| A | 19.3?@20.6?@20.7?@19.7?@19.4?@20.2?@20.3?@20.2?@20.7?@19.5 |
| B | 20.1?@19.9?@19.7?@20.4?@20.2?@20.7?@20.4?@19.9?@20.9?@20.4 |
| ?\1?@?_?@A?Ɣ_?@B??????o?????T???v???̒l?i???x?j | |
?@?}6?́A?????̒l????ɂ??ꂼ??̕s?Ε??U?????߁AF?l?Ƃ???ɑ???ݐϊm???ƉE???m???????߂????̂ł??B?m???p??n???[?N?V?[?g???J???A?}???Ɏ??????菇?Ŏ????Ă݂Ă????????B
?}6?@F?l?̑召?Ɨݐϊm???A?E???m???_?@A?Ɣ_?@B?̃T???v???̒l?͏c?????ɓ??͂???Ă???B?s?Ε??U?????߂?Ɣ_?@B?̂???????????悤?Ɍ?????B?Z??F4?ŋ??߂??s?Ε??U?̔䂪F?l?ƂȂ?BF?l????ɃZ??F6?ʼnE???m???????߂??0.141?i??14.1???j?ƂȂ?B???R?x??9?ł??邱?Ƃɒ??ӁB
?@???ʂ?14.1???ƂȂ?܂??B??ʂɁA5?????邢??1???ȉ??ł???u?܂?ɂ????N????Ȃ????Ɓv?ƍl?????A?ꕪ?U?????????Ɖ??肷??ɂ͖?????????i?_?@B?̕ꕪ?U?????????j?Ƃ??????ƂɂȂ?܂??B???????A???̏ꍇ?A??r?I?????Ȓl?ł???Ƃ͂????A?ꕪ?U?????????Ƃ?????????̂Ă?قǂł͂Ȃ??悤?ł??B?܂?A?_?@B?̕ꕪ?U?????????Ƃ͌????Ȃ??Ƃ??????ƂɂȂ?܂??i?Ƃ????Ă??A?????????i???j?Ă??Ȃ??Ƃ????????Ȃ̂ŁA???????ƒf?肷?邱?Ƃ͂ł??܂???j?B
?@???́A???̌v?Z?͓????U?̌???̂??߂̌v?Z?ɂق??Ȃ?܂???B???????A?A????????Η??????Ȃǂ̍l???????\???ɒm??????Ŏg???K?v??????̂ŁA???̎??_?Łu???_?͂??????I?v?ƌ?????̂͏????҂??Ă????????B?????U?̌???ɂ??Ă͐??????v?҂ł??b?????܂??B
F???z?̗ݐϕ??z???ɑ???t???́H
?@F.INV????F.INV.RT?????g???AF???z?̗ݐϕ??z???ɑ???t???̒l?????߂??܂??B
?@F.INV???ɂ͍????m???Ǝ??R?x1?A???R?x2???w?肵?AF.INV.RT???ɂ͉E???m???Ǝ??R?x1?A???R?x2???w?肵?܂??B?Ⴆ?A???R?x1??6?A???R?x2??10??F???z?ŁA?ݐϊm???i?????m???j??95???̂Ƃ???F?l??=F.INV(95%, 6, 10)?ŋ??߂??܂??B???ʂ?3.217?ƂȂ?܂??B???̊m???́A?E???m????5???̂Ƃ???F?l?Ɠ??????Ȃ?̂ŁA=F.INV.RT(5%, 6, 10)?̌??ʂƈ?v???܂??B?Ă???Z???ɂ????̎?????͂??Ă݂Ċm?F???Ă????Ă????????B
?@?Ȃ??A?????̗?́mF???z?̋t???n???[?N?V?[?g?ɓ??͂???Ă??܂??BF???z?̗ݐϕ??z???ɑ???t???̒l?́A?ꕪ?U?̔?̋?Ԑ???ȂǂɎg???܂??B?ڍׂ͐??????v?҂ł??b?????܂??B
?@?????܂ŁAF???z?̊m???ϐ??Ɗm?????x???A?ݐϕ??z???ɂ??Č??Ă??܂????B?܂??A???p??Ƃ??āA?????U?̌???ɂȂ??邨?b?ɂ??i???Ȃ?j???ݍ??݂܂????B????????́A??????V?~?????[?V?????ɂ????F???z?ɂ??Ă̗?????[?߂Ă????????Ǝv???܂??B???p?I?ɂ͒m??Ȃ??Ă????܂??肪?Ȃ??̂ŁA?????????ȕ??́A?Ō?́u???̋L???Ŏ??グ?????̌`???v???m?F???āA????͂??J???Ƃ??Ă?????Ă??\???܂???B
?R?????@F???z?ƃJ?C??敪?z?A?s?Ε??U?̊W
?@?`???Ō????i1?j?????i2?j???ɕό`????菇????????܂??B?i1?j???Ɓi2?j???????ꂼ??Čf???Ă????܂??傤?B
?@?ꕽ?ς????m?̏ꍇ?ɃJ?C??敪?z?̊m???ϐ????ȒP?ɋ??߂???@?????̘A?ڂ???7???ŏЉ?܂????B???R?xn?|1??k?ƕ\???ƁA?ȉ??̂悤?ɂȂ?܂??B
?@???ӂ????ꂼ????1,??2?ł???A
?ƂȂ?܂??B?i3?j???Ɓi4?j?????i1?j???ɑ?????Ă݂܂??傤?B
?ƂȂ?܂??B?????Ɓi2?j???ɂȂ??Ă??܂??ˁB
?R?????@F???z?̊m?????x?????V?~?????[?V?????ŋ??߂?
?@?ꕪ?U????1,??2??2?̐??K??W?c????n1,n2?̃T???v???????o???ĕs?Ε??U?????߁A??Ō????i2?j????F?l???J??Ԃ????߂Ă݂܂??傤?B?q?X?g?O???????쐬????ƁA???R?x1??n1?|1?A???R?x2??n2?|2??F???z?ɏ]???͂??ł??B
?@?Ƃ????킯?ŁA?V?~?????[?V???????Ă݂܂??傤?B?V?~?????[?V??????Excel?ł??ł??܂????A?????̃Z?????g???K?v??????A??????Ɩʓ|?ł??B?ꉞ?T???v???t?@?C???ɂ͍쐬??i?mF???z?̃V?~?????[?V?????n???[?N?V?[?g?j???܂߂Ă????܂????A?????ł́APython?̃v???O???????g?????Ƃɂ??܂??i???X?g1?j?B
?@?T???v???v???O?????͂?????????Q?Ƃł??܂??B?????N???N???b?N????A?u???E?U???N?????AGoogle Colaboratory?̉?ʂ??\??????܂??iGoogle?A?J?E???g?ł̃??O?C?????K?v?ł??j?B?ŏ??̃R?[?h?Z?????N???b?N???A?mShift?n?{?mEnter?n?L?[???????ăR?[?h?????s???Ă݂Ă????????B???ʂ͐}7?̂悤?ɂȂ?܂??B?R?[?h?̏ڍׂɂ??Ă͉?????܂??A?R?????g?ƃ??X?g1?̐?????????Ή???????Ă??邩????̕?????Ǝv???܂??B
# F???z?̊m?????x???̃V?~?????[?V????
import numpy as np
import matplotlib.pyplot as plt
from scipy.stats import f
# ???K???zN1?i??=3?A??^2=3?j???烉???_????10?̃T???v???????o???????̂?10000???
x1_varp = 3
x1 = np.random.normal(loc=3, scale=np.sqrt(x1_varp), size=(10000, 10))
# ???K???zN2?i??=4?A??^2=5?j???烉???_????10?̃T???v???????o???????̂?10000???
x2_varp = 5
x2 = np.random.normal(loc=4, scale=np.sqrt(x2_varp), size=(10000, 10))
# ?T???v???̕s?Ε??U???v?Z
x1_vars = np.var(x1, axis=1, ddof=1)
x2_vars = np.var(x2, axis=1, ddof=1)
# F?l?????߂?
F = (x1_vars/x1_varp) / (x2_vars/x2_varp)
# ?q?X?g?O??????`???iF?l???ǂ̂悤?ɕ\??邩????????j
plt.hist(F, bins=100, range=(0, 6), density=True) # ?K????100?A?c???͊m???Ƃ???
# F???z?̊m?????x????`??
x = np.linspace(0, 6, 100) # 0?`6?܂ł?100?ɕ?????????????i?????̒l?j
plt.plot(x, f.pdf(x, 9, 9)) # x?ɑ???F???z?̊m?????x???̒l???v???b?g????
plt.show()
???K???zN1?i?ʁ?3, ??2??3?j?Ɛ??K???zN2?i?ʁ?4, ??2??5?j???烉???_????n??10?̒l?????o?????Ƃ?10000???J??Ԃ??B10000?s?~10??̃f?[?^???????̂ŁA?e?s?̕s?Ε??U?????߂?B10???̃f?[?^?̕s?Ε??U??10000??????邱?ƂɂȂ?B????10000???̕s?Ε??U?ƕꕪ?U?????F?l?????߂?B?????āA?c?????m???Ƃ???F?l?̃q?X?g?O??????`???B?Ō?ɁA???R?x1??9?A???R?x2??9??F???z?̊m?????x????`???A?q?X?g?O?????Ƃقڏd?Ȃ邱?Ƃ???????B
?@???X?g1?̎??s?Ⴊ?ȉ??̐}7?ł??B???????g???̂Ō??ʂ͖??????قȂ?܂????A?قƂ?Ǐd?Ȃ??Ă??܂??ˁB
?}7?@F???z?̊m?????x???̃V?~?????[?V?????????_?O???t?́A2?̐??K???z????10???̃T???v????10000?????o???A?????̕s?Ε??U?ƕꕪ?U????ɋ??߂?F?l???q?X?g?O?????ɂ??????́B?܂???O???t?͎??R?x1??9?A???R?x2??9??F???z?̊m?????x???B
?R?????@F???z?̊m?????x???Ɨݐϕ??z???𐔎??ŕ\??
?@?ŏ??ɁAF???z?̊m?????x??f(x;k1,k2)?Ɨݐϕ??z??F(x;k1,k2)??\???????f?ڂ??܂????i?m???ϐ?x?Ǝ??R?xk1,k2??;?ŋ???ĕ\?L???Ă??܂??j?B?????????ڂ????m?肽?????̂??߂ɁA??`?ʂ?Ɍv?Z??????@???Љ?Ă????܂??B
?@???????Ak1,k2?͎??R?x?AIz?͐????????ꂽ?s???S?x?[?^???ŁA
?Ƃ??܂??B
?@???͂??̘A?ڂʼn??x???o?ꂵ???K???}???ł??B?K???}???ƕs???S?x?[?^???̒?`?ɂ??ẮA?O??Љ???̂ŁA????????Q?Ƃ??Ă??????????ƂƂ??āA?????ł́AExcel?̊????g?????v?Z???@???????????Ă????܂??B?K???}???̒l??GAMMA???ŋ??߂??A?s???S?x?[?^???̒l??BETA.DIST???̗ݐϕ??z???ŋ??߂??܂??B
?@?Ⴆ?A???R?x1??6?ŁA???R?x2??10?̏ꍇ?AF??2?ɑ???m?????x???̒l???i5?j???̒?`?ɏ]???ċ??߂????ꍇ?́Ak1??6?Ak2??10?Ax??2???????邾???ł??B???q??
?@?@=GAMMA((6+10)/2)*(6/10)^(6/2)*2^(6/2-1)
?ŋ??߁A?????
?@?@=GAMMA(6/2)*GAMMA(10/2)*(1+6/10*2)^((6+10)/2)
?ŋ??߂Ċ???Z????????ł??ˁB???q??4354.56?A?????26340.42?ƂȂ?̂ŁA???ʂ?0.1653?ƂȂ?܂??B????A?ݐϕ??z???̒l???i6?j???ɏ]???ċ??߂????ꍇ?́ABETA.DIST????z?̒l??a??k1/2, b??k2/2?̒l???w?肵?܂??B?]???āA
?@?@=BETA.DIST(6*2/(6*2+10), 6/2, 10/2, TRUE)
?Ɠ??͂??܂??B???ʂ?0.8411?ƂȂ?܂??B?T???v???t?@?C???́mF???z?i??`?ʂ?Ɂj?n???[?N?V?[?g?ɂ͏?̂悤?Ȓl?ł͂Ȃ??A?Z???A?h???X???w?肵??0.0?`6.0?܂ł̊m?????x???̒l?Ɨݐϕ??z???̒l?????߂?????܂߂Ă???܂??B?????Ƃ??A???p?I?ɂ?F.DIST?????g?????????֗??ł??ˁB
?@?????F???z?̊m???ϐ??ł???F?l?̈Ӗ??₻?̋??ߕ??A????ɁAF???z?̊m?????x???Ɨݐϕ??z???̋??ߕ??Ȃǂɂ??Ă??b?????܂????B???????v?҂̓??e?ɂ??Ă??A???Ȃ蓥?ݍ???ł??b?????Ă??܂??܂????BF???z?́A?ꕪ?U?̔?̋?Ԑ???ⓙ???U?̌???ȂǂɎg???܂????A?????ł́AF???z?̊m???ϐ??Ɗm?????x???A?ݐϕ??z???ɂ??Ă̗?????[?߂Ă?????????Ώ\?????Ǝv???܂??B
?@????͈?莞?ԓ??ɉ??炩?̎??ۂ??N????m???????߂?ꍇ?ȂǂɎg????w?????z?ɂ??Ă??b?????܂??B????????y???݂ɁI
???̋L???Ŏ??グ?????̌`??
?@???̗??p??ɂ??ẮA???̋L???̒??ŏЉ?Ă???ʂ?ł??B?????ł́A??????グ?????̊?{?I?ȋ@?\?ƈ????̎w????@???????????Ă????܂??B
F???z?̊m?????x????ݐϕ??z???̒l?????߂邽?߂̊?
F.DIST???FF???z?̊m?????x????ݐϕ??z???̒l?????߂?
?`??
F.DIST(x, ???R?x1, ???R?x2, ???`??)
????
- x?F ?m???ϐ??̒l?iF?l?j???w?肷??B
- ???R?x1?F ???R?x1???w?肷??B
- ???R?x2?F ???R?x2???w?肷??B
- ???`???F ?ȉ??̒l???w?肷??B
- FALSE ?c?c ?m?????x???̒l?????߂?
- TRUE ?c?c ?ݐϕ??z???̒l?????߂?
???l
???ݐϕ??z???̒l???????m???i?܂????????m???j?Ƃ??Ă?܂??B
F.DIST.RT???F F???z?̉E???m???̒l?????߂?
?`??
F.DIST.RT(x, ???R?x1, ???R?x2)
????
- x?F ?m???ϐ??̒l?iF?l?j???w?肷??B
- ???R?x1?F ???R?x1???w?肷??B
- ???R?x2?F ???R?x2???w?肷??B
???l
??1????AF.DIST???ŋ??߂???ݐϕ??z???̒l?????????l???Ԃ???܂??B
F???z?̗ݐϕ??z???ɑ???t???̒l?????߂邽?߂̊?
F.INV???F F???z?̗ݐϕ??z???ɑ???t???̒l?????߂?
?`??
F.INV(?ݐϊm??, ???R?x1, ???R?x2)
????
- ?ݐϊm???F ?ݐϕ??z???̒l???w?肷??B
- ???R?x1?F ???R?x1???w?肷??B
- ???R?x2?F ???R?x2???w?肷??B
???l
???ݐϊm???ɂ͍????m???̒l???w?肵?܂??B?E???m???ɑ???t???̒l?????߂????Ƃ??ɂ́AF.INV.RT?????g?????A1?|?E???m?????w?肵?܂??B
F.INV.RT???F F???z?̉E???m???ɑ???t???̒l?????߂?
?`??
F.INV.RT(?E???m??, ???R?x1, ???R?x2)
????
- ?E???m???F ?ݐϕ??z???̉E???m???̒l???w?肷??B
- ???R?x1?F ???R?x1???w?肷??B
- ???R?x2?F ???R?x2???w?肷??B
???l
???Ⴆ?A?E???m????5%?̏ꍇ??F?l?́AF.INV???ō????m????95%?Ǝw?肵???ꍇ??F?l?ƈ?v???܂??B
?u?₳?????m?????z?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
?ҏ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??? | ??????


?H?R??





















