Gretl MS Office Excel
1
.
658.
Gretl Ms Office Excel. / . .., .., .. - : - , 2008. - 20 .
Gretl . .
Gretl.
, ( ____ _______________2008 .)
-
:
-
.. 1
. 1
1. . 4
2. Gretl. 10
5. .. 19
..27
7. 28
: Gretl MS Office Excel .
:
- . , ;
- , , ;
- , ;
- ;
- ;
- ;
- Gretl.
. ( ) X. .
N X (). :
|
|
1. :
(1)
() . (, ), . , . ( ), .
2. , . . . :
(2)
3. () :
(3)
‑ () .
.
4. ‑ , . , .
. . ak (k=1,..., 2*m+1) , . , : am+1. , :
(4)
5. ‑ (), .
6. ‑ , . , . :
(5)
σ () ;
‑ .
, , .
7. ‑ . :
(6)
‑ ;
‑ ;
E(t) ‑ t.
, .
, .
, , .
8. [1] ( 1905 .). :
(7)
‑ ;
‑ , .
, :
(8)
N .
(9)
, , . , , .
|
|
9. , () .
, 23, p =.05 19 27 , , 95% 19 27. p-, , , . , (.. ), .
, . , . , , , , N 100.
10. ( r) , .. .
, , . , .
, , , .
.
, (. 1-3). , . , ( Y) . , , .
, , , .
:
(10)
‑ Y;
‑ X;
‑ Y.
-1 +1. , .
, , 1.
Y ( . . price ‑ ).
, .. , ‑ Q ( . . quantity ‑ , ).
1.1
, ‑1, .. .
, , 2.
1. 2.
, +1, .. .
, , (. 3).
Y m5 . . .
m6 . . .
0,22. .. .
|
|
1.3 , . .
11. , , .
4.
1 , .
1.1
1.4
Y .
.
2. Gretl
:
1. , , .
2. .
.
, View Summary statistics.
Summary statistics ( profit - sales) 1.1.
2.1 Summary Statistics.
2.1. :
MEAN ;
MEDIAN ;
MIN MAX .
S.D. ;
C.V. -
SKEW
EXCKURT .
2.2. . : view > Correlation matrix. :
2.2 - Correlation matrix.
(Selected vars) profit, sales. :
2.3.
(. 2.2.) , (. 2.4).
2.4.
2.3. . Gretl :
2.3.1. x- graph ( ) . . (. 2.5)
2.5 .
2.3.2 View Graph specified vars
:
Time series plot (. 2.6)
2.6 .
x-y scatter ( 2.5)
x-y with impulses - (.. )
.
2.3.3. View Multiply graphs .
2.7 , .
:
- X, Y.
|
|
- OK Enter.
( Copy to clipboard).
2.4. , , : Variable frequence plot , 2.8
2.8 frequency distribution.
Number of bins .
Minimum value, left bin bin width .
Show data only
Show normal distribution .
Show gamma distribution -.
gretl 2.9.
2.9 .
, Gretl, "", . , .