| |
A |
B |
C |
D |
E |
F |
| 0 |
"X" |
"Y" |
"Est" |
"Err" |
"maxErr" |
"Coef" |
| 1 |
0 |
((2*exp((0.5*A1)))+(4*drand()))-2 |
$F$1*exp(($F$2*A1)) |
fabs((B1-C1)) |
max(D1:D11) |
($1) |
| 2 |
0.4 |
((2*exp((0.5*A2)))+(4*drand()))-2 |
$F$1*exp(($F$2*A2)) |
fabs((B2-C2)) |
|
($1) |
| 3 |
0.8 |
((2*exp((0.5*A3)))+(4*drand()))-2 |
$F$1*exp(($F$2*A3)) |
fabs((B3-C3)) |
|
|
| 4 |
1.2 |
((2*exp((0.5*A4)))+(4*drand()))-2 |
$F$1*exp(($F$2*A4)) |
fabs((B4-C4)) |
|
|
| 5 |
1.6 |
((2*exp((0.5*A5)))+(4*drand()))-2 |
$F$1*exp(($F$2*A5)) |
fabs((B5-C5)) |
|
|
| 6 |
2 |
((2*exp((0.5*A6)))+(4*drand()))-2 |
$F$1*exp(($F$2*A6)) |
fabs((B6-C6)) |
|
|
| 7 |
2.4 |
((2*exp((0.5*A7)))+(4*drand()))-2 |
$F$1*exp(($F$2*A7)) |
fabs((B7-C7)) |
|
|
| 8 |
2.8 |
((2*exp((0.5*A8)))+(4*drand()))-2 |
$F$1*exp(($F$2*A8)) |
fabs((B8-C8)) |
|
|
| 9 |
3.2 |
((2*exp((0.5*A9)))+(4*drand()))-2 |
$F$1*exp(($F$2*A9)) |
fabs((B9-C9)) |
|
|
| 10 |
3.6 |
((2*exp((0.5*A10)))+(4*drand()))-2 |
$F$1*exp(($F$2*A10)) |
fabs((B10-C10)) |
|
|
| 11 |
4 |
((2*exp((0.5*A11)))+(4*drand()))-2 |
$F$1*exp(($F$2*A11)) |
fabs((B11-C11)) |
|
|
| |
A |
B |
C |
D |
E |
F |
| 0 |
X |
Y |
Est |
Err |
maxErr |
Coef |
| 1 |
0.00 |
0.713581 |
1.190612 |
0.477031 |
0.515320 |
1.190684 |
| 2 |
0.40 |
2.041515 |
1.526125 |
0.515390 |
|
0.620625 |
| 3 |
0.80 |
1.650045 |
1.956185 |
0.306140 |
|
|
| 4 |
1.20 |
2.492725 |
2.507435 |
0.014710 |
|
|
| 5 |
1.60 |
2.698825 |
3.214027 |
0.515202 |
|
|
| 6 |
2.00 |
3.653163 |
4.119736 |
0.466573 |
|
|
| 7 |
2.40 |
5.742896 |
5.280671 |
0.462224 |
|
|
| 8 |
2.80 |
6.301429 |
6.768757 |
0.467328 |
|
|
| 9 |
3.20 |
9.190198 |
8.676184 |
0.514014 |
|
|
| 10 |
3.60 |
11.190230 |
11.121121 |
0.069109 |
|
|
| 11 |
4.00 |
14.249060 |
14.255037 |
0.005978 |
|
|