Ukuze unqume izinga lokuxhomekeka phakathi kwezinkomba eziningana, ama-coefficients amaningi wokulungiswa asetshenzisiwe. Bese bancishiselwa etafuleni elihlukile, elinalo igama le-matrix yokulungiswa. Amagama emigqa namakholomu we-matrix anjalo ngamagama wemingcele, ukuxhomeka komunye nomunye lapho kusungulwa khona. Emkhakheni wezinhla kanye namakholomu yizingqinamba ezihambisanayo zokulungiswa. Ake sithole ukuthi singakwenza kanjani lokhu ngamathuluzi we-Excel.
Bheka futhi: Ukuhlaziywa kwe-Correlation ku-Excel
Ukubalwa kwe-coefficient multiple correlation
Yamukelwa ngalendlela elandelayo ukucacisa izinga lokungalingani phakathi kwezinkomba ezihlukahlukene, kuye ngokulingana kokulingana:
- 0 - 0.3 - akukho uxhumano;
- 0.3 - 0.5 - uxhumano lubuthakathaka;
- 0.5 - 0.7 - isibopho esiphakathi;
- 0.7 - 0.9 - phezulu;
- 0.9 - 1 - inamandla kakhulu.
Uma i-coefficient yokuhlanganiswa ingalungile, kusho ukuthi ubudlelwane bemingcele buyinto engafani.
Ukuze udale i-matrix yokulungisa ku-Excel, ithuluzi elilodwa lisetshenzisiwe, elifakwe kuphakheji. "Ukuhlaziywa kwedatha". Ubizwa - "Ukulungiswa". Ake sithole ukuthi singasetshenziswa kanjani ukubala izinkomba eziningi zokulungisa.
Isigaba 1: ukusebenza kwephakheji yokuhlaziywa
Masinyane kumele ngithi iphakheji elizenzakalelayo "Ukuhlaziywa kwedatha" ukhutshaziwe. Ngakho-ke, ngaphambi kokuqhubeka nenqubo yokubala ngokuqondile ama-coefficients wokulungisa, kuyadingeka ukuyisebenzise. Ngeshwa, akuwona wonke umsebenzisi owazi ukukwenza. Ngakho-ke, sizogxila kulo magazini.
- Iya kuthebhu "Ifayela". Emenyu yangakwesokunxele yefasitela evula emva kwalokho, chofoza entweni "Izinketho".
- Ngemuva kokuqalisa iwindi lemingcele ngokusebenzisa imenyu yayo yokuma kwesokunxele, iya kusigaba Engeza-ons. Kukhona insimu ekugcineni kwesokudla kwesokudla kwewindi. "Ukuphathwa". Hlela kabusha ukushintshela kuyo kusikhundla Faka i-Exceluma enye ipharamitha iboniswa. Ngemuva kwalokho sichofoza inkinobho. "Hamba ..."ngakwesokudla kwenkambu ecacisiwe.
- Iwindi elincane liqala. Engeza-ons. Hlola ibhokisi eceleni kwepharamitha "I-Package Analysis". Khona-ke ngakwesokudla kweswindi chofoza inkinobho. "Kulungile".
Ngemuva kwephakheji lesenzo esicacisiwe samathuluzi "Ukuhlaziywa kwedatha" izosebenza.
Isigaba sesi-2: ukulingana kokulingana
Manje ungaqhubeka ngqo ekubalweni kwe-coefficient multiple correlation. Ake sisebenzise isibonelo setafula lezinkomba ezilandelayo zomkhiqizo wezabasebenzi, isilinganiso se-capital-labor kanye namandla-amandla emabhizinisini ahlukene ukuze kubalwe ukulingana okuhlangene okuhlangene kwalezi zici.
- Hambisa kuthebhu "Idatha". Njengoba ungabona, ibhulogi elisha lamathuluzi livele kuthebhu. "Ukuhlaziywa". Sichofoza inkinobho "Ukuhlaziywa kwedatha"esitholakala kuwo.
- Iwindi livula ukuthi libizwa ngegama. "Ukuhlaziywa kwedatha". Khetha ohlwini lwamathuluzi akhona kuwo, igama "Ukulungiswa". Emva kwalokho chofoza inkinobho "Kulungile" ngakwesokudla kwes window esibonakalayo.
- Iwindi lesithuluzi livuleka. "Ukulungiswa". Ensimini "Isikhathi sokufaka" Ikheli lobubanzi betafula lapho imininingwane yezinto ezintathu ezifundwayo ezitholakala kufanele ifakwe: isilinganiso samandla-to-labor, isilinganiso senzuzo kanye nokukhiqiza. Ungenza ukufaka amabhukhamakhi okubhaliwe, kodwa kulula ukusetha isikhombisi ensimini futhi, ubambe inkinobho yegundane lesokunxele, khetha indawo ehambelana nayo etafuleni. Ngemuva kwalokho, ikheli lebanga lizoboniswa ebhokisini lebhokisi "Ukulungiswa".
Njengoba sinezici eziphulwe ngamakholomu, hhayi ngemigqa, kupharamitha "Ukuqoqa" setha inkinobho ukuma "Ngamakholomu". Nokho, sekuvele kufakwe lapho ngokuzenzakalelayo. Ngakho-ke, ihlala kuphela ukuqinisekisa ukufaneleka kwendawo yayo.
Indawo eseduzane "Amathegi eyokuqala" uphawu aludingeki. Ngakho-ke, sizokweqa le parameter, ngoba ngeke kuthinte isimo esijwayelekile sokubala.
Ebhokisini lesethingi "I-Parameter yokuphuma" Kumele kuboniswe ngqo lapho i-matrix yethu yokulungiswa khona izotholakala khona, lapho umphumela wokubala uboniswa khona. Izinketho ezintathu ziyatholakala:
- Incwadi entsha (enye ifayela);
- Ishidi elisha (uma ufisa, ungalipha igama ensimini ekhethekile);
- Ububanzi beshidi langamanje.
Ake sikhethe okukhethwa kukho kokugcina. Hambisa ukushintshela "Isikhala sokuPhuma". Kulesi simo, ensimini ehambelanayo, kumele ucacise ikheli lobubanzi be-matrix, noma okungenani iseli elingenhla elingakwesokunxele. Setha isikhangiso endle bese uchofoza esitokeni kushidi, esilungiselela ukwenza ingxenye ephezulu kwesokunxele ebangeni lokukhishwa kwedatha.
Ngemuva kokuthi wenze konke okushiwo ngenhla, konke okusele ukuchofoza inkinobho. "Kulungile" ngakwesokudla kwes window "Ukulungiswa".
- Ngemuva kwesenzo sokugcina, i-Excel yakha umthamo wokulungisa, ukuwugcwalisa ngemininingwane ebangeni elichazwe ngumsebenzisi.
Isigaba 3: ukuhlaziywa komphumela
Manje ake sibone ukuthi singawuqonda kanjani umphumela esiwutholile ngesikhathi sesebenzisa ithuluzi lokucubungula idatha "Ukulungiswa" ku-Excel.
Njengoba sibona kusukela etafuleni, isilinganiso sokuhlanganiswa kwesilinganiso se-capital-labor (Ikholomu 2) nokunikezwa kwamandla (Ikholomu 1) ngu-0.92, okuhambisana nobuhlobo obunamandla kakhulu. Phakathi komkhiqizo womsebenzi (Ikholomu 3) nokunikezwa kwamandla (Ikholomu 1) Lesi sibonakaliso silingana no-0.72, okuyizinga eliphezulu lokuthembela. Ukulingana kokulingana phakathi kokukhiqiza komsebenzi (Ikholomu 3) kanye nesilinganiso senani-labasebenzi (Ikholomu 2) elilingana no-0.88, eliphinde lihambelane nezinga eliphezulu lokuthembela. Ngakho-ke, kungashiwo ukuthi ukuthembela phakathi kwazo zonke izici ezifundwayo kungalandelwa kakhulu.
Njengoba ungabona, iphakheji "Ukuhlaziywa kwedatha" Ku-Excel kuyithuluzi elilula kakhulu futhi elisebenziseka kalula lokunquma ukulingana okuhlangene okuningi. Ngosizo lwakhe, ungenza isibalo kanye nokulingana okuvamile phakathi kwezici ezimbili.
