Okuqukethwe
Enye yezindlela ezivame ukusetshenziswa ezibalweni zokutadisha idatha ukuhlaziya ukuhlobana, okungasetshenziswa ukunquma umthelela wenani elilodwa kwelinye. Ake sibone ukuthi lokhu kuhlaziya kungenziwa kanjani ku-Excel.
Inhloso yokuhlaziya ukuhlobana
Ukuhlaziywa kokuhlobana kukuvumela ukuthi uthole ukuncika kwenkomba eyodwa kwenye, futhi uma kutholakala, bala i-coefficient yokuhlanganisa (izinga lobudlelwano), elingathatha amanani ukusuka ku -1 kuye ku +1:
- uma i-coefficient inegethivu, ukuncika kuphambene, okungukuthi ukunyuka kwevelu eyodwa kuholela ekwehleni kwelinye futhi ngokuphambene nalokho.
- uma i-coefficient iphozithivu, ukuncika kuqondile, okungukuthi ukwanda kwenkomba eyodwa kuholela ekwenyukeni kwesibili nokuphambene.
Amandla okuncika anqunywa imodulus ye-coefficient yokuxhumanisa. Uma inani likhulu, uguquko lwenani elilodwa luba nomthelela kwelinye. Ngokusekelwe kulokhu, nge-coefficient engu-zero, kungaphikiswana ngokuthi abukho ubuhlobo.
Ukwenza ukuhlaziya kokuhlobana
Ukuze ufunde futhi uqonde kangcono ukuhlaziywa kokuhlobana, ake sikuzame kuthebula elingezansi.
Nansi idatha yezinga lokushisa lansuku zonke kanye nokuswakama okumaphakathi kwezinyanga zonyaka. Umsebenzi wethu ukuthola ukuthi ngabe bukhona yini ubudlelwano phakathi kwale mingcele futhi, uma kunjalo, buqine kangakanani.
Indlela 1: Sebenzisa Umsebenzi we-CORREL
I-Excel ihlinzeka ngomsebenzi okhethekile okuvumela ukuthi wenze ukuhlaziya kokuhlanganisa - I-CORREL. I-syntax yayo ibukeka kanje:
КОРРЕЛ(массив1;массив2).
Inqubo yokusebenza ngaleli thuluzi imi kanje:
- Sivuka kuseli lamahhala lethebula lapho sihlela ukubala khona i-coefficient yokuxhumanisa. Bese uchofoza isithonjana "fx (Faka umsebenzi)" kwesokunxele sebha yefomula.
- Ewindini elivuliwe lokufaka umsebenzi, khetha isigaba "Izibalo" (noma “Uhlu oluphelele lwama-alfabhethi”), phakathi kwezinketho ezihlongozwayo esiziqaphelayo "CORREL" bese uchofoza OK.
- Iwindi lezimpikiswano zomsebenzi lizovezwa esikrinini ngekhesa endaweni yokuqala ephambene "Uhlu 1". Lapha sibonisa izixhumanisi zamaseli ekholomu yokuqala (ngaphandle kwesihloko sethebula), idatha okufanele ihlaziywe (kithi, B2:B13). Ungakwenza lokhu mathupha ngokuthayipha izinhlamvu ozifunayo usebenzisa ikhibhodi. Ungakwazi futhi ukukhetha ububanzi obudingekayo ngokuqondile kuthebula ngokwalo ngokucindezela inkinobho yegundane engakwesokunxele. Bese sidlulela empikiswano yesibili "Uhlu 2", ngokuchofoza nje ngaphakathi kwenkundla efanele noma ngokucindezela inkinobho Ithebhu. Lapha sibonisa izixhumanisi zobubanzi bamaseli wekholomu yesibili ehlaziywe (ethebulani lethu, lokhu C2:C13). Chofoza uma usulungile OK.
- Sithola i-coefficient yokuxhumanisa kuseli nomsebenzi. Incazelo "-0,63" ibonisa ubudlelwano obuphambene obuqinile phakathi kwedatha ehlaziywe.
Indlela 2: Sebenzisa “Ikhithi yamathuluzi okuhlaziya”
Enye indlela yokwenza ukuhlaziya ukuhlobana iwukusebenzisa "Ukuhlaziywa kwephakheji", okumele iqale inikwe amandla. Kwalokhu:
- Iya kumenyu "Fayela".
- Khetha into ohlwini olungakwesokunxele "Amapharamitha".
- Ewindini elivelayo, chofoza isigatshana "Izengezo". Bese engxenyeni engakwesokudla yefasitela ezansi kakhulu ngepharamitha "Ukulawula" Khetha "Izengezo ze-Excel" bese uchofoza "Hamba".
- Efasiteleni elivulekayo, maka "Iphakheji Yokuhlaziya" bese uqinisekisa isenzo ngokucindezela inkinobho OK.
Konke sekumi ngomumo, "Iphakheji Yokuhlaziya" yenziwe yasebenza. Manje sesingadlulela emsebenzini wethu oyinhloko:
- Cindezela inkinobho "Ukuhlaziywa kwedatha", ekuthebhu "Idatha".
- Kuzovela iwindi elinohlu lwezinketho zokuhlaziya ezitholakalayo. Siyagubha "Ukuhlobana" bese uchofoza OK.
- Iwindi lizovela esikrinini lapho kufanele ucacise imingcele elandelayo:
- "Isikhawu Sokufaka". Sikhetha lonke uhla lwamaseli ahlaziywe (okungukuthi, womabili amakholomu ngesikhathi esisodwa, hhayi elilodwa ngesikhathi, njengoba kwakunjalo endleleni echazwe ngenhla).
- “Ukwenza iqembu”. Kunezinketho ezimbili ongakhetha kuzo: ngamakholomu nemigqa. Esimweni sethu, inketho yokuqala ifanelekile, ngoba. yile ndlela idatha ehlaziywe etholakala ngayo kuthebula. Uma izihloko zifakiwe ebangeni elikhethiwe, khetha ibhokisi eliseduze kokuthi “Amalebula emgqeni wokuqala”.
- "Izinketho Zokukhiphayo". Ungakhetha inketho "Phuma Isikhawu", kulokhu imiphumela yokuhlaziywa izofakwa eshidini lamanje (uzodinga ukucacisa ikheli leseli lapho imiphumela izoboniswa khona). Kuphinde kuphakanyiswe ukuthi imiphumela ibonakale eshidini elisha noma ebhukwini elisha (idatha izofakwa ekuqaleni, okungukuthi kusukela kuseli. (A1). Njengesibonelo, siyahamba “Ishidi Lokusebenza Elisha” (kukhethwe ngokuzenzakalelayo).
- Uma yonke into isilungile, chofoza OK.
- Sithola i-coefficient yokuhlanganisa efanayo nasendleleni yokuqala. Lokhu kusikisela ukuthi kuzo zombili izimo senze konke ngendlela efanele.
Isiphetho
Ngakho-ke, ukwenza ukuhlaziywa kokuhlobanisa ku-Excel kuyinqubo ezenzakalelayo futhi kulula ukuyifunda. Odinga ukukwazi ukuthi ungathola kuphi futhi kanjani ukusetha ithuluzi elidingekayo, futhi esimweni "iphakethe lesixazululo", ukuthi ungayenza kanjani isebenze, uma ngaphambi kwalokho ibingakanikwa amandla kuzilungiselelo zohlelo.