函數
>
統計
>
描述性統計
>
範例：計算標準誤差
範例：計算標準誤差
計算均數與比例的標準誤差，以及遞歸斜率與截距的標準誤差。
均數的標準誤差
1.
定義向量
D
。
<region id="ID0EV6KGB" top="192.00000000000003" left="19.200000000000003" xml:lang="zh_TW" height="111.24000000000001" width="105.79666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="44" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">D</id> <matrix rows="36" cols="1" xml:lang="zh_TW"> <display size="4,1" xml:lang="zh_TW" /> <real xml:lang="zh_TW">10.23</real> <real xml:lang="zh_TW">10.12</real> <real xml:lang="zh_TW">9.841</real> <real xml:lang="zh_TW">10.28</real> <real xml:lang="zh_TW">9.35</real> <real xml:lang="zh_TW">10.03</real> <real xml:lang="zh_TW">9.734</real> <real xml:lang="zh_TW">9.325</real> <real xml:lang="zh_TW">7.16</real> <real xml:lang="zh_TW">12.01</real> <real xml:lang="zh_TW">9.366</real> <real xml:lang="zh_TW">9.537</real> <real xml:lang="zh_TW">9.857</real> <real xml:lang="zh_TW">9.946</real> <real xml:lang="zh_TW">10.8</real> <real xml:lang="zh_TW">9.912</real> <real xml:lang="zh_TW">9.911</real> <real xml:lang="zh_TW">13.22</real> <real xml:lang="zh_TW">10.74</real> <real xml:lang="zh_TW">9.962</real> <real xml:lang="zh_TW">10.42</real> <real xml:lang="zh_TW">10.21</real> <real xml:lang="zh_TW">9.002</real> <real xml:lang="zh_TW">9.799</real> <real xml:lang="zh_TW">10.03</real> <real xml:lang="zh_TW">9.227</real> <real xml:lang="zh_TW">9.851</real> <real xml:lang="zh_TW">11.78</real> <real xml:lang="zh_TW">3.63</real> <real xml:lang="zh_TW">10.57</real> <real xml:lang="zh_TW">11.37</real> <real xml:lang="zh_TW">10.18</real> <real xml:lang="zh_TW">10.02</real> <real xml:lang="zh_TW">13.93</real> <real xml:lang="zh_TW">10.48</real> <real xml:lang="zh_TW">6.377</real> </matrix> </define> </math> </region>
2.
計算均數的標準誤差。
<region id="ID0ESCLGB" top="288.00000000000006" left="19.200000000000003" xml:lang="zh_TW" height="25.6" width="106.07666666666668" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="46" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">N</id> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">length</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">D</id> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ELDLGB" top="288.00000000000006" left="192.00000000000003" xml:lang="zh_TW" height="25.6" width="60.573333333333338" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="48" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">N</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EHELGB" top="326.40000000000003" left="19.200000000000003" xml:lang="zh_TW" height="50.065333527326587" width="202.86933330357073" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="50" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">SE_mean</id> <apply xml:lang="zh_TW"> <nthRoot xml:lang="zh_TW" /> <placeholder xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">N</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">N</id> <real xml:lang="zh_TW">1</real> </apply> </apply> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">D</id> </apply> </apply> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0E6ELGB" top="345.6" left="268.80000000000007" xml:lang="zh_TW" height="25.6" width="134.46666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="52" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">SE_mean</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
比例的標準誤差
1.
定義向量
Dp
。
<region id="ID0EIHLGB" top="499.20000000000005" left="19.200000000000003" xml:lang="zh_TW" height="129.84" width="86.006666666666661" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="54" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">Dp</id> <matrix rows="100" cols="1" xml:lang="zh_TW"> <display size="5,1" xml:lang="zh_TW" /> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">1</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> <real xml:lang="zh_TW">0</real> </matrix> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
2.
計算比例的標準誤差。
<region id="ID0EFKLGB" top="652.80000000000007" left="19.200000000000003" xml:lang="zh_TW" height="25.6" width="111.92333333333335" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="56" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">Np</id> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">rows</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Dp</id> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0E5KLGB" top="652.80000000000007" left="211.20000000000005" xml:lang="zh_TW" height="25.6" width="77.073333333333338" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="58" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Np</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0E2LLGB" top="691.2" left="19.200000000000003" xml:lang="zh_TW" height="71.600000000000009" width="80.093333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="60" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">p</id> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <summation xml:lang="zh_TW" /> <lambda xml:lang="zh_TW"> <boundVars xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </boundVars> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Dp</id> </lambda> <upperBound xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </upperBound> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Np</id> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EUMLGB" top="691.2" left="211.20000000000005" xml:lang="zh_TW" height="25.6" width="69.136666666666684" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="62" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">p</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EQNLGB" top="748.80000000000007" left="19.200000000000003" xml:lang="zh_TW" height="50.065333527326587" width="148.55933330357075" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="64" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">SE_pr</id> <apply xml:lang="zh_TW"> <nthRoot xml:lang="zh_TW" /> <placeholder xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">p</id> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <real xml:lang="zh_TW">1</real> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">p</id> </apply> </parens> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Np</id> </apply> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EIOLGB" top="748.80000000000007" left="211.20000000000005" xml:lang="zh_TW" height="25.6" width="111.61333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="66" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">SE_pr</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
遞歸的標準誤差
1.
定義向量
Dr
。
<region id="ID0ERQLGB" top="902.40000000000009" left="19.200000000000003" xml:lang="zh_TW" height="111.24000000000001" width="157.08333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="68" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">Dr</id> <matrix rows="100" cols="2" xml:lang="zh_TW"> <display size="4,2" xml:lang="zh_TW" /> <real xml:lang="zh_TW">0.006</real> <real xml:lang="zh_TW">1.967</real> <real xml:lang="zh_TW">4.925</real> <real xml:lang="zh_TW">4.752</real> <real xml:lang="zh_TW">8.114</real> <real xml:lang="zh_TW">5.871</real> <real xml:lang="zh_TW">9.552</real> <real xml:lang="zh_TW">8.52</real> <real xml:lang="zh_TW">8.457</real> <real xml:lang="zh_TW">9.737</real> <real xml:lang="zh_TW">14.94</real> <real xml:lang="zh_TW">11.6</real> <real xml:lang="zh_TW">12.04</real> <real xml:lang="zh_TW">15.66</real> <real xml:lang="zh_TW">17.01</real> <real xml:lang="zh_TW">15.83</real> <real xml:lang="zh_TW">18.25</real> <real xml:lang="zh_TW">17.29</real> <real xml:lang="zh_TW">21.92</real> <real xml:lang="zh_TW">21.6</real> <real xml:lang="zh_TW">24.38</real> <real xml:lang="zh_TW">25.78</real> <real xml:lang="zh_TW">24.7</real> <real xml:lang="zh_TW">25.31</real> <real xml:lang="zh_TW">28.31</real> <real xml:lang="zh_TW">28.9</real> <real xml:lang="zh_TW">30.98</real> <real xml:lang="zh_TW">30.06</real> <real xml:lang="zh_TW">29.33</real> <real xml:lang="zh_TW">33.2</real> <real xml:lang="zh_TW">31.88</real> <real xml:lang="zh_TW">34.39</real> <real xml:lang="zh_TW">32.04</real> <real xml:lang="zh_TW">34.38</real> <real xml:lang="zh_TW">36.94</real> <real xml:lang="zh_TW">39.19</real> <real xml:lang="zh_TW">38.42</real> <real xml:lang="zh_TW">40.72</real> <real xml:lang="zh_TW">40.29</real> <real xml:lang="zh_TW">42.72</real> <real xml:lang="zh_TW">43</real> <real xml:lang="zh_TW">44.68</real> <real xml:lang="zh_TW">44.86</real> <real xml:lang="zh_TW">43.76</real> <real xml:lang="zh_TW">46.13</real> <real xml:lang="zh_TW">47.59</real> <real xml:lang="zh_TW">49.76</real> <real xml:lang="zh_TW">47.84</real> <real xml:lang="zh_TW">50.46</real> <real xml:lang="zh_TW">52.5</real> <real xml:lang="zh_TW">50.74</real> <real xml:lang="zh_TW">51.71</real> <real xml:lang="zh_TW">55.46</real> <real xml:lang="zh_TW">55.13</real> <real xml:lang="zh_TW">58.83</real> <real xml:lang="zh_TW">55.77</real> <real xml:lang="zh_TW">60.11</real> <real xml:lang="zh_TW">57.96</real> <real xml:lang="zh_TW">62.09</real> <real xml:lang="zh_TW">59.78</real> <real xml:lang="zh_TW">63.66</real> <real xml:lang="zh_TW">62.4</real> <real xml:lang="zh_TW">65.41</real> <real xml:lang="zh_TW">66.61</real> <real xml:lang="zh_TW">64.62</real> <real xml:lang="zh_TW">69.17</real> <real xml:lang="zh_TW">68.59</real> <real xml:lang="zh_TW">69.13</real> <real xml:lang="zh_TW">72.75</real> <real xml:lang="zh_TW">71.75</real> <real xml:lang="zh_TW">72.36</real> <real xml:lang="zh_TW">75.23</real> <real xml:lang="zh_TW">74.28</real> <real xml:lang="zh_TW">77.91</real> <real xml:lang="zh_TW">77.7</real> <real xml:lang="zh_TW">75.98</real> <real xml:lang="zh_TW">80.2</real> <real xml:lang="zh_TW">79.5</real> <real xml:lang="zh_TW">78.14</real> <real xml:lang="zh_TW">81.86</real> <real xml:lang="zh_TW">82.66</real> <real xml:lang="zh_TW">85.22</real> <real xml:lang="zh_TW">85.29</real> <real xml:lang="zh_TW">87.21</real> <real xml:lang="zh_TW">84.55</real> <real xml:lang="zh_TW">86.57</real> <real xml:lang="zh_TW">87.43</real> <real xml:lang="zh_TW">87.7</real> <real xml:lang="zh_TW">92.17</real> <real xml:lang="zh_TW">92</real> <real xml:lang="zh_TW">91.26</real> <real xml:lang="zh_TW">91.01</real> <real xml:lang="zh_TW">96.03</real> <real xml:lang="zh_TW">94.05</real> <real xml:lang="zh_TW">96.77</real> <real xml:lang="zh_TW">95.57</real> <real xml:lang="zh_TW">99.76</real> <real xml:lang="zh_TW">99.72</real> <real xml:lang="zh_TW">100.2</real> <real xml:lang="zh_TW">102.5</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">4.437</real> <real xml:lang="zh_TW">6.156</real> <real xml:lang="zh_TW">7.886</real> <real xml:lang="zh_TW">9.017</real> <real xml:lang="zh_TW">11.48</real> <real xml:lang="zh_TW">10.14</real> <real xml:lang="zh_TW">11.25</real> <real xml:lang="zh_TW">14.66</real> <real xml:lang="zh_TW">12.88</real> <real xml:lang="zh_TW">13.94</real> <real xml:lang="zh_TW">24.25</real> <real xml:lang="zh_TW">25.74</real> <real xml:lang="zh_TW">18.96</real> <real xml:lang="zh_TW">22.75</real> <real xml:lang="zh_TW">27.42</real> <real xml:lang="zh_TW">26.23</real> <real xml:lang="zh_TW">30.16</real> <real xml:lang="zh_TW">36.39</real> <real xml:lang="zh_TW">33.87</real> <real xml:lang="zh_TW">34.31</real> <real xml:lang="zh_TW">27.87</real> <real xml:lang="zh_TW">37.21</real> <real xml:lang="zh_TW">31.59</real> <real xml:lang="zh_TW">41.51</real> <real xml:lang="zh_TW">42.62</real> <real xml:lang="zh_TW">41.86</real> <real xml:lang="zh_TW">50</real> <real xml:lang="zh_TW">48.37</real> <real xml:lang="zh_TW">55.33</real> <real xml:lang="zh_TW">50.28</real> <real xml:lang="zh_TW">62.26</real> <real xml:lang="zh_TW">58.29</real> <real xml:lang="zh_TW">58.04</real> <real xml:lang="zh_TW">47.71</real> <real xml:lang="zh_TW">48.7</real> <real xml:lang="zh_TW">42.91</real> <real xml:lang="zh_TW">71.5</real> <real xml:lang="zh_TW">46.89</real> <real xml:lang="zh_TW">45.09</real> <real xml:lang="zh_TW">68.64</real> <real xml:lang="zh_TW">66.35</real> <real xml:lang="zh_TW">62.18</real> <real xml:lang="zh_TW">66.02</real> <real xml:lang="zh_TW">53.72</real> <real xml:lang="zh_TW">81.21</real> <real xml:lang="zh_TW">87.03</real> <real xml:lang="zh_TW">91.05</real> <real xml:lang="zh_TW">65.4</real> <real xml:lang="zh_TW">58.23</real> <real xml:lang="zh_TW">92.25</real> <real xml:lang="zh_TW">85.09</real> <real xml:lang="zh_TW">58.76</real> <real xml:lang="zh_TW">90.65</real> <real xml:lang="zh_TW">62.66</real> <real xml:lang="zh_TW">70.49</real> <real xml:lang="zh_TW">110.5</real> <real xml:lang="zh_TW">97.78</real> <real xml:lang="zh_TW">89.57</real> <real xml:lang="zh_TW">91.31</real> <real xml:lang="zh_TW">93.56</real> <real xml:lang="zh_TW">106</real> <real xml:lang="zh_TW">102.6</real> <real xml:lang="zh_TW">66.37</real> <real xml:lang="zh_TW">73.44</real> <real xml:lang="zh_TW">124.1</real> <real xml:lang="zh_TW">118.3</real> <real xml:lang="zh_TW">95.47</real> <real xml:lang="zh_TW">108.6</real> <real xml:lang="zh_TW">137.9</real> <real xml:lang="zh_TW">85.36</real> <real xml:lang="zh_TW">83.35</real> <real xml:lang="zh_TW">143.5</real> <real xml:lang="zh_TW">78.03</real> <real xml:lang="zh_TW">81.14</real> <real xml:lang="zh_TW">87.87</real> <real xml:lang="zh_TW">144.7</real> <real xml:lang="zh_TW">135.6</real> <real xml:lang="zh_TW">82.15</real> <real xml:lang="zh_TW">137.9</real> <real xml:lang="zh_TW">100.4</real> <real xml:lang="zh_TW">97.68</real> <real xml:lang="zh_TW">113</real> <real xml:lang="zh_TW">116.5</real> <real xml:lang="zh_TW">154.4</real> <real xml:lang="zh_TW">132.8</real> <real xml:lang="zh_TW">157.6</real> <real xml:lang="zh_TW">102.6</real> <real xml:lang="zh_TW">126.4</real> <real xml:lang="zh_TW">104.2</real> <real xml:lang="zh_TW">98.96</real> <real xml:lang="zh_TW">146.2</real> <real xml:lang="zh_TW">145.4</real> <real xml:lang="zh_TW">125</real> <real xml:lang="zh_TW">173</real> <real xml:lang="zh_TW">125</real> <real xml:lang="zh_TW">184.9</real> <real xml:lang="zh_TW">172.1</real> <real xml:lang="zh_TW">136.4</real> <real xml:lang="zh_TW">124.6</real> </matrix> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
2.
利用以上數據集計算最佳擬合直線的斜率與截距。
<region id="ID0ENTLGB" top="1017.6000000000001" left="19.200000000000003" xml:lang="zh_TW" height="27.752000000000002" width="69.24666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="70" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">X</id> <apply xml:lang="zh_TW"> <matcol xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Dr</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EGULGB" top="1017.6000000000001" left="192.00000000000003" xml:lang="zh_TW" height="27.752000000000002" width="68.613333333333344" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="72" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">Y</id> <apply xml:lang="zh_TW"> <matcol xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Dr</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EBVLGB" top="1036.8000000000002" left="19.200000000000003" xml:lang="zh_TW" height="25.6" width="118.24333333333334" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="74" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">m</id> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">slope</id> <sequence xml:lang="zh_TW"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Y</id> </sequence> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EZVLGB" top="1036.8000000000002" left="192.00000000000003" xml:lang="zh_TW" height="25.6" width="139.07" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="76" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">b</id> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">intercept</id> <sequence xml:lang="zh_TW"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Y</id> </sequence> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
3.
計算斜率的標準誤差。
<region id="ID0EOXLGB" top="1113.6000000000001" left="19.200000000000003" xml:lang="zh_TW" height="25.6" width="108.87666666666667" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="78" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">Nr</id> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">rows</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Dr</id> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EAYLGB" top="1171.2000000000003" left="19.200000000000003" xml:lang="zh_TW" height="74.465333527326592" width="286.21528235077858" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="80" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">SE_slope</id> <apply xml:lang="zh_TW"> <nthRoot xml:lang="zh_TW" /> <placeholder xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <summation xml:lang="zh_TW" /> <lambda xml:lang="zh_TW"> <boundVars xml:lang="zh_TW"> <id xml:space="preserve" xml:lang="zh_TW">i</id> </boundVars> <apply xml:lang="zh_TW"> <pow xml:lang="zh_TW" /> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Y</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id xml:space="preserve" xml:lang="zh_TW">i</id> <real xml:lang="zh_TW">1</real> </apply> </apply> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <plus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id xml:space="preserve" xml:lang="zh_TW">i</id> <real xml:lang="zh_TW">1</real> </apply> </apply> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">b</id> </apply> </parens> </apply> </parens> <real xml:lang="zh_TW">2</real> </apply> </lambda> <lowerBound xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> </lowerBound> <upperBound xml:lang="zh_TW"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> </upperBound> </apply> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> <real xml:lang="zh_TW">2</real> </apply> </parens> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> </apply> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> </apply> </apply> </apply> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ESYLGB" top="1171.2000000000003" left="307.20000000000005" xml:lang="zh_TW" height="25.6" width="130.57666666666668" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="82" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">SE_slope</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
4.
計算截距的標準誤差。
<region id="ID0EH1LGB" top="1305.6000000000001" left="38.400000000000006" xml:lang="zh_TW" height="74.465333527326592" width="442.34861568411196" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="84" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="*" xml:space="preserve" xml:lang="zh_TW">SE_intercept</id> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <real xml:lang="zh_TW">1</real> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> </apply> <apply xml:lang="zh_TW"> <nthRoot xml:lang="zh_TW" /> <placeholder xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <div xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <summation xml:lang="zh_TW" /> <lambda xml:lang="zh_TW"> <boundVars xml:lang="zh_TW"> <id xml:space="preserve" xml:lang="zh_TW">i</id> </boundVars> <apply xml:lang="zh_TW"> <pow xml:lang="zh_TW" /> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Y</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id xml:space="preserve" xml:lang="zh_TW">i</id> <real xml:lang="zh_TW">1</real> </apply> </apply> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <plus xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id xml:space="preserve" xml:lang="zh_TW">i</id> <real xml:lang="zh_TW">1</real> </apply> </apply> </apply> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">b</id> </apply> </parens> </apply> </parens> <real xml:lang="zh_TW">2</real> </apply> </lambda> <lowerBound xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> </lowerBound> <upperBound xml:lang="zh_TW"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> </upperBound> </apply> </parens> <apply xml:lang="zh_TW"> <summation xml:lang="zh_TW" /> <lambda xml:lang="zh_TW"> <boundVars xml:lang="zh_TW"> <id xml:space="preserve" xml:lang="zh_TW">i</id> </boundVars> <apply xml:lang="zh_TW"> <pow xml:lang="zh_TW" /> <parens xml:lang="zh_TW"> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> <apply xml:lang="zh_TW"> <minus xml:lang="zh_TW" /> <id xml:space="preserve" xml:lang="zh_TW">i</id> <real xml:lang="zh_TW">1</real> </apply> </apply> </parens> <real xml:lang="zh_TW">2</real> </apply> </lambda> <lowerBound xml:lang="zh_TW"> <real xml:lang="zh_TW">1</real> </lowerBound> <upperBound xml:lang="zh_TW"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Nr</id> </upperBound> </apply> </apply> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">var</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">X</id> </apply> </apply> </apply> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EZ1LGB" top="1382.4" left="38.400000000000006" xml:lang="zh_TW" height="25.6" width="167.14333333333335" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="86" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">SE_intercept</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
複製運算式
