1.1
1. - 1:2 5:
1) 2 =3* ;
2) 2 ;
3) D1:E2 =1:2*5 <Ctrl>+<Shift>+<Enter> - :
=A1:B2*5 | =A1:B2*5 | |||
=(78;LOG(1;78)) | =3*LOG(10;10) | =A1:B2*5 | =A1:B2*5 |
2. () .
1) 2 =2* ;
2) 2 = ;
3) G1:H2 =A1:B2+D1:E2 <Ctrl>+<Shift>+<Enter> - :
=A1:B2+D1:E2 | =A1:B2+D1:E2 | ||||||
=(78;LOG(3;78)) | = 2*LOG(10;10) | =A1:B2+D1:E2 | =A1:B2+D1:E2 |
3. () .
1) G1:H2 =A1:B2*D1:E2 <Ctrl>+<Shift>+<Enter> - :
=A1:B2*D1:E2 | =A1:B2*D1:E2 | ||||||
=(78;LOG(3;78)) | = 2*LOG(10;10) | =A1:B2*D1:E2 | =A1:B2*D1:E2 |
1.2.
5. :
AX=B, , X - , - . X = , , :
1) F1:F2 =((A1:B2);D1:D2) <Ctrl>+<Shift>+<Enter> - :
=((A1:B2);D1:D2) | |||||
=((A1:B2);D1:D2) |
2,166666667 | |||||
-1,333333333 |
6. ,
= , B=
:
1) 1:2 ;
2) D1:D2 ;
2) F1:F2 =(((A1:B2;A1:B2));D1:D2) <Ctrl>+<Shift>+<Enter> - :
|
|
=(78;LOG(7;78)) | =(((A1:B2;A1:B2));D1:D2) | ||||
=LOG(10;10) | =(((A1:B2;A1:B2));D1:D2) |
0,020710059 | |||||
0,042899408 |
7. z= , , 1:2; , D1:D2, () ( 5). F1 -=(((D1:D2);A1:B2);D1:D2) :
=(((D1:D2);A1:B2);D1:D2) | |||||
8. Z= ,
= , Y=
1:2 , D1:D2 Y, F1 =((D1:D2);((A1:B2);D1:D2)):
=(78;LOG(7;78)) | =((D1:D2);((A1:B2);D1:D2)) | ||||
=LOG(10;10) |
1. AX=B, Z= ,
= , = , Y=
AX=B:
1) A1:D4 ;
2) F1:F4 ;
3) 1 =((A1:D4);F1:F4) <Ctrl>+<Shift>+<Enter> - :
=((A1:D4);F1:F4) | |||||||
-0,735189016 | |||||||
=:
1 =((((A1:D4;A1:D4);A1:D4));F1:F4) <Ctrl>+<Shift>+<Enter> - :
=((((A1:D4;A1:D4);A1:D4));F1:F4) | |||||||
0,013795645 | |||||||
Z= :
J1 =(((H1:H4);(A1:D4));((A1:D4;A1:D4);H1:H4)) <Ctrl>+<Shift>+<Enter> - :
|
|
=(((H1:H4);(A1:D4));((A1:D4;A1:D4);H1:H4)) | |||||||||
1.3 .
1) A1:D4 E1:E4 ;
2) 1:! 6:6, 1:11, 16:16;
3) 7:7 {=A2:E2-$A$1:$E$1*(A2/$A$1)};
4) 7:7 , 7:9;
5) 7:7 12:12 17:17;
6) 13:13 =A8:E8-$A$7:$E$7*(B8/$B$7);
7) 13:13 , 13:14;
8) 13:13 18:18;
9) 19:19 =A14:E14-$A$13:$E$13*(C14/$C$13);
10) G4:K4, G3:K3, G2:K2,G1:K1 :
=A19:E19/D19;
=(A18:E18-G4:K4*D18)/C18;
=(A17:E17-G4:K4*D17-G3:K3*C17)/B17;
=(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 :
=(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 | =(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 | =(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 | =(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 | =(A16:E16-G4:K4*D16-G3:K3*C16-G2:K2*B16)/A16 | ||||||
=(A17:E17-G4:K4*D17-G3:K3*C17)/B17 | =(A17:E17-G4:K4*D17-G3:K3*C17)/B17 | =(A17:E17-G4:K4*D17-G3:K3*C17)/B17 | =(A17:E17-G4:K4*D17-G3:K3*C17)/B17 | =(A17:E17-G4:K4*D17-G3:K3*C17)/B17 | ||||||
=(A18:E18-G4:K4*D18)/C18 | =(A18:E18-G4:K4*D18)/C18 | =(A18:E18-G4:K4*D18)/C18 | =(A18:E18-G4:K4*D18)/C18 | =(A18:E18-G4:K4*D18)/C18 | ||||||
=A19:E19/D19 | =A19:E19/D19 | =A19:E19/D19 | =A19:E19/D19 | =A19:E19/D19 | ||||||
=A2:E2-$A$1:$E$1*(A2/$A$1) | =A2:E2-$A$1:$E$1*(A2/$A$1) | =A2:E2-$A$1:$E$1*(A2/$A$1) | =A2:E2-$A$1:$E$1*(A2/$A$1) | =A2:E2-$A$1:$E$1*(A2/$A$1) | ||||||
=A3:E3-$A$1:$E$1*(A3/$A$1) | =A3:E3-$A$1:$E$1*(A3/$A$1) | =A3:E3-$A$1:$E$1*(A3/$A$1) | =A3:E3-$A$1:$E$1*(A3/$A$1) | =A3:E3-$A$1:$E$1*(A3/$A$1) | ||||||
=A4:E4-$A$1:$E$1*(A4/$A$1) | =A4:E4-$A$1:$E$1*(A4/$A$1) | =A4:E4-$A$1:$E$1*(A4/$A$1) | =A4:E4-$A$1:$E$1*(A4/$A$1) | =A4:E4-$A$1:$E$1*(A4/$A$1) | ||||||
0,5 | -7,5 | -8 | 1,5 | |||||||
=A8:E8-$A$7:$E$7*(B8/$B$7) | =A8:E8-$A$7:$E$7*(B8/$B$7) | =A8:E8-$A$7:$E$7*(B8/$B$7) | =A8:E8-$A$7:$E$7*(B8/$B$7) | =A8:E8-$A$7:$E$7*(B8/$B$7) | ||||||
=A9:E9-$A$7:$E$7*(B9/$B$7) | =A9:E9-$A$7:$E$7*(B9/$B$7) | =A9:E9-$A$7:$E$7*(B9/$B$7) | =A9:E9-$A$7:$E$7*(B9/$B$7) | =A9:E9-$A$7:$E$7*(B9/$B$7) | ||||||
0,5 | -7,5 | -8 | 1,5 | |||||||
-84 | -84 | |||||||||
=A14:E14-$A$13:$E$13*(C14/$C$13) | =A14:E14-$A$13:$E$13*(C14/$C$13) | =A14:E14-$A$13:$E$13*(C14/$C$13) | =A14:E14-$A$13:$E$13*(C14/$C$13) | =A14:E14-$A$13:$E$13*(C14/$C$13) |
|
|
0,185714 | ||||||||||
0,778571 | ||||||||||
-0,63571 | ||||||||||
0,457143 | ||||||||||
0,5 | -7,5 | -8 | 1,5 | |||||||
-4,5 | -16,5 | -12 | 1,5 | |||||||
-1,5 | -9,5 | -3 | 3,5 | |||||||
0,5 | -7,5 | -8 | 1,5 | |||||||
-84 | -84 | |||||||||
-32 | -27 | |||||||||
0,5 | -7,5 | -8 | 1,5 | |||||||
-84 | -84 | |||||||||
2,285714 |
2.
2.1.
9. :
1) 2 =7*LOG(10;10);
2) 2 =(78;LOG(1;78));
3) F3 =(B2:B7;E2+D3*A2:A7);
4) :
x | y | m | b | ||
=(78;LOG(1;78)) | =7*LOG(10;10) | ||||
1,88571412875188 | 5,39999996034584 | =(B2:B7;E3+D3*A2:A7) | |||
x | y | m | b | ||
1,885714 | 5,4 | 1,771428571 | |||
2.2.
10. m b :
1) m D2 =(B2:B7;A2:A7);
|
|
2) b E2 =(B2:B7;A2:A7$);
3) :
x | y | m | b | ||
=(78;LOG(1;78)) | =7*LOG(10;10) | =(B2:B7;A2:A7) | =(B2:B7;A2:A7) | ||
1,88571412875188 | 5,39999996034584 | =(B2:B7;E3+D3*A2:A7) | |||
x | y | m | b | ||
1,885714286 | 5,4 | ||||
1,885714129 | 5,39999996 | 1,771428571 | |||
11. m b :
1) 2:7, ( );
2) , ;
3) ; ;
4) 2 =$D$2*A2+$E$2 2:7:
x | y | . | m | b | |
=(78;LOG(1;78)) | =7*LOG(10;10) | =$D$2*A2+$E$2 | =(B2:B7;A2:A7) | =(B2:B7;A2:A7) | |
=$D$2*A3+$E$2 | 1,88571412875188 | 5,39999996034584 | =(B2:B7;E3+D3*A2:A7) | ||
=$D$2*A4+$E$2 | |||||
=$D$2*A5+$E$2 | |||||
=$D$2*A6+$E$2 | |||||
=$D$2*A7+$E$2 |
x | y | . | m | b | |
7,285714286 | 1,885714286 | 5,4 | |||
9,171428571 | 1,885714129 | 5,39999996 | 1,771428571 | ||
11,05714286 | |||||
12,94285714 | |||||
14,82857143 | |||||
16,71428571 |
3
1. :
=(A2:H2;A1:H1) | =(A2:H2;A1:H1) | |||||||||
=13*LOG(10;10) | =(78;LOG(55;78)) |
6,011904762 | 7,07142857 | |||||||||
2. :
=(A2:H2;A1:H1) | =(A2:H2;A1:H1) | |||||||||||||||||
=13*LOG(10;10) | =(78;LOG(55;78)) | =$J$1*A1+$K$1 | =$J$1*B1+$K$1 | =$J$1*C1+$K$1 | =$J$1*D1+$K$1 | =$J$1*E1+$K$1 | =$J$1*F1+$K$1 | =$J$1*G1+$K$1 | =$J$1*H1+$K$1 |
6,011904762 | 7,071429 | |||||||||||||||||
13,08333333 | 19,09524 | 25,10714 | 31,11905 | 37,13095 | 43,14286 | 49,15476 | 55,16667 |
3. Excel
3.1.
12.
1) [1;-1] 0,2 ;
2) 2 =A3^3-0,01*LOG(78;78)*A3^2-0,7044*A3+0,139104;
3) ;
4) 2:4 D2 =C2^3-0,01*LOG(78;78)*C2^2-0,7044*C2+0,139104 D3, D4;
5) ( - - ):
x | y | |||
-1 | =A2^3-0,01*LOG(78;78)*A2^2-0,7044*A2+0,139104 | -0,919994327978423 | =C2^3-0,01*LOG(78;78)*C2^2-0,7044*C2+0,139104 | |
-0,8 | =A3^3-0,01*LOG(78;78)*A3^2-0,7044*A3+0,139104 | 0,210000684055703 | =C3^3-0,01*LOG(78;78)*C3^2-0,7044*C3+0,139104 | |
-0,6 | =A4^3-0,01*LOG(78;78)*A4^2-0,7044*A4+0,139104 | 0,719975360423083 | =C4^3-0,01*LOG(78;78)*C4^2-0,7044*C4+0,139104 | |
-0,4 | =A5^3-0,01*LOG(78;78)*A5^2-0,7044*A5+0,139104 | |||
-0,2 | =A6^3-0,01*LOG(78;78)*A6^2-0,7044*A6+0,139104 | |||
=A7^3-0,01*LOG(78;78)*A7^2-0,7044*A7+0,139104 | ||||
0,2 | =A8^3-0,01*LOG(78;78)*A8^2-0,7044*A8+0,139104 | |||
0,4 | =A9^3-0,01*LOG(78;78)*A9^2-0,7044*A9+0,139104 | |||
0,6 | =A10^3-0,01*LOG(78;78)*A10^2-0,7044*A10+0,139104 | |||
0,8 | =A11^3-0,01*LOG(78;78)*A11^2-0,7044*A11+0,139104 | |||
=A12^3-0,01*LOG(78;78)*A12^2-0,7044*A12+0,139104 |
|
|
x | y | |||
-1 | -0,166496 | -0,919994328 | 1,05113E-05 | |
-0,8 | 0,184224 | 0,210000684 | -3,9422E-07 | |
-0,6 | 0,342144 | 0,71997536 | -2,0607E-05 | |
-0,4 | 0,355264 | |||
-0,2 | 0,271584 | |||
0,139104 | ||||
0,2 | 0,005824 | |||
0,4 | -0,080256 | |||
0,6 | -0,071136 | |||
0,8 | 0,081184 | |||
0,424704 |
4.
:
1) [1;-1] 0,2 ;
2) 2 =A2^3-2,92*A2^2+1,4355*A2+0,791136+10/1000;
3) ;
4) = -0,4 2 ;
5) D2 =C2^3-2,92*C2^2+1,4355*C2+0,791136+10/1000;
6) ( - - ):
x | y | ||
-1 | =A2^3-2,92*A2^2+1,4355*A2+0,791136+10/1000 | -0,4 | =C2^3-2,92*C2^2+1,4355*C2+0,791136+10/1000 |
-0,8 | =A3^3-2,92*A3^2+1,4355*A3+0,791136+10/1000 | ||
-0,6 | =A4^3-2,92*A4^2+1,4355*A4+0,791136+10/1000 | ||
-0,4 | =A5^3-2,92*A5^2+1,4355*A5+0,791136+10/1000 | ||
-0,2 | =A6^3-2,92*A6^2+1,4355*A6+0,791136+10/1000 | ||
=A7^3-2,92*A7^2+1,4355*A7+0,791136+10/1000 | |||
0,2 | =A8^3-2,92*A8^2+1,4355*A8+0,791136+10/1000 | ||
0,4 | =A9^3-2,92*A9^2+1,4355*A9+0,791136+10/1000 | ||
0,6 | =A10^3-2,92*A10^2+1,4355*A10+0,791136+10/1000 | ||
0,8 | =A11^3-2,92*A11^2+1,4355*A11+0,791136+10/1000 | ||
=A12^3-2,92*A12^2+1,4355*A12+0,791136+10/1000 |
x | y | ||
-1 | -4,55436 | -0,4 | -0,304264 |
-0,8 | -2,72806 | ||
-0,6 | -1,32736 | ||
-0,4 | -0,30426 | ||
-0,2 | 0,389236 | ||
0,801136 | |||
0,2 | 0,979436 | ||
0,4 | 0,972136 | ||
0,6 | 0,827236 | ||
0,8 | 0,592736 | ||
0,316636 |
3.2.
13. 0,001 .
1) 1 0,001;
2) [0;2];
3) C3, D3, E3, A4, B4, F4 ;
4) :
0,001 | |||||||
a | b | c | |||||
=(A3+B3)/2 | =(A3^2-2)*(C3^2-2) | =C3^2-2 | |||||
=(D3<=0;A3;C3) | =(D3<=0;C3;B3) | =(A4+B4)/2 | =(A4^2-2)*(C4^2-2) | =C4^2-2 | =(B3-A3<$B$1;" " &(C3;"0?0000");"") | ||
=(D4<=0;A4;C4) | =(D4<=0;C4;B4) | =(A5+B5)/2 | =(A5^2-2)*(C5^2-2) | =C5^2-2 | =(B4-A4<$B$1;" " &(C4;"0?0000");"") | ||
=(D5<=0;A5;C5) | =(D5<=0;C5;B5) | =(A6+B6)/2 | =(A6^2-2)*(C6^2-2) | =C6^2-2 | =(B5-A5<$B$1;" " &(C5;"0?0000");"") | ||
=(D6<=0;A6;C6) | =(D6<=0;C6;B6) | =(A7+B7)/2 | =(A7^2-2)*(C7^2-2) | =C7^2-2 | =(B6-A6<$B$1;" " &(C6;"0?0000");"") | ||
=(D7<=0;A7;C7) | =(D7<=0;C7;B7) | =(A8+B8)/2 | =(A8^2-2)*(C8^2-2) | =C8^2-2 | =(B7-A7<$B$1;" " &(C7;"0?0000");"") | ||
=(D8<=0;A8;C8) | =(D8<=0;C8;B8) | =(A9+B9)/2 | =(A9^2-2)*(C9^2-2) | =C9^2-2 | =(B8-A8<$B$1;" " &(C8;"0?0000");"") | ||
=(D9<=0;A9;C9) | =(D9<=0;C9;B9) | =(A10+B10)/2 | =(A10^2-2)*(C10^2-2) | =C10^2-2 | =(B9-A9<$B$1;" " &(C9;"0?0000");"") | ||
=(D10<=0;A10;C10) | =(D10<=0;C10;B10) | =(A11+B11)/2 | =(A11^2-2)*(C11^2-2) | =C11^2-2 | =(B10-A10<$B$1;" " &(C10;"0?0000");"") | ||
=(D11<=0;A11;C11) | =(D11<=0;C11;B11) | =(A12+B12)/2 | =(A12^2-2)*(C12^2-2) | =C12^2-2 | =(B11-A11<$B$1;" " &(C11;"0?0000");"") | ||
=(D12<=0;A12;C12) | =(D12<=0;C12;B12) | =(A13+B13)/2 | =(A13^2-2)*(C13^2-2) | =C13^2-2 | =(B12-A12<$B$1;" " &(C12;"0?0000");"") | ||
=(D13<=0;A13;C13) | =(D13<=0;C13;B13) | =(A14+B14)/2 | =(A14^2-2)*(C14^2-2) | =C14^2-2 | =(B13-A13<$B$1;" " &(C13;"0?0000");"") | ||
=(D14<=0;A14;C14) | =(D14<=0;C14;B14) | =(A15+B15)/2 | =(A15^2-2)*(C15^2-2) | =C15^2-2 | =(B14-A14<$B$1;" " &(C14; "0,0000");" ") |
0,001 | |||||||
a | b | c | |||||
-1 | |||||||
1,5 | -0,25 | 0,25 | |||||
1,5 | 1,25 | 0,4375 | -0,4375 | ||||
1,25 | 1,5 | 1,375 | 0,047851563 | -0,109375 | |||
1,375 | 1,5 | 1,4375 | -0,007263184 | 0,06640625 | |||
1,375 | 1,4375 | 1,40625 | 0,002456665 | -0,022460938 | |||
1,40625 | 1,4375 | 1,421875 | -0,000488043 | 0,021728516 | |||
1,40625 | 1,421875 | 1,414063 | 9,59635E-06 | -0,000427246 | |||
1,4140625 | 1,421875 | 1,417969 | -4,54392E-06 | 0,010635376 | |||
1,4140625 | 1,4179688 | 1,416016 | -2,17906E-06 | 0,00510025 | |||
1,4140625 | 1,4160156 | 1,415039 | -9,97854E-07 | 0,002335548 | |||
1,4140625 | 1,4150391 | 1,414551 | -4,07555E-07 | 0,000953913 | |||
1,4140625 | 1,4145508 | 1,414307 | -1,12483E-07 | 0,000263274 | 1,4146 |
5. :
1) 1 0,001;
2) [0;2];
3) C3, D3, E3, A4, B4, F4 ;
4) :
0,001 | |||||||
a | b | c | |||||
=(A3+B3)/2 | =(A3^4-10)*(C3^4-10) | =C3^4-10 | |||||
=(D3<=0;A3;C3) | =(D3<=0;C3;B3) | =(A4+B4)/2 | =(A4^4-10)*(C4^4-10) | =C4^4-10 | =(B3-A3<$B$1;" " &(C3;"0?0000");"") | ||
=(D4<=0;A4;C4) | =(D4<=0;C4;B4) | =(A5+B5)/2 | =(A5^4-10)*(C5^4-10) | =C5^4-10 | =(B4-A4<$B$1;" " &(C4;"0?0000");"") | ||
=(D5<=0;A5;C5) | =(D5<=0;C5;B5) | =(A6+B6)/2 | =(A6^4-10)*(C6^4-10) | =C6^4-10 | =(B5-A5<$B$1;" " &(C5;"0?0000");"") | ||
=(D6<=0;A6;C6) | =(D6<=0;C6;B6) | =(A7+B7)/2 | =(A7^4-10)*(C7^4-10) | =C7^4-10 | =(B6-A6<$B$1;" " &(C6;"0?0000");"") | ||
=(D7<=0;A7;C7) | =(D7<=0;C7;B7) | =(A8+B8)/2 | =(A8^4-10)*(C8^4-10) | =C8^4-10 | =(B7-A7<$B$1;" " &(C7;"0?0000");"") | ||
=(D8<=0;A8;C8) | =(D8<=0;C8;B8) | =(A9+B9)/2 | =(A9^4-10)*(C9^4-10) | =C9^4-10 | =(B8-A8<$B$1;" " &(C8;"0?0000");"") | ||
=(D9<=0;A9;C9) | =(D9<=0;C9;B9) | =(A10+B10)/2 | =(A10^4-10)*(C10^4-10) | =C10^4-10 | =(B9-A9<$B$1;" " &(C9;"0?0000");"") | ||
=(D10<=0;A10;C10) | =(D10<=0;C10;B10) | =(A11+B11)/2 | =(A11^4-10)*(C11^4-10) | =C11^4-10 | =(B10-A10<$B$1;" " &(C10;"0?0000");"") | ||
=(D11<=0;A11;C11) | =(D11<=0;C11;B11) | =(A12+B12)/2 | =(A12^4-10)*(C12^4-10) | =C12^4-10 | =(B11-A11<$B$1;" " &(C11;"0?0000");"") | ||
=(D12<=0;A12;C12) | =(D12<=0;C12;B12) | =(A13+B13)/2 | =(A13^4-10)*(C13^4-10) | =C13^4-10 | =(B12-A12<$B$1;" " &(C12;"0?0000");"") | ||
=(D13<=0;A13;C13) | =(D13<=0;C13;B13) | =(A14+B14)/2 | =(A14^4-10)*(C14^4-10) | =C14^4-10 | =(B13-A13<$B$1;" " &(C13;"0?0000");"") | ||
=(D14<=0;A14;C14) | =(D14<=0;C14;B14) | =(A15+B15)/2 | =(A15^4-10)*(C15^4-10) | =C15^4-10 | =(B14-A14<$B$1;" " &(C14; "0,0000");" ") |
0,001 | |||||||
a | b | c | |||||
-9 | |||||||
1,5 | 44,4375 | -4,9375 | |||||
1,5 | 1,75 | 3,06665 | -0,62109 | ||||
1,75 | 1,875 | -1,46554 | 2,359619 | ||||
1,75 | 1,875 | 1,8125 | -0,49206 | 0,792252 | |||
1,75 | 1,8125 | 1,78125 | -0,04161 | 0,066987 | |||
1,75 | 1,78125 | 1,765625 | 0,174912 | -0,28162 | |||
1,765625 | 1,78125 | 1,773438 | 0,030547 | -0,10847 | |||
1,773438 | 1,78125 | 1,777344 | 0,002281 | -0,02103 | |||
1,777344 | 1,78125 | 1,779297 | -0,00048 | 0,022906 | |||
1,777344 | 1,779297 | 1,77832 | -1,9E-05 | 0,00092 | |||
1,777344 | 1,77832 | 1,777832 | 0,000212 | -0,01006 | |||
1,777832 | 1,77832 | 1,778076 | 4,6E-05 | -0,00457 | 1,7778 |
:
. . 2- / . .. . .: ,2006. 640 .: . ISBN 5-94723-752-0
. . . . .: . 2006 640 . ISBN 5-8046-0134-2
. . . -./.. , .. , .. ո; . .. ո 3- . . 4 . .: , 2004.-848 . ISBN 5-7695-1709-3
.., .., .., .. ..
MICROSOFT OFFICE 2007, : WORD, EXCEL, ACCESS,POWERPOINT, PUBLISHER, OULOOK, ONENOTE, INFOPATH, GROOVE. .: , 2008. 608 .: .+ . .