Ukuhlaziywa kwe-correlation kuyindlela ethandwayo yocwaningo lwezibalo, esetshenziselwa ukukhomba izinga lokuxhomekeka kwesikhombi kwesinye kwesinye. I-Microsoft Excel inethuluzi elikhethekile elenzelwe ukwenza lolu hlobo lokuhlaziya. Ake sibheke ukuthi singasisebenzisa kanjani lesi sici.
Umnyombo wokuhlaziywa kokuhlobana
Inhloso yokuhlaziywa kokuhlobanisa ukukhomba ubukhona bokuxhomekeka phakathi kwezinto ezahlukahlukene. Lokho wukuthi, kunqunywa ukuthi ngabe ukwehla noma ukwanda kwesikhombi esisodwa kuthinta ushintsho kwesinye.
Uma ukuxhomekeka kumisiwe, khona-ke ukuvumelana kokuhlanganisa kunqunywa. Ngokungafani nokuhlaziywa kokubhalwa phansi, lokhu kuyinkomba kuphela yokuthi le ndlela yokucwaninga kwezibalo ibalwa. I-fitlation fitlation ihluka kusuka ku- +1 kuya -1. Lapho kukhona ukuxhumana okuhle, ukwanda kwesikhombi esisodwa kunomthelela ekwandeni kwesibili. Ngokuxhunyaniswa okungekuhle, ukwanda kwesikhombi esisodwa kufaka ukwehla kwesinye. Lapho kukhulu imodulus ye-coatffee eyanele, okubonakalayo kakhulu ukushintshwa kwenkomba eyodwa kuthinta ushintsho kwesesibili. Lapho i-coefficient ingu-0, ukuncika phakathi kwabo akukho ngokuphelele.
Ukubalwa kwethala lokuhlobanisa
Manje ake sizame ukubala isilinganiso sokuhlanganiswa usebenzisa isibonelo esithile. Sinethebula lapho izindleko zanyanga zonke zokukhangisa kanye nevolumu yokuthengisa zibhalwe khona kukholamu ehlukile. Kufanele sithole isilinganiso sokuncika kwenani lokuthengisa ngenani lemali elachithwa ekukhangiseni.
Indlela yoku-1: nquma ukuhlangana ngokusebenzisa I-Wizard Yomsebenzi
Enye yezindlela okungenziwa ngayo ukuhlaziywa kokuhlobanisa ukusebenzisa umsebenzi we-CORREL. Umsebenzi uqobo unokubuka okujwayelekile CORREL (uhlu1; uhlu2).
- Khetha iseli lapho umphumela wokubala kufanele uboniswe khona. Chofoza inkinobho "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.
- Kuluhlu olwethulwe ngewindows Workiz Wizard, sesha bese ukhetha umsebenzi ISITOLO. Chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana ngomsebenzi liyavula. Ensimini "I-Array1" faka izixhumanisi zobubanzi beseli enye yamanani, ukuncika kwako okufanele kunqunywe. Esimweni sethu, lawa kuzoba amanani kwikholomu "Yezokuthengisa". Ukuze ufake ikheli lamalungu afanayo enkambu, simane sikhethe wonke amaseli anemininingwane kwikholamu engenhla.
Ensimini Array2 udinga ukufaka izixhumanisi zekholamu yesibili. Sinazo izindleko zokukhangisa. Ngendlela efanayo nasecaleni elidlule, sifaka idatha enkundleni.
Chofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, ukuvumelana kokuhlangana kwesimo senombolo kuvela kuseli elikhethiwe ngaphambili. Kulokhu, yi-0.97, okuyisibonakaliso esiphakeme kakhulu sokuncika kwenani elithile kwelinye.
Indlela 2: ukubala ukuxhumana usebenzisa iphakethe lokuhlaziywa
Ngaphezu kwalokho, ukuhlangana kungabalwa kusetshenziswa elinye lamathuluzi, elivezwe kwiphakheji lokuhlaziya. Kepha okokuqala kudingeka sisebenzise leli thuluzi.
- Iya kuthebhu Ifayela.
- Ewindini elivulayo, dlulela esigabeni "Izinketho".
- Okulandelayo, iya ku "Okengezwayo".
- Ngezansi kwewindi elilandelayo esigabeni "Abaphathi" hambisa switch uye esikhundleni I-Excel-Ins-Insuma esesimweni esehlukile. Chofoza inkinobho "Kulungile".
- Kuwindi lezengezo, hlola ibhokisi eliseduze Iphakheji Yokuhlaziya. Chofoza inkinobho "Kulungile".
- Ngemuva kwalokho, iphakheji lokuhlaziywa lisebenza. Iya kuthebhu "Idatha". Njengoba ukwazi ukubona, lapha ethepheni kuvela ibhulokhi entsha yamathuluzi - "Ukuhlaziywa". Chofoza inkinobho "Ukuhlaziywa kwedatha"etholakala kuyo.
- Uhlu luqala ngezinketho ezahlukahlukene zokuhlaziywa kwedatha. Khetha into Ukuhlangana. Chofoza inkinobho "Kulungile".
- Iwindi livuleka ngamapharamitha wokuhlaziywa kokuhlangana. Ngokungafani nendlela yangaphambilini, enkundleni Isikhawu sokufaka sifaka isikhathi sokuphumula hhayi kukholamu ngalinye ngokwehlukana, kodwa kuwo wonke amakholomu abamba iqhaza ekuhlaziyeni. Esimweni sethu, lena idatha esekholamu "Izindleko Zokukhangisa" kanye "Inani Lokuthengisa".
Ipharamitha "Ukuhlanganisa amaqembu" shiya singashintshiwe - Ikholomu ngekholamu, ngoba amaqembu ethu wedatha ahlukaniswe ngamakholomu amabili. Uma bephuke umugqa ngomugqa, lapho-ke switch kufanele idluliselwe esikhundleni Umugqa ngomugqa.
Ezikhethweni zokukhipha, okuzenzakalelayo kusethelwe kuzo "Ishidi lokusebenzela elisha", okungukuthi, imininingwane izokhonjiswa kwelinye iphepha. Ungashintsha indawo ngokuhambisa switch. Lokhu kungaba ishidi lamanje (lapho uzodinga ukucacisa izixhumanisi zamaseli wokukhishwa kolwazi) noma incwadi yokusebenza entsha (ifayela).
Lapho wonke amasethingi esethiwe, chofoza inkinobho "Kulungile".
Njengoba indawo lapho ukuphuma kwemiphumela yokuhlaziya kushiywe khona ngokuzenzakalelayo, sithuthela ekhasini elisha. Njengoba ukwazi ukubona, ukuvumelana kokuhlangana kukhonjisiwe lapha. Ngokwemvelo, kuyafana nalapho usebenzisa indlela yokuqala - 0.97. Lokhu kungenxa yokuthi zombili izinketho zenza izibalo ezifanayo, zingenziwa ngezindlela ezihlukile.
Njengoba ukwazi ukubona, uhlelo lokusebenza lwe-Excel lunikeza izindlela ezimbili zokuhlaziywa kokuhlobana ngasikhathi sinye. Umphumela wezibalo, uma wenza konke kahle, kuzofana ngokuphelele. Kepha, umsebenzisi ngamunye angakhetha inketho elula kakhudlwana kuye ukufeza ukubala.
