関数
>
統計
>
記述統計
>
例: 標準誤差を計算する
例: 標準誤差を計算する
平均値と割合の標準誤差、および回帰直線の傾きと切片の標準誤差を計算します。
平均値の標準誤差
1.
ベクトル
D
を定義します。
<region id="ID0EG1JGB" top="192.00000000000003" left="19.200000000000003" xml:lang="ja" height="111.24000000000001" width="105.79666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="44" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja">D</id> <matrix rows="36" cols="1" xml:lang="ja"> <display size="4,1" xml:lang="ja" /> <real xml:lang="ja">10.23</real> <real xml:lang="ja">10.12</real> <real xml:lang="ja">9.841</real> <real xml:lang="ja">10.28</real> <real xml:lang="ja">9.35</real> <real xml:lang="ja">10.03</real> <real xml:lang="ja">9.734</real> <real xml:lang="ja">9.325</real> <real xml:lang="ja">7.16</real> <real xml:lang="ja">12.01</real> <real xml:lang="ja">9.366</real> <real xml:lang="ja">9.537</real> <real xml:lang="ja">9.857</real> <real xml:lang="ja">9.946</real> <real xml:lang="ja">10.8</real> <real xml:lang="ja">9.912</real> <real xml:lang="ja">9.911</real> <real xml:lang="ja">13.22</real> <real xml:lang="ja">10.74</real> <real xml:lang="ja">9.962</real> <real xml:lang="ja">10.42</real> <real xml:lang="ja">10.21</real> <real xml:lang="ja">9.002</real> <real xml:lang="ja">9.799</real> <real xml:lang="ja">10.03</real> <real xml:lang="ja">9.227</real> <real xml:lang="ja">9.851</real> <real xml:lang="ja">11.78</real> <real xml:lang="ja">3.63</real> <real xml:lang="ja">10.57</real> <real xml:lang="ja">11.37</real> <real xml:lang="ja">10.18</real> <real xml:lang="ja">10.02</real> <real xml:lang="ja">13.93</real> <real xml:lang="ja">10.48</real> <real xml:lang="ja">6.377</real> </matrix> </define> </math> </region>
2.
平均値の標準誤差を計算します。
<region id="ID0ED4JGB" top="288.00000000000006" left="19.200000000000003" xml:lang="ja" height="25.6" width="106.07666666666668" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="46" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">N</id> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">length</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">D</id> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0E34JGB" top="288.00000000000006" left="192.00000000000003" xml:lang="ja" height="25.6" width="60.573333333333338" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="48" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">N</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EY5JGB" top="326.40000000000003" left="19.200000000000003" xml:lang="ja" height="50.065333527326587" width="202.86933330357073" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="50" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">SE_mean</id> <apply xml:lang="ja"> <nthRoot xml:lang="ja" /> <placeholder xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <apply xml:lang="ja"> <div xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">N</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">N</id> <real xml:lang="ja">1</real> </apply> </apply> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">D</id> </apply> </apply> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EQ6JGB" top="345.6" left="268.80000000000007" xml:lang="ja" height="25.6" width="134.46666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="52" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">SE_mean</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
割合の標準誤差
1.
ベクトル
Dp
を定義します。
<region id="ID0EZBKGB" top="499.20000000000005" left="19.200000000000003" xml:lang="ja" height="129.84" width="86.006666666666661" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="54" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">Dp</id> <matrix rows="100" cols="1" xml:lang="ja"> <display size="5,1" xml:lang="ja" /> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">1</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> <real xml:lang="ja">0</real> </matrix> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
2.
割合の標準誤差を計算します。
<region id="ID0EWEKGB" top="652.80000000000007" left="19.200000000000003" xml:lang="ja" height="25.6" width="111.92333333333335" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="56" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">Np</id> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">rows</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Dp</id> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EPFKGB" top="652.80000000000007" left="211.20000000000005" xml:lang="ja" height="25.6" width="77.073333333333338" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="58" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Np</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EMGKGB" top="691.2" left="19.200000000000003" xml:lang="ja" height="71.600000000000009" width="80.093333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="60" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">p</id> <apply xml:lang="ja"> <div xml:lang="ja" /> <apply xml:lang="ja"> <summation xml:lang="ja" /> <lambda xml:lang="ja"> <boundVars xml:lang="ja"> <placeholder xml:lang="ja" /> </boundVars> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Dp</id> </lambda> <upperBound xml:lang="ja"> <placeholder xml:lang="ja" /> </upperBound> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Np</id> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EFHKGB" top="691.2" left="211.20000000000005" xml:lang="ja" height="25.6" width="69.136666666666684" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="62" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">p</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EBIKGB" top="748.80000000000007" left="19.200000000000003" xml:lang="ja" height="50.065333527326587" width="148.55933330357075" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="64" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">SE_pr</id> <apply xml:lang="ja"> <nthRoot xml:lang="ja" /> <placeholder xml:lang="ja" /> <apply xml:lang="ja"> <div xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">p</id> <parens xml:lang="ja"> <apply xml:lang="ja"> <minus xml:lang="ja" /> <real xml:lang="ja">1</real> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">p</id> </apply> </parens> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Np</id> </apply> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EZIKGB" top="748.80000000000007" left="211.20000000000005" xml:lang="ja" height="25.6" width="111.61333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="66" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">SE_pr</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
回帰直線の標準誤差
1.
ベクトル
Dr
を定義します。
<region id="ID0ECLKGB" top="902.40000000000009" left="19.200000000000003" xml:lang="ja" height="111.24000000000001" width="157.08333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="68" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">Dr</id> <matrix rows="100" cols="2" xml:lang="ja"> <display size="4,2" xml:lang="ja" /> <real xml:lang="ja">0.006</real> <real xml:lang="ja">1.967</real> <real xml:lang="ja">4.925</real> <real xml:lang="ja">4.752</real> <real xml:lang="ja">8.114</real> <real xml:lang="ja">5.871</real> <real xml:lang="ja">9.552</real> <real xml:lang="ja">8.52</real> <real xml:lang="ja">8.457</real> <real xml:lang="ja">9.737</real> <real xml:lang="ja">14.94</real> <real xml:lang="ja">11.6</real> <real xml:lang="ja">12.04</real> <real xml:lang="ja">15.66</real> <real xml:lang="ja">17.01</real> <real xml:lang="ja">15.83</real> <real xml:lang="ja">18.25</real> <real xml:lang="ja">17.29</real> <real xml:lang="ja">21.92</real> <real xml:lang="ja">21.6</real> <real xml:lang="ja">24.38</real> <real xml:lang="ja">25.78</real> <real xml:lang="ja">24.7</real> <real xml:lang="ja">25.31</real> <real xml:lang="ja">28.31</real> <real xml:lang="ja">28.9</real> <real xml:lang="ja">30.98</real> <real xml:lang="ja">30.06</real> <real xml:lang="ja">29.33</real> <real xml:lang="ja">33.2</real> <real xml:lang="ja">31.88</real> <real xml:lang="ja">34.39</real> <real xml:lang="ja">32.04</real> <real xml:lang="ja">34.38</real> <real xml:lang="ja">36.94</real> <real xml:lang="ja">39.19</real> <real xml:lang="ja">38.42</real> <real xml:lang="ja">40.72</real> <real xml:lang="ja">40.29</real> <real xml:lang="ja">42.72</real> <real xml:lang="ja">43</real> <real xml:lang="ja">44.68</real> <real xml:lang="ja">44.86</real> <real xml:lang="ja">43.76</real> <real xml:lang="ja">46.13</real> <real xml:lang="ja">47.59</real> <real xml:lang="ja">49.76</real> <real xml:lang="ja">47.84</real> <real xml:lang="ja">50.46</real> <real xml:lang="ja">52.5</real> <real xml:lang="ja">50.74</real> <real xml:lang="ja">51.71</real> <real xml:lang="ja">55.46</real> <real xml:lang="ja">55.13</real> <real xml:lang="ja">58.83</real> <real xml:lang="ja">55.77</real> <real xml:lang="ja">60.11</real> <real xml:lang="ja">57.96</real> <real xml:lang="ja">62.09</real> <real xml:lang="ja">59.78</real> <real xml:lang="ja">63.66</real> <real xml:lang="ja">62.4</real> <real xml:lang="ja">65.41</real> <real xml:lang="ja">66.61</real> <real xml:lang="ja">64.62</real> <real xml:lang="ja">69.17</real> <real xml:lang="ja">68.59</real> <real xml:lang="ja">69.13</real> <real xml:lang="ja">72.75</real> <real xml:lang="ja">71.75</real> <real xml:lang="ja">72.36</real> <real xml:lang="ja">75.23</real> <real xml:lang="ja">74.28</real> <real xml:lang="ja">77.91</real> <real xml:lang="ja">77.7</real> <real xml:lang="ja">75.98</real> <real xml:lang="ja">80.2</real> <real xml:lang="ja">79.5</real> <real xml:lang="ja">78.14</real> <real xml:lang="ja">81.86</real> <real xml:lang="ja">82.66</real> <real xml:lang="ja">85.22</real> <real xml:lang="ja">85.29</real> <real xml:lang="ja">87.21</real> <real xml:lang="ja">84.55</real> <real xml:lang="ja">86.57</real> <real xml:lang="ja">87.43</real> <real xml:lang="ja">87.7</real> <real xml:lang="ja">92.17</real> <real xml:lang="ja">92</real> <real xml:lang="ja">91.26</real> <real xml:lang="ja">91.01</real> <real xml:lang="ja">96.03</real> <real xml:lang="ja">94.05</real> <real xml:lang="ja">96.77</real> <real xml:lang="ja">95.57</real> <real xml:lang="ja">99.76</real> <real xml:lang="ja">99.72</real> <real xml:lang="ja">100.2</real> <real xml:lang="ja">102.5</real> <real xml:lang="ja">3</real> <real xml:lang="ja">4.437</real> <real xml:lang="ja">6.156</real> <real xml:lang="ja">7.886</real> <real xml:lang="ja">9.017</real> <real xml:lang="ja">11.48</real> <real xml:lang="ja">10.14</real> <real xml:lang="ja">11.25</real> <real xml:lang="ja">14.66</real> <real xml:lang="ja">12.88</real> <real xml:lang="ja">13.94</real> <real xml:lang="ja">24.25</real> <real xml:lang="ja">25.74</real> <real xml:lang="ja">18.96</real> <real xml:lang="ja">22.75</real> <real xml:lang="ja">27.42</real> <real xml:lang="ja">26.23</real> <real xml:lang="ja">30.16</real> <real xml:lang="ja">36.39</real> <real xml:lang="ja">33.87</real> <real xml:lang="ja">34.31</real> <real xml:lang="ja">27.87</real> <real xml:lang="ja">37.21</real> <real xml:lang="ja">31.59</real> <real xml:lang="ja">41.51</real> <real xml:lang="ja">42.62</real> <real xml:lang="ja">41.86</real> <real xml:lang="ja">50</real> <real xml:lang="ja">48.37</real> <real xml:lang="ja">55.33</real> <real xml:lang="ja">50.28</real> <real xml:lang="ja">62.26</real> <real xml:lang="ja">58.29</real> <real xml:lang="ja">58.04</real> <real xml:lang="ja">47.71</real> <real xml:lang="ja">48.7</real> <real xml:lang="ja">42.91</real> <real xml:lang="ja">71.5</real> <real xml:lang="ja">46.89</real> <real xml:lang="ja">45.09</real> <real xml:lang="ja">68.64</real> <real xml:lang="ja">66.35</real> <real xml:lang="ja">62.18</real> <real xml:lang="ja">66.02</real> <real xml:lang="ja">53.72</real> <real xml:lang="ja">81.21</real> <real xml:lang="ja">87.03</real> <real xml:lang="ja">91.05</real> <real xml:lang="ja">65.4</real> <real xml:lang="ja">58.23</real> <real xml:lang="ja">92.25</real> <real xml:lang="ja">85.09</real> <real xml:lang="ja">58.76</real> <real xml:lang="ja">90.65</real> <real xml:lang="ja">62.66</real> <real xml:lang="ja">70.49</real> <real xml:lang="ja">110.5</real> <real xml:lang="ja">97.78</real> <real xml:lang="ja">89.57</real> <real xml:lang="ja">91.31</real> <real xml:lang="ja">93.56</real> <real xml:lang="ja">106</real> <real xml:lang="ja">102.6</real> <real xml:lang="ja">66.37</real> <real xml:lang="ja">73.44</real> <real xml:lang="ja">124.1</real> <real xml:lang="ja">118.3</real> <real xml:lang="ja">95.47</real> <real xml:lang="ja">108.6</real> <real xml:lang="ja">137.9</real> <real xml:lang="ja">85.36</real> <real xml:lang="ja">83.35</real> <real xml:lang="ja">143.5</real> <real xml:lang="ja">78.03</real> <real xml:lang="ja">81.14</real> <real xml:lang="ja">87.87</real> <real xml:lang="ja">144.7</real> <real xml:lang="ja">135.6</real> <real xml:lang="ja">82.15</real> <real xml:lang="ja">137.9</real> <real xml:lang="ja">100.4</real> <real xml:lang="ja">97.68</real> <real xml:lang="ja">113</real> <real xml:lang="ja">116.5</real> <real xml:lang="ja">154.4</real> <real xml:lang="ja">132.8</real> <real xml:lang="ja">157.6</real> <real xml:lang="ja">102.6</real> <real xml:lang="ja">126.4</real> <real xml:lang="ja">104.2</real> <real xml:lang="ja">98.96</real> <real xml:lang="ja">146.2</real> <real xml:lang="ja">145.4</real> <real xml:lang="ja">125</real> <real xml:lang="ja">173</real> <real xml:lang="ja">125</real> <real xml:lang="ja">184.9</real> <real xml:lang="ja">172.1</real> <real xml:lang="ja">136.4</real> <real xml:lang="ja">124.6</real> </matrix> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
2.
上記のデータセットを最良適合する直線の傾きと切片を計算します。
<region id="ID0E5NKGB" top="1017.6000000000001" left="19.200000000000003" xml:lang="ja" height="27.752000000000002" width="69.24666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="70" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">X</id> <apply xml:lang="ja"> <matcol xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Dr</id> <real xml:lang="ja">0</real> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EXOKGB" top="1017.6000000000001" left="192.00000000000003" xml:lang="ja" height="27.752000000000002" width="68.613333333333344" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="72" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">Y</id> <apply xml:lang="ja"> <matcol xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Dr</id> <real xml:lang="ja">1</real> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0ESPKGB" top="1036.8000000000002" left="19.200000000000003" xml:lang="ja" height="25.6" width="118.24333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="74" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">m</id> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">slope</id> <sequence xml:lang="ja"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Y</id> </sequence> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EKQKGB" top="1036.8000000000002" left="192.00000000000003" xml:lang="ja" height="25.6" width="139.07" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="76" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">b</id> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">intercept</id> <sequence xml:lang="ja"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Y</id> </sequence> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
3.
傾きの標準誤差を計算します。
<region id="ID0E6RKGB" top="1113.6000000000001" left="19.200000000000003" xml:lang="ja" height="25.6" width="108.87666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="78" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">Nr</id> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">rows</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Dr</id> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0ERSKGB" top="1171.2000000000003" left="19.200000000000003" xml:lang="ja" height="74.465333527326592" width="286.21528235077858" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="80" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">SE_slope</id> <apply xml:lang="ja"> <nthRoot xml:lang="ja" /> <placeholder xml:lang="ja" /> <apply xml:lang="ja"> <div xml:lang="ja" /> <apply xml:lang="ja"> <summation xml:lang="ja" /> <lambda xml:lang="ja"> <boundVars xml:lang="ja"> <id xml:space="preserve" xml:lang="ja">i</id> </boundVars> <apply xml:lang="ja"> <pow xml:lang="ja" /> <parens xml:lang="ja"> <apply xml:lang="ja"> <minus xml:lang="ja" /> <apply xml:lang="ja"> <indexer xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Y</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id xml:space="preserve" xml:lang="ja">i</id> <real xml:lang="ja">1</real> </apply> </apply> <parens xml:lang="ja"> <apply xml:lang="ja"> <plus xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">m</id> <apply xml:lang="ja"> <indexer xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id xml:space="preserve" xml:lang="ja">i</id> <real xml:lang="ja">1</real> </apply> </apply> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">b</id> </apply> </parens> </apply> </parens> <real xml:lang="ja">2</real> </apply> </lambda> <lowerBound xml:lang="ja"> <real xml:lang="ja">1</real> </lowerBound> <upperBound xml:lang="ja"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> </upperBound> </apply> <apply xml:lang="ja"> <mult xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <parens xml:lang="ja"> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> <real xml:lang="ja">2</real> </apply> </parens> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> </apply> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> </apply> </apply> </apply> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EDTKGB" top="1171.2000000000003" left="307.20000000000005" xml:lang="ja" height="25.6" width="130.57666666666668" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="82" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">SE_slope</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
4.
切片の標準誤差を計算します。
<region id="ID0EYUKGB" top="1305.6000000000001" left="38.400000000000006" xml:lang="ja" height="74.465333527326592" width="442.34861568411196" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="84" xml:lang="ja"> <define xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="ja">SE_intercept</id> <apply xml:lang="ja"> <mult xml:lang="ja" /> <apply xml:lang="ja"> <div xml:lang="ja" /> <real xml:lang="ja">1</real> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> </apply> <apply xml:lang="ja"> <nthRoot xml:lang="ja" /> <placeholder xml:lang="ja" /> <apply xml:lang="ja"> <div xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <parens xml:lang="ja"> <apply xml:lang="ja"> <summation xml:lang="ja" /> <lambda xml:lang="ja"> <boundVars xml:lang="ja"> <id xml:space="preserve" xml:lang="ja">i</id> </boundVars> <apply xml:lang="ja"> <pow xml:lang="ja" /> <parens xml:lang="ja"> <apply xml:lang="ja"> <minus xml:lang="ja" /> <apply xml:lang="ja"> <indexer xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Y</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id xml:space="preserve" xml:lang="ja">i</id> <real xml:lang="ja">1</real> </apply> </apply> <parens xml:lang="ja"> <apply xml:lang="ja"> <plus xml:lang="ja" /> <apply xml:lang="ja"> <mult xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">m</id> <apply xml:lang="ja"> <indexer xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id xml:space="preserve" xml:lang="ja">i</id> <real xml:lang="ja">1</real> </apply> </apply> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">b</id> </apply> </parens> </apply> </parens> <real xml:lang="ja">2</real> </apply> </lambda> <lowerBound xml:lang="ja"> <real xml:lang="ja">1</real> </lowerBound> <upperBound xml:lang="ja"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> </upperBound> </apply> </parens> <apply xml:lang="ja"> <summation xml:lang="ja" /> <lambda xml:lang="ja"> <boundVars xml:lang="ja"> <id xml:space="preserve" xml:lang="ja">i</id> </boundVars> <apply xml:lang="ja"> <pow xml:lang="ja" /> <parens xml:lang="ja"> <apply xml:lang="ja"> <indexer xml:lang="ja" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> <apply xml:lang="ja"> <minus xml:lang="ja" /> <id xml:space="preserve" xml:lang="ja">i</id> <real xml:lang="ja">1</real> </apply> </apply> </parens> <real xml:lang="ja">2</real> </apply> </lambda> <lowerBound xml:lang="ja"> <real xml:lang="ja">1</real> </lowerBound> <upperBound xml:lang="ja"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">Nr</id> </upperBound> </apply> </apply> <apply xml:lang="ja"> <id labels="FUNCTION" xml:space="preserve" xml:lang="ja" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">X</id> </apply> </apply> </apply> </apply> </define> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
<region id="ID0EKVKGB" top="1382.4" left="38.400000000000006" xml:lang="ja" height="25.6" width="167.14333333333335" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="86" xml:lang="ja"> <eval xml:lang="ja" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="ja" label-is-contextual="true">SE_intercept</id> <unitOverride xml:lang="ja"> <placeholder xml:lang="ja" /> </unitOverride> </eval> <resultFormat xml:lang="ja"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="ja" /> </resultFormat> </math> </region>
式をコピー
