{"id":17193,"date":"2023-05-11T06:00:00","date_gmt":"2023-05-10T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=17193"},"modified":"2023-02-08T16:19:30","modified_gmt":"2023-02-08T07:19:30","slug":"%e3%83%9d%e3%82%a2%e3%82%bd%e3%83%b3%e5%9b%9e%e5%b8%b0%e3%83%a2%e3%83%87%e3%83%ab%e3%82%92%e7%94%a8%e3%81%84%e3%81%a6%e7%86%b1%e4%b8%ad%e7%97%87%e6%90%ac%e9%80%81%e4%ba%ba%e5%93%a1%e6%95%b0%e3%81%ab","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=17193","title":{"rendered":"\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u304a\u3088\u3073\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3092\u7528\u3044\u3066\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u6570\u306b\u5bfe\u3059\u308b\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u306e\u56de\u5e30\u4fc2\u6570\u3092\u63a8\u5b9a\u3059\u308b"},"content":{"rendered":"\n<p>\u3000\u4ee5\u524d\uff0c<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=14504\" target=\"_blank\" rel=\"noopener\">\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u6570\u306f\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u76f8\u95a2\u95a2\u4fc2<\/a>\u304c\u3042\u308a\uff0c\u7247\u5bfe\u6570\u30b0\u30e9\u30d5\u3067\u76f4\u7dda\u306b\u306a\u308b\u3068\u8ff0\u3079\u305f\uff0e\u4eca\u56de\u306f\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u304a\u3088\u3073\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3067\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u6570\u306b\u5bfe\u3059\u308b\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u306e\u56de\u5e30\u4fc2\u6570\u3092\u63a8\u5b9a\u3059\u308b\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>SQL Server\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b<\/h2>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9HeatStrokeDB\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\uff0c\u7d50\u679c\u3092Excel\u306b\u30b3\u30d4\u30da\u3057\u3066\u4fdd\u5b58\u3059\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u3092HeatStroke.xlsx\u3068\u3059\u308b\uff0e<\/p>\n<pre>USE HeatStrokeDB;\nGO\nSELECT\tH.\u65e5\u4ed8\tAS Date\n\t,\tH.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\tAS PrefCode\n\t,\tM.\u90fd\u9053\u5e9c\u770c\tAS Pref\n\t,\tM.\u65e5\u6700\u9ad8\u6c17\u6e29\tAS Temp\n\t,\tV.\u65e5\u5e73\u5747\u84b8\u6c17\u5727\tAS Vapor\n\t,\tH.[\u642c\u9001\u4eba\u54e1\uff08\u8a08\uff09]\tAS HeatStroke\nFROM\tdbo.T_HeatStroke\tAS H\nINNER\tJOIN\tdbo.T_MaxTemperature\tAS M\nON\tH.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9=M.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\nAND\tH.\u65e5\u4ed8=M.\u5e74\u6708\u65e5\nINNER\tJOIN\tdbo.T_VaporPressure\tAS V\nON\tH.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9=V.\u90fd\u9053\u5e9c\u770c\u30b3\u30fc\u30c9\nAND\tH.\u65e5\u4ed8=V.\u5e74\u6708\u65e5\nORDER\tBY\tPrefCode, Date<\/pre>\n<h2>Excel\u306e\u30d5\u30a1\u30a4\u30eb\u3092R\u3067\u8aad\u307f\u8fbc\u3080<\/h2>\n<p>\u3000Environment\u30bf\u30d6\u306eImport Dataset\u3092\u62bc\u4e0b\u3057From Excel&#8230;\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_17196\" aria-describedby=\"caption-attachment-17196\" style=\"width: 539px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/30-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17196\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/30-1.png\" alt=\"Import Dataset\u306eFrom Excel...\" width=\"539\" height=\"275\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/30-1.png 539w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/30-1-300x153.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><figcaption id=\"caption-attachment-17196\" class=\"wp-caption-text\">Import Dataset\u306eFrom Excel&#8230;<\/figcaption><\/figure>\n<p>\u3000\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u958b\u304f\u306e\u3067\uff0c\u5148\u7a0b\u4fdd\u5b58\u3057\u305f\u76ee\u7684\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\uff0e<\/p>\n<figure id=\"attachment_17197\" aria-describedby=\"caption-attachment-17197\" style=\"width: 946px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/31-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17197\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/31-1.png\" alt=\"Choose File\" width=\"946\" height=\"533\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/31-1.png 946w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/31-1-300x169.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/31-1-768x433.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-17197\" class=\"wp-caption-text\">Choose File<\/figcaption><\/figure>\n<p>\u3000\u30c7\u30fc\u30bf\u578b\u306e\u5909\u66f4\u304c\u3067\u304d\u308b\uff0eDate\u5217\u3092\u65e5\u4ed8\u578b\u306b\u5909\u66f4\u3057\uff0cPrefCode\u5217\u3092\u6587\u5b57\u5217\u578b\u306b\u5909\u66f4\u3057\uff0cImport\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_17198\" aria-describedby=\"caption-attachment-17198\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-17198\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1-1024x771.png\" alt=\"Data Preview\u3067\u30c7\u30fc\u30bf\u578b\u306e\u5909\u66f4\u304c\u3067\u304d\u308b\" width=\"525\" height=\"395\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1-1024x771.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1-300x226.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1-768x578.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/32-1.png 1186w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-17198\" class=\"wp-caption-text\">Data Preview\u3067\u30c7\u30fc\u30bf\u578b\u306e\u5909\u66f4\u304c\u3067\u304d\u308b<\/figcaption><\/figure>\n<p>\u3000HeatStroke\u3068\u3044\u3046\u5909\u6570\u306bExcel\u306e\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\u72b6\u614b\uff0e\u3053\u306e\u5909\u6570\u306f\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3068\u547c\u3070\u308c\uff0c\u3053\u3053\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3057\u3066\u3044\u304f\uff0e<\/p>\n<figure id=\"attachment_17199\" aria-describedby=\"caption-attachment-17199\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-17199\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1-1024x756.png\" alt=\"HeatStroke\u3068\u3044\u3046\u5909\u6570\u306bExcel\u306e\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\" width=\"525\" height=\"388\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1-1024x756.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1-300x222.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1-768x567.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/33-1.png 1186w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-17199\" class=\"wp-caption-text\">HeatStroke\u3068\u3044\u3046\u5909\u6570\u306bExcel\u306e\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f<\/figcaption><\/figure>\n<h2>R\u3067\u306e\u64cd\u4f5c<\/h2>\n<p>\u3000\u30b3\u30f3\u30bd\u30fc\u30eb\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u5de6\u4e0b\u306b\u3042\u308b\uff0e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304b\u3089\u5404\u5217\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\u306b\u306f\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u540d$\u5217\u540d\u3068\u8a18\u8ff0\u3059\u308b\uff0e<\/p>\n<h3>\u5404\u5217\u306e\u62bd\u51fa<\/h3>\n<p>\u3000\u4e0b\u8a18\u306e\u3088\u3046\u306b\u6700\u9ad8\u6c17\u6e29\u3092vTemp\uff0c\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u3092vVapor\uff0c\u642c\u9001\u4eba\u54e1\u6570\u3092vNum\u3068\u6c7a\u3081\uff0c\u305d\u308c\u305e\u308c\u62bd\u51fa\u3059\u308b\uff0e\u30b3\u30fc\u30c9\u88dc\u5b8c\u304c\u50cd\u304d\uff0c\u5909\u6570\u540d\u3092\u88dc\u5b8c\u3057\u3066\u304f\u308c\u308b\uff0e<\/p>\n<pre>&gt; vTemp=HeatStroke$Temp\n&gt; vVapor=HeatStroke$Vapor\n&gt; vNum=HeatStroke$HeatStroke<\/pre>\n<h3>\u6563\u5e03\u56f3\u306e\u63cf\u753b<\/h3>\n<p>\u3000\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308b\uff0e<\/p>\n<pre>&gt; plot(vTemp, vNum)\n&gt; plot(vVapor, vNum)<\/pre>\n<figure id=\"attachment_17203\" aria-describedby=\"caption-attachment-17203\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/34-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17203\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/34-1.png\" alt=\"\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u642c\u9001\u4eba\u54e1\u6570\" width=\"530\" height=\"467\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/34-1.png 530w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/34-1-300x264.png 300w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><\/a><figcaption id=\"caption-attachment-17203\" class=\"wp-caption-text\">\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n<figure id=\"attachment_17204\" aria-describedby=\"caption-attachment-17204\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/35-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17204\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/35-1.png\" alt=\"\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u3068\u642c\u9001\u4eba\u54e1\u6570\" width=\"530\" height=\"467\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/35-1.png 530w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/01\/35-1-300x264.png 300w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><\/a><figcaption id=\"caption-attachment-17204\" class=\"wp-caption-text\">\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u3068\u642c\u9001\u4eba\u54e1\u6570<\/figcaption><\/figure>\n<h3>\u30c7\u30fc\u30bf\u306e\u8981\u7d04<\/h3>\n<p>\u3000\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30c7\u30fc\u30bf\u306e\u8981\u7d04\u3092\u884c\u3046\uff0e<\/p>\n<pre>&gt; summary(HeatStroke)<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<pre>      Date                           PrefCode         Pref          \n Min.   :2008-07-01 00:00:00.00   Min.   : 1.00   Length:82785      \n 1st Qu.:2012-07-18 00:00:00.00   1st Qu.:13.00   Class :character  \n Median :2015-09-17 00:00:00.00   Median :25.00   Mode  :character  \n Mean   :2015-08-29 00:12:51.26   Mean   :24.32                     \n 3rd Qu.:2018-09-09 00:00:00.00   3rd Qu.:36.00                     \n Max.   :2021-09-30 00:00:00.00   Max.   :47.00                     \n      Temp           Vapor         HeatStroke     \n Min.   : 8.40   Min.   : 4.20   Min.   :  0.000  \n 1st Qu.:26.10   1st Qu.:19.00   1st Qu.:  1.000  \n Median :29.20   Median :23.80   Median :  2.000  \n Mean   :28.99   Mean   :23.02   Mean   :  8.171  \n 3rd Qu.:32.30   3rd Qu.:27.50   3rd Qu.:  8.000  \n Max.   :40.70   Max.   :37.00   Max.   :406.000  <\/pre>\n<h3>\u642c\u9001\u4eba\u54e1\u6570\u3092\u56f3\u793a\u3059\u308b<\/h3>\n<p>\u3000\u642c\u9001\u4eba\u54e1\u6570\u3092\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306b\u3057\u3066\u5206\u5e03\u3092\u56f3\u793a\u3059\u308b\uff0e<\/p>\n<pre>&gt; hist(HeatStroke$HeatStroke, breaks = 406)<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_17231\" aria-describedby=\"caption-attachment-17231\" style=\"width: 529px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/05\/37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17231\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/05\/37.png\" alt=\"\u642c\u9001\u4eba\u54e1\u6570\u306e\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\" width=\"529\" height=\"545\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/05\/37.png 529w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2023\/05\/37-291x300.png 291w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/a><figcaption id=\"caption-attachment-17231\" class=\"wp-caption-text\">\u642c\u9001\u4eba\u54e1\u6570\u306e\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0<\/figcaption><\/figure>\n<h2>\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u306b\u3088\u308b\u56de\u5e30\u4fc2\u6570\u306e\u63a8\u5b9a<\/h2>\n<p>\u3000\u642c\u9001\u4eba\u54e1\u6570\u306f\u975e\u8ca0\u306e\u6574\u6570\u3067\u3042\u308a\uff0c\u4e0b\u9650\u306f0\u3067\u3042\u308b\u304c\u4e0a\u9650\u306f\u4e0d\u660e\u3067\u3042\u308b\u305f\u3081\uff0c\u307e\u305a\u306f\u30dd\u30a2\u30bd\u30f3\u5206\u5e03\u3092\u4eee\u5b9a\u3057\u3066\u89e3\u6790\u3057\u3066\u307f\u308b\uff0e<\/p>\n<p>\u3000\u4e0b\u8a18\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n<pre>&gt; z = glm(vNum ~ vTemp + vVapor, family = poisson(link=\"log\"))\n&gt; summary(z)<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e<\/p>\n<pre>Call:\nglm(formula = vNum ~ vTemp + vVapor, family = poisson(link = \"log\"))\n\nDeviance Residuals: \n    Min       1Q   Median       3Q      Max  \n-10.770   -1.958   -0.887    0.586   33.508  \n\nCoefficients:\n              Estimate Std. Error z value Pr(&gt;|z|)    \n(Intercept) -8.0235926  0.0142797  -561.9   &lt;2e-16 ***\nvTemp        0.2695439  0.0004490   600.3   &lt;2e-16 ***\nvVapor       0.0660829  0.0003571   185.1   &lt;2e-16 ***\n---\nSignif. codes:  0 \u2018***\u2019 0.001 \u2018**\u2019 0.01 \u2018*\u2019 0.05 \u2018.\u2019 0.1 \u2018 \u2019 1\n\n(Dispersion parameter for poisson family taken to be 1)\n\n    Null deviance: 1463940  on 82784  degrees of freedom\nResidual deviance:  662439  on 82782  degrees of freedom\nAIC: 879565\n\nNumber of Fisher Scoring iterations: 5<\/pre>\n<p>\u3000\u56de\u5e30\u5f0f\u306f\u4ee5\u4e0b\u306e\u901a\u308a\uff0e\u6e29\u5ea6\u304c1\u2103\u4e0a\u6607\u3059\u308b\u3068\u642c\u9001\u6570\u304c\u7d04e<sup>0.27<\/sup>\u500d\uff08\u7d041.3\u500d\uff09\u306b\u306a\u308a\uff0c\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u304c1mmHg\u4e0a\u6607\u3059\u308b\u3068\u642c\u9001\u6570\u304c\u7d04e<sup>0.07<\/sup>\u500d\uff08\u7d041.07\u500d\uff09\u306b\u306a\u308b\u3068\u3044\u3046\u610f\u5473\u3067\u3042\u308b\uff0e<\/p>\n<p><img src='https:\/\/s0.wp.com\/latex.php?latex=log%28%5Clambda%29%3D-8.0235926+%2B+0.2695439vTemp+%2B+0.0660829vVapor&#038;bg=ffffff&#038;fg=000000&#038;s=0' alt='log(\\lambda)=-8.0235926 + 0.2695439vTemp + 0.0660829vVapor' title='log(\\lambda)=-8.0235926 + 0.2695439vTemp + 0.0660829vVapor' class='latex' \/><\/p>\n<p>\u3000\u3057\u304b\u3057\uff0c\u30b5\u30de\u30ea\u30fc\u3092\u3088\u304f\u898b\u308b\u3068Residual deviance\u3092degree of freedom\u3067\u9664\u3057\u305f\u5024\u304c8.002211\u30681\u3092\u8d85\u3048\u3066\u304a\u308a\uff0c\u904e\u5206\u6563\u3068\u8003\u3048\u3089\u308c\u308b\uff0e\u3053\u306e\u5834\u5408\uff0c\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3092\u5f53\u3066\u306f\u3081\u308b\u306e\u304c\u59a5\u5f53\u3068\u8003\u3048\u3089\u308c\u308b\uff0e<\/p>\n<h2>\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u306b\u3088\u308b\u56de\u5e30\u4fc2\u6570\u306e\u63a8\u5b9a<\/h2>\n<p>\u3000\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u3067\u306f\u904e\u5206\u6563\u3068\u306a\u3063\u305f\u305f\u3081\uff0c\u3088\u308a\u5206\u6563\u306e\u5927\u304d\u306a\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3092\u9069\u7528\u3057\u3066\u307f\u308b\uff0e<\/p>\n<pre>&gt; y=HeatStroke$HeatStroke\n&gt; x1=HeatStroke$Temp\n&gt; x2=HeatStroke$Vapor\n&gt; library(MASS)\n&gt; Z=glm.nb(y~x1+x2)\n&gt; summary(Z)<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<pre>Call:\nglm.nb(formula = y ~ x1 + x2, init.theta = 1.086748839, link = log)\n\nDeviance Residuals: \n    Min       1Q   Median       3Q      Max  \n-2.6560  -1.0483  -0.4735   0.2358   5.9940  \n\nCoefficients:\n              Estimate Std. Error z value Pr(&gt;|z|)    \n(Intercept) -7.6852676  0.0329494 -233.24   &lt;2e-16 ***\nx1           0.2844962  0.0013080  217.50   &lt;2e-16 ***\nx2           0.0342140  0.0009293   36.82   &lt;2e-16 ***\n---\nSignif. codes:  0 \u2018***\u2019 0.001 \u2018**\u2019 0.01 \u2018*\u2019 0.05 \u2018.\u2019 0.1 \u2018 \u2019 1\n\n(Dispersion parameter for Negative Binomial(1.0867) family taken to be 1)\n\n    Null deviance: 193086  on 82784  degrees of freedom\nResidual deviance:  89163  on 82782  degrees of freedom\nAIC: 425939\n\nNumber of Fisher Scoring iterations: 1\n\n\n              Theta:  1.08675 \n          Std. Err.:  0.00720 \n\n 2 x log-likelihood:  -425930.92800 <\/pre>\n<p>\u3000\u56de\u5e30\u4fc2\u6570\u306f\u82e5\u5e72\u5909\u5316\u3057\u3066\u3044\u308b\u304c\u307b\u307c\u5909\u308f\u3089\u305a\uff0cAIC\u304c879565\u304b\u3089425939\u306b\u6e1b\u5c11\u3057\uff0c\u5f53\u3066\u306f\u307e\u308a\u304c\u5927\u304d\u304f\u6539\u5584\u3055\u308c\u305f\u3053\u3068\u304c\u308f\u304b\u308b\uff0e<\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000SQL Server\u304b\u3089\u62bd\u51fa\u3057\u305f\u30c7\u30fc\u30bf\u3092\u3082\u3068\u306bR\u3067\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u304a\u3088\u3073\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3092\u7528\u3044\u3066\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u3068\u306e\u56de\u5e30\u4fc2\u6570\u3092\u63a8\u5b9a\u3057\u305f\uff0e\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u3067\u306f\u904e\u5206\u6563\u3067\u3042\u308a\uff0c\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3092\u5f53\u3066\u306f\u3081\u308b\u306e\u304c\u59a5\u5f53\u3067\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u4ee5\u524d\uff0c\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u6570\u306f\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u76f8\u95a2\u95a2\u4fc2\u304c\u3042\u308a\uff0c\u7247\u5bfe\u6570\u30b0\u30e9\u30d5\u3067\u76f4\u7dda\u306b\u306a\u308b\u3068\u8ff0\u3079\u305f\uff0e\u4eca\u56de\u306f\u30dd\u30a2\u30bd\u30f3\u56de\u5e30\u30e2\u30c7\u30eb\u304a\u3088\u3073\u8ca0\u306e\u4e8c\u9805\u5206\u5e03\u30e2\u30c7\u30eb\u3067\u71b1\u4e2d\u75c7\u642c\u9001\u4eba\u54e1\u6570\u306b\u5bfe\u3059\u308b\u65e5\u6700\u9ad8\u6c17\u6e29\u3068\u5e73\u5747\u6c34\u84b8\u6c17\u5727\u306e\u56de\u5e30\u4fc2\u6570\u3092\u63a8\u5b9a\u3059\u308b\uff0e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[13317,3559,13324,6391,13311,13318,13301,13313,265,11356,4673,13303,13308,13321,13323,13304,13302,5411,13312,5914,13310,3962,7096,4644,13307,13309,677,13316,4672,2740,13314,13322,7154,13315,2783,13306,13305,32,13299,13268,3615,11240,13300,5852,2893,4424,13320,3680,13319],"class_list":["post-17193","post","type-post","status-publish","format-standard","hentry","category-technology","tag-aic","tag-and","tag-breaks","tag-by","tag-coefficients","tag-degrees-of-freedom","tag-environment","tag-estimate","tag-excel","tag-family","tag-from","tag-from-excel","tag-glm","tag-glm-nb","tag-hist","tag-import","tag-import-dataset","tag-inner","tag-intercept","tag-join","tag-link","tag-log","tag-on","tag-order","tag-plot","tag-poisson","tag-r","tag-residual-deviance","tag-select","tag-sql-server","tag-std-error","tag-summary","tag-use","tag-z-value","tag-2783","tag-13306","tag-13305","tag-32","tag-13299","tag-13268","tag-3615","tag-11240","tag-13300","tag-5852","tag-2893","tag-4424","tag-13320","tag-3680","tag-13319"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/17193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17193"}],"version-history":[{"count":29,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/17193\/revisions"}],"predecessor-version":[{"id":17312,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/17193\/revisions\/17312"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}