, , . , . г :
y = m1x1 + m2x2 +... + b
y = mx + b,
y - x.
m - , x,
b - .
, y, x m .
{mn,mn-1,...,m1,b}. .
:
(__y, __x, , )
__y - y, y = mx + b.
__y , __x .
__y , __x .
__x - x, y = mx + b.
__x . , __y __x , , . , __y ( ).
__x , , {1,2,3,...} , __y.
- , , , b 0.
, b .
, b 0 m , y = mx.
- , , .
, , , , {mn, mn-1,..., m1, b; sen, sen-1,..., se1, seb; r2, sey; F, df; ssreg, ssresid}.
, m b.
:
se1,se2,...,sen m1,m2,...,mn.
seb b (seb = #/, ).
r2 . y , ; , 0 1. 1, - y. , 0, y. , Microsoft Excel y y. . Microsoft Excel y y, ( + ). , r2, , , .
|
|
sey y.
F F-, F- . F- , .
df . F- . F-, .
ssreg .
ssresid .
:
se1 | se2 | ... | sen | seb |
r2 | sey | |||
F | df | |||
ssreg | ssresid |
, . , , .
, , . г :
y = (b*(m1^x1)*(m2^x2)*_)
y = b*m^x,
y - x.
m - x,
b - .
, y, x m . {mn; mn-1;...; m1; b}.
. , , . , , :
ln y = x1 ln m1 +... + xn ln mn + ln b
, sei seb, ln mi ln b, mi b.
. ( ) __y __x. y, __x.
:
(__y; __x;
__x; )
__y, __x .
__x - x, y.
__x ( ) , , __x. , __y , __x __x . __y , __x __x .
|
|
__x , , __x.
__x __x, , {1;2;3;...} , __y.
__y __x x, __x.
: (__y; __x; __x; ).
, . , , .
. ֳ , __x, y x .
! , , , :
1) ;
2) CTRL-SHIFT-ENTER.
. Գ . .
y ֳ
x1
x2 ʳ
x3 ʳ
x4
, (x1, x2, x3 x4) (y), .
11 1230 :
1.5 -
X1 | X2 | X3 | X4 | Y | |
.
-220.263 | 2378.639 | 12556.42 | 28.0664 | 51108.91 | |
17.41382 | 630.7686 | 509.564 | 6.405821 | 14494.56 | |
0.995008 | 1207.569 | ||||
298.9901 | |||||
1.74E+09 |
г y = m1*x1 + m2*x2 + m3*x3 + m4*x4 + b :
y = 28,07*x1 + 12 556*x2 + 2379*x3+ 220,26*x4 + 51109
, 2500 , , , 25 , :
y = 28,07*2500 + 12556*3 + 2379*2 - 220,26*25 + 51109 = 158 195 .
F R2
r2 0,995, . F-, , ( r2) , .
|
|
, , 11 , . a , .
F- , F-, . F- F- . , , , a = 0,05, ( v1 v2):
v1 = k = 4 v2 = n - (k + 1) = 11 - (4 + 1) = 6, k - ,
n - . F- 4,53.
F- 298,9901, , F- 4,53. , .
t-
, . , , , -220,263 ( ) 17,41382 ( ). t-:
t = m4 / se4 = -220,263 / 17,414 =-12,6488
t- 6 a = 0,05 1,94. t, 12,65, , 1,94, . . t- :
t
4,38
ʳ 24,6
ʳ 3,77
12,65
, 1,94. , , , .
1 .
2 , , , .
3 , ?
4 .
5 ?
2
Excel 2000
Excel 2000
1 : MS-Excel; MS-Excel MS-Excel
2 : Գ . .
1 2 ( г- .. ; Qi - , г.)
: 1 , , ;
2 , ( ()), ( );
|
|
3 , ( ()), ( );
4 , , , ;
5 , , .
6 () () ( 3);
7 EXCEL (()), (()), (()) (̲()) , , , (()), (()) (()); (()), , (()), ϳ, (()), , , - Գ .
8 , . , () , . ? ?
9 , ( TR=P*Qd ). .
2.1, 2.2, 2.3.