²
:
5
,
Գ ,
³
:
2012
...3
1. 5
2. ..9
3. 13
4. ..15
ꅅ..17
MS Excel, , 1 .
, .
:
- ;
- () ;
- ;
- MS Excel;
- ;
- ;
- ;
- .
, . - ( 25 ).
1. (, /) (1, ) 1 (2, .-.)
, / | , | 1 , .-. | |
1 | 2 | ||
32,00 | 1,09 | ||
18,40 | 2,00 | ||
30,00 | 1,20 | ||
24,20 | 1,54 | ||
31,10 | 1,50 | ||
16,70 | 2,00 | ||
26,20 | 1,55 | ||
20,30 | 1,62 | ||
25,10 | 1,41 | ||
18,80 | 1,88 | ||
25,70 | 1,47 | ||
19,60 | 1,90 | ||
25,70 | 2,19 | ||
19,30 | 1,80 | ||
17,60 | 2,21 | ||
32,80 | 1,30 | ||
24,00 | 1,62 | ||
20,40 | 1,67 | ||
33,10 | 1,19 | ||
20,90 | 1,96 | ||
26,40 | 1,43 | ||
28,50 | 1,33 | ||
31,90 | 1,00 | ||
28,60 | 1,56 | ||
19,00 | 1,92 |
|
|
.
. : . MS Excel . 25 .
2.
1 | 2 | ||||
24,652 | 69,04 | 1,6136 | |||
1,062106712 | 2,869657355 | 0,066987262 | |||
25,1 | 1,56 | ||||
25,7 | |||||
5,310533558 | 14,34828677 | 0,334936312 | |||
28,20176667 | 205,8733333 | 0,112182333 | |||
-1,345540619 | -1,35901344 | -0,796418385 | |||
0,150828482 | -0,08818879 | 0,05249815 | |||
16,4 | 1,21 | ||||
16,7 | |||||
33,1 | 2,21 | ||||
616,3 | 40,34 | ||||
(1) | 33,1 | (1) | (1) | 2,21 | |
(1) | 16,7 | (1) | (1) | ||
(95,0%) | 2,192080499 | (95,0%) | 5,922681646 | (95,0%) | 0,138254914 |
.
=25,7;
1=90;
2=2.
, .
=25,1;
1=72;
2=1,56.
, .
=-1,3455 -
2=-1,3590-
4=-0,7964-
.
AsY=0,1508 .
AsX1=0,0882 .
AsX2= 0,0525 .
.
=24,652
1=69,04
2=1,61
, , , .
2 =28,20
2 1=205,87
22=0,11
, .
=5,31
1=14,35
2=0,33
г , , .
τ . τ 3, .
|
|
( ). ( ). .
: , .
:
Ø
│16,7 24,652│/5,31<3;
│33,1-24,652│/5,31<3;
Ø
│45-69,04│/14,35<3;
│90-69,04│/14,35<3;
Ø 1
│1-1,61│/0,33<3;
│2,21-1│/0,33>3.
2 , (, 1, 2) . ( ) 33%:
5,31*100/24,652<33%
14,35*100/69,04<33%
0,33*100/1,61<33 %
, .
, . , . , .