-BO’LIM. AMALIY HISOB QISMI

2-BO’LIM. AMALIY HISOB QISMI
REGRESSION VA KORRELYATSION TAHLIL
I. BOSHLANG’ICH MA’LUMOTLAR (TAJRIBA NATIJALARI).
1.1) Passiv tajriba natijalari (2.1-jadval)
2.1-jadval.
№
|
x1
|
x2
|
x3
|
y1
|
y2
|
1
|
44,04620499
|
2,560345763
|
83,7088242
|
34,1935319
|
10,71599252
|
2
|
43,51324199
|
2,764336378
|
83,2582542
|
33,6758833
|
9,78668952
|
3
|
44,34095341
|
2,765347488
|
84,1290242
|
33,5737833
|
10,77609252
|
4
|
46,12851309
|
2,835336473
|
84,8303342
|
34,1780833
|
11,31598452
|
5
|
43,11098646
|
3,025336841
|
83,9652842
|
33,1529533
|
10,81612952
|
6
|
44,54248704
|
2,885331488
|
84,9092542
|
34,2207719
|
10,83615952
|
7
|
43,20221396
|
2,745329904
|
84,7992742
|
33,3735833
|
11,18138452
|
8
|
44,87487588
|
2,895347542
|
85,7952942
|
33,5753933
|
12,01707377
|
9
|
42,57989756
|
2,719317237
|
83,0793142
|
33,7949019
|
10,81171372
|
10
|
42,78221378
|
2,625336387
|
85,1443042
|
33,1718574
|
11,30154143
|
11
|
43,34495373
|
2,545347378
|
83,1432642
|
33,4041021
|
9,81714952
|
12
|
44,54184454
|
2,805337215
|
84,5792742
|
33,6697523
|
10,81609252
|
13
|
45,6457424
|
2,895347413
|
85,9043342
|
33,9347313
|
11,81138452
|
14
|
48,54620499
|
2,785295904
|
89,1893142
|
35,1747103
|
15,47771372
|
15
|
44,84620499
|
2,752118913
|
85,3432842
|
33,9759827
|
10,80949593
|
16
|
44,24620499
|
2,93878306
|
84,3589242
|
33,8723765
|
10,31745064
|
17
|
44,76591601
|
2,839798609
|
85,5292142
|
33,6451589
|
11,30759432
|
18
|
45,34312647
|
2,949399664
|
87,0991042
|
33,9150633
|
11,51698262
|
19
|
46,50207957
|
2,634698618
|
88,7494142
|
34,1725733
|
12,30152095
|
20
|
48,46620499
|
2,721698244
|
87,9157042
|
34,8541433
|
11,81588657
|
21
|
45,24620499
|
2,884956264
|
86,2138142
|
34,1743238
|
11,31609252
|
22
|
47,43620499
|
2,787289911
|
85,3198942
|
34,5548933
|
10,81609252
|
23
|
45,54620499
|
2,675032843
|
86,8271342
|
34,1753387
|
11,31609252
|
24
|
44,34620499
|
2,485396064
|
84,3001942
|
33,6629954
|
10,31609252
|
25
|
44,44185609
|
2,584734333
|
88,3791242
|
33,7341157
|
9,81609052
|
26
|
42,61057645
|
3,007299518
|
85,1459042
|
33,0631104
|
11,31609252
|
27
|
44,14016789
|
2,745338389
|
83,4590842
|
33,6243435
|
10,81609252
|
28
|
45,33176748
|
2,975345763
|
85,9459942
|
33,8047545
|
11,81609252
|
29
|
43,8455502
|
2,716345763
|
84,4690942
|
33,5829364
|
10,05609252
|
30
|
44,1424673
|
2,894345763
|
83,8952142
|
33,6550833
|
9,81609052
|
31
|
44,34485759
|
2,525345763
|
84,4397342
|
33,7783387
|
10,47609252
|
32
|
45,85167396
|
2,655345763
|
86,8193642
|
33,8630023
|
11,81609252
|
33
|
46,04057635
|
2,654345763
|
87,7515842
|
34,1694487
|
11,80822719
|
34
|
46,2406295
|
2,804255255
|
88,2189642
|
34,0436916
|
12,31211372
|
35
|
44,54462911
|
2,725320904
|
84,7297942
|
33,733903
|
10,31042354
|
36
|
47,99574499
|
2,625256337
|
87,1290742
|
34,6547381
|
11,53609252
|
37
|
44,94681211
|
2,505798619
|
85,8288042
|
33,7779583
|
11,31609252
|
38
|
44,74856735
|
2,444701061
|
85,2149142
|
33,8456287
|
10,61305104
|
39
|
48,32575374
|
2,694587359
|
86,4307242
|
34,8041917
|
11,53698253
|
40
|
44,2461973
|
2,505349375
|
84,1758342
|
33,8150235
|
10,33093727
|
41
|
45,08620499
|
2,445296076
|
85,4573542
|
33,9452493
|
10,61910239
|
42
|
45,65620499
|
2,615220864
|
86,0375867
|
34,2705787
|
10,81799607
|
43
|
48,48620499
|
2,997118942
|
88,1788312
|
34,8850233
|
11,31609252
|
44
|
46,50622625
|
2,841921949
|
85,9789022
|
34,3339498
|
10,81531372
|
45
|
44,14565625
|
2,622395564
|
84,0399442
|
33,7703346
|
11,31738277
|
46
|
45,04624512
|
2,895813242
|
85,7673242
|
34,1680898
|
10,79942873
|
47
|
42,6264521
|
3,056289893
|
83,0993242
|
33,274278
|
10,47532796
|
48
|
45,5453251
|
3,015307599
|
86,6053242
|
33,8145533
|
11,81170904
|
49
|
43,54310969
|
2,92531435
|
85,1693242
|
33,3695387
|
10,47218799
|
50
|
45,04641577
|
2,829367488
|
85,8402442
|
33,9046633
|
11,31451354
|
51
|
45,74620499
|
2,945267622
|
88,6588542
|
34,0251833
|
12,31528374
|
52
|
45,81520499
|
2,885347458
|
87,3327242
|
34,2647833
|
12,28710239
|
53
|
45,24620499
|
2,674784619
|
86,2911742
|
33,8750233
|
11,31531372
|
54
|
46,41620499
|
2,699207239
|
87,8161942
|
33,9740923
|
12,80254223
|
55
|
46,54592986
|
2,875299528
|
86,6748142
|
34,0731035
|
11,80138452
|
56
|
44,04574264
|
2,975396119
|
83,5648542
|
33,6638545
|
10,31211664
|
57
|
44,47624201
|
2,92520995
|
84,2191142
|
33,8730029
|
10,31570989
|
58
|
45,14185371
|
3,055399517
|
87,8493242
|
33,7742311
|
10,81548493
|
59
|
47,04675645
|
2,968333598
|
88,9088842
|
34,0445497
|
12,81071421
|
60
|
48,23620499
|
2,829345763
|
89,7293242
|
34,3839033
|
13,31562898
|
Quyidagi belgilashlarni kiritamiz:
- kirishda neft sarfi -
- kirishda neft bosimi -
- separatorda neft sarfi -
- chiqishda neft sarfi -
- chiqishda gaz sarfi -
№
|
Berilishi
|
Kirish yoki chiqish
|
Shartli belgilanishi
|
1
|
|
1-kirish faktori
|
|
2
|
|
2-kirish faktori
|
|
3
|
|
3-kirish faktori
|
|
4
|
|
1-chiqish kattaligi
|
|
5
|
|
2- chiqish kattaligi
|
|
II. JUFT REGRESSIYANING EMPERIK CHIZIG’INI QURISH
(1-bosqich: strukturaviy isentifikasiyalash masalasini yechish)
Tajriba natijalari asosida tanlanma ajratish
2.1) X1 va Y1 tanlanmasi
X1 ning qiymatlarini teng intervallarda bo’lib chiqamiz. Bunda X1 qiymatlari ichidagi min va mak qiymatlarini bilish zarur: min{X1}= 44,50722837; max{X1}= 47,64148072 .
Har bir interval uzunligini 0,5 ga teng deb olsak u holda X1 ning qiymatlari uchun quyidagi intervallarni olishimiz mumkin:
(40,5; 41), (41; 41,5), (41,5; 42), (42; 42,5), (42,5; 43), (43; 43,5), (43,5; 44), (44,44,5),
(44,5; 45); (45; 45,5), (45,5;46) va (46; 46,5)
Y1 ning qiymatlari uchun har bir intervalga mos keluvchi Y1 lar o’rtachasi olinadi.
Jadval tuzamiz. Bunda tajriba natijalarining 60 ta qiymatini Excel dasturiga kiritib, X1 bo’yicha usib borish tartibida tartiblaymiz (avval filtr o’rnatib, filtr ichida tartiblash kerak, aks holda X1 dan boshqa qolgan ustunlar o’zgarmay qoladi!!!)
x1
|
y1
|
44,50722837
|
33,90532
|
43,61856249
|
33,58244
|
43,41232907
|
33,51405
|
45,74424105
|
34,11232
|
44,30059942
|
33,66283
|
45,58918637
|
33,98334
|
46,0646355
|
34,26062
|
44,190283
|
33,65661
|
45,53594192
|
34,06488
|
45,83120499
|
33,92456
|
45,05244205
|
33,84605
|
47,64148072
|
34,21423
|
X1 va Y1 o’rtasidagi regressiya chizigini tasvirlaymiz:
ESLATMA! (40,5; 41) intervalda X1 va Y1ning 4 ta qiymati mos keladi. Y1 ning shu 4 ta qiymatining o’rtachasini olib X1=40,5 bo’lganda mos ravishda Y1=33,16135913 deb yozamiz.
|