搜索
人大经济论坛 附件下载

附件下载

所在主题:
文件名:  87482.rar
资料下载链接地址: https://bbs.pinggu.org/a-87482.html
本附件包括:
  • excel一元及多元线性回归实例.doc
附件大小:
15.09 KB   举报本内容
<br /><br /> <p>呵呵,不要钱了</p>
<p>&nbsp;</p><br>
<p align="right"><font color="#000066">[此贴子已经被作者于2007-1-26 21:41:46编辑过]</font></p>
<p align="left"><font color="#000066">Brief introduction for the file:</font></p>
<p align="right"><font color="#000066"></font>&nbsp;</p>
<p style="TEXT-ALIGN: center; MARGIN: auto 0in" class="song14" align="center"><font color="#000000"><strong><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥; mso-bidi-font-family: 宋体" lang="ZH-CN">野外实习资料的数理统计分析</span></strong></font></p>
<p style="TEXT-ALIGN: center; MARGIN: auto 0in" class="song14" align="center"><font color="#000000"><strong><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥; mso-bidi-font-family: 宋体" lang="ZH-CN"></span></strong></font>&nbsp;</p>
<p style="TEXT-ALIGN: center; MARGIN: auto 0in" class="song14" align="left"><font color="#000000"><strong><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥; mso-bidi-font-family: 宋体" lang="ZH-CN"></span></strong></font><font color="#000000"><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">一元线性回归分析</span><span style="FONT-FAMILY: 'ˎ̥','serif'; FONT-SIZE: 12pt"><font face="PMingLiu"> <!--?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /--><o:p></o:p></font></span></font></p>
<p style="MARGIN: auto 0in" class="song12"><font color="#000000"><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">一元回归处理的是两个变量之间的关系,即两个变量</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">和</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">之间如果存在一定的关系,则通过观测所得数据,找出两者之间的关系式。如果两个变量的关系大致是线性的,那就是一元线性回归问题。</span><span style="FONT-SIZE: 12pt"><o:p></o:p></span></font></p>
<p style="MARGIN: auto 0in" class="song12"><font color="#000000"><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">对两个现象</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">和</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">进行观察或实验,得到两组数值:</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X1</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X2,…</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Xn</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">和</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y1</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y2</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">…</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Yn,</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">假如要找出一个函数</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y=f(X),</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">使它在</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X=X1,X2, …,Xn</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">时的数值</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">f(X1),f(X2), …,f(Xn)</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">与观察值</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y1</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y2</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">…</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Yn</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">趋于接近。</span><span style="FONT-SIZE: 12pt"><o:p></o:p></span></font></p>
<p style="MARGIN: auto 0in" class="song12"><font color="#000000"><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">在一个平面直角坐标</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">XOY</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">中找出(</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X1</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y1</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">),(</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X2</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y2</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">),</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">…</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,(</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Xn</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Yn</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">)各点,将其各点分布状况进行察看,即可以清楚地看出其各点分布状况接近一条直线。对于这种线性关系,可以用数学公式表示:</span><span style="FONT-SIZE: 12pt"><o:p></o:p></span></font></p>
<p style="MARGIN: auto 0in; mso-outline-level: 1" class="song12"><span style="FONT-SIZE: 12pt"><font face="PMingLiu"><font color="#000000">Y = a + bX<o:p></o:p></font></font></span></p>
<p style="MARGIN: auto 0in" class="song12"><font color="#000000"><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">这条直线所表示的关系,叫做变量</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">对</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">的回归直线,也叫</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">对</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">的回归方程。其中</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">a</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">为常数,</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">b</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">为</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">Y</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">对于</span><span style="FONT-SIZE: 12pt"><font face="PMingLiu">X</font></span><span style="FONT-FAMILY: 宋体; FONT-SIZE: 12pt; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥" lang="ZH-CN">的回归系数。</span></font><span style="FONT-SIZE: 12pt"><o:p></o:p></span></p>
<p align="right">&nbsp;</p>


    熟悉论坛请点击新手指南
下载说明
1、论坛支持迅雷和网际快车等p2p多线程软件下载,请在上面选择下载通道单击右健下载即可。
2、论坛会定期自动批量更新下载地址,所以请不要浪费时间盗链论坛资源,盗链地址会很快失效。
3、本站为非盈利性质的学术交流网站,鼓励和保护原创作品,拒绝未经版权人许可的上传行为。本站如接到版权人发出的合格侵权通知,将积极的采取必要措施;同时,本站也将在技术手段和能力范围内,履行版权保护的注意义务。
(如有侵权,欢迎举报)
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

GMT+8, 2026-1-8 06:02