__Y .
__X ( ), ( ) ,
__X. __X , , __X.
, , , b 0.
1. 2 200. , . (Y) , .().
2. 200
, . | , . | |
X | Y | |
3:24 Excel. 22-24 , ( .1).
, . (Y) , . (X) y = m∙x + b
(. .1 .2), 5:9 : =(C6:C21;B6:B21;1;1).
:
E5, F5 m=1.4111 b=3816,154;
7 R2 =0.885;
E8 F=108.12.
.1 .
, :
Y = 1.411∙x + 3816.154
: R2=0.885 0,75 1, F=108,12 (F(0,05;1;F8)= 4,6), , .
22 =E5*B22+F5. 23, 24 (. .2).
12:14 , 4000 ., 4500 ., 5000 . ( 2224) :
|
|
=(C6:C21;B6:B21;B22:24;1)
. 2 .
15 :
=(B22;C6:C21;B6:B21).
18 R2:
=(C6:C21;B6:B21)^2.
12 :
=F(0,05;1;F8)
c , .
Excel , , . , .
, , , . , .