求助怎么拟合啊
1E7 6.55602
8.91251E6 6.44001
7.94328E6 6.27651
7.07946E6 5.99227
6.30957E6 5.67849
5.62341E6 5.61973
5.01187E6 5.51215
4.46684E6 5.30786
3.98107E6 5.27881
3.54813E6 5.29654
3.16228E6 5.64984
2.81838E6 5.80062
2.51189E6 6.05543
2.23872E6 6.88391
1.99526E6 7.21995
1.77828E6 7.65759
1.58489E6 8.14837
1.41254E6 8.68784
1.25892E6 9.28022
1.12202E6 9.9292
1000000 10.6
891251 11.3532
794328 12.1158
707946 12.9182
630957 13.7587
562341 14.6327
501187 15.5415
446684 16.4784
398107 17.4437
354813 18.432
316228 19.4457
281838 20.4827
251189 21.54
223872 22.6133
199526 23.705
177828 24.8007
158489 25.9077
141254 27.0253
125892 28.1482
112202 29.2767
100000 30.4082
89125.1 31.5443
79432.8 32.683
70794.6 33.8223
63095.7 34.963
56234.1 36.106
50118.7 37.2555
44668.4 38.409
39810.7 39.5715
35481.3 40.7453
31622.8 41.9341
28183.8 43.1401
25118.9 44.3921
22387.2 45.655
19952.6 46.958
17782.8 48.3082
15848.9 49.7156
14125.4 51.1922
12589.2 52.7493
11220.2 54.4027
10000 56.1641
8912.51 58.0524
7943.28 60.088
7079.46 62.3364
6309.57 64.7172
5623.41 67.3031
5011.87 70.1115
4466.84 73.1755
3981.07 76.5089
3548.13 80.1494
3162.28 84.123
2818.38 88.4596
2511.89 93.1328
2238.72 98.3022
1995.26 103.964
1778.28 110.145
1584.89 116.912
1412.54 124.313
1258.93 132.484
1122.02 141.359
1000 151.093
891.251 161.775
794.328 173.492
707.946 186.258
630.957 200.424
562.341 216.012
501.187 233.197
446.684 252.15
398.107 273.178
354.813 296.32
316.228 321.927
281.838 350.261
251.189 381.556
223.872 416.353
199.526 455.097
177.828 497.984
158.489 545.739
141.254 598.191
125.893 657.074
112.202 722.849
100 796.289
89.1251 877.792
79.4328 968.514
70.7946 1069.98
63.0957 1184.47
56.2341 1307.74
50.1187 1448.32
44.6684 1600.98
39.8107 1776.33
35.4813 1970.58
31.6228 2179.48
28.1838 2421.08
25.1189 2685.38
22.3872 2971.28
19.9526 3299.6
17.7828 3655.74
15.8489 4053.92
14.1254 4482.58
12.5892 4963.73
11.2202 5499.55
10 6064.62
7.94328 7422.04
6.30957 9087.78
5.01187 11151.3
3.98107 13713.1
3.16228 16919.6
2.51189 20940.5
1.99526 25992.9
1.58489 32352.5
1.25892 40356.1
1 50452.8
0.79433 63197.3
0.63096 79263.4
0.50119 99548
0.39811 125116
0.31623 157315
0.25119 197955
0.19953 249124
0.15849 313577
0.12589 394733
0.1 497216
y=B*cos((1-D)*pi/2)*(2*pi*x*C)^D/(1+2*sin((1-D)*pi/2)*(2*pi*x*C)^D+(2*pi*x*C)^(2*D))+F/(8.854e-12*(2*pi*x)^G)
用这个方程怎么拟合啊@月只蓝@月只蓝 返回小木虫查看更多
参考 :
http://blog.sina.com.cn/s/blog_c0cb8ce60102z6um.html
origin也一样吗
求助
批注 2020-01-10 190438.png
用matlab的 nlinfit函数拟合,可以得到
B=-40740064.8226 C=-774756686.9509 D=-43479037.648 F=2.7888e-06 G=0.94475
123.jpg
1stOpt计算,不需初值,结果稳定唯一:
Root of Mean Square Error (RMSE): 26.7060662365447
Sum of Squared Residual: 100563.17031013
Correlation Coef. (R): 0.999999943393601
R-Square: 0.999999886787206
Adjusted R-Square: 0.999999885146441
Determination Coef. (DC): 0.999999839657384
Chi-Square: 1162.8630969381
F-Statistic: 212069300.445705
Parameter Best Estimate
---------- -------------
b 4257.68720024953
d 0.71356422250504
c 0.0444921399025092
f 2.76150737591064E-6
g 1.00213441592028
楼上Matlab结果似乎是一个局部最优解。
y=B*cos((1-D)*pi/2)*(2*pi*x*C)^D/(1+2*sin((1-D)*pi/2)*(2*pi*x*C)^D+(2*pi*x*C)^(2*D))+F/(8.854e-12*(2*pi*x)^G)
Where B=εs-ε∞, C=τ, D=1-α, F=σ1, G=s
用 的origin拟合,好难啊,还是拟合不出来
TIM图片20200111103409.png
,