mf[^́nz ` ioj̊m߂IF₳mz
f[^͂̏牞p܂ŏXebvAbvȂwłAځimzҁj̑3B܂uoiFjƂ͉vB̊mzł钴zグÄӖȂǂ܂B
AځF
@̘Aڂ́Af[^܂܂Ȋpx番͂A̔wɂLvȏo@wwЉl1NwԁA₳f[^́xAځiLqvƉA͕ҁj̑҂ŁAmzɏœ_ĂĂ܂B
@̊mz҂ł́Av̊bƂȂ邳܂܂Ȋmz̓≞p܂Bg߂Ɏg\vZ\tgiMicrosoft ExcelGoogleXvbhV[gjgȂ̓IɎĂ܂B
@KvɉāAPythoñvOⓝv\tguRvȂǂł̍쐬ɂG邱Ƃɂ܂B
@wȂǂ̑Om͓ɖ₢܂BwEZ̋ȏx̐oꂷ邩܂AKvɉĐt̂łSzȂB̗͂ĂЂƂCyɓǂݐi߂ĂB
HRMҏЉF ITnC^[̖TAutƂēŏEvO~O֘A̎ƂAꋴAI֘A̎ƂSB̌͐SĂ܂99ŒfBSx@\߂邽߂ɐjn߂AɏBB܂A^[C_[Ƃĉ\NԂ肩ɑ^oCNɂ܂A̗͕͂sɊBb邽߂ɍŋ߂͎l҂ޓXBS^]Ȃ̂ŁAt`ɔ邱Ƃi蔲LPAxĂˁIjB
@f[^͂̏牞p܂ŏXebvAbvȂwłAڂ̊mzҁA3łBO͗Uz̊bƂăxk[CzƓzグ܂B́uoƂ͉vbÅmzł钴zグÄӖȂǂĂ܂B
s{Im߂ɂ́H
@XX̕iӂтjŁA1̉sɃ`WivׂĂ݂ĂB茳ɂ镟3ƌɁuKKv3AƂA11{m߂Ă݂Ǝv܂B
@KḰuK|vƂĂт܂B@ɂ܂A2000`3000̋ʂ̂悤łBȂẤuV䎮]o@vłB
@̗́ARCTCRA邢ŐLŌqbgomƌIɈقȂ_܂B͂ł傤B}1ȂAႢlĂ݂ĂB
@ł́Ab₷邽߁A1̉s10{3{̂Ƃ܂B܂AKKɂ͋ʂ10ĂāA肪3Ƃ킯łBۂɂ͂Ȃɓ₷͂܂AqbgomƔr₷lƂ܂B̏ꍇɁA3̃`ŴA11{ml܂B
}1@oƔoi3l̑Ŏ҂qbg1{łmƁA3̕11{m̈ႢjႢ₷邽߁Aꂼ̊mŕ\ĂBqbgom͏3/10i103jBȀꍇ͑O̎sœ肪oǂɂĎ̊mςB}ɂ́A1{ڂqbgij̊mĂBۂɂ́A2{ڂqbgij̏ꍇ3{ڂqbgij̏ꍇB̏ꍇ܂߂mɂĂ͌qB
@싅̗ł́Aꂼ̑Ŏ҂qbgłǂƗłƂOłB܂AȎŎ҂qbgłĂA}ނłĂȂŎ҂qbgłm3/100.3A}ނm7/100.7ƂȂ܂B
@Ȁꍇ́AKKтɋʂ1Ă܂BO̎sœ肪oAOꂪoɂāA̎sœ肪omς܂BႦAŏłm3/100.3łA͋ʂ1̂őŜ9ƂȂA2Ɍ܂BO͑ς炸7̂܂܂łB̏ꍇA2Ԗڂ̋ʂłm2/9ŁAOłm7/9łB̂悤ɁAO̎šʂ̎s̊mɉe悤ȏꍇ]ƌĂт܂B
@싅̗́AႦΐԋʂ3Aʂ7̍v10̋ʂĂiځjʂoAoʂɖ߂ꍇƓłBʂ̑ԋʂƔʂ̌ς܂B̂悤ȎooƌĂт܂B
@Á̗Aoʂɖ߂ȂꍇƓłBʂoтɋʂ̌1Ă܂B܂Aԋʂoΐԋʂ̌AʂoΔʂ̌܂B̂悤ȎooƌĂт܂B
R@tmƂ
@̃ŔAb̗ꂩ班ÔŁAɐi݂͓ǂݔĂĂ\܂B
@̗ł́A1ڂœɊOmƁA1ڂŊOɂ܂Om͈قȂ܂ˁBu1ڂɓvƂۂAƕ\Au2ڂɊOvƂۂBƕ\ƁA1ڂɓƂ̉ŁA2ڂɊOmP(B|A)ƕ\킳܂BP(B|A)tmƌĂ܂B
@tmɂẮAȉ̎itm̏@j藧܂B
- P(AB) cc 1ڂɓA2ڂɊOmi1ڂ2ڂ̗m̂Ɓj
- P(B|A)cc 1ڂɓꍇɁA2ڂɊOmi2ڂ̊m̂Ɓj
@}11ڂ2ڂグƁAȉ̂悤ɂȂ܂B
@Ȃ̂ŁA
ƂȂA}1̗̕Ōŏ2ɓĂ͂܂܂B
@tm̏@̓xCYvw̏o_ƂȂłBڍׂɂẮAmAIE@BwK̐wn@BwKł悭guxCY̒藝v𗝉QƂB
z͔o̊mz
@ł́A̗ŁA3̂1m߂Ă݂܂B}1ł1{ڂ̗܂A2{ڂ̏ꍇƁA3{ڂ̏ꍇ܂B
@oŁANÂ̐MAsnAŝ̐k̏ꍇ̊mzzi傤ԂՁAHypergeometric distributionjƌĂт܂BŏɒžĂ܂BmϐlkƂ܂Bŋ̓IȗȂ璴z̈ӖقĂ̂ŁAłȂĂCɂɐi߂ĂivZɂĂAqExcelHYPGEOM.DISTgΊȒPɂł܂jB
@̎ɂ( )́AxNgsł͂ȂAgݍ킹\܂BvZ@ɂẮAŐLŐ܂̂ŁAYꂽꍇ͂KĂB
@܂́ANAMAnAkA̗łǂ̒lɓ邩mFĂ܂傤BIWF̕NbN܂̓^bvƓ\܂B
| l | Ӗ | ̗ł̒ĺH |
|---|---|---|
| N | @10@ | |
| M | ̂̐ | @3@ 1̋ʂ̌ |
| n | s | @3@ KK邩 |
| k | ŝ̐ | @1@ 1̋ʂo |
@i1jɒlĂ͂߂ƁA肪1{om߂܂i}1Ō1{ڂ̏ꍇłȂA2{ڂ̏ꍇA3{ڂ̏ꍇ܂߂młjB( )ŕ\gݍ킹̌vZ@͌Ő܂Bł͌vZʂm߂ĂB
@F A@3@AC@10@AE@1@AG@3@
@肠m͋߂܂B͕̗̓IɌȂǍʂƈv邱ƂmF܂B܂Ǎ̈ӖɂĂA炽߂Đ܂B
@łɏqׂ悤ɁA}1Ō̂3̎ŝA1ڂɓmłB3̎ŝA1{̂́A2ڂɓꍇƁA3ڂɓꍇ܂BSĐ}ɂĂ݂܂傤i}2jB
@̏ꍇA10~9~8ŁAq́i|Z͈̏قȂ܂j3~7~6łB3ʂ̏ꍇ̂ŁA߂m͈ȉ̂悤ɂȂ܂B
@ŋ߂ʂƈv܂ˁBł炽߂ČmFĂ܂傤B
@̗N10, M3, n3, k1Ă͂߂āAӖĂ݂܂i}3jBN|M10|37, n|k3|12łB
@}3̎vZĂ݂܂傤B͈ȉ̂悤ɂȂ܂B
@q͈ȉ̂悤ɂȂ܂B
@]āAf(1)̒l͈ȉ̂悤ɂȂA}2ł̌vZƈv܂ˁB
z̊mʊƗݐϕzĂ݂悤
@܂ł́A1{mĂ܂łB܂Amϐ̒lk1̏ꍇłB̗łASĊOik0jA3{Ƃik3j̏ꍇ܂ł̂ŁÅmSċ߁AmʊƗݐϕzĂ݂܂傤B
@i1jgČvZ邱Ƃł܂AExcelHYPGEOM.DISTgΊȒPłBʂ͐}4̂悤ɂȂ܂BOt쐬̎菇͐}4̌ɋLĂ܂B
@Ot쐬̎菇͈ȉ̒ʂłBTvt@C_E[hAmzn[NV[gJĎĂ݂ĂBGoogleXvbhV[g̃Tv͂JƂł܂Bj[mt@Cn|mRs[쐬nIAGooglehCuɃRs[ĂgBȂAGoogleXvbhV[gHYPEGEOM.DISTɂ͍Ō̈Ȃimʊ̒l߂ȂjƂɒӂKvłB̓Iȑ@́ATvt@CɋLڂĂ܂B
Excelł̑@
- ZB7=HYPGEOM.DIST(A7:A10,B4,D3,B3,FALSE)Ɠ͂
- Âo[WExcelŃXs@\gȂꍇ́A炩ߌʂ߂Ź͈iZB7`B10jIĂA͂A͂̏IɁmCtrln{mShiftn{mEnternL[
- ZC7=HYPGEOM.DIST(A7:A10,B4,D3,B3,TRUE)Ɠ͂
- Âo[WExcelŃXs@\gȂꍇ́A炩ߌʂ߂Ź͈iZC7`C10jIĂA͂A͂̏IɁmCtrln{mShiftn{mEnternL[
- ZB6`C10I
- m}n^uJAmOt̑}n{^NbNāmWc_ - ܂nI
- mOt̃fUCn^uJAmf[^̑In{^NbN
- mf[^\[X̑In_CAO{bNXŁmiځjxn̉́mҏWn{^NbN
- mxn_CAO{bNXŁmx͈̔́n{bNXNbNAZA7`A10I
- mOKnNbNāmxn_CAO{bNX
- mOKnNbNāmf[^\[X̑In_CAO{bNX
@HYPEGEOM.DIST̈͐}5̂悤Ɏw肵܂BWcƂ͏WcŜ̂ƂŁA̗ŌAKK̒ɓĂʑŜ̂ƂłBW{Ƃ͕Wcô̂ƂłB}5ɂ́Az̊mʊ̌ĎĂ̂ŁAΉmFĂĂB
}5@HYPGEOM.DISTɎw肷}4̗ł́AW{̐ikɓlړI̎ۂNjƂA7:A10ƂZ͈͂w肵Ă̂ŁAXs@\ɂZA7`A10̐ɑmʊ̒lݐϕz̒lxɋ߂BExcel̃wvɂ́A2Ԗڂ̈uW{vƋLĂ邪AW{ƂṕAW{̒os\AW{ނ邩iO[v̐j\肷̂ɎĝŁÂȂ悤ɁuW{̑傫vƂB
@ȂATvt@Cɂ́Ai1jɏ]ĊmʊƗݐϕz̒l߂܂߂Ă܂B̂͂QƂB
zƒz
@zƒz̈Ⴂ́Aoł邩oł邩ƂƂłBWc傫ȂƓzƒz̒l͂قړȂ܂BႦA100{̂1{ƂĂAc̐͂قƂǕςȂłic999999{łˁjBTvt@Cɂ͓肪30{100{̂10Ƃ́Azƒzf(0)`f(10)̒l߁AOt`܂߂Ă܂i}6jBN100łȂ߂lɂȂĂ邱Ƃ܂B
@́Ao̊mzƂĒzグ܂Bz͂Ō̊m߂邾łȂAf[^̌Ȃꍇ̓Ɨ̌Ȃǂɂg܂B̂ƂɂĂAЉƎv܂B
@āÁAU^mz̕ʂ̗ƂāA܂ɂNȂۂ̊m߂邽߂Ɏg|A\zグ܂By݂ɁI
̋LŎグ̌`
@̗pɂẮA̋L̒ŏЉĂʂłBł́Aグ̊{Iȋ@\ƈ̎w@Ă܂B
z̊mʊݐϕz̒l߂邽߂̊
HYPGEOM.DISTF z̊mʊݐϕz̒l߂
`
HYPGEOM.DIST(W{̐, W{̑傫, Wc̐, Wc̑傫, `)
- W{̐F W{̒ŖړI̎ۂN鐔w肷B
- W{̑傫F WcoW{̐is̑jw肷B
- Wc̐F Wc̒ł̖ړI̎ۂN鐔w肷B
- Wc̑傫F WcŜ̐w肷B
- `F ȉ̒lw肷B
- FALSE cc W{̐ɑmʊ̒l߂
- TRUE cc W{̐܂ł̗ݐϕz̒l߂
u₳mzv
Copyright© Digital Advantage Corp. All Rights Reserved.
ڂ̃e[}
ITmedia̓ACeBfBAЂ̓o^WłB