.. 4
1. . 6
1.1 6
1.2 7
1.3 9
1.4 11
1.5 13
1.6 15
2. ... 17
2.1 . 17
2.2 22
3.
. 24
3.1 25
3.2 28
4.
. 35
4.1 35
1 . 39
2 . 41
43
( ) . Excel. Excel Excel. , , .
( ) Excel.
( ) (, ). (.. ), Excel ( XP), .
Excel XP. , (, ), Excel.
, , Excel XP.
1. , . , , . , ( ) :
|
|
(,
, 30 (). , B3, B4, B5, B6, C3, C4, C5, C6,
= (B3:B6;3:C6),
.. .
2. , ( ) ( ). , , , .
. , 90 % , . , , .
1.
,
(1.1)
.
1.1. ( Y, ) ( X, ) 10 , 1.1.
1.1
i | ||||||||||
xi | ||||||||||
yi |
1.1