Теория систем и системный анализ (1088583), страница 7
Текст из файла (страница 7)
F | G | |
26 | x | y=a1+a2*x+a3*x^2 |
27 | 20 | =$C$28*(H27^2)+$C$27*H27+$C$26 |
28 | 21 | =$C$28*(H28^2)+$C$27*H28+$C$26 |
29 | 22 | |
30 | 23 | |
31 | 24 | |
32 | 25 | |
33 | 26 | |
34 | 27 | |
35 | 28 | |
36 | 29 | |
37 | 30 | |
38 | 31 | |
39 | 32 | |
40 | 33 | |
41 | 34 | |
42 | 35 | |
43 | 36 | |
44 | 37 | |
45 | 38 | |
46 | 39 |
Построим график
2.4.4. Кубическая модель.
По значениям в таблице ищем A1, A2, A3 и A4:
Кубическая |
|
|
| a1 = | 36,69551392 |
| a2 = | -7,365680765 |
| a3 = | 0,441764789 |
| a4 = | -0,005235723 |
| 1355 | 1355 |
| 42931 | 42931 |
| 1399331 | 1399331 |
| 46719073 | 46719073 |
X | y=a1+a2*x+a3*x^2+a4*x^3 |
20 | 24,20203331 |
21 | 28,34646267 |
22 | 32,71472057 |
23 | 37,27539266 |
24 | 41,9970646 |
25 | 46,84832207 |
26 | 51,79775072 |
27 | 56,81393622 |
28 | 61,86546423 |
29 | 66,92092043 |
30 | 71,94889046 |
31 | 76,91796001 |
32 | 81,79671472 |
33 | 86,55374027 |
34 | 91,15762232 |
35 | 95,57694654 |
36 | 99,78029858 |
37 | 103,7362641 |
38 | 107,4134288 |
39 | 110,7803783 |
A | B | C | ||
25 | Кубическая
|
| ||
26 |
| a1 = | 36,69551392 | |
27 |
| a2 = | -7,365680765 | |
28 | a3 = | 0,441764789 | ||
29 | a4 = | -0,005235723 | ||
30 |
| =20*C26+C27*A22+ C28*C22+C29*E22 | =B22 | |
31 | =C26*A22+C27*C22+ C28*E22+C29*F22 | =D22 | ||
32 | =C26*C22+C27*E22+ C28*F22+C29*G22 | =I22 | ||
33 |
| =C26*E22+C27*F22+ C28*G22+C29*H22 | =J22 |
F | G | |
26 | x | y=a1+a2*x+a3*x^2+a4*x^3 |
27 | 20 | =$C$26+$C$27*G26+$C$28*G26^2+$C$29*G26^3 |
28 | 21 | =$C$26+$C$27*G27+$C$28*G27^2+$C$29*G27^3 |
29 | 22 | |
30 | 23 | |
31 | 24 | |
32 | 25 | |
33 | 26 | |
34 | 27 | |
35 | 28 | |
36 | 29 | |
37 | 30 | |
38 | 31 | |
39 | 32 | |
40 | 33 | |
41 | 34 | |
42 | 35 | |
43 | 36 | |
44 | 37 | |
45 | 38 | |
46 | 39 |
Построим график
2.4.5. Гипербалическая модель.
По значениям в таблице ищем A1 и A2:
Гипербалическая
|
| ||
| a1 = | 199,889847415494 | |
| a2 = | -3714,38040886779 | |
| 1355 | 1355 | |
| 44,19096899 | 44,19096899 |
x | y=a1+a2*(1/x) |
20 | 14,17082697 |
21 | 23,01458985 |
22 | 31,05437429 |
23 | 38,39504703 |
24 | 45,12399705 |
25 | 51,31463106 |
26 | 57,02906246 |
27 | 62,32020264 |
28 | 67,23340424 |
29 | 71,80776435 |
30 | 76,07716712 |
31 | 80,07112455 |
32 | 83,81545964 |
33 | 87,33286533 |
34 | 90,6433648 |
35 | 93,76469288 |
36 | 96,71261384 |
37 | 99,50118772 |
38 | 102,1429946 |
39 | 104,6493241 |
A | B | C | ||
26 | Гипербалическая |
| ||
27 |
| a1 = | 199,889847415494 | |
28 |
| a2 = | -3714,38040886779 | |
29 |
| =20*C27+C28*M22 | =B22 | |
30 |
| =C27*M22+C28*N22 | =O22 |
F | G | |
26 | x | y=a1*x^a2 |
27 | 20 | =$C$27+$C$28*(1/E26) |
28 | 21 | =$C$27+$C$28*(1/E27) |
29 | 22 | |
30 | 23 | |
31 | 24 | |
32 | 25 | |
33 | 26 | |
34 | 27 | |
35 | 28 | |
36 | 29 | |
37 | 30 | |
38 | 31 | |
39 | 32 | |
40 | 33 | |
41 | 34 | |
42 | 35 | |
43 | 36 | |
44 | 37 | |
45 | 38 | |
46 | 39 |