Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel

Enye yezindlela ezivame ukusetshenziswa ezibalweni zokutadisha idatha ukuhlaziya ukuhlobana, okungasetshenziswa ukunquma umthelela wenani elilodwa kwelinye. Ake sibone ukuthi lokhu kuhlaziya kungenziwa kanjani ku-Excel.

Okuqukethwe

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.

Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel

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:

  1. Sivuka kuseli lamahhala lethebula lapho sihlela ukubala khona i-coefficient yokuxhumanisa. Bese uchofoza isithonjana "fx (Faka umsebenzi)" kwesokunxele sebha yefomula.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  2. Ewindini elivuliwe lokufaka umsebenzi, khetha isigaba "Izibalo" (noma “Uhlu oluphelele lwama-alfabhethi”), phakathi kwezinketho ezihlongozwayo esiziqaphelayo "CORREL" bese uchofoza OK.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  3. 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.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  4. Sithola i-coefficient yokuxhumanisa kuseli nomsebenzi. Incazelo "-0,63" ibonisa ubudlelwano obuphambene obuqinile phakathi kwedatha ehlaziywe.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel

Indlela 2: Sebenzisa “Ikhithi yamathuluzi okuhlaziya”

Enye indlela yokwenza ukuhlaziya ukuhlobana iwukusebenzisa "Ukuhlaziywa kwephakheji", okumele iqale inikwe amandla. Kwalokhu:

  1. Iya kumenyu "Fayela".Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  2. Khetha into ohlwini olungakwesokunxele "Amapharamitha".Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  3. Ewindini elivelayo, chofoza isigatshana "Izengezo". Bese engxenyeni engakwesokudla yefasitela ezansi kakhulu ngepharamitha "Ukulawula" Khetha "Izengezo ze-Excel" bese uchofoza "Hamba".Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  4. Efasiteleni elivulekayo, maka "Iphakheji Yokuhlaziya" bese uqinisekisa isenzo ngokucindezela inkinobho OK.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel

Konke sekumi ngomumo, "Iphakheji Yokuhlaziya" yenziwe yasebenza. Manje sesingadlulela emsebenzini wethu oyinhloko:

  1. Cindezela inkinobho "Ukuhlaziywa kwedatha", ekuthebhu "Idatha".Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  2. Kuzovela iwindi elinohlu lwezinketho zokuhlaziya ezitholakalayo. Siyagubha "Ukuhlobana" bese uchofoza OK.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  3. 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.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel
  4. Sithola i-coefficient yokuhlanganisa efanayo nasendleleni yokuqala. Lokhu kusikisela ukuthi kuzo zombili izimo senze konke ngendlela efanele.Isibonelo sokwenza ukuhlaziywa kokuhlobanisa ku-Excel

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.

shiya impendulo