101-200, 201(NM). NM .
: 113; 201(13), 13.
1.
. 101-200 .
1. , .
Excel
ai1 | ai2 | ai3 | ai4 | ai5 | bi | ||
a 1j | |||||||
a2j | |||||||
a3j | |||||||
cj | |||||||
x1 | x2 | x3 | x4 | x5 | |||
6,375 | 0,875 | ||||||
1 | 41,75 | ||||||
2 | |||||||
3 | |||||||
86,125 |
1. , .
:
x1 | x2 | x3 | x4 | x5 |
6,375 | 0,875 |
86,125 .
2-4 .
.
. | . | - | |||||
$C$8 | x1 | 6,375 | 3,75 | ||||
$D$8 | x2 | -21,3125 | 21,3125 | - | |||
$E$8 | x3 | -8,3125 | 8,3125 | - | |||
$F$8 | x4 | 0,875 | 5,8 | ||||
$G$8 | x5 | -12,4375 | 12,4375 | - | |||
. | - | ||||||
$C$9 | 1 x1 | 41,75 | - | 3,25 | |||
$C$10 | 2 x1 | 1,8125 | 2,364 | 14,57 | |||
$C$11 | 3 x1 | 1,3125 | 8,667 | 4,667 |
2. , , .
|
|
. 1 4 , 12 11 .
3. , .
: , ( 5, 2 6) .
4. , .
: , , ( 5 9 11) .
101 200
. .
1. .
2. .
3. , .
4. Excel.
5. ( ) (N/3)% (N/2)% .
6. 6%. , (. .1).
7. . .5.
101 | ||