MS Excel)
:
, . . .
, . . | ֳ, . |
60,60 | 205,39 |
40,30 | 206,42 |
50,20 | 206,23 |
70,40 | 205,40 |
50,80 | 206,96 |
60,40 | 206,54 |
50,70 | 205,69 |
60,90 | 207,84 |
60,60 | 207,09 |
80,00 | 209,19 |
80,70 | 206,74 |
80,00 | 206,84 |
1)
г : yx=a0+a1*x
, MS Excel ().
:
1. , .
. 1
2. (5 2 ) .
3. (), <CTRL>+<SHIFT>+<ENTER>.
.
. 1
()
1 | 0 |
1 | 0 |
F- | ʳ |
. 2
:
y=-890,82 + 4,61*
1>0, 䒺, .
(1 ) , 1 4, 61 .
R2 = 0, 14, 14% , 86%.
, .
. 3
:
17,20%, .
. 4 .
1% :
, 1%, 15,34%
Գ, F , F:
F=1,587
α=0,05, k1=m=1, k2=n-m-1=10
|
|
F=4,96
F<F, 95% .