| |
A |
B |
C |
D |
E |
| 0 |
"X" |
"Y" |
"Est" |
"Err" |
"Coef" |
| 1 |
0 |
(2+(A1*(-2+A1)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A1) |
B1-C1 |
($1) |
| 2 |
0.2 |
(2+(A2*(-2+A2)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A2) |
B2-C2 |
($1) |
| 3 |
0.4 |
(2+(A3*(-2+A3)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A3) |
B3-C3 |
($1) |
| 4 |
0.6 |
(2+(A4*(-2+A4)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A4) |
B4-C4 |
|
| 5 |
0.8 |
(2+(A5*(-2+A5)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A5) |
B5-C5 |
|
| 6 |
1 |
(2+(A6*(-2+A6)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A6) |
B6-C6 |
|
| 7 |
1.2 |
(2+(A7*(-2+A7)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A7) |
B7-C7 |
|
| 8 |
1.4 |
(2+(A8*(-2+A8)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A8) |
B8-C8 |
|
| 9 |
1.6 |
(2+(A9*(-2+A9)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A9) |
B9-C9 |
|
| 10 |
1.8 |
(2+(A10*(-2+A10)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A10) |
B10-C10 |
|
| 11 |
2 |
(2+(A11*(-2+A11)))+((drand()-0.5)/5) |
feval("poly",$E$1:$E$3,A11) |
B11-C11 |
|
| |
A |
B |
C |
D |
E |
| 0 |
X |
Y |
Est |
Err |
Coef |
| 1 |
0.00 |
2.027030 |
1.993850 |
0.033180 |
1.993850 |
| 2 |
0.20 |
1.556823 |
1.634842 |
-0.078019 |
-1.992933 |
| 3 |
0.40 |
1.337442 |
1.354991 |
-0.017549 |
0.989464 |
| 4 |
0.60 |
1.246677 |
1.154297 |
0.092379 |
|
| 5 |
0.80 |
1.051274 |
1.032760 |
0.018514 |
|
| 6 |
1.00 |
0.927278 |
0.990381 |
-0.063103 |
|
| 7 |
1.20 |
1.055699 |
1.027158 |
0.028541 |
|
| 8 |
1.40 |
1.172817 |
1.143093 |
0.029725 |
|
| 9 |
1.60 |
1.298053 |
1.338184 |
-0.040131 |
|
| 10 |
1.80 |
1.557888 |
1.612433 |
-0.054545 |
|
| 11 |
2.00 |
2.016845 |
1.965839 |
0.051007 |
|