, :
(9.139)
, , , , . .
, :
(9.140)
, , , . , , , , , . , , , .
:
(9.141)
:
(9.142)
.
, , , .
, , 1%, , , , .
(9.143)
9.20. 40 (/), (), (-./1.), (... 1.), (. . 100 .) (. 9.35).
9.35
, / | , | .- 1 | . 1 ... | .. 100 | ||||
1 | 10,49 | 67 | 15,45 | 0,76 | 18,21 | 10,048113 | ||
2 | 8,57 | 53 | 16,13 | 1,06 | 19,17 | 9,601560 | ||
3 | 10,95 | 70 | 17,59 | 1,06 | 20,42 | 11,593826 | ||
4 | 9,23 | 51 | 18,84 | 0,52 | 20,00 | 8,633346 | ||
5 | 11,97 | 70 | 18,43 | 0,99 | 20,37 | 11,524121 | ||
6 | 8,56 | 56 | 12,44 | 0,67 | 21,04 | 8,887059 | ||
7 | 12,18 | 55 | 15,50 | 1,02 | 20,25 | 9,800000 | ||
8 | 7,93 | 47 | 16,34 | 0,44 | 17,68 | 7,427264 | ||
9 | 15,75 | 89 | 17,13 | 1,22 | 28,19 | 14,929855 | ||
10 | 13,61 | 74 | 17,10 | 0,72 | 22,63 | 11,502371 | ||
11 | 13,99 | 52 | 27,16 | 1,59 | 40,16 | 15,194027 | ||
12
| 12,57 | 87 | 14,92 | 1,23 | 21,12 | 13,414848 | ||
13 | 10,93 | 65 | 18,17 | 0,82 | 26,01 | 11,506605 | ||
14 | 9,86 | 54 | 17,24 | 0,98 | 17,99 | 9,461020 | ||
15 | 7,39 | 48 | 14,64 | 0,41 | 21,90 | 7,917362 | ||
16 | 9,23 | 61 | 14,70 | 0,79 | 20,47 | 9,804117 | ||
17 | 15,40 | 79 | 28,81 | 1,20 | 29,01 | 15,372985 | ||
18 | 13,14 | 85 | 21,87 | 0,99 | 23,40 | 13,824023 | ||
19 | 13,12 | 83 | 16,88 | 0,91 | 25,53 | 13,217642 | ||
20 | 10,27 | 64 | 16,65 | 0,83 | 21,18 | 10,512752 | ||
21 | 9,12 | 55 | 16,10 | 0,81 | 20,24 | 9,395289 | ||
22 | 13,42 | 72 | 18,02 | 1,21 | 20,22 | 12,140147 | ||
23 | 10,29 | 69 | 16,91 | 0,78 | 24,89 | 11,485126 | ||
24 | 11,55 | 72 | 14,90 | 0,86 | 20,86 | 11,101097 | ||
25 | 15,26 | 87 | 17,64 | 1,21 | 28,42 | 14,808601 | ||
26 | 12,35 | 79 | 14,41 | 1,20 | 19,73 | 12,305857 | ||
27 | 8,24 | 49 | 12,62 | 1,07 | 18,57 | 8,749497 | ||
28 | 10,41 | 64 | 18,13 | 0,79 | 21,07 | 10,573475 | ||
29 | 9,62 | 52 | 17,30 | 0,77 | 24,46 | 9,806811 | ||
30 | 10,76 | 65 | 17,16 | 0,82 | 20,46 | 10,532588 | ||
31 | 8,35 | 51 | 14,65 | 0,63 | 22,82 | 8,842748 | ||
32 | 10,31 | 75 | 13,66 | 0,79 | 19,89 | 10,941740 | ||
33 | 9,38 | 55 | 12,07 | 0,73 | 22,92 | 9,174913 | ||
34 | 14,93 | 72 | 14,38 | 1,05 | 33,99 | 13,502339 | ||
35 | 12,46 | 79 | 14,53 | 1,03 | 22,95 | 12,436891 | ||
36 | 10,45 | 59 | 16,54 | 0,92 | 23,20 | 10,534678 | ||
37 | 12,38 | 80 | 21,64 | 0,95 | 21,64 | 12,955222 | ||
38 | 7,74 | 76 | 10,27 | 0,65 | 16,87 | 9,872332 | ||
39 | 14,49 | 89 | 19,44 | 1,05 | 24,49 | 14,236792 | ||
40 | 8,50 | 47 | 15,05 | 0,56 | 17,89 | 7,582986 | ||
445,15 | 2657,00 | 671,41 | 36,09 | 900,31 | 445,152022 | |||
11,128750 | 66,425000 | 16,785250 | 0,902250 | 22,507750 | ||||
2,305561 | 12,959335 | 3,458573 | 0,240692 | 4,463267 |
, , , , , :
,
,
,
, .
.
1) :
:
: - :
,
-
:
:
:
2) . , Microsoft, 9.36.
9.36
1 y | 2 x1 | 3 x2 | 4 x3 | 5 x4 | |
1 y | 1,000000 | ||||
2 x1 | 0,749996 | 1,000000 | |||
3 x2 | 0,545459 | 0,188222 | 1,000000 | ||
4 x3 | 0,731053 | 0,474013 | 0,466501 | 1,000000 | |
5 x4 | 0,640037 | 0,223318 | 0,549570 | 0,539163 | 1,000000 |
|
|
3) .
.
4). , () , :
1
5) 2,3,4, . :
) () 1- 1, .. ,
1, 1.
) () 1- 1, ..
1, 2.
) () 1- 1, ..
1, 3.
6) ( 2). 1, () 1, 2, 3.
2
7) , 3 4 2, , . :
) , 2 - , , ( ) - . : , , () 2:
2, 4:
) , 2 - , , ( ) - . : , , () 2:
2, 5:
8). 3. , () 4, 5.
3
9) 4. :
, 3 - , , ( ) - . , , () 3.
3
10) 4. , 6.
4
11)
12) .
) :
) :
) :
) , , :
13) , b - :
)
)
)
)
, , , :
|
|
14) :
) , - 1 , 0,096083 /., .
) , - 1 .-./, 0,113165 /., .
) , - 1 .../ 2,243155 /., .
) , - ../100, 0,15490 /., .
15) :
) , , , , , . , , , , , .
) , , , , , . , , , , , .
) , , , , , .
16)
) ( ), , , .
) ( ), , , .
) ( ), , , .
) ( ), , , .
17) :
) , , , .
, 0,64%, .
) ( ), , , .
, 0,26%, .
) ( ), , , .
|
|
, 0,28%, .
) ( ), , , .
, 0,45%, .
18) :
)
, 1%, 0,57%, .
)
, 1%, 0,17%, .
)
, 1%, 0,18%, .
)
, 1%, 0,31%, .
19) , :
1. - ,
2. - .. 100
3. - 1...
4. - , .-.
20) Microsoft Excel 1 ( , ). , 9.9.
9.9
Y-, - 1, - 2, - 3, - 4.
.
. 0 1, .
- , .
() () .
( , .. ) .
() , :
(9.144)
:
- (9.145)
- (9.146)
(9.147)
, :
(9.148)
:
- .
(, , . . ) .
(9.149)
() , () , .
(9.150)
(9.151)
(9.152)
|
|
, , .
. , , , , , , . , , , . .
(9.153)
(9.154)
:
(9.155)
(9.156)
:
- . - ( ), .
- .
, , , , 8-10 .
() , , , , .
() .
, : , , , .. , :
, .
, (, , ..).
, (, , ..) .
. , .. :
(9.157)
-1 1.
. :
.. (9.158)
:
(9.159)
- .
- .
0 1.
, . , , , :
(9.160)
:
(9.161)
, .
- , . .
, , . .
(9.162)
- .
- .
, , , , .
(156)
9.21. 9.20 :
1. ,
2. , .
.
1. :
9.37 .
9.37
1 | 10,49 | 0,408002 | 10,048113 | 0,195264 |
2 | 8,57 | 6,547202 | 9,601560 | 1,064116 |
3 | 10,95 | 0,031952 | 11,593826 | 0,414512 |
4 | 9,23 | 3,605252 | 8,633346 | 0,355996 |
5 | 11,97 | 0,707702 | 11,524121 | 0,198808 |
6 | 8,56 | 6,598477 | 8,887059 | 0,106968 |
7 | 12,18 | 1,105127 | 9,800000 | 5,664400 |
8 | 7,93 | 10,232002 | 7,427264 | 0,252743 |
9 | 15,75 | 21,355952 | 14,929855 | 0,672638 |
10 | 13,61 | 6,156602 | 11,502371 | 4,442100 |
11 | 13,99 | 8,186752 | 15,194027 | 1,449681 |
12 | 12,57 | 2,077202 | 13,414848 | 0,713768 |
13 | 10,93 | 0,039502 | 11,506605 | 0,332473 |
14 | 9,86 | 1,609727 | 9,461020 | 0,159185 |
15 | 7,39 | 13,978252 | 7,917362 | 0,278111 |
16 | 9,23 | 3,605252 | 9,804117 | 0,329610 |
17 | 15,40 | 18,243577 | 15,372985 | 0,000730 |
18 | 13,14 | 4,045127 | 13,824023 | 0,467887 |
19 | 13,12 | 3,965077 | 13,217642 | 0,009534 |
20 | 10,27 | 0,737452 | 10,512752 | 0,058929 |
21 | 9,12 | 4,035077 | 9,395289 | 0,075784 |
22 | 13,42 | 5,249827 | 12,140147 | 1,638024 |
23 | 10,29 | 0,703502 | 11,485126 | 1,428326 |
24 | 11,55 | 0,177452 | 11,101097 | 0,201514 |
25 | 15,26 | 17,067227 | 14,808601 | 0,203761 |
26 | 12,35 | 1,491452 | 12,305857 | 0,001949 |
27 | 8,24 | 8,344877 | 8,749497 | 0,259587 |
28 | 10,41 | 0,516602 | 10,573475 | 0,026724 |
29 | 9,62 | 2,276327 | 9,806811 | 0,034898 |
30 | 10,76 | 0,135977 | 10,532588 | 0,051716 |
31 | 8,35 | 7,721452 | 8,842748 | 0,242801 |
32 | 10,31 | 0,670352 | 10,941740 | 0,399095 |
33 | 9,38 | 3,058127 | 9,174913 | 0,042061 |
34 | 14,93 | 14,449502 | 13,502339 | 2,038216 |
35 | 12,46 | 1,772227 | 12,436891 | 0,000534 |
36 | 10,45 | 0,460702 | 10,534678 | 0,007170 |
37 | 12,38 | 1,565627 | 12,955222 | 0,330880 |
38 | 7,74 | 11,483627 | 9,872332 | 4,546840 |
39 | 14,49 | 11,298002 | 14,236792 | 0,064114 |
40 | 8,50 | 6,910327 | 7,582986 | 0,840915 |
445,150000 | 212,624438 | 445,152025 | 29,602363 | |
11,128750 |
:
21.
, ( ).
:
, 86% .
Microsoft Excel 20, 9.
2. :
9.20, (. 9.37).
9.37
1 y | 2 x1 | 3 x2 | 4 x3 | 5 x4 | |
1 y | 1,000000 | ||||
2 x1 | 0,749996 | 1,000000 | |||
3 x2 | 0,545459 | 0,188222 | 1,000000 | ||
4 x3 | 0,731053 | 0,474013 | 0,466501 | 1,000000 | |
5 x4 | 0,640037 | 0,223318 | 0,549570 | 0,539163 | 1,000000 |
) .