a, b y=a+bx , . , ATA , .
slope(vx,vy) intercept(vx,vy), a=intercept(vx,vy), b=slope(vx,vy), vx, vy - x y. .
, . y (u(1,5)) (u(5)).
6. . .
Excel
. 12 :
, . . | , . | ||
y=a+b1x1+b2x2, :
y | x1 | x2 | x1^2 | x1*x2 | x2^2 | x1*y | x2*y | |
Σ |
:
a=-24,023; b1=0.3829; b2=1.6774
..
|
|
y=0.3829x1+1.6774x2 24,023,
y ().
x1 | x2 | y | y( ) | │ y-y ()│ |
197,29 | 5,7138 | |||
80,633 | 17,6326 | |||
73,066 | 28,0659 | |||
100,8 | 12,2018 | |||
44,387 | 76,6134 | |||
98,903 | 10,9028 | |||
110,97 | 0,973 | |||
93,907 | 37,9074 | |||
x1 | x2 | y | y() | Ιy-y()Ι |
80,014 | 0,014 | |||
212,75 | 24,252 | |||
167,62 | 7,6217 | |||
90,662 | 15,6616 |
, .
, y=a+b1x1++bmxm, . :
1. ;
2. 5 (m-1) (5 , m-1 ) 1 (m-1) ;
3. ;
4.
, ;
, ;
5. , ; =1, , =0, 0;
, , . =1, , =0, ;
6. . , <F2>, <CTRL>+<SHIFT>+<ENTER>.
, :
bm | bm-1 | a | |
bm | bm-1 | a | |
R2 | y | ||
F - | |||
(2:13, 2:D13, 1, 1),
# | y | x1 | x2 | ||||
1,677398105 | 0,382903574 | -24,02304365 | |||||
0,421525183 | 0,253317751 | 28,05754959 | |||||
0,75569291 | 32,65658398 | #/ | |||||
13,91944086 | #/ | ||||||
29688,84437 | 9598,072295 | #/ | |||||
|
|
y=-24.023+0.382904x1+1.677398x2, , . , R2=0.755693, .. . , a, b1, , bm. , y=a+b1x1+b2x2+b3x12+b4x1x2+b5x22, y=a+b1x1+b2x2+b3z3+b4z4+b5z5, z3=x12, z4=x1x2, z5=x22.