1, 2 (Microsoft Excel, ).
- .
- : → → .
- : →→.
- : ( )
- .
-99 | . | . | . | ||||
-07 | . | . | . | ||||
Mazda | . | . | . | ||||
Ford-Passat | . | . | . | ||||
Volkswagen | . | . | . | ||||
Tatra | . | . | . | ||||
-99 | . | . | . | ||||
Ford-Passat | . | . | . | ||||
-07 | . | . | . | ||||
. | . | . | |||||
. | . | . | |||||
Audi-90 | . | . | . | ||||
Audi-80 | . | . | . | ||||
Renault | . | . | . | ||||
-07 | . | . | . | ||||
Ford-Passat | . | . | . | ||||
Tatra | . | . | . | ||||
. | . | . | |||||
. | . | . | . | . | . |
, :
1) : = *;
2) ;
3) = * 3%;
4) = / . ( ; =1. )
- Z=x2+y, x = 2, 4,6, 8,....., y = 1, 3, 5, 7....
z =x^2 + y | |||||||
. ( ). ( → ).
|
|
- :
.
- , .
. .
" ".
.
: /, , , , , , , .
.
: , 18 , 18 25, 25 40, 40 55, 55 .
- 0, - 1. . .., - , 0 .
I6 =(H6="";0;1). .
.
I6. ( =). . : , : . . .
6="". . 6 .
__ 0.
__ 1.
.
I6 0.
.
.. .
18 . , . J6 : =(G6<18;1;0).
18 25 2- ( ), .. >18 <25, 1, - 0. , .
6 : =((G6>=18;G6<25);1;0)
: 25 40, 40 55, 55.
.
.
( ). . : =(G6:G18)
F20 I6:I16
- 18 . ( ). . : = (I6:I16;J6:J16)
:
- 25 40
- 40 55
- 55
Max =(G6:G16)
Min =(G6:G16)