Теория систем и системный анализ (Готовый курсовой проект), страница 5
Описание файла
Файл "Теория систем и системный анализ" внутри архива находится в папке "Готовый курсовой проект". Документ из архива "Готовый курсовой проект", который расположен в категории "". Всё это находится в предмете "теория систем и системный анализ (тсиса)" из 10 семестр (2 семестр магистратуры), которые можно найти в файловом архиве РТУ МИРЭА. Не смотря на прямую связь этого архива с РТУ МИРЭА, его также можно найти и в других разделах. Архив можно найти в разделе "курсовые/домашние работы", в предмете "теория систем и системный анализ (тсиса)" в общих файлах.
Онлайн просмотр документа "Теория систем и системный анализ"
Текст 5 страницы из документа "Теория систем и системный анализ"
Рассчитывали по формулам:
A | B | C | D | E | F | G | H | I | J | K | |
1 | X | Y | X^2 | X*Y | X^3 | X^4 | X^5 | X^6 | X^2*Y | X^3*Y | lnY |
2 | 20 | 28 | =A2^2 | =A2*B2 | =A2^3 | =A2^4 | =A2^5 | =A2^6 | =(A2^2)*B2 | =A2^3*B2 | =LN(B2) |
3 | 21 | 21 | =A3^2 | =A3*B3 | =A3^3 | =A3^4 | =A3^5 | =A3^6 | =(A3^2)*B3 | =A3^3*B3 | =LN(B3) |
4 | 22 | 41 | =A4^2 | =A4*B4 | =A4^3 | =A4^4 | =A4^5 | =A4^6 | =(A4^2)*B4 | =A4^3*B4 | =LN(B4) |
5 | 23 | 27 | =A5^2 | =A5*B5 | =A5^3 | =A5^4 | =A5^5 | =A5^6 | =(A5^2)*B5 | =A5^3*B5 | =LN(B5) |
6 | 24 | 35 | =A6^2 | =A6*B6 | =A6^3 | =A6^4 | =A6^5 | =A6^6 | =(A6^2)*B6 | =A6^3*B6 | =LN(B6) |
7 | 24 | 46 | =A7^2 | =A7*B7 | =A7^3 | =A7^4 | =A7^5 | =A7^6 | =(A7^2)*B7 | =A7^3*B7 | =LN(B7) |
8 | 25 | 56 | =A8^2 | =A8*B8 | =A8^3 | =A8^4 | =A8^5 | =A8^6 | =(A8^2)*B8 | =A8^3*B8 | =LN(B8) |
9 | 27 | 52 | =A9^2 | =A9*B9 | =A9^3 | =A9^4 | =A9^5 | =A9^6 | =(A9^2)*B9 | =A9^3*B9 | =LN(B9) |
10 | 27 | 59 | =A10^2 | =A10*B10 | =A10^3 | =A10^4 | =A10^5 | =A10^6 | =(A10^2)*B10 | =A10^3*B10 | =LN(B10) |
11 | 27 | 63 | =A11^2 | =A11*B11 | =A11^3 | =A11^4 | =A11^5 | =A11^6 | =(A11^2)*B11 | =A11^3*B11 | =LN(B11) |
12 | 32 | 72 | =A12^2 | =A12*B12 | =A12^3 | =A12^4 | =A12^5 | =A12^6 | =(A12^2)*B12 | =A12^3*B12 | =LN(B12) |
13 | 32 | 76 | =A13^2 | =A13*B13 | =A13^3 | =A13^4 | =A13^5 | =A13^6 | =(A13^2)*B13 | =A13^3*B13 | =LN(B13) |
14 | 32 | 88 | =A14^2 | =A14*B14 | =A14^3 | =A14^4 | =A14^5 | =A14^6 | =(A14^2)*B14 | =A14^3*B14 | =LN(B14) |
15 | 33 | 87 | =A15^2 | =A15*B15 | =A15^3 | =A15^4 | =A15^5 | =A15^6 | =(A15^2)*B15 | =A15^3*B15 | =LN(B15) |
16 | 34 | 82 | =A16^2 | =A16*B16 | =A16^3 | =A16^4 | =A16^5 | =A16^6 | =(A16^2)*B16 | =A16^3*B16 | =LN(B16) |
17 | 34 | 100 | =A17^2 | =A17*B17 | =A17^3 | =A17^4 | =A17^5 | =A17^6 | =(A17^2)*B17 | =A17^3*B17 | =LN(B17) |
18 | 35 | 95 | =A18^2 | =A18*B18 | =A18^3 | =A18^4 | =A18^5 | =A18^6 | =(A18^2)*B18 | =A18^3*B18 | =LN(B18) |
19 | 36 | 108 | =A19^2 | =A19*B19 | =A19^3 | =A19^4 | =A19^5 | =A19^6 | =(A19^2)*B19 | =A19^3*B19 | =LN(B19) |
20 | 39 | 106 | =A20^2 | =A20*B20 | =A20^3 | =A20^4 | =A20^5 | =A20^6 | =(A20^2)*B20 | =A20^3*B20 | =LN(B20) |
21 | 39 | 113 | =A21^2 | =A21*B21 | =A21^3 | =A21^4 | =A21^5 | =A21^6 | =(A21^2)*B21 | =A21^3*B21 | =LN(B21) |
22 | =СУММ (A2:A21) | =СУММ (B2:B21) | =СУММ (C2:C21) | =СУММ (D2:D21) | =СУММ (E2:E21) | =СУММ (F2:F21) | =СУММ (G2:G21) | =СУММ (H2:H21) | =СУММ (I2:I21) | =СУММ (J2:J21) | =СУММ (K2:K21) |
L | M | N | O | P | Q | R | S | |
1 | lnX | lnX^2 | lnX*lnY | X*lnY | Y*lnX | 1/X | 1/x^2 | y/x |
2 | =LN(A2) | =LN(A2^2) | =LN(A2)*LN(B2) | =A2*LN(B2) | =B2*LN(A2) | =1/A2 | =1/A2^2 | =B2/A2 |
3 | =LN(A3) | =LN(A3^2) | =LN(A3)*LN(B3) | =A3*LN(B3) | =B3*LN(A3) | =1/A3 | =1/A3^2 | =B3/A3 |
4 | =LN(A4) | =LN(A4^2) | =LN(A4)*LN(B4) | =A4*LN(B4) | =B4*LN(A4) | =1/A4 | =1/A4^2 | =B4/A4 |
5 | =LN(A5) | =LN(A5^2) | =LN(A5)*LN(B5) | =A5*LN(B5) | =B5*LN(A5) | =1/A5 | =1/A5^2 | =B5/A5 |
6 | =LN(A6) | =LN(A6^2) | =LN(A6)*LN(B6) | =A6*LN(B6) | =B6*LN(A6) | =1/A6 | =1/A6^2 | =B6/A6 |
7 | =LN(A7) | =LN(A7^2) | =LN(A7)*LN(B7) | =A7*LN(B7) | =B7*LN(A7) | =1/A7 | =1/A7^2 | =B7/A7 |
8 | =LN(A8) | =LN(A8^2) | =LN(A8)*LN(B8) | =A8*LN(B8) | =B8*LN(A8) | =1/A8 | =1/A8^2 | =B8/A8 |
9 | =LN(A9) | =LN(A9^2) | =LN(A9)*LN(B9) | =A9*LN(B9) | =B9*LN(A9) | =1/A9 | =1/A9^2 | =B9/A9 |
10 | =LN(A10) | =LN(A10^2) | =LN(A10)*LN(B10) | =A10*LN(B10) | =B10*LN(A10) | =1/A10 | =1/A10^2 | =B10/A10 |
11 | =LN(A11) | =LN(A11^2) | =LN(A11)*LN(B11) | =A11*LN(B11) | =B11*LN(A11) | =1/A11 | =1/A11^2 | =B11/A11 |
12 | =LN(A12) | =LN(A12^2) | =LN(A12)*LN(B12) | =A12*LN(B12) | =B12*LN(A12) | =1/A12 | =1/A12^2 | =B12/A12 |
13 | =LN(A13) | =LN(A13^2) | =LN(A13)*LN(B13) | =A13*LN(B13) | =B13*LN(A13) | =1/A13 | =1/A13^2 | =B13/A13 |
14 | =LN(A14) | =LN(A14^2) | =LN(A14)*LN(B14) | =A14*LN(B14) | =B14*LN(A14) | =1/A14 | =1/A14^2 | =B14/A14 |
15 | =LN(A15) | =LN(A15^2) | =LN(A15)*LN(B15) | =A15*LN(B15) | =B15*LN(A15) | =1/A15 | =1/A15^2 | =B15/A15 |
16 | =LN(A16) | =LN(A16^2) | =LN(A16)*LN(B16) | =A16*LN(B16) | =B16*LN(A16) | =1/A16 | =1/A16^2 | =B16/A16 |
17 | =LN(A17) | =LN(A17^2) | =LN(A17)*LN(B17) | =A17*LN(B17) | =B17*LN(A17) | =1/A17 | =1/A17^2 | =B17/A17 |
18 | =LN(A18) | =LN(A18^2) | =LN(A18)*LN(B18) | =A18*LN(B18) | =B18*LN(A18) | =1/A18 | =1/A18^2 | =B18/A18 |
19 | =LN(A19) | =LN(A19^2) | =LN(A19)*LN(B19) | =A19*LN(B19) | =B19*LN(A19) | =1/A19 | =1/A19^2 | =B19/A19 |
20 | =LN(A20) | =LN(A20^2) | =LN(A20)*LN(B20) | =A20*LN(B20) | =B20*LN(A20) | =1/A20 | =1/A20^2 | =B20/A20 |
21 | =LN(A21) | =LN(A21^2) | =LN(A21)*LN(B21) | =A21*LN(B21) | =B21*LN(A21) | =1/A21 | =1/A21^2 | =B21/A21 |
22 | =СУММ(L2:L21) | =СУММ(M2:M21) | =СУММ(N2:N21) | =СУММ(O2:O21) | =СУММ(P2:P21) | =СУММ(Q2:Q21) | =СУММ(R2:R21) | =СУММ(S2:S21) |
2.4.1. Степенная модель.
По значениям в таблице ищем A1 и A2:
Степенная |
|
|
| a1 = | 65,25631288 |
| a2 = | -0,020995801 |
| 82,15676178 | 82,15676178 |
| 277,7203577 | 277,7203577 |