Kuongororwa kweCorrelation muExcel: 2 Sarudzo dzebasa

Kuongororwa kweCorrelation inzira yakakurumbira yekutsvaga kwehuwandu, iyo inoshandiswa kuziva iyo degree rekuvimbika kwechiratidzo chimwe kubva kune mumwe. Microsoft Excel ine chishandiso chakakosha chakagadzirirwa kuita iyi mhando yekuongorora. Ngatitsvagei kushandisa sei basa iri.

Kukosha kwekugadzirisa kuongorora

Chinangwa chekuongororwa kweCorrelation chinoderedzwa kuti uzive kutsamira pakati pezvakasiyana zvinhu. Ndokunge, yakatemwa kuti kuderera kunofuridzirwa kana kuwedzera kwechiratidzo pane shanduko mune imwe.

Kana kutsamira kwasimbiswa, iyo correlation coefficient inotemwa. Kusiyana nekudzokorora kuongorora, ichi ndicho chega chiratidzo chinoverenga nzira iyi yekutsvaga nhamba. Kuwirirana kuwirirana kunosiyana mumhando kubva ku +1 kusvika ku -1. Kana paine kuwirirana kwakanaka, kuwedzera kwechiratidzo chimwe kunobatsira kuwedzera kwechipiri. Nekubatana kwakashata, kuwedzera mune chimwe chiratidzo kunosanganisira kuderera mune imwe. Iyo yakakura iyo correlation coefficient module, shanduko inoonekwa mune imwe chiratidzo inoratidzwa pakuchinja kwechipiri. Ine coefficient yakaenzana 0, kuvimba pakati pavo hakuna zvachose.

Kuverenga kweiyo correlation coefficient

Zvino ngatiitei kuti tirongedze correlation coeffication pane chaiyo muenzaniso. Tine tafura iyo iyo pamwedzi yakapendwa mumapendeketi akapatsanurwa kuti ashambadzire mitengo uye kutengesa. Isu tinofanirwa kutsvaga iyo degree rekuvimbika kwehuwandu hwekutengesa kubva kune huwandu hwemari, iyo yakashandiswa pakushambadzira.

Nzira 1: Kufunga kuwirirana kuburikidza neThe Master yeMabasa

Imwe nzira iyo iyo iyo yekuongorora kuongororwa kunogona kuitwa ndeyekushandisa kushanda kwecrelation. Basa racho pacharo rine maonero emaonero eiyo corneal (army1; array2).

1. Sarudza iyo sero umo mhedzisiro yekuverenga inofanira kunge iri kubuda. Dzvanya pane iyo "Insert basa" bhatani, iyo inoiswa kuruboshwe rwetambo ye formula.



2. Pane iyo rondedzero, iyo inoratidzwa muWizard Wizard, tinotsvaga uye kugovera basa rekornel. Dzvanya pane "OK" bhatani.



3. Nhaurwa dzebasa dzinovhura. Mu "musana" "munda, isu tinosuma marongi emhando yemasero eimwe yetsika, kuvimba kwavo kunofanira kutsanangurwa. Takaita isu, ava vachave tsika mu "kutengesa" ikholamu. Kuti uwedzere kero yehurongwa mumunda, ingogovera masero ese nedata mune iri pamusoro wenyaya.

   Mumunda "masasi2" iwe unofanirwa kuita kuronga kweiyo yechipiri chikamu. Tine mutengo wekushambadzira. Sezvakangoita kare, takapinda data iri mumunda.

   Dzvanya pane "OK" bhatani.

Sezvatinoona, iyo correlation coefficient mune fomu yehuwandu inoonekwa muchitokisi chatakasarudza. Mune ino kesi, yakaenzana ne 0.97, iyo iri yakanyanya chimiro chekuvimbika kweimwe kukosha kubva kune imwe.

Nzira 2: Kuverenga iyo Correlation uchishandisa package yekuongorora

Uye zvakare, kuwirirana kunogona kuverengerwa uchishandisa imwe yezvishandiso, iyo inomiririrwa mukuongorora kweiyo. Asi isu tisati tada chishandiso ichi kuti tiite.

1. Enda kune "faira" tab.



2. Muwindo rinovhura, fambisa kune "parameter" chikamu.



3. Tevere, enda ku "Wedzera-mu".



4. Pazasi pewindo rinotevera mu "manejimendi" chikamu, tinogadzirazve switch ku "Excel inowedzera-mu" chinzvimbo, kana chiri mune imwe chinzvimbo. Dzvanya pane "OK" bhatani.



5. Muwindo rewindo rekuwedzera-ones, isu tinoisa tick padhuze ne "Ongorora package" chinhu. Dzvanya pane "OK" bhatani.



6. Mushure meizvozvo, iyo ongororo package yakaitwa. Enda ku "data" tab. Sezvauri kuona, chitsva chitsva block chinoonekwa pane ribhoni - "kuongororwa". Dzvanya pane "kuongororwa kwedata", iyo iri mazviri.



7. Rondedzero ine dzakasiyana siyana data yekuongorora sarudzo. Sarudza poindi "kuwirirana". Dzvanya pane "OK" bhatani.



8. Hwindo rinovhura neakashongedza kuongororwa paramita. Mukupesana nenzira yekare, mumunda "Inplay Interlation" Isu tinosuma nguva yekamuri imwe neimwe zvakasiyana, asi makoramu ese anobatanidzwa mukuongororwa. Kwedu isu, aya idatha mumakoramu "ekushambadzira" uye "kukosha kwe" kutengesa ".

   Iyo "yekugeda" paramende inosiyiwa isina kuchinjika - "pamakoramu", sezvo isu tine boka re data rakaputswa mumakoramu maviri. Dai vakatsemuka mutsara, saka vanofanirwa kugadzirwazve kuchinjika kuchinzvimbo "pamitsara".

   Mune iyo default inoburitsa paramita, iyo "nyowani yebasa rondedzero" chinhu chakaiswa, ndiko kuti, iyo data icharatidzwa pane imwe pepa. Iwe unogona kushandura nzvimbo yacho nekumisa switch. Inogona kunge iri parizvino pepa (saka iwe uchafanirwa kutsanangura marongero emashoko ekubuda masero) kana bhuku rutsva rekushanda (faira).

   Kana zvese zvigadziriso zvakaiswa, tinya pane "OK" bhatani.

Sezvo kuongororwa kwemhedzisiro yekuongororwa kwakasiiwa nekukanganisa, tinoenda kune rimwe bepa racho. Sezvauri kuona, kuwirirana kwecreffient kunoratidzwa. Nomuzvarirwo, iye akafanana kana uchishandisa nzira yekutanga - 0.97. Izvi zvakatsanangurwa nenyaya yekuti zvese zvingasarudzwa zvinoita kuongororwa kumwechete, kungovagadzirira nenzira dzakasiyana.

Sezvauri kuona, iyo Excel app inopa nzira mbiri dzekuongororwa kuongororwa kamwechete. Mhedzisiro yekuverenga, kana iwe ukaita zvese nenzira kwayo, ichave yakazara zvizere. Asi, mumwe nemumwe mushandisi anogona kusarudza mongororo yakanyanya nyore.