紧急求救数据拟合问题？

weiwei43

我做二维拟合，这个软件确实不错，能拟合出我的曲线吗？
我的数据如下。（第一、二列分别是x1，X2，第三列是y）
  -2.53604E-5 -0.83585 1460
  1.93322E-5 -0.83595 1900
  1.93322E-5 -0.83595 2570
  1.93322E-5 -0.83595 3240
  4.16786E-5 -0.83595 3680
  4.16786E-5 -0.83585 4120
  1.93322E-5 -0.83585 6560
  -3.0141E-6 -0.83575 15200
  4.16786E-5 -0.83565 29200
  9.37697E-5 -0.83555 42100
  1.61726E-4 -0.83545 49800
  1.18806E-4 -0.83535 63600
  1.08076E-4 -0.83515 83176.42458
  -5.28724E-5 -0.83485 97892.76269
-2.26477E-4 -0.83445 112740.49667
  -3.60555E-4 -0.83385 123383.56262
     -4.05248E-4 -0.83285 132844.065
     -6.28711E-4 -0.83145 139000
  -0.00101 -0.82955 149000
  -0.0017 -0.82715 164000
  -0.00286 -0.82405 182000
  -0.00443 -0.82045 205000
  -0.00601 -0.81635 232000
  -0.00731 -0.81175 258000
  -0.00836 -0.80675 281000
  -0.00952 -0.80135 300000
  -0.01086 -0.79565 316000
  -0.01198 -0.78945 332000
  -0.01438 -0.78265 349000
  -0.01634 -0.77525 374000
-0.01907 -0.76705 403000
  -0.02119 -0.75795 433000
  -0.02365 -0.74785 461000
     -0.02653 -0.73705 480000
  -0.02773 -0.72525 493000
  -0.02919 -0.71275 513000
  -0.03055 -0.69945 535000
  -0.03174 -0.68525 556769.04603
  -0.0326 -0.67025 586848.23048
  -0.03381 -0.65425 619935.33338
  -0.03451 -0.63725 651819.2689
  -0.03587 -0.61925 708969.71936
  -0.03677 -0.60025 774000
  -0.03738 -0.58035 815000
  -0.03797 -0.55985 825000
  -0.03838 -0.53865 844000
  -0.0388 -0.51675 882000
-0.03918 -0.49365 922000
  -0.03945 -0.46885 945000
     -0.03938 -0.44165 953000
     -0.03927 -0.41125 955000
  -0.03915 -0.37725 947000
  -0.03896 -0.33945 924000
  -0.03878 -0.29795 885000
  -0.03859 -0.25335 837000
  -0.03845 -0.20675 785000
  -0.03827 -0.15915 726000
  -0.03815 -0.11205 660000
  -0.03801 -0.06705 589000
  -0.03781 -0.02525 518000
  -0.0377 0.01195 448000
  -0.03754 0.02561 381000
  -0.03737 0.04146 319000
-0.03719 0.05253 262000
  -0.03703 0.05706 214000
  -0.03685 0.06033 173000
     -0.03679 0.06385 137000
-0.03664 0.06713 106000
-0.03654 0.06939 81600
-0.03647 0.07367 64500
  -0.03634 0.07669 46814.89592
-0.03629 0.07643 33806.70421
-0.03613 0.07719 22506.65887
-0.03591 0.07922 15805.4692
-0.03576 0.07994 10024.05066
  -0.03567 0.07964 7921.71664
-0.0356 0.08084 4899.6115
-0.03545 0.08066 1220.52697
-0.03518 0.08168 -1013.20292
-0.03492 0.0821 -619.01529
-0.03455 0.08198 -2984.14106
-0.03426 0.08192 -3772.51631
-0.03382 0.0824 -3772.51631
    -0.03339 0.08725 -2984.14106
-0.03271 0.08826 -2195.7658
-0.03227 0.08775 -2984.14106
-0.0315 0.08901 -2195.7658
-0.03088 0.08826 -2195.7658
-0.03035 0.08876 -2195.7658
-0.02977 0.09027 -619.01529
  -0.02902 0.08977 300.75584
-0.0285 0.09128 300.75584
-0.02786 0.09354 169.35996
-0.02713 0.09606 169.35996
-0.02639 0.09275 957.73522
  -0.02597 0.09832 957.73522
-0.02548 0.09795 1746.11048
-0.02485 0.10045 2534.48573
-0.02429 0.10265 2534.48573
-0.02369 0.10465 2638.96687
  -0.02344 0.10645 2665.88161
  -0.02281 0.10795 3454.25686
-0.02211 0.10935 4111.23624
-0.02128 0.11045 4899.6115
-0.02062 0.11125 4899.6115
-0.02024 0.11195 5687.98675
-0.01962 0.11245 5819.38263
-0.01893 0.11285 7264.73726
-0.01828 0.11325 5687.98675
-0.0173 0.11365 4899.6115
-0.01681 0.1187 5819.38263
-0.01624 0.11945 6607.75789
-0.01573 0.12046 6607.75789
-0.01468 0.12046 5031.00737
-0.0137 0.12222 2638.96687
-0.01292 0.12449 11285.7945
-0.01227 0.12405 11285.7945
   -0.01153 0.12695 5783.26783
   -0.01068 0.13015 5783.26783
   -0.00975 0.13355 10499.71926
-0.00879 0.13695 13644.02021
-0.00789 0.14035 8927.56878
-0.00718 0.14365 8141.49354
-0.00635 0.14675 2638.96687
-0.00532 0.14975 10499.71926
-0.00427 0.15265 5783.26783
-0.00347 0.15535 6569.34307
-0.0028 0.15805 16002.24593
-0.00192 0.16075 15216.17069
-6.51058E-4 0.16355 12857.94497
-1.11055E-5 0.16635 10499.71926
1.82196E-5 0.16935 15216.17069
-5.24046E-6 0.17235 14430.09545
-5.24046E-6 0.17555 13644.02021
2.40846E-5 0.17885 11400
6.48955E-6 0.18215 11285.7945
1.82196E-5 0.18535 8927.56878
-5.24046E-6 0.18845 16788.32117
-5.24046E-6 0.19135 17574.39641
6.48955E-6 0.19375 12071.86974
-5.24046E-6 0.19585 12857.94497
1.82196E-5 0.19755 16788.32117
1.23546E-5 0.19875 -505.33408
6.24547E-7 0.19975 -4435.71028
-5.24046E-6 0.20075 10499.71926
6.24547E-7 0.20175 16002.24593
6.24547E-7 0.20305 19146.54688
6.48955E-6 0.20455 16002.24593
2.40846E-5 0.20645 18360.47165
6.48955E-6 0.20855 16788.32117
2.40846E-5 0.21105 19146.54688
1.23546E-5 0.21375 16002.24593
-5.24046E-6 0.21665 7355.4183
6.48955E-6 0.21995 7355.4183
-5.24046E-6 0.22345 12071.86974
6.48955E-6 0.22715 10499.71926
1.82196E-5 0.23105 9713.64402
2.40846E-5 0.23495 5783.26783
6.48955E-6 0.23895 10499.71926
1.23546E-5 0.24275 8927.56878
6.24547E-7 0.24645 905.71731
6.24547E-7 0.24995 2638.96687
2.40846E-5 0.25335 -982
1.23546E-5 0.25645 -6980
  -5.24046E-6 0.25935 -3650
  1.82196E-5 0.26205 1020
  -5.24046E-6 0.26455 2350
  -5.24046E-6 0.26665 1680
  1.23546E-5 0.26835 794
  6.24547E-7 0.26965 794
  2.40846E-5 0.27055 1020
  1.82196E-5 0.27095 350
  -5.24046E-6 0.27115 -1200
  1.23546E-5 0.27095 -2980
  2.40846E-5 0.27055 -2760
  5.34096E-5 0.27015 -1870
  4.16796E-5 0.26965 -1200
  3.58146E-5 0.26925 -1870
1.0033E-4 0.26895 -2540
  8.27346E-5 0.26875 -2760
  8.85996E-5 0.26875 -2760
  4.16796E-5 0.26865 -2760
  8.27346E-5 0.26865 -3200
  1.23546E-5 0.26865 -3650
  3.58146E-5 0.26855 -3200
  85996E-5 0.26845 -1870
  1.1206E-4 0.26815 -982
  1.2379E-4 0.26775 -760

[ 本帖最后由 无水1324 于 2008-8-16 12:19 编辑 ]

dingd

如果不知道现成的模型公式，同时也没有什么物理含义限制的话：
1：可以用1stOpt的公式自动搜索功能
2：下面这个公式如何，如有时间，还能找到更好的：
z=p1*x+p2*y+z0+A/((1+((x-xc)/w1)^2)*(1+((y-yc)/w2)^2));
均方差(RMSE): 41689.2964831561
残差平方和(SSE): 326743518956.972
相关系数(R): 0.987719683252206
相关系数之平方(R^2): 0.975590172683839
决定系数(DC): 0.97559017268384
卡方系数(Chi-Square): 2931577.25593557
F统计(F-Statistic): 1053.43988637157
参数 最佳估算
---------- -------------
p1          -6884304.52573399
p2          4389689.30742042
z0          4947120.43383241
a           -6871662.07437862
xc          -0.0499249243189326
w1          0.16469531917366
yc          0.36469263249171
w2          -0.578096325490525

weiwei43

非常感谢！
怎么使用自动搜索功能？这个我一直没有弄懂。能贴图介绍一下吗。

zzlglw

其实你可以用MATLAB编一下 很快的