Microsoft Mathematics ãæšæºæ£èŠååžé¢æ°ãèšç®ããŠãããªãã®ã¯ãããã£ããã§ã¯ã©ããŸã§ãªãèšç®ããŠãããã®ããããã£ãŠã¿ãã
ãŸãã¯f(x)=xã®ãåºé [-1,1] ã§ã®å®ç©åãããããªãã§ãããã¯ãã£ãŠãããªããã
ã¹ãã³ãµãŒãªã³ã¯
Â
Â
ãâ è§£æ³ããšããã®ãŸã§åºããŠãããããâããã¯ãªãã¯ãããšã次ã®ããã«èª¬æããŠãããã
次ã«ãf(x)=exp(x)ã®ããã¯ãåºé [-1,1] ã§ã®å®ç©åãæ±ããŠã¿ãã
èšç®ã¯ããŠãããããã ãè§£æ³ãŸã§ã¯è¡šç€ºããŠãããªãã£ãã
次ã¯ãf(x)=exp(-x)ããã£ãŠã¿ãã
ããããã§ããã
ããããf(x)=exp(-x^2)ã
ããã§åå°œãããïŒ
ã¡ãªã¿ã«ãã®ç©åã«ã¯ãã¬ãŠã¹ç©åããšããååãã€ããŠããŠãWordã®æ°åŒã®ã¡ãã¥ãŒã®ãOffice.com ã®ãã®ä»ã®æ°åŒ(M)ãããã¯ã³ã¯ãªãã¯ã§æ¿å ¥ã§ããŠããŸãïŒ
Wordããã¥ã¡ã³ãã«æ¿å ¥ãããšããã
ãããã®æªæ ã¯ã€ããããã®ã§ããã
ã¡ãã£ãšãã©ããŒãããšãWordã§äœã£ãæ°åŒãMathematicsã«ã³ããŒããŠãèšç®ããŠããããªã©ã䟿å©ãªããšã¯ä»ã«ããããã§ããã
ããã¯ãšããããå®ã¯æšæºæ£èŠååžãæ£èŠååžãäžãã颿°ã¯ãExcelã®ã»ãã«å®åãããŠããããããã£ã¡ã䜿ãã°ãããšãã話ã¯ããã
ãã€ãã®æç§æžãæ°ç¢ºççµ±èšãã®P71ã«ããããªäŸé¡ãããã
[äŸé¡6] Z ãæšæºæ£èŠååžã«åŸããšãïŒæ¬¡ã®ç¢ºçã®å€ãæ±ããïŒ
(1) P (0.61 ⊠Z ⊠0.82ïŒ
(2) P (Z â§ 1.57ïŒ
(3) P (Z ⊠ïŒ2.06ïŒ
(4) P (ïŒ1 ⊠Z ⊠2ïŒ
å€èŠã¯æ°åŠã®æ°åŒãšäŒŒãŠã䌌ã€ããªããããããã¯Excel颿° âNORM.S.DISTâïŒExcel2007以åã§ã¯ âNORMSDISTâïŒã䜿ã£ãŠè§£ãããšãã§ãããæšæºæ£èŠé¢æ°ã®ãè² ã®ç¡é倧ããã®çޝç©å€ãäžãã颿°ã ã
ãŸãã¯(1)ãåèãŸã§ã«æ°åŒãæ¿å ¥ããŠãããExcelã§ãWordãšåæ§ã«æ°åŒãæ¿å ¥ããããšãã§ãããããã ã®ã³ã¡ã³ãã«ããã颿°ã®å€ãæ±ããã®ã«äœã®åœ¹å²ãæãããŠããªãã颿°ã®äœ¿ãæ¹ã¯ãæ°åŒããŒããåç §ãã ããã
(2)ãæ£ã®ç¡é倧ããã®çޝç©å€ãæ±ããããã«ã¯ãæšæºæ£èŠååžãå¶é¢æ°ã§ããããšãå©çšããç©ååºéã [1.57,â] ãã [ïŒâ,ïŒ1.57] ã«å€æããŠããããšã«æ³šæã
(3)ã
(4)ã
æãã«ãExcelã®åŒ±ç¹ã®äžã€ã¯ãåæ°ãåæ°åœ¢åŒã®ãŸãŸæ±ãããšãã§ããªãããšãããªãã ããããã ããExcelã§ã¯ãçµåããäºé ååžãæ±ãããšã¯ã§ããªããã§ããããç¥ããªããã©ç§ã¯ç¥ããªãïŒè¿œèšïŒãã¿ãŸãããã§ããŸããçµã¿åããã¯COMBIN颿°ãäºé ååžã¯BINOM.DIST颿°ãšããã®ãçšæãããŠããŸãããè©«ã³ããŠèšæ£ããŸãïŒããæ°ç¢ºççµ±èšããšãšãã«ããã¿ãæ¬ã«äœ¿ãããŠããã£ãŠããã€ã³ãã¬ã¹ãã§ããã·ãªãŒãºãã®ãããããåŠã¶Excelçµ±èšå ¥éãã¯ããšãŠãããã§ããæ¬ã ãšæãããé åãçµåããäºé ååžãã¬ã³ç¡èŠããŠããç¹ãçã«çã ãšæããäºé ååžã¯æ£èŠååžããã¢ãœã³ååžãšå¯æ¥ãªé¢ä¿ããããã¿ã€ãã«ã§çµ±èšãåä¹ãæ¬ãæ±ã£ãŠããªãã®ã¯ãã¡ãã£ãšç©è¶³ããªãã
ïŒè¿œèšïŒãã¿ãŸããããã¡ããP74ã«ã詊è¡åæ°ãå¢ãããšæ£èŠååžã«è¿ã¥ãããšç޹ä»ãããŠããŸããããçšèªéããšã颿°INDEXãã«ãèŒã£ãŠããŸããããã¬ã³ç¡èŠãã£ãŠããšã¯ãªãã£ãã§ãã倱瀌ããŸããïŒ
æ³åãªãã ãã©ãcombination颿°ã®ãããªMicrosoft Mathematicsã®ããã€ãã®æ©èœã¯ãExcelã®å°æ¥ã®ããŒãžã§ã³ã§ã®æ¡çšãæ€èšããããéçºããããã®ãããªãã ãããïŒ
ãã ãææ°ããŒãžã§ã³ã§ããExcel2016ã«ã¯æªæèŒã®ããã ããExcelã§åæ°ãã©ãæ±ããããšãã宿é¡ã解決ãããŠããªãããã§ãããã
ãªãã§ããèããããšãããšãMicrosoft Mathematics ã«ã¯ãã€ã³ã¯ããšããæ©èœããããæ°åŒããã©ãã°ã§å ¥åããæ©èœã ã
ãŸãã¢ããªãã§ããã©ãã
ãã®ãã€ã³ã¯ããšããæ©èœã¯ãWordã»ãOffice2016ã«æ°æ©èœãšããŠé³Žãç©å ¥ãã§è¿œå ããããç§ã®ããœã³ã³ã¯2013ããã€ã³ã¹ããŒã«ããŠãªãã®ã§ãä»äººã®ããœã³ã³ã䜿ãããŠãããã¹ã¯ãªãŒã³ã·ã§ãããæ®ã£ãã
ãã£ã±ã䜿ããªãã£ãã
远èšïŒ
ãã¿ãŸãããExcel2013ã«ã¯çµåããèšç®ãã颿° âCOMBINâ ãå®è£ ãããŠããŸãããçµåããã§æ€çŽ¢ãããšåºãŠæ¥ãŸããããçµã¿åãããã§æ€çŽ¢ãããèŠã€ãããŸããããè©«ã³ãã€ã€èšæ£ããŸãã
äºé ååžé¢é£ã§ããâBINOM.DISTâ 颿°ä»ããã€ãã®ããªãšãŒã·ã§ã³ãçšæãããŠããŸããããã¡ãããè©«ã³ãã€ã€èšæ£ããŸãã
ã¹ãã³ãµãŒãªã³ã¯
Â
Â
â» ãªã³ã¯éïŒéæè¿œå ïŒ
Microsoft Mathematics ç§å®¶çé äžåãªãã¡ã¬ã³ã¹
倿°ãžã®å€ã®ä»£å ¥ããªã¹ãã«ãã倿°ãžã®å€ã®ä»£å ¥
埮åã®èšç®ãšããåºããšã©ãŒã¡ãã»ãŒãž
ã°ã©ãã®äœæãšã°ã©ãç¯å²ã®æå®
ãå ¬åŒãšæ¹çšåŒãã®èª€èš³ã«ã€ããŠ
ãæ¹çšåŒãœã«ãããšè€çŽ æ°è§£ã®è¡šç€º
è¡ååŒãéè¡åãåºææ¹çšåŒã察è§å
ãšããããäœãå ¥åãããããšå æ°åè§£ãšå±é
Â