Mmt-91 I akhmedov Nematbek

MMT-91 I Akhmedov Nematbek

№	Yillar	Aholining umumiy daromad solig'i (mln.so'm) (y)	Iqtisodiyotda band aholining soni (ming kishi) (x1)	Ishsizlar soni (ming kishi) (x2)
1	2003	1 795	9 589	32
2	2004	1 815	9 911	35
3	2005	1 837	10 196	28
4	2006	1 857	10 467	26
5	2007	1 882	10 735	564
6	2008	1 911	11 035	568
7	2009	1 943	11 328	601
8	2010	1 976	11 628	658
9	2011	2 056	11 919	622
10	2012	2 086	12 224	626
11	2013	2 117	12 523	640
12	2014	2 152	12 818	687
13	2015	2 190	13 058	709
14	2016	2 229	13 298	724
15	2017	2 267	13 520	837
16	2018	2 305	13 273	1 369
17	2019	2 347	13 541	1 335
18	2020	2 393	13 236	1 561
19	2021	2 439	13 539	1 442
20	2022	2 490	13 706	1 333

___ ____ ____ ____ ____ (R)

/__ / ____/ / ____/
___/ / /___/ / /___/ 14.0 Copyright 1985-2015 StataCorp LP
Statistics/Data Analysis StataCorp
4905 Lakeway Drive
Special Edition College Station, Texas 77845 USA
800-STATA-PC http://www.stata.com
979-696-4600 [e-mail]
979-696-4601 (fax)

30-student Stata lab perpetual license:

Serial number: 401406214627
Licensed to: Administrator
WIUT

Notes:
1. Unicode is supported; see help unicode_advice.

2. Maximum number of variables is set to 5000; see help set_maxvar.
3. New update available; type -update all-

. import excel "C:\Users\Lenovo\Desktop\Книга1.xlsx", sheet("Лист1") firstrow

. gen time=_n

. tsset time

time variable: time, 1 to 20
delta: 1 unit
cor y x1 x2
(obs=20)

| y x1 x2

-------------+---------------------------
y | 1.0000
x1 | 0.9569 1.0000
x2 | 0.9246 0.8693 1.0000
reg y x1 x2

Source | SS df MS Number of obs = 20

-------------+---------------------------------- F(2, 17) = 164.76
Model | 893344.967 2 446672.483 Prob > F = 0.0000
Residual | 46086.5701 17 2710.97471 R-squared = 0.9509
-------------+---------------------------------- Adj R-squared = 0.9452
Total | 939431.537 19 49443.7651 Root MSE = 52.067

------------------------------------------------------------------------------

y | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
x1 | .1016693 .0176277 5.77 0.000 .0644781 .1388605
x2 | .175252 .0501443 3.49 0.003 .0694568 .2810472
_cons | 750.3623 182.7657 4.11 0.001 364.7603 1135.964
tsline x1

. dfuller d1.x1

Dickey-Fuller test for unit root Number of obs = 18

---------- Interpolated Dickey-Fuller ---------
Test 1% Critical 5% Critical 10% Critical
Statistic Value Value Value
------------------------------------------------------------------------------
Z(t) -4.344 -3.750 -3.000 -2.630
------------------------------------------------------------------------------
MacKinnon approximate p-value for Z(t) = 0.0004
tsline d1.x1

. ac x1