{"id":802,"date":"2020-12-20T11:38:10","date_gmt":"2020-12-20T02:38:10","guid":{"rendered":"https:\/\/skyit.biz\/?p=802"},"modified":"2020-12-20T14:07:09","modified_gmt":"2020-12-20T05:07:09","slug":"%e7%ac%ac6%e7%ab%a0%e3%80%80%e6%8e%a8%e5%ae%9a%e3%81%a8%e6%a4%9c%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/skyit.biz\/?p=802","title":{"rendered":"\u7b2c6\u7ae0\u3000\u63a8\u5b9a\u3068\u691c\u5b9a"},"content":{"rendered":"\n<p>\u89b3\u6e2c\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3057\u3001\u305d\u3053\u304b\u3089\u4f55\u3089\u304b\u306e\u672a\u77e5\u306e\u6570\u5b57\u3092\u5c0e\u304d\u51fa\u3059\u3001\u63a8\u5b9a\u3084\u63a8\u5b9a\u5024\u306e\u78ba\u304b\u3055\u3092\u5224\u65ad\u3059\u308b\u691c\u5b9a\u306f\u3001<br>\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5b9f\u52d9\u306b\u7f6e\u3044\u3066\u3001\u975e\u5e38\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u624b\u6cd5\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff11\u3000\u63a8\u5b9a<br>\u4e00\u90e8\u5206\u306e\u30c7\u30fc\u30bf\u304b\u3089\u3001\u30c7\u30fc\u30bf\u5168\u4f53\u306e\u5e73\u5747\u3084\u5206\u6563\u306a\u3069\u3092\u6c42\u3081\u308b\u3053\u3068\u3092\u3001\u63a8\u5b9a\u3068\u3044\u3046\u3002<br>\u4f8b\u3048\u3070\u3001\u5927\u5b66\u751f\u306e\u5e73\u5747\u8eab\u9577\u3092\u7b97\u51fa\u3057\u305f\u3044\u5834\u5408\u3001\u5927\u5b66\u751f\u5168\u54e1\u306e\u8eab\u9577\u3092\u6e2c\u308b\u3002\u51fa\u6765\u306a\u3044\u5834\u5408\u306f\u3001\u30b5\u30f3\u30d7\u30eb\u3092\u96c6\u3081\u308b\u3002<br>\u30b5\u30f3\u30d7\u30eb\u304b\u3089\u5168\u4f53\u306e\u5e73\u5747\u3084\u5206\u6563\u306a\u3069\u3092\u6c42\u3081\u308b\u306e\u304c\u63a8\u5b9a\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff11\uff0e\uff11\u3000\u70b9\u63a8\u5b9a\u3068\u533a\u9593\u63a8\u5b9a<br>\u63a8\u5b9a\u306e\u5206\u985e<br>\u63a8\u5b9a\u306b\u306f\u3001\u70b9\u63a8\u5b9a\u3068\u533a\u9593\u63a8\u5b9a\u306b\u5927\u5225\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\u70b9\u63a8\u5b9a\u3068\u306f\u3001\u63a8\u5b9a\u5024\u3068\u3057\u3066\u3001\uff11\u3064\u306e\u5024\u3092\u6c42\u3081\u308b\u3082\u306e\u3002<br>\u533a\u9593\u63a8\u5b9a\u3068\u306f\u3001\u63a8\u5b9a\u5024\u3092\u533a\u9593\u3067\u6c42\u3081\u308b\u3082\u306e\u3002<\/p>\n\n\n\n<p>\u63a8\u5b9a\u5024\u306f\u3001\u672a\u77e5\u306e\u5024\u3067\u3042\u308a\u3001\u6b63\u89e3\u3092\u77e5\u308b\u3053\u3068\u306f\u51fa\u6765\u306a\u3044\u3002<br>\u533a\u9593\u5185\u306b\u306f\u3001\u5024\u304c\u5165\u3063\u3066\u3044\u308b\u3060\u308d\u3046\u3068\u63a8\u5b9a\u3059\u308b\u306e\u533a\u9593\u63a8\u5b9a\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u6bcd\u96c6\u56e3\u306e\u5e73\u5747\u3068\u5206\u6563\u306e\u63a8\u5b9a\u306b\u304a\u3051\u308b\u70b9\u63a8\u5b9a\u3068\u533a\u9593\u63a8\u5b9a\u306e\u65b9\u6cd5<\/p>\n\n\n\n<p>\u6b63\u898f\u5206\u5e03\u306b\u5f93\u3046\u6bcd\u96c6\u56e3\u306e\u3053\u3068\u3092\u6b63\u898f\u6bcd\u96c6\u56e3\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\uff08\uff11\uff09 \u70b9\u63a8\u5b9a<\/p>\n\n\n\n<p>\u2460 \u6bcd\u96c6\u56e3\u306e\u5e73\u5747\uff08\u6bcd\u5e73\u5747\uff09\u306e\u70b9\u63a8\u5b9a<br>\u6bcd\u5e73\u5747\u306e\u70b9\u63a8\u5b9a\u306f\u3001\u6a19\u672c\u306e\u5e73\u5747\u304b\u3089\u70b9\u63a8\u5b9a\u3055\u308c\u308b\u6bcd\u5e73\u5747\u306e\u5024\uff08\u6bcd\u5e73\u5747\u306e\u70b9\u63a8\u5b9a\u91cf\u3001<br>\u307e\u305f\u306f\u3001\u70b9\u63a8\u5b9a\u5024\uff09\u306f\u3001\u6a19\u672c\u5e73\u5747\u3068\u4e00\u81f4\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u70b9\u63a8\u5b9a\u3055\u308c\u308b\u6bcd\u5e73\u5747\uff1d\u6a19\u672c\u5e73\u5747<\/p>\n\n\n\n<p>\u2461 \u6bcd\u96c6\u56e3\u306e\u5206\u6563\uff08\u6bcd\u5206\u6563\uff09\u306e\u70b9\u63a8\u5b9a<br>\u6bcd\u5206\u6563\u306e\u70b9\u63a8\u5b9a\u306f\u3001\u6a19\u672c\u5206\u6563\u3092\u30b5\u30f3\u30d7\u30eb\u6570\u3067\u9664\u3057\u3066\u6c42\u3081\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_1.png\" alt=\"\" class=\"wp-image-812\" width=\"728\" height=\"183\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_1.png 330w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_1-300x75.png 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/figure>\n\n\n\n<p>\uff08\uff12\uff09 \u533a\u9593\u63a8\u5b9a<br>\u63a8\u5b9a\u5024\u304c\u542b\u307e\u308c\u308b\u3067\u3042\u308d\u3046\u533a\u9593\u306e\u3053\u3068\u3092\u4fe1\u983c\u533a\u9593\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\u63a8\u5b9a\u5024\u306e\u305f\u3081\u3001\u4fe1\u983c\u533a\u9593\u306e\u4e2d\u306b\u73fe\u308c\u306a\u3044\u53ef\u80fd\u6027\u3082\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u63a8\u5b9a\u5024\u304c\u4fe1\u983c\u533a\u9593\u306b\u73fe\u308c\u306a\u3044\u78ba\u7387\u3092a\u3068\u3059\u308b\u3068\u3001\u63a8\u5b9a\u5024\u304c\u4fe1\u983c\u533a\u9593\u306b\u73fe\u308c\u308b\u78ba\u7387\u3092<br>(1-a)\u3068\u8868\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u3002<br>(1-a)\u3092\u4fe1\u983c\u4fc2\u6570\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\u6a19\u6e96\u6b63\u898f\u5206\u5e03<\/p>\n\n\n\n<p>\u659c\u7dda\u90e8\u5206\u306e\u9762\u7a4d\u304c\u4fe1\u983c\u4fc2\u6570\uff08\uff11\uff0da\uff09\u3067\u3042\u308b\u3002<br>\u4fe1\u983c\u4fc2\u6570\u304c\u5927\u304d\u304f\u306a\u308b\u307b\u3069\u3001\u659c\u7dda\u90e8\u5206\u306e\u9762\u7a4d\u306f\u5927\u304d\u304f\u306a\u308b\u3002<br>\u3053\u308c\u306f\u3001\u63a8\u5b9a\u5024\u304c\u4fe1\u983c\u533a\u9593\u306b\u73fe\u308c\u306a\u3044\u78ba\u7387a\u304c\u4e0b\u304c\u308b\u3053\u3068\u3092\u610f\u5473\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u9762\u7a4d\uff1d\u4fe1\u983c\u4fc2\u6570\u3092\u5927\u304d\u304f\u3057\u904e\u304e\u308b\u3068\u3001\u4fe1\u983c\u533a\u9593\u304c\u5e83\u304f\u306a\u308a\u904e\u304e\u308b\u3002<br>\u3053\u308c\u306f\u3001\u63a8\u5b9a\u5024\u306e\u7bc4\u56f2\u304c\u5e83\u304f\u306a\u308b\u3053\u3068\u3092\u610f\u5473\u3057\u3066\u304a\u308a\u3001\u5e83\u3059\u304e\u308b\u63a8\u5b9a\u5024\u306f\u7cbe\u5ea6\u304c\u4f4e\u304f\u306a\u3063\u3066\u3057\u307e\u3044\u610f\u5473\u304c\u306a\u3044\u3002<br>\u3088\u3063\u3066\u3001\u4fe1\u983c\u4fc2\u6570\u306f\u300195%\u300199%\u3092\u4f7f\u3046\u3053\u3068\u304c\u7d71\u8a08\u5b66\u7684\u306a\u6163\u4f8b\u3068\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<p>\u2460 \u6bcd\u96c6\u56e3\u306e\u5e73\u5747\uff08\u6bcd\u5e73\u5747\uff09\u306e\u533a\u9593\u63a8\u5b9a<br>\u6bcd\u5e73\u5747\u3092\u533a\u9593\u63a8\u5b9a\u3059\u308b\u5834\u5408\u3001\u6bcd\u5206\u6563\u306e\u5024\u304c\u65e2\u77e5\u3067\u3042\u308b\u304b\u3001\u672a\u77e5\u3067\u3042\u308b\u304b\u5206\u3051\u3066\u8003\u3048\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_2.png\" alt=\"\" class=\"wp-image-814\" width=\"767\" height=\"320\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_2.png 643w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_2-300x126.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure>\n\n\n\n<p>\u3053\u308c\u3092\u6e80\u305f\u3059\u4e0a\u9650\u3001\u4e0b\u9650\u306f\u3001Excel\u95a2\u6570<br>NORM.S.INV<br>\u3092\u7528\u3044\u308b\u3053\u3068\u3067\u7c21\u5358\u306b\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\u3088\u3063\u3066\u3001\u4fe1\u983c\u4fc2\u6570\u304c95%\u3001\u3064\u307e\u308aa\u304c5%\u3067\u3042\u308c\u3070\u3001a\u306b0.55\u3092\u4ee3\u5165\u3057\u3066\u3001<br>\u4fe1\u983c\u533a\u9593\u306e\u4e0b\u9650\u5024\u304c-1.960\u3001\u4e0a\u9650\u5024\u304c1.960\u3060\u3068\u308f\u304b\u308b\u3002<\/p>\n\n\n\n<p>\u6bcd\u5e73\u5747\u306b\u3064\u3044\u3066\u3001\u6574\u7406\u3059\u308b\u3068\u3001\u4e0b\u8a18\u306e\u5982\u304f\u6210\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_3.png\" alt=\"\" class=\"wp-image-816\" width=\"802\" height=\"106\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_3.png 736w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_3-300x40.png 300w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_4.png\" alt=\"\" class=\"wp-image-818\" width=\"814\" height=\"216\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_4.png 794w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_4-300x80.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_4-768x204.png 768w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/figure>\n\n\n\n<p>b)\u6bcd\u5206\u6563\u304c\u672a\u77e5\u306e\u5834\u5408<\/p>\n\n\n\n<p>\u6bcd\u5206\u6563\u304c\u672a\u77e5\u3067\u3042\u308b\u5834\u5408\u3001a)\u3068\u540c\u3058\u624b\u9806\u3067\u533a\u9593\u63a8\u5b9a\u3092\u884c\u304a\u3046\u3068\u3059\u308b\u3068\u3001\u6a19\u6e96\u5316\u3055\u308c\u305f\u6a19\u672c\u5e73\u5747\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u51fa\u6765\u305a\u3001<br>\u63a8\u5b9a\u3092\u3059\u3059\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u306a\u3044\u3002\uff08\u6bcd\u5206\u6563\u304c\u672a\u77e5\u3067\u3042\u308c\u3070\u3001\u6bcd\u6a19\u6e96\u504f\u5dee\u3082\u672a\u77e5\u3067\u3042\u308b\u305f\u3081\uff09<\/p>\n\n\n\n<p>\u305d\u306e\u305f\u3081\u3001\u6a19\u672c\u7d71\u8a08\u91cf\u3068\u547c\u3070\u308c\u308b\u4e0b\u8a18\u306e\u5024\u3092\u7528\u3044\u308b\u3053\u3068\u306b\u306a\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_5.png\" alt=\"\" class=\"wp-image-820\" width=\"771\" height=\"548\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_5.png 834w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_5-300x213.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_5-768x546.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p>t\u5206\u5e03\u306b\u5f93\u3046\u6a19\u672c\u7d71\u8a08\u91cf\u3092\u4f7f\u3046\u70b9\u304ca)\u3068\u7570\u306a\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_6.png\" alt=\"\" class=\"wp-image-822\" width=\"802\" height=\"426\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_6.png 814w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_6-300x159.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_6-768x407.png 768w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<p>Excel\u95a2\u6570<br>T.INV.2T<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_7.png\" alt=\"\" class=\"wp-image-824\" width=\"783\" height=\"373\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_7.png 803w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_7-300x143.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_7-768x366.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>\u2461 \u6bcd\u96c6\u56e3\u306e\u5206\u6563\uff08\u6bcd\u5206\u6563\uff09\u306e\u533a\u9593\u63a8\u5b9a<br>\u6bcd\u5206\u6563\u306e\u533a\u9593\u63a8\u5b9a\u306e\u57fa\u672c\u7684\u306a\u8003\u3048\u65b9\u306f\u3001\u6bcd\u5e73\u5747\u306e\u533a\u9593\u63a8\u5b9a\u3068\u307b\u3069\u540c\u69d8\u3067\u3042\u308b\u3002<br>\u9055\u3044\u306f\u3001\u6a19\u6e96\u5316\u3055\u308c\u305f\u6a19\u672c\u5e73\u5747\u3084\u6a19\u672c\u7d71\u8a08\u91cf\u306e\u4ee3\u308f\u308a\u306b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_16.png\" alt=\"\" class=\"wp-image-828\" width=\"686\" height=\"95\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_16.png 471w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_16-300x41.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<p>\u3092\u4f7f\u3046\u3053\u3068\u3067\u3042\u308b\u3002<br>\u4f7f\u3046\u78ba\u7387\u5206\u5e03\u304c\u7570\u306a\u308b\u3060\u3051\u3002<\/p>\n\n\n\n<p>\u6bcd\u5e73\u5747\u306e\u533a\u9593\u63a8\u5b9a\u306b\u304a\u3044\u3066\u306f\u3001<br>\u6bcd\u5206\u6563\u304c\u65e2\u77e5\u3067\u3042\u308c\u3070\u3001\u6a19\u6e96\u6b63\u898f\u5206\u5e03\u3092\u4f7f\u3046\u3002<br>\u6bcd\u5206\u6563\u304c\u672a\u77e5\u3067\u3042\u308c\u3070\u3001t\u5206\u5e03\u3092\u4f7f\u3046\u3002<br>\u6bcd\u5206\u6570\u3067\u306f\u3001\u30ab\u30a4\u4e8c\u4e57\u5206\u5e03\u3092\u4f7f\u3046\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_8-1.png\" alt=\"\" class=\"wp-image-830\" width=\"796\" height=\"821\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_8-1.png 823w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_8-1-291x300.png 291w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_8-1-768x792.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<p>\u30a8\u30af\u30bb\u30eb\u95a2\u6570<br>CHISQ.INV.RT<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\u3000\u691c\u5b9a<br>\u30c7\u30fc\u30bf\u306f\u30d0\u30e9\u3064\u304d\u304c\u3064\u304d\u3082\u306e\u3067\u3042\u308b\u3002<br>\u30c7\u30fc\u30bf\u306e\u3070\u3089\u3064\u304d\u3092\u8003\u616e\u3057\u305f\u4e0a\u3067\u5ba2\u89b3\u7684\u306a\u5224\u65ad\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308b\u3002<br>\u3053\u306e\u7d71\u8a08\u7684\u306a\u5224\u65ad\u65b9\u6cd5\u3092\u691c\u5b9a\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\uff0e\uff11\u3000\u691c\u5b9a\u306e\u8003\u3048\u65b9<br>\u691c\u5b9a\u306b\u304a\u3044\u3066\u306f\u3001\u6709\u308b\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u4eee\u8a2d\u3092\u7acb\u3066\u3001\u305d\u306e\u4eee\u8a2d\u306f\u6210\u308a\u7acb\u3064\u304b\uff1f\u3092\u8003\u3048\u308b\u3002<br>\u3053\u306e\u5224\u65ad\u306b\u306f\u3001\u7d71\u8a08\u7684\u306a\u78ba\u7387\u8a08\u7b97\u3092\u7528\u3044\u3066\u3001\u30c7\u30fc\u30bf\u3092\u89b3\u5bdf\u3057\u3001\u305d\u306e\u4eee\u8a2d\u304c\u89b3\u5bdf\u3055\u308c\u308b\u78ba\u7387\u3092\u8a08\u7b97\u3059\u308b\u3002<br>\u78ba\u7387\u304c\u6975\u7a00\u306b\u3057\u304b\u8d77\u3053\u3089\u306a\u3044\u5834\u5408\u3001\u4eee\u8a2d\u304c\u9593\u9055\u3063\u3066\u3044\u308b\u30fb\u4e0b\u8d8a\u304c\u6210\u308a\u7acb\u305f\u306a\u3044<br>\u3068\u5224\u65ad\u3059\u308b\u3002<br>\u3053\u308c\u304c\u691c\u5b9a\u306e\u57fa\u672c\u7684\u306a\u8003\u3048\u65b9\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\uff0e\uff12\u3000\u691c\u5b9a\u306e\u624b\u9806<br>\uff08\uff11\uff09 \u5e30\u7121\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\uff08\uff12\uff09 \u5bfe\u7acb\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\uff08\uff13\uff09 \u6709\u610f\u6c34\u6e96\u3092\u6c7a\u3081\u308b<br>\uff08\uff14\uff09 \u68c4\u5374\u57df\u3092\u6c42\u3081\u308b<br>\uff08\uff15\uff09 \u691c\u5b9a\u7d71\u8a08\u91cf\u3092\u8a08\u7b97\u3059\u308b<br>\uff08\uff16\uff09 \u6709\u610f\u6027\u3092\u5224\u5b9a\u3057\u3066\u3001\u7d50\u8ad6\u3092\u51fa\u3059<\/p>\n\n\n\n<p>\uff08\uff11\uff09 \u5e30\u7121\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\u5e30\u7121\u4eee\u8aac\u3068\u306f\u3001\u691c\u5b9a\u306e\u59cb\u3081\u306b\u7acb\u3066\u308b\u4eee\u8a2d\u306e\u3053\u3068\u3067\u3042\u308b\u3002<br>\u5e30\u7121\u4eee\u8aac\u306e\u4f8b\u3068\u3057\u3066\u306f\u3001\u6bcd\u5e73\u5747\u306fXX\u3067\u3042\u308b\u3084\u3001\u30b0\u30eb\u30fc\u30d7A\u3068\u30b0\u30eb\u30fc\u30d7B\u306e\u5e73\u5747\u306b\u5dee\u304c\u306a\u3044\u306a\u3069<\/p>\n\n\n\n<p>\uff08\uff12\uff09 \u5bfe\u7acb\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\u5e30\u7121\u4eee\u8aac\u306b\u5bfe\u7acb\u3059\u308b\u4eee\u8a2d\u306e\u3053\u3068\u3067\u3042\u308b\u3002<br>\u5bfe\u7acb\u3059\u308b\u4eee\u8a2d\u306e\u305f\u3081\u3001\u5e30\u7121\u4eee\u8aac\u3092\u5426\u5b9a\u3059\u308b\u3088\u3046\u306a\u5185\u5bb9\u3068\u6210\u308b\u3053\u3068\u304c\u307b\u3068\u3093\u3069\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u691c\u5b9a\u3067\u306f\u3001\u7acb\u3066\u305f\u4eee\u8a2d\u304c\u6b63\u3057\u3044\u304b\u3092\u8003\u3048\u308b\u3002<br>\u7acb\u3066\u305f\u4eee\u8a2d\uff1d\u5e30\u7121\u4eee\u8aac\u304c\u6b63\u3057\u304f\u306a\u3044\u3068\u5224\u65ad\u3055\u308c\u305f\u5834\u5408\u306b\u63a1\u7528\u3055\u308c\u308b\u306e\u304c\u3001\u5bfe\u7acb\u4eee\u8aac\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u4f8b\u3048\u3070\u3001\u5e30\u7121\u4eee\u8aac\u304c\u3001\u6bcd\u5e73\u5747\u306fXX\u3067\u3042\u308b\u3068\u3059\u308c\u3070\u3001\u3053\u308c\u306b\u5bfe\u7acb\u3059\u308b\u4eee\u8a2d\u306f\u3001<br>\u30fb\u6bcd\u5e73\u5747\u306fXX\u3067\u306f\u306a\u3044 \u4e21\u5074\u691c\u5b9a<br>\u30fb\u6bcd\u5e73\u5747\u306fXX\u3088\u308a\u4f4e\u3044\u3000OR\u3000\u6bcd\u5e73\u5747\u306fXX\u3088\u308a\u9ad8\u3044 \u7247\u5074\u691c\u5b9a<\/p>\n\n\n\n<p>\uff08\uff13\uff09 \u6709\u610f\u6c34\u6e96\u3092\u6c7a\u3081\u308b<br>\u6975\u7a00\u306b\u3057\u304b\u8d77\u3053\u3089\u306a\u3044\u78ba\u7387\u3068\u306f\u3001\u6700\u521d\u306b\u5b9a\u3081\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308b\u3002<br>\u3053\u306e\u78ba\u7387\u306e\u3053\u3068\u3092\u3001\u6709\u610f\u6c34\u6e96\u3068\u547c\u3073\u3001\u03b1\u3067\u8868\u3059\u3002<br>\u03b1\u306e\u5927\u304d\u3055\u306b\u3064\u3044\u3066\u306f\u3001\u6c7a\u307e\u308a\u306f\u306a\u3044\u304c\u3001<br>\u03b1\uff1d0.05\u3000\u3000\u03b1\uff1d0.01\u3068\u3059\u308b\u306e\u304c\u7d71\u8a08\u5b66\u7684\u306a\u6163\u4f8b\u3068\u306a\u3063\u3066\u3044\u308b\u3002<br>\u03b1\uff1d0.05\u3000\u3000\u306f\u3001\uff15\uff05\u4ee5\u4e0b\u306e\u78ba\u7387\u3067\u767a\u751f\u3057\u5f97\u308b\u4e8b\u8c61\u3068\u306a\u308a\u3001\u6700\u3082\u4e00\u822c\u7684\u306a\u6975\u7a00\u306e\u5024\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff14\uff09 \u68c4\u5374\u57df\u3092\u6c42\u3081\u308b<br>\u68c4\u5374\u57df\u306f\u3001\u6709\u610f\u6c34\u6e96\u03b1\u306b\u3088\u3063\u3066\u3001\u4e0e\u3048\u3089\u308c\u308b\u3002<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u57df\u306b\u5165\u3063\u3066\u3044\u308c\u3070\u3001\u5e30\u7121\u4eee\u8aac\u304c\u68c4\u5374\uff08\u5e30\u7121\u4eee\u8aac\u306f\u6b63\u3057\u304f\u306a\u3044\u3068\u5224\u5b9a\u3059\u308b\uff09\u9818\u57df\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_9.png\" alt=\"\" class=\"wp-image-832\" width=\"786\" height=\"772\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_9.png 806w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_9-300x295.png 300w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_10.png\" alt=\"\" class=\"wp-image-834\" width=\"756\" height=\"383\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_10.png 771w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_10-300x153.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_10-768x390.png 768w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<p>\u6a2a\u8ef8\u306b\u78ba\u7387\u5909\u6570\u3001\u7e26\u8ef8\u306b\u78ba\u7387\u5bc6\u5ea6\u3092\u57f7\u3063\u305f\u5834\u5408\u3001\u78ba\u7387\u5909\u6570\u304c\u3042\u308b\u4e00\u5b9a\u533a\u9593\u306e\u5024\u3092\u53d6\u308b\u78ba\u7387\u304c\u9762\u7a4d\u3067\u8868\u3055\u308c\u308b\u3002<br>\u6709\u610f\u6c34\u6e96\u3088\u308a\u3082\u5c0f\u3055\u304f\u306a\u308b\u3088\u3046\u306a\u78ba\u7387\u5909\u6570\u306e\u7bc4\u56f2\u306e\u3053\u3068\u3092\u3001\u68c4\u5374\u57df\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\u691c\u5b9a\u306b\u7528\u3044\u308b\u3001\u68c4\u5374\u57df\u3092\u6c42\u3081\u308b\u305f\u3081\u306e\u78ba\u7387\u5206\u5e03\u3082\u3001\u7528\u9014\u306b\u3088\u3063\u3066\u4f7f\u3044\u5206\u3051\u3092\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u4f8b\u3048\u3070\u3001\u65e2\u77e5\u306e\u6bcd\u5206\u6570\u3092\u7528\u3044\u305f\u6bcd\u5e73\u5747\u306e\u691c\u5b9a\u3092\u884c\u3046\u5834\u5408\u3001\u6a19\u6e96\u6b63\u898f\u5206\u5e03\u3092\u4f7f\u3046\u3002<br>\u672a\u77e5\u306e\u6bcd\u5206\u6570\u3092\u7528\u3044\u305f\u6bcd\u5e73\u5747\u306e\u691c\u5b9a\u3067\u3042\u308c\u3070\u3001t\u5206\u5e03\u3092\u4f7f\u3046\u3002<\/p>\n\n\n\n<p>\u68c4\u5374\u57df\u3092\u7b97\u51fa\u3059\u308b\u969b\u3001\u63a8\u5b9a\u306e\u4e0b\u9650\u5024\u30fb\u4e0a\u9650\u5024\u3092\u6c42\u3081\u305fExcel\u95a2\u6570\u3092\u4f7f\u3046\u3068\u4fbf\u5229\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_11.png\" alt=\"\" class=\"wp-image-837\" width=\"779\" height=\"396\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_11.png 801w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_11-300x152.png 300w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_11-768x390.png 768w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/figure>\n\n\n\n<p>\uff08\uff15\uff09 \u691c\u5b9a\u7d71\u8a08\u91cf\u3092\u8a08\u7b97\u3059\u308b<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u3068\u306f\u3001\u4eee\u8aac\u691c\u5b9a\u306e\u57fa\u6e96\u3068\u306a\u308b\u7d71\u8a08\u91cf\u306e\u3053\u3068\u3067\u3042\u308b\u3002<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u306f\u3001\u4f8b\u3048\u3070\u3001\u6bcd\u5e73\u5747\u306e\u63a8\u5b9a\u91cf\u306a\u3069\u3067\u3001\u4e09\u9031\u306e\u65b9\u6cd5\u306f\u3001\u533a\u9593\u63a8\u5b9a\u304c\u53c2\u8003\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff16\uff09 \u6709\u610f\u6027\u3092\u5224\u5b9a\u3057\u3066\u3001\u7d50\u8ad6\u3092\u51fa\u3059<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u3068\u3001\u68c4\u5374\u57df\u3092\u6c42\u3081\u305f\u78ba\u7387\u5206\u5e03\u306e\u30b0\u30e9\u30d5\u306e\u6a2a\u8ef8\u306e\u5024\u3092\u7167\u3089\u3057\u5408\u308f\u305b\u3001\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u57df\u306b\u5165\u3063\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u8abf\u3079\u308b\u3002<br>\u3053\u308c\u3092\u6709\u610f\u6027\u3092\u5224\u5b9a\u3059\u308b\u3068\u547c\u3076\u3002<\/p>\n\n\n\n<p>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u57df\u306b\u5165\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u5e30\u7121\u4eee\u8aac\u304c\u8aa4\u308a\u3068\u306a\u308a\u3001\u5bfe\u7acb\u4eee\u8aac\u304c\u6b63\u3057\u3044\u3068\u6210\u308b\u3002<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u57df\u306b\u5165\u3063\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u5e30\u7121\u4eee\u8aac\u3092\u68c4\u5374\u3059\u308b\u3053\u3068\u306f\u51fa\u6765\u306a\u3044\u3002<\/p>\n\n\n\n<p>\u5e30\u7121\u4eee\u8aac\u304c\u68c4\u5374\u3055\u308c\u306a\u3044\u3053\u3068\u3068\u3001\u5e30\u7121\u4eee\u8aac\u304c\u7a4d\u6975\u7684\u306b\u63a1\u629e\u3059\u308b\u3053\u3068\u306f\u540c\u610f\u3067\u306f\u306a\u3044\u3002<br>\u2605\u2605<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u57df\u306b\u5165\u3063\u3066\u3044\u306a\u3044\u5834\u5408\u3067\u3082\u3001\u305d\u308c\u306f\u3001\u68c4\u5374\u3059\u308b\u6839\u62e0\u3092\u5f97\u3089\u308c\u306a\u304b\u3063\u305f\u3060\u3051\u3067\u3001\u5e30\u7121\u4eee\u8aac\u304c\u6b63\u3057\u3044\u3068\u306f\u8a00\u3044\u5207\u308c\u306a\u3044\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\uff0e\uff13\u3000P\u5024<br>P\u5024\u3092\u3082\u3068\u306b\u6709\u610f\u6027\u3092\u5224\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\u3002<br>P\u5024\u3068\u306f\u3001\u56f3\uff12\uff0e\uff16\u306e\u50be\u659c\u90e8\u5206\u306e\u9762\u7a4d\u306e\u3053\u3068\u3002<br>\u9762\u7a4d\uff1d\u78ba\u7387\u3092\u7d20\u306b\u3057\u3066\u3001\u5e30\u7121\u4eee\u8aac\u3092\u68c4\u5374\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u5224\u65ad\u3059\u308b\u3002<br>P\u5024\u306ePha,Probability(\u78ba\u7387)\u306e\u982d\u6587\u5b57\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<p>\u691c\u5b9a\u7d71\u8a08\u91cf\u304b\u3089P\u5024\u3092\u7b97\u51fa\u3057\u3001\u305d\u308c\u304c\u6709\u610f\u6c34\u6e96\u3068\u3057\u3066\u3001\u5b9a\u3081\u305f\u4efb\u610f\u306e\u78ba\u7387\u3088\u308a\u3082\u5c0f\u3055\u3051\u308c\u3070\u3001\u5e30\u7121\u4eee\u8aac\u304c\u68c4\u5374\u3055\u308c\u308b\u3002<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u68c4\u5374\u306b\u5165\u308b\u3053\u3068\u3001\u3068P\u5024\u304c\u6709\u610f\u6c34\u6e96\u3088\u308a\u3082\u5c0f\u3055\u3044\u3053\u3068\u306f\u3001\u540c\u3058\u610f\u5473\u3067\u3042\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_12-619x1024.png\" alt=\"\" class=\"wp-image-839\" width=\"732\" height=\"1210\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_12-619x1024.png 619w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_12-181x300.png 181w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_12.png 681w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/figure>\n\n\n\n<p>\uff1c\u78ba\u7387\u5206\u5e03\u304c\u30ab\u30a4\u4e8c\u4e57\u5206\u5e03\u306e\u5834\u5408\uff1e<br>\u4e0a\u5074\u78ba\u7387\u3000\uff1a\uff1dCHISQ.DIST.RT\uff08\u691c\u5b9a\u7d71\u8a08\u91cf,\u81ea\u7531\u5ea6\uff09<br>\u4e0b\u5074\u78ba\u7387\u3000\uff1a\uff1dCHISQ.DIST.RT\uff08\u691c\u5b9a\u7d71\u8a08\u91cf,\u81ea\u7531\u5ea6\uff09<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\uff0e\uff14\u3000\u4eee\u8aac\u691c\u5b9a\uff08\u6bcd\u5206\u6570\u304c\u65e2\u77e5\u306e\u5834\u5408\u306e\u6bcd\u5e73\u5747\uff09<br>A\u9ad8\u6821 \u6570\u5b66\u5e73\u5747\u70b9 60 \u70b9<br>\u6a19\u6e96\u504f\u5dee 5 \u70b9<\/p>\n\n\n\n<p>B\u9ad8\u6821 \u6570\u5b66\u5e73\u5747\u70b9 61 \u70b9<br>\u6a19\u6e96\u504f\u5dee 5 \u70b9<br>\u4e0a\u8a18\u306e\u6761\u4ef6\u306e\u6642\u3001B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f\u3001A\u9ad8\u6821\u306b\u6bd4\u3079\u3066\u9ad8\u3044\u3068\u8a00\u3048\u308b\u304b\u3069\u3046\u304b\u3001\u691c\u5b9a\u3067\u78ba\u304b\u3081\u3066\u307f\u3088\u3046\u3002<\/p>\n\n\n\n<p>\uff08\uff11\uff09 \u5e30\u7121\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\u5e30\u7121\u4eee\u8aac\uff1aB\u9ad8\u6821\u5168\u4f53\u306e\u5e73\u5747\u70b9\u306f\u300160\u70b9\u3067\u3042\u308b\u3002<br>\uff08\uff12\uff09 \u5bfe\u7acb\u4eee\u8aac\u3092\u7acb\u3066\u308b<br>\u5bfe\u7acb\u4eee\u8aac\uff1aB\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f60\u70b9\u3088\u308a\u9ad8\u3044 \u7247\u5074\u691c\u5b9a<br>\u203b\u691c\u5b9a\u306b\u3088\u3063\u3066\u3001\u5e30\u7121\u4eee\u8aac\u304c\u68c4\u5374\u3055\u308c\u305f\u5834\u5408\u3001B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u304cA\u9ad8\u6821\u3088\u308a\u3082\u9ad8\u3044\u3068\u7d50\u8ad6\u3065\u3051\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff13\uff09 \u6709\u610f\u6c34\u6e96\u3092\u6c7a\u3081\u308b<br>\u6709\u610f\u6c34\u6e96\u03b1\u3092\u6c7a\u3081\u308b\u3002<br>\u03b1\uff1d0..05\u3000\u3059\u306a\u308f\u3061\u3001\uff15\uff05\u4ee5\u4e0b\u306e\u78ba\u7387\u3067\u767a\u751f\u3057\u5f97\u308b\u4e8b\u8c61\u3092\u6975\u7a00\u3067\u3042\u308b\u3068\u5b9a\u7fa9\u3059\u308b\u3002<br>\uff08\uff14\uff09 \u68c4\u5374\u57df\u3092\u6c42\u3081\u308b<br>\u68c4\u5374\u57df\u3092\u306f\u3001\u6709\u610f\u6c34\u6e96\u03b1\u306b\u3088\u3063\u3066\u3001\u4e0e\u3048\u3089\u308c\u308b\u304c\u3001\u4eca\u56de\u306f\u3001\uff08\uff13\uff09\u306e\u901a\u308a\uff15\uff05\u3068\u6c7a\u3081\u305f\u3002<br>\u4eca\u56de\u306f\u5bfe\u7acb\u4eee\u8aac\u304c\uff5e\u3088\u308a\u9ad8\u3044\u3068\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u53f3\u8fba\u5074\u691c\u5b9a\u3068\u6210\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_13.png\" alt=\"\" class=\"wp-image-842\" width=\"689\" height=\"543\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_13.png 506w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_13-300x237.png 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure>\n\n\n\n<p>\u4eca\u56de\u77e5\u308a\u305f\u3044\u306e\u306f\u3001B\u9ad8\u6821\u306e\u751f\u5f92100\u4eba\u306e\u70b9\u6570\u304b\u3089B\u9ad8\u6821\u5168\u4f53\u306e\u5e73\u5747\u70b9\u3067\u3042\u308b\u3002<br>B\u9ad8\u6821\u306e\u6a19\u6e96\u504f\u5dee\u306f\u3001A\u9ad8\u6821\u3068\u540c\u3058\uff15\u70b9\u3067\u3042\u308b\u3002<br>\u3053\u308c\u306f\u3001\u6bcd\u96c6\u56e3\u3092B\u9ad8\u6821\u5168\u4f53\u3068\u3057\u3001\u6bcd\u5206\u6563\u304c\u65e2\u77e5\u3067\u3001\u6bcd\u5e73\u5747\u3092\u63a8\u5b9a\u3059\u308b\u3053\u3068\u306b\u306a\u308b\u3002<br>\u3053\u306e\u63a8\u5b9a\u3067\u306f\u3001\u6a19\u6e96\u6b63\u898f\u5206\u5e03\u3092\u4f7f\u3046\u3002<\/p>\n\n\n\n<p>\u7528\u3044\u308b\u78ba\u7387\u5206\u5e03\u304c\u5206\u304b\u308c\u3070\u3001Excel\u95a2\u6570\u304b\u3089\u68c4\u5374\u57df\u3092\u6c42\u3081\u3089\u308c\u308b\u3002<br>Excel\u306e\u4efb\u610f\u306e\u30bb\u30eb\u3067<br>=NORM.S.INV(1-0.05)<br>\u3092\u5b9f\u884c\u3059\u308b\u3002<br>\u4eca\u56de\u306f\u7247\u5074\u691c\u5b9a\u306e\u305f\u3081\u3001&#8217;=NORM.S.INV(1-0.025)\u3068\u306f\u306a\u3089\u306a\u3044\u3002<br>\u51fa\u529b\u5024 1.644853627<\/p>\n\n\n\n<p>\u6c42\u3081\u308b\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u51fa\u6f01\u5024\u306e1.644854\u3088\u308a\u3082\u5927\u304d\u3051\u308c\u3070\u3001\u5e30\u7121\u4eee\u8aac\u306f\u68c4\u5374\u3055\u308c\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff15\uff09 \u691c\u5b9a\u7d71\u8a08\u91cf\u3092\u8a08\u7b97\u3059\u308b<br>\u4eca\u56de\u306e\u691c\u5b9a\u7d71\u8a08\u91cf\u306f\u3001B\u9ad8\u6821\u5168\u4f53\u3092\u6bcd\u96c6\u56e3\u3068\u3057\u305f\u5834\u5408\u306e\u6bcd\u5e73\u5747\u3067\u3042\u308b\u3002<br>\u6bcd\u5206\u6563\u306f\u3001\u65e2\u77e5\u306e\u305f\u3081\u3001\u691c\u5b9a\u7d71\u8a08\u91cf\u306f\u4e0b\u8a18\u306e\u5f0f\u3067\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_14.png\" alt=\"\" class=\"wp-image-844\" width=\"670\" height=\"440\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_14.png 411w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_14-300x197.png 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/figure>\n\n\n\n<p>\u6bcd\u5e73\u5747\u306b\u306f\u3001A\u9ad8\u6821\u5e73\u5747\u3067\u3042\u308b60\u70b9\u3092\u5165\u308c\u3066\u3044\u308b\u304c\u3001\u3053\u308c\u306f\u5e30\u7121\u4eee\u8aac\u901a\u308a\u3001<br>A\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u3068B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u304c\u7b49\u3057\u3044\u3068\u3057\u305f\u5834\u5408\u3001B\u9ad8\u6821\u306e\u70b9\u6570\u5206\u5e03\u3082A\u9ad8\u6821\u3068\u540c\u3058\u5206\u5e03\u306b\u6210\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff16\uff09 \u6709\u610f\u6027\u3092\u5224\u5b9a\u3057\u3066\u7d50\u8ad6\u3092\u51fa\u3059<br>\u5e30\u7121\u4eee\u8aac\u306f\u6b63\u3057\u304f\u306a\u304f\u3001\u5bfe\u7acb\u4eee\u8aac\u304c\u6b63\u3057\u3044\u3068\u8a00\u3048\u308b\u3002<br>\u3059\u306a\u308f\u3061\u3001B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f\u3001A\u9ad8\u6821\u3088\u308a\u3082\u9ad8\u3044\uff08B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f\u3001A\u9ad8\u6821\u306e\u5e73\u5747\u70b960\u70b9\u3088\u308a\u9ad8\u3044\uff09\u3068\u8a00\u3048\u308b\u3002<\/p>\n\n\n\n<p>P\u5024\u304b\u3089\u3082\u3053\u306e\u7d50\u8ad6\u304c\u6b63\u3057\u3044\u304b\u3092\u78ba\u8a8d\u3059\u308b\u3002<br>P\u5024\u306f\u3001\u4e0b\u8a18\u306eExcel\u95a2\u6570\u3067\u6c42\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<br>=1-NORM.S.DIST(2,TRUE)<br>\u51fa\u529b\u5024 0.022750132<br>P\u5024\u306f\u30012.28\uff05\u3068\u306a\u308b\u3002<br>\u6709\u610f\u6c34\u6e96\uff15\uff05\uff080.05\uff09\u3092\u4e0b\u56de\u3063\u3066\u3044\u308b\u306e\u3067\u3001<br>P\u5024\u304b\u3089\u3082\u5e30\u7121\u4eee\u8aac\u304c\u3001\u68c4\u5374\u3055\u308c\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u308b\u3002<br>\u3082\u3057\u3001\u6709\u610f\u6c34\u6e96\uff11\uff05\u3068\u3057\u305f\u5834\u5408\u3001\u68c4\u5374\u57df\u306f\u30012.326\u4ee5\u4e0a\u3068\u306a\u308b\u3002<\/p>\n\n\n\n<p>\uff12\uff0e\uff12\uff0e\uff15\u3000\u4eee\u8aac\u691c\u5b9a\uff08\u6bcd\u5206\u6563\u304c\u672a\u77e5\u306e\u5834\u5408\u306e\u6bcd\u5e73\u5747\uff09<br>\u6bcd\u5206\u6563\u304c\u672a\u77e5\u3067\u3042\u308b\u5834\u5408\u306e\u691c\u5b9a\u624b\u9806\u306e\u78ba\u8a8d<br>\u4f8b\uff09A\u9ad8\u6821\u3068B\u9ad8\u6821\u306e\u30c6\u30b9\u30c8\u306e\u70b9\u6570<br>B\u9ad8\u6821\u306e\u6a19\u6e96\u504f\u5dee\u304c\u672a\u77e5\uff08A\u9ad8\u6821\u3068\u7b49\u3057\u3044\u304b\u306f\u4e0d\u660e\u3067\u3042\u308b\uff09<br>\u89b3\u5bdf\u3057\u305f\uff11\uff10\uff10\u4eba\u306e\u751f\u5f92\u306e\u70b9\u6570\u306e\u6a19\u6e96\u504f\u5dee\u306f\uff17\u3067\u3042\u3063\u305f\u3002<br>\uff08\uff11\uff09\u5e30\u7121\u4eee\u8aac\u3068\u2019\uff08\uff12\uff09\u5bfe\u7acb\u4eee\u8aac\u306f\u3001\u6bcd\u5206\u6563\u304c\u57fa\u5730\u306e\u5834\u5408\u306e\u691c\u5b9a\u3068\u540c\u3058\u3082\u306e\u3068\u3059\u308b\u3002<br>\uff08\uff13\uff09\u6709\u610f\u6c34\u6e96\u3082\u540c\u3058\u304f\uff15\uff05\u3068\u3059\u308b\u3002<\/p>\n\n\n\n<p>\u5e30\u7121\u4eee\u8aac\uff1aB\u9ad8\u6821\u5168\u4f53\u306e\u5e73\u5747\u70b9\u306f\uff16\uff10\u70b9\u3067\u308b<br>\u5bfe\u7acb\u4eee\u8aac\uff1aB\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f\uff16\uff10\u70b9\u3088\u308a\u9ad8\u3044<\/p>\n\n\n\n<p>\uff08\uff14\uff09 \u68c4\u5374\u57df\u3092\u6c42\u3081\u308b<br>\u7528\u3044\u308b\u78ba\u7387\u5206\u5e03\u306ft\u5206\u5e03\u3068\u3059\u308b\u3002<br>\u68c4\u5374\u57df\u3092\u6c42\u3081\u308b\u306b\u306f\u3001Excel\u95a2\u6570\u3092\u4f7f\u3046\u3002<\/p>\n\n\n\n<p>=T.INV(1-0.05,99)<br>\u51fa\u529b\u5024 1.660391156<\/p>\n\n\n\n<p>\u9593\u4f5c\u3057\u305f100\u4eba\u30b5\u30f3\u30d7\u30eb\u306e\u305f\u3081\u3001\u81ea\u7531\u5ea6\u306f99\u3068\u306a\u308b\uff08100-1\uff09<br>\u7d50\u679c\u306e\u51fa\u529b\u5024\u306f\u30011.660<br>\u691c\u5b9a\u7d71\u8a08\u91cf\u304c\u3053\u306e\u5024\u3088\u308a\u3082\u5927\u304d\u3051\u308c\u3070\u3001\u5e30\u7121\u4eee\u8aac\u306f\u68c4\u5374\u3055\u308c\u308b\u3002<\/p>\n\n\n\n<p>\uff08\uff15\uff09 \u691c\u5b9a\u7d71\u8a08\u91cf\u3092\u8a08\u7b97\u3059\u308b<br>B\u9ad8\u6821\u5168\u4f53\u3092\u6bcd\u96c6\u56e3\u3068\u3057\u3001\u6bcd\u5206\u6563\u304c\u672a\u77e5\u306e\u6bcd\u5e73\u5747\u3092\u6c42\u3081\u305f\u3044\u306e\u3067\u3001\u691c\u5b9a\u7d71\u8a08\u91cf\u306f\u4e0b\u8a18\u306e\u5f0f\u3067\u6c42\u3081\u3089\u308c\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_15.png\" alt=\"\" class=\"wp-image-846\" width=\"683\" height=\"391\" srcset=\"https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_15.png 482w, https:\/\/skyit.biz\/wp-content\/uploads\/2020\/12\/Excel_data_Science_6_15-300x172.png 300w\" sizes=\"auto, (max-width: 683px) 100vw, 683px\" \/><\/figure>\n\n\n\n<p>\uff08\uff16\uff09 \u6709\u610f\u6027\u3092\u5224\u5b9a\u3057\u3066\u7d50\u8ad6\u3092\u51fa\u3059<br>\uff08\uff15\uff09\u3067\u8a08\u7b97\u3057\u305f\u691c\u5b9a\u7d71\u8a08\u91cf\u306f\u30011.4286<br>\uff08\uff14\uff09\u3067\u6c42\u3081\u305f\u68c4\u5374\u57df\uff08\uff1e1.660\uff09\u4ee5\u4e0b\u306e\u305f\u3081\u3001\u5e30\u7121\u4eee\u8aac\u306f\u68c4\u5374\u3055\u308c\u305a\u3001<br>B\u9ad8\u6821\u306e\u5e73\u5747\u70b9\u306f\u3001A\u9ad8\u6821\u3088\u308a\u9ad8\u3044\u3068\u306f\u8a00\u3048\u306a\u3044\u3053\u3068\u304c\u308f\u304b\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u89b3\u6e2c\u5bfe\u8c61\u306e\u30c7\u30fc\u30bf\u3092\u5206\u6790\u3057\u3001\u305d\u3053\u304b\u3089\u4f55\u3089\u304b\u306e\u672a\u77e5\u306e\u6570\u5b57\u3092\u5c0e\u304d\u51fa\u3059\u3001\u63a8\u5b9a\u3084\u63a8\u5b9a\u5024\u306e\u78ba\u304b\u3055\u3092\u5224\u65ad\u3059\u308b\u691c\u5b9a\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5b9f\u52d9\u306b\u7f6e\u3044\u3066\u3001\u975e\u5e38\u306b\u3088\u304f\u4f7f\u308f\u308c\u308b\u624b\u6cd5\u3067\u3042\u308b\u3002 \uff12\uff0e\uff11\u3000\u63a8\u5b9a\u4e00\u90e8\u5206\u306e\u30c7\u30fc\u30bf\u304b\u3089\u3001\u30c7\u30fc\u30bf\u5168\u4f53\u306e\u5e73\u5747\u3084\u5206\u6563\u306a\u3069\u3092 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":846,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,48],"tags":[],"class_list":{"0":"post-802","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"category-48"},"_links":{"self":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=802"}],"version-history":[{"count":24,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/802\/revisions"}],"predecessor-version":[{"id":884,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/posts\/802\/revisions\/884"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=\/wp\/v2\/media\/846"}],"wp:attachment":[{"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skyit.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}