Ызбекистон Республикаси

Bunga misol ko’ramiz:

Bir oilaning hususiy do’koni va tomorqasi bor. Oila boshliqlari otasi va onasi boshqa bir fermer ho’jaligida ishlaydi. Hususiy do’kondan keladigan sof foyda tomorqadan oladigan daromad, ota onalarining ish haqlari va oilaviy harajatlarga bog’liq. Olti oy mobaynida do’kondan oladigan sof foyda, tomorqa daromadi, ota va onani ish haqi va oilaviy harajat hisobi qayd etilgan. Hususiy do’kon sof foydasini tomorqadan oladigan daromad, ota onalarining ish haqlari va oilaviy harajatlarga bog’liqlik funksiyasini tuzing.
Qayd etilgan ko’rsatkichlar quyidagicha:

Tomorqa daromadi	Otaning ish haqi	Onaning ish haqi	Oilaviy harajat	Do’kon sof foydasi
100	50	35	20	25
150	56	45	24	22
140	62	40	28	28
200	60	48	26	29
190	70	52	30	30
210	68	50	24	25

Yechish:

Berilganlarni Excel jadvaliga yozamiz. Bu yerda n=6, m=4. Shunga mos holda,

yuqorida berilgan ko’rsatmadagi yacheyka adreslari qiymatlarini o’zgartiramiz va quyidagi natijaga ega bo’lamiz

100	50	35	20	25
150	56	45	24	22
140	62	40	28	28
200	60	48	26	29
190	70	52	30	30
210	68	50	24	25
0,780732	-0,480732	-0,015244	0,064024	18,72024
0,874417	0,914181	0,585089	0,13492	21,68904
0,624851	4,131497	#Н/Д	#Н/Д	#Н/Д
0,416402	1	#Н/Д	#Н/Д	#Н/Д
28,43073	17,06927	#Н/Д	#Н/Д	#Н/Д

Funksiya ko'rinishi

y= 0,064024 *X1+ -0,015244 *X2+ -0,481 *X3+ 0,781 *X4+ 18,72


^{S= cумм(v2 )=} 17,06927
r2= 0,624851
Prognoz, agar:
tomorqa daromadi 50
otani ish haqi 100
onani ish haqi 80
oilaviy harajati 30
bo'lsa, do'kon sof foydasi 5,360488
Izoh: # Н/Д - ma’lumot yo’q ekanligini bildiradi.
Determinatsiya koeffisientiga qaraganda hususiy do’kon sof foydasi tomorqadan oladigan daromad, ota-ona ish haqi va oila harajatiga sezilarli darajada bog’liq ekan. Tuzilgan funksiyadan prognoz uchun foydalanish mumkin. Bu ma’lumot 62% ishonchli.
Masalan, yuqoridagi jadvalda tomorqadan oladigan daromad X1=50, otaning ish haqi X2=100, onaning ish haqi X3=80, oilaviy harajat X4=30 bo’lsa, hususiy do’kondan oladigan sof foyda qanday bo’ladi degan savolga berilgan javob 5,360488ga 62% ishonish mumkin.

Mustaqil bajarish uchun topshiriqlar

1)	Y	^X1	^X2	5)		Y		^X1		^X2		^X3
	22	19	98			28		95		88		5
	29	29	68			35		97		86		21
	35	35	66			45		85		74		29
	39	32	59			59		81		71		35
	48	39	44			66		77		69		39
	58	44	38			69		51		61		56
	54	51	33			68		46		55		61
	66	60	20			77		45		51		67
2)	Y	^X1	^X2		6)		Y		^X1		^X2		^X3
	12	54	43				121		29		99		24
	15	45	41				135		38		91		29
	21	46	39				158		44		89		28
	20	40	40				166		49		82		33

	26	37	32		174	61	76	39
	29	33	22		175	66	71	41
	33	31	20		188	84	55	49
	35	20	16		191	88	51	48
3)	Y	^X1	^X2	7)	Y	^X1	^X2	^X3
	68	22	145		214	64	147	66
	71	28	122		224	78	124	68
	77	33	114		256	98	101	69
	85	39	116		312	114	91	79
	91	35	100		354	128	88	82
	96	44	96		408	129	84	91
	99	49	92		445	162	75	96
	101	50	81		465	192	36	123
4)	Y	^X1	^X2	8)	Y	^X1	^X2	^X3
	11	81	32		51	325	24	46
	19	75	24		59	318	28	49
	28	72	21		69	295	36	58
	35	66	19		77	298	49	65
	36	61	15		84	268	51	62
	41	51	11		89	251	52	78
	47	48	12		99	199	66	81
	81	40	5		100	125	69	91

9)	Y	^X1	^X2	^X3	^X4	13)	Y	^X1	^X2	^X3	^X4	^X5
	142	59	43	24	118		265	10	3	100	20	60
	154	61	41	29	145		270	11	2	110	22	65
	158	69	39	38	164		280	12	1	120	24	70
	164	68	40	44	166		55	79	94	47	16	14
	168	77	32	49	178		97	13	89	46	26	29
	171	84	22	55	187		61	24	15	57	11	10
	181	94	20	59	194		74	08	27	49	81	57
	199	96	16	69	200		260	9	4	90	18	55
10)	Y	^X1	^X2	^X3	^X4	14)	Y	X1	X2	X3	X4	X5
	47	98	4	81	32		25	14	22	59	48	19
	49	84	15	75	24		48	46	51	56	58	77
	55	81	24	72	21		64	78	88	52	54	82
	58	80	29	66	19		55	79	94	47	16	14
	66	74	64	61	15		97	13	89	46	26	29
	69	71	69	51	11		61	24	15	57	11	10
	78	70	74	48	12		74	08	27	49	81	57
	79	35	81	40	5		23	53	29	71	53	81

11)	Y	X1	X2	X3	X4	X5	15)	Y	^X1	^X2	^X3	^X4
	55	14	2	8	-4	0		99	24	81	54	43
	57	46	3	7	-3	-1		91	29	75	45	41
	61	78	4	6	-2	-2		89	28	72	46	39
	66	79	5	5	-1	-3		82	33	66	40	40
	67	13	6	4	0	-4		76	39	61	37	32
	70	24	7	3	1	-5		71	41	51	33	22
	74	08	8	2	2	-6		55	49	48	31	20
	76	53	9	1	3	-7		51	48	40	20	16
12)	Y	X1	X2	X3	X4	X5	16)	Y	^X1	^X2	^X3	^X4
	200	1	12	10	2	5		28	54	2	154	178
	215	2	11	20	4	10		33	45	8	150	158
	220	3	10	30	6	15		65	46	19	144	154
	230	4	9	40	8	20		64	40	25	143	151
	235	5	8	50	10	25		69	37	29	125	142
	240	6	7	60	12	30		77	33	36	120	140
	250	7	6	70	14	40		79	31	39	113	122
	255	8	5	80	16	50		88	20	44	111	120

12.