, -309
2 (13 2012)
i(2) i(3), i. 30 :
N | Xi(2) | Xi(3) | Yi |
85,5 | -13 | 28,89711793 | |
40,5 | -71 | -307,0420699 | |
40,5 | -30 | -20,50835083 | |
-27 | -32,51220636 | ||
67,5 | -12 | 67,92873883 | |
67,5 | -27 | -36,83925888 | |
4,5 | -87 | -365,0802037 | |
-49 | -214,2252598 | ||
58,5 | -29 | -38,38206328 | |
-35 | -89,74960806 | ||
76,5 | -25 | -40,08020104 | |
-97 | -534,0446786 | ||
-64 | -304,0461209 | ||
-62 | -226,1294095 | ||
31,5 | -86 | -401,1559593 | |
-84 | -434,7973033 | ||
40,5 | -92 | -454,9618916 | |
4,5 | -65 | -216,2293141 | |
-87 | -385,8604148 | ||
22,5 | -52 | -146,7915814 | |
58,5 | -59 | -249,7164027 | |
-88 | -473,5142786 | ||
22,5 | -41 | -70,05208563 | |
-91 | -427,0390642 | ||
85,5 | -67 | -346,4849361 | |
67,5 | -63 | -294,7714893 | |
22,5 | -73 | -294,7595001 | |
-97 | -438,6091208 | ||
-48 | -208,5582177 | ||
49,5 | -67 | -292,583516 |
()
- . ( , Xi(1)=1), (30).
: (303) , (330) , ( 33) . Exel , , F2 + Ctrl-Shift-Enter. (33) :
(*)(-1) | ||
0,5826 | -0,0049 | 0,0051 |
-0,0049 | 0,0001 | 0,0000 |
0,0051 | 0,0000 | 0,0001 |
.
) β1, β2, β3
, , :
, - , . () i. :
- (*)^-1** | |
250,0883345 | |
-1,493117693 | |
7,002030678 |
- . :
() R2
, :
|
|
RSS, TSS. i (),
. , ( Exel), :
1. RSS = 833885,7
2. TSS = 833985,4
3. R2 = RSS/TSS = 0,999880425
() -
:
) , :
, ,
- Exel; : . In, . :
V^(β^)=(*)(-1) * σ2 * In | ||
2,151922 | -0,018124108 | 0,018896402 |
-0,01812 | 0,00024075 | -0,000102932 |
0,018896 | -0,000102932 | 0,000231046 |
)
:
, - . SE, :
SE (B1^) | 1,466943045 |
SE (B2^) | 0,015516113 |
SE (B3^) | 0,015200213 |
() Gretl,
, ()()
Exel Gretl. , . , "" " ", :