Mukati
Imwe yenzira dzakajairika dzinoshandiswa muhuwandu hwekudzidza data ndeyekuwirirana kuongororwa, iyo inogona kushandiswa kuona pesvedzero yehuwandu humwe pane imwe. Ngationei kuti ongororo iyi inogona kuitwa sei muExcel.
Chinangwa chekuongorora kuwirirana
Correlation ongororo inobvumidza iwe kuwana kutsamira kweimwe chiratidzo pane imwe, uye kana yawanikwa, verenga kuwirirana coefficient (dhigirii rehukama), iyo inogona kutora kukosha kubva -1 kusvika +1:
- kana iyo coefficient isina kunaka, kutsamira kuri inverse, kureva kuwedzera kune imwe kukosha kunotungamirira kuderera mune imwe uye zvakasiyana.
- kana iyo coefficient yakanaka, kuvimba kwakananga, kureva kuwedzera kwechiratidzo chimwe kunotungamirira kuwedzera kwechipiri uye zvakasiyana.
Simba rekutsamira rinogadziriswa ne modulus ye coefficient coefficient. Iyo yakakura kukosha, iyo yakasimba shanduko mune imwe kukosha inobata imwe. Kubva pane izvi, ne zero coefficient, zvinogona kukakavara kuti hapana hukama.
Kuita ongororo yekubatanidza
Kuti udzidze uye unzwisise zvirinani ongororo yewirirano, ngatiedzei patafura iri pazasi.
Heano data paavhareji tembiricha yezuva nezuva uye avhareji humidity yemwedzi yegore. Basa redu nderekutsvaga kana paine hukama pakati pemaparamita aya uye, kana zvakadaro, yakasimba sei.
Method 1: Isa iyo CORREL Basa
Excel inopa basa rakakosha iro rinokutendera kuti uite ongororo yekubatanidza - CORREL. Syntax yayo inotaridzika seizvi:
КОРРЕЛ(массив1;массив2).
Maitiro ekushanda nechishandiso ichi ndeaya anotevera:
- Isu tinosimuka musero remahara retafura yatinoronga kuverenga iyo coefficient yekubatanidza. Wobva wadzvanya pane icon "fx (Isa basa)" kuruboshwe rweformula bar.
- Muhwindo rekuisa basa rakavhurwa, sarudza chikamu "Statistical" (kana “Runyorwa ruzere rwearufabheti”), pakati pezvakarongwa sarudzo tinoona "CORREL" uye baya OK.
- Iro hwindo rekupokana rebasa richaratidzwa pachiratidziri necursor mundima yekutanga yakatarisana "Mutambo 1". Pano tinoratidza kurongeka kwemasero ekutanga koramu (isina musoro wetafura), iyo data inoda kuongororwa (munyaya yedu, B2:B13) Iwe unogona kuita izvi nemaoko nekunyora mavara aunoda uchishandisa keyboard. Iwe unogona zvakare kusarudza chiyero chinodiwa zvakananga mutafura pachayo nekubata pasi bhatani rekuruboshwe. Zvadaro tinoenda kune imwe nharo yechipiri "Kurongwa 2", nekungodzvanya mukati mechikamu chakakodzera kana nekudzvanya kiyi Tab. Pano tinoratidza kurongeka kwehuwandu hwemasero echipiri akaongororwa column (mutafura yedu, izvi C2:C13) Dzvanya kana wagadzirira OK.
- Isu tinowana corelation coefficient musero nebasa. Meaning "-0,63" inoratidza hukama hwakasimba pakati pe data yakaongororwa.
Nzira 2: Shandisa "Analysis Toolkit"
Imwe nzira yekuita ongororo yekubatanidza ndeye kushandisa "Package Analysis", iyo inofanira kutanga yagoneswa. Nokuda kweizvi:
- Enda kumenyu "Faira".
- Sarudza chinhu kubva pane zvakarongwa kuruboshwe "Parameters".
- Muhwindo rinoonekwa, tinya pane chikamu "Zviwedzerwa". Zvadaro muchikamu chekurudyi chehwindo pazasi chaipo kune parameter "Kudzora" Sarudza "Excel add-ins" uye baya “Enda”.
- Mufafitera rinovhurika, maka "Analysis Package" uye simbisa chiito nekudzvanya bhatani OK.
Zvese zvagadzirira, "Analysis Package" activated. Iye zvino tinogona kuenderera kune basa redu guru:
- Dhonza bhatani "Data analysis", iri mu tab "Dhata".
- Hwindo richaonekwa rine runyoro rwezvisarudzo zvekuongorora zviripo. Tinopemberera "Kuwirirana" uye baya OK.
- Iwindo richaonekwa pachiratidziro umo iwe unofanirwa kutsanangura zvinotevera paramita:
- "Input Interval". Isu tinosarudza huwandu hwese hwemaseru akaongororwa (kureva, makoramu ese kamwechete, uye kwete imwe panguva, sezvakaitika munzira inotsanangurwa pamusoro).
- “Kuita Boka”. Pane nzira mbiri dzekusarudza kubva: nemakoramu nemitsara. Muchiitiko chedu, sarudzo yekutanga yakakodzera, nokuti. iyi ndiyo nzira iyo data yakaongororwa inowanikwa mutafura. Kana misoro yakabatanidzwa muchikamu chakasarudzwa, tarisa bhokisi riri pedyo "Mazita mumutsetse wekutanga".
- "Output Options". Unogona kusarudza sarudzo "Exit Interval", munyaya iyi migumisiro yekuongorora ichaiswa pane pepa razvino (iwe uchada kutsanangura kero yesero kubva pane izvo zvigumisiro zvicharatidzwa). Zvinotarisirwawo kuratidza zvabuda pabepa idzva kana mubhuku idzva (iyo data ichaiswa pakutanga, kureva kutanga kubva muchitokisi. (A1). Somuenzaniso, tinoenda "New Worksheet" (yakasarudzwa neyakagadzika).
- Kana zvese zvagadzirwa, tinya OK.
- Isu tinowana imwechete yekubatanidza coefficient seyekutanga nzira. Izvi zvinoratidza kuti mune zvese zviri zviviri takaita zvese nemazvo.
mhedziso
Saka, kuita ongororo yekuenzanisa muExcel inzira yakangojairika uye iri nyore kudzidza. Zvese zvaunoda kuti uzive kuti ndekupi kwekuwana uye nzira yekumisikidza chinodiwa chishandiso, uye mune iyo kesi "solution package", kuti uishandise sei, kana zvisati zvaitika iyo yakanga isati yave yakagoneswa muzvirongwa zvepurogiramu.