Izindlela ezimbili zokuhlaziywa kwe-correlation ku-Microsoft Excel

Ukuhlaziywa kwe-Correlation - indlela evamile yokucwaninga ngezibalo, esetshenziselwa ukukhomba izinga lokuxhomekeka kwesinye isibonakaliso kwesinye. I-Microsoft Excel inethuluzi elikhethekile elenzelwe ukwenza lolu hlobo lokuhlaziywa. Ake sithole ukuthi singayisebenzisa kanjani lesi sici.

Okuyinhloko kokuhlaziywa kokuhlanganiswa

Inhloso yokuhlaziywa kokuhlanganiswa ukukhomba ukuthi kukhona ubuhlobo phakathi kwezici ezihlukahlukene. Okusho ukuthi kunqunywe ukuthi ukwehla noma ukwanda kwikhombisi eyodwa kuthinta ushintsho kwenye.

Uma ukuthembela kusungulwe, khona-ke u-coefficient wokulungisa uzimisele. Ngokungafani nokuhlaziywa kwe-regression, lokhu kuyona kuphela inkomba yokuthi le ndlela yokucwaninga yezibalo inquma. Ama-coefficient ranges kusuka ku +1 ukuya ku- -1. Lapho kukhona ukulungiswa okuhle, ukwanda kwesinye isibonakaliso kunomthelela ekwandeni kwesibili. Nge-correlation engalungile, ukwanda kwesinye isibonakaliso kuhlanganisa ukwehla komunye. I-modus enkulu ye-coefficient yokuhlanganiswa, ukuguqulwa kokubonakala kwesinye isibonakaliso kubonakala ekushintsheni okwesibili. Lapho i-coefficient engu-0, ubuhlobo phakathi kwabo abukho ngokuphelele.

Ukubalwa komklomelo wokuhlanganiswa

Manje ake sizame ukubala coefficient yokuhlanganiswa kwesibonelo esithile. Sinetafula lapho izindleko zenyanga zibhalwa ngamakholomu ahlukene ekuthengiseni izindleko nokuthengisa. Kufanele sithole izinga lokuthembela kwenombolo yokuthengisa ngemali yemali esetshenziselwe ukukhangisa.

Indlela yoku-1: Hlela ukulinganisa usebenzisa i-Wizard Wizard

Enye yezindlela lapho kuhlaziywa khona ukuhlanganiswa kokusebenzisa ukusebenzisa umsebenzi we-CORREL. Umsebenzi ngokwawo unombono jikelele. CORREL (i-array1; i-array2).

1. Khetha iseli lapho umphumela wokubala kufanele uboniswe khona. Chofoza inkinobho "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.



2. Kuloluhlu, olwethulwa efasiteleni leWindows Wizard, sibheke futhi sikhetha umsebenzi CORREL. Sicindezela inkinobho "Kulungile".



3. Iwindi lempikiswano yokusebenza ivula. Ensimini "Massive1" faka izixhumanisi zohlu lwamaseli womunye wamagugu, ukuxhomekeka okumele kutholakale. Esikhathini sethu, lezi ziyoba yizilinganiso kukholomu "Sales Value". Ukuze ufake ikheli lendawo emkhakheni, mane ukhethe wonke amaseli anedatha kukholomu elingenhla.

   Ensimini "Massiv2" udinga ukufaka izixhumanisi zekholomu yesibili. Sinezindleko zokukhangisa. Ngendlela efanayo nasendabeni yangaphambili, sifaka idatha ensimini.

   Sicindezela inkinobho "Kulungile".

Njengoba ubona, ukulingana kwe-correlation kubonakala njengenombolo kuseli elanduliwe. Kulesi simo, lilingana no-0.97, okuyisibonakaliso esikhulu kakhulu sokuthembela kwesilinganiso esisodwa komunye.

Indlela 2: Bala Ukulinganisa Ngisebenzisa Iphakheji Yokuhlaziya

Ngaphezu kwalokho, ukulungiswa kungabalwa ngokusebenzisa elinye lamathuluzi akhishwa kuphakheji lokuhlaziya. Kodwa okokuqala sidinga ukucupha leli thuluzi.

1. Iya kuthebhu "Ifayela".



2. Ewindini evulekayo, hamba kusigaba "Izinketho".



3. Okulandelayo, iya endaweni Engeza-ons.



4. Ngaphansi kwefasitela elilandelayo esigabeni "Ukuphathwa" shintshela inkinobho ukuma Faka i-Exceluma kusendaweni ehlukile. Sicindezela inkinobho "Kulungile".



5. Ebhokisini lokungezela, hlola ibhokisi eceleni kwento. "I-Package Analysis". Sicindezela inkinobho "Kulungile".



6. Emva kwalokhu, iphakheji lokuhlaziywa livuliwe. Iya kuthebhu "Idatha". Njengoba sibona, ibhulogi elisha lamathuluzi livela kwi-tape - "Ukuhlaziywa". Sicindezela inkinobho "Ukuhlaziywa kwedatha"esitholakala kuwo.



7. Uhlu luvuleka ngezinketho ezahlukene zokuhlaziya idatha. Khetha into "Ukulungiswa". Chofoza inkinobho "Kulungile".



8. Ifasitela ivuleka ngemigomo yokuhlaziywa kokulungisa. Ngokungafani nendlela eyedlule, ensimini "Isikhathi sokufaka" sifaka isikhala hhayi ikholomu ngayinye ngokwehlukana, kodwa zonke izinsika ezibandakanyeka ekuhlaziyweni. Esikhathini sethu, lena yidatha kwi "Izindleko Zokukhangisa" namakholomu "Sales Value".

   Ipharamitha "Ukuqoqa" shiya ungashintshi - "Ngamakholomu", njengoba sinamaqembu e-data ahlukaniswe ngqo phakathi kwamakholomu amabili. Uma bephukile umugqa ngomugqa, kuzodingeka ukuthi uhlele kabusha ushintsho endaweni "Emigqa".

   Okukhethwa kukho okuzenzakalelayo okukhethwa kukho kusethwe "Iphepha Elisha Lomsebenzi", okungukuthi, idatha izoboniswa kwenye ishidi. Ungashintsha indawo ngokuhambisa umshini. Lokhu kungaba ishidi lamanje (khona-ke kuzodingeka ucacise izixhumanisi zamaseli okukhishwa kolwazi) noma incwadi entsha yokusebenzela (ifayela).

   Uma zonke izilungiselelo zisethiwe, chofoza inkinobho. "Kulungile".

Njengoba indawo yokukhishwa kwemiphumela yokuhlaziywa ishiywe ngokuzenzakalelayo, sithuthela eshadini elisha. Njengoba ungabona, nansi coefficient yokulungisa. Ngokuvamile, kufana nokusebenzisa indlela yokuqala - 0.97. Lokhu kuchazwa ukuthi kokubili izinketho zenza izibalo ezifanayo, ungakwazi nje ukuzenza ngezindlela ezahlukene.

Njengoba ubona, isicelo se-Excel sinikeza ngesikhathi esisodwa izindlela ezimbili zokuhlaziywa kokulungisa. Umphumela wokubala, uma wenza konke ngokufanele, uzofana ngokuphelele. Kodwa, umsebenzisi ngamunye angakhetha inketho elula kakhulu ekusetshenzisweni kokubala.