[算表]求救 在規劃求解卡關很久了
軟體:excel
版本:2007
要求算model price
假設模型為:PV(t)= at^3+ bt^2+ ct+1
已找出t chart 如下
T chart
Coupon# A97101 A97102 A97103 A97104 A97105 A97106
1 0.0767 0.1562 0.2329 0.5836 0.6521 0.7644
2 1.0767 1.1562 1.2329 1.5836 1.6521 1.7644
3 2.0767 2.1562 2.2329 2.5836 2.6521 2.7644
4 3.0767 3.1562 3.2329 3.5836 3.6521 3.7644
5 4.0767 4.1562 4.2329 4.5836 4.6521 4.7644
6 5.1562 5.2329 5.6521 5.7644
7 6.1562 6.2329 6.6521 6.7644
8 7.1562 7.2329 7.6521 7.7644
9 8.1562 8.2329 8.6521 8.7644
10 9.1562 9.2329 9.6521 9.7644
11 10.1562 10.6521
12 11.1562 11.6521
13 12.1562 12.6521
14 13.1562 13.6521
15 14.1562 14.6521
16 15.1562 15.6521
17 16.1562 16.6521
18 17.1562 17.6521
19 18.1562 18.6521
20 19.1562 19.6521
要求出a, b, c
知道要用規劃求解,也找書並上網查了,但還是無解卡關中,只好上網求救高手了
-謝謝您
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.4.234