一个比较棘手的非线性拟和
<p>请教高手：帮我拟和一个方程，致谢！</p><p>X= Y=</p><p><table cellspacing="0" cellpadding="0" width="170" border="0" xstr="" style="WIDTH: 128pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col width="98" style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" width="72" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">180.71 </font></td><td align="right" width="98" xnum="1.2102876003359097E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 74pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.001210288</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">189.24</font></td><td align="right" xnum="1.3573426674764102E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体"> 0.001357343</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">195.95</font></td><td align="right" xnum="1.7246602354323529E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.00172466</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">201.2</font></td><td align="right" xnum="2.1656126347544412E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.002165613</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">205.31</font></td><td align="right" xnum="2.6802880879748269E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.002680288</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">208.78</font></td><td align="right" xnum="3.171762256410009E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.003171762</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">211.67</font></td><td align="right" xnum="4.5188451041411884E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.004518845</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">213.47</font></td><td align="right" xnum="5.3287159387116643E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.005328716</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">215.47</font></td><td align="right" xnum="6.2127241449195401E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.006212724</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">216.82</font></td><td align="right" xnum="8.0533673451164203E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.008053367</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">217.98</font></td><td align="right" xnum="9.3067371464824553E-3" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.009306737</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">219</font></td><td align="right" xnum="1.1075888551665901E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.011075889</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">219.82</font></td><td align="right" xnum="1.3877133670776684E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.013877134</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">220.47</font></td><td align="right" xnum="2.3529464564057682E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.023529465</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">220.79</font></td><td align="right" xnum="2.8400192138260491E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.028400192</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">221.19</font></td><td align="right" xnum="3.2021165628706695E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.032021166</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">221.45</font></td><td align="right" xnum="5.0979672509982622E-2" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.050979673</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">221.61</font></td><td align="right" xnum="0.1326413360829054" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.132641336</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" align="right" height="19" xnum="" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">221.66</font></td><td align="right" xnum="0.20219272877593547" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: transparent;"><font face="宋体">0.202192729</font></td></tr></tbody></table></p><p> </p>[此贴子已经被作者于2006-6-26 11:10:24编辑过] 不能使用最小二乘法吗？ <p>建议一个思路：</p><p>Y=A/（B-X）^n</p><p>Ln(Y)=Ln(A)-n*Ln(B-X)</p><p>然后再用最小二乘法</p>
页:
[1]