JUFT KORRELYATSION TAHLIL(Amaliy)Ishdan maqsad: Microsoft Excel dasturiy ta’minoti yordamida natijaviy va omil belgilar o’rtasidagi bog’lanish zichligini aniqlash, model qurishda omillarni tanlash masalalarini o’rganish. Topshiriq: Quyida shartli ma’lumotlar berilgan.Vaqt, Sotish hajmi, mln. so‘m, Reklama xarajatlari, mln. so‘m, Maxsulot birligi bahosi, Raqobatchining bir birlik mahsuloti bahosi, Iste’mol xarajatlari indeksi, 11264,015,017,0100,021374,814,817,398,431483,815,216,8101,241918,715,516,2103,552748,215,516,0104,163709,716,018,0107,0743214,718,120,2107,4844518,713,015,8108,5936719,815,818,2108,31036710,616,916,8109,2113218,616,317,0110,1123076,516,118,3110,71333112,615,416,4110,3143456,515,716,2111,8153645,816,017,7112,3163845,715,116,2112,91) Korrelyatsiya matritsasini tuzing.2) Modelda qatnashadigan omil belgilar haqida xulosa qiling. Ishni bajarish tartibi:Ushbu topshiriqni Microsoft Excel dasturi yordamida bajaramiz.1) Birinchi topshiriqni bajarish uchun o’zgaruvchilar qiymatlarini, avval natijaviy belgi, keyin omil belgilar ma’lumotlarini tartib bilan kiritib chiqamiz: