: Excel .
:
= a + b × + u ;
y = + b × x ;
;
i- ;
i- ( );
) ;
;
;
;
() ;
.
: R2 ,
MS Excel
. b , a . , Excel . , , , . .
( b ). , y, x.
a , , .
x. . x, , .
, , . , .
, 1, Excel :
b= | = (C2:C16;B2:B16)/(B2:B16) |
b= | =(C2:C16;B2:B16) |
a= | = (C2:C16)- (C2:C16;B2:B16)* (B2:B16) |
a= | =(C2:C16;B2:B16) |
R2= | =(C2:C16;B2:B16)* (C2:C16;B2:B16) |
x=17 | =(17;C2:C16;B2:B16) |
: .
:
b = 7,703
a = 239,96
R2 = 0,7868.
, 17, 109,014.
|
|
, :
b = 7,703, , 7,703 , 7,703 .
239,96, , . oy.
: y = 239,96 7,703 x.
17 109,014 .
0,7868. : , y 78 %, () x, .
. . , . (). .
Excel , . ( ), , . , , . , ( 6).
6
. , , .
, . -, , . , (R^2) . , 1, , , 7.
7
.
, , , , . , . , , . ( 8).
|
|
, .
, Y X, . Y X , ( ), X Y, . .
, X Y , , .
4
Y C1:C16, X B1:B16, , , 4.
4
R | 0,887036 |
R- | 0,786833 |
R- | 0,770435 |
2,264609 | |
df | SS | MS | F | F | ||
246,0889 | 246,0889 | 47,985 | 1,04E05 | |||
66,66991 | 5,128455 | |||||
312,7588 | ||||||
t- | P- | 95 % | 95 % | |||
Y- | 240,142 | 17,70861 | 13,56075 | 4,76E09 | 201,8849 | 278,3991 |
x (.) | 7,71453 | 1,113671 | 6,92712 | 1,04E05 | 10,1205 | 5,30859 |
, , . :
¾
¾
¾ .
. R R- . R- , . .
.
SS . , , RSS,
() ESS,
TSS.
, , , . , . Y- a. x (.) b.
, .
. , , (. 5) :
5
y (. .) | ||
123,7511 | 1,426776 | |
122,7896 | 1,019821 | |
122,2914 | 1,11646 | |
120,6462 | 3,7319 | |
120,2544 | 0,39014 | |
119,6494 | 1,5813 | |
119,0288 | 4,559903 | |
117,4316 | 0,34387 | |
117,2931 | 1,12322 | |
117,0864 | 1,257187 | |
114,353 | 1,847847 | |
114,1298 | 2,67328 | |
112,0989 | 3,003645 | |
111,4176 | 1,31194 | |
110,8662 | 0,84306 |
|
|
. , .
. . , . . , , . . , . .