Kuti mudziwe kuchuluka kwa kudalira pakati pa zizindikiro zingapo, kugwirizanitsa zinthu zambiri kumagwiritsidwa ntchito. Iwo amatsitsidwa kukhala tebulo losiyana, lomwe liri ndi dzina la matrix yolumikizana. Mayina a mizere ndi zipilala za matrix otero ndi maina a magawo, kudalira kwa wina ndi mzake kukhazikitsidwa. Pakati pa mizere ndi mizere ndizomwe zili zofanana zogwirizana. Tiyeni tione momwe tingachitire izi ndi zida za Excel.
Onaninso: Kulumikizana Kwachidule mu Excel
Kuwerengera kokwanira kophatikizana
Amavomerezedwa motere pofuna kudziwa kuchuluka kwa kusiyana pakati pa zizindikiro zosiyanasiyana, malinga ndi coefficient yogwirizana:
- 0 - 0.3 - palibe kugwirizana;
- 0.3 - 0.5 - kugwirizana kuli kofooka;
- 0.5 - 0.7 - sing'anga;
- 0.7 - 0.9 - pamwamba;
- 0.9 - 1 - wamphamvu kwambiri.
Ngati coefficient chigwirizano ndi zoipa, zikutanthauza kuti ubale wa magawo ndi zosiyana.
Kuti tipeze matrix yolumikizana mu Excel, chida chimodzi chimagwiritsidwa ntchito, chomwe chimaphatikizidwa mu phukusi. "Kusanthula Deta". Iye akutchedwa - "Mgwirizano". Tiyeni tipeze momwe angagwiritsire ntchito kuwerengetsa zizindikiro zamakonzedwe angapo.
Gawo 1: kuyambitsa phukusi lofufuza
Nthawi yomweyo ndiyenera kunena kuti phukusi losasinthika "Kusanthula Deta" olumala. Choncho, musanayambe ndondomekoyi kuti muwerenge mwachindunji coefficients, muyenera kuigwiritsa ntchito. Tsoka ilo, osati wosuta aliyense amadziwa momwe angachitire. Choncho, tidzakambirana nkhaniyi.
- Pitani ku tabu "Foni". Kumanzere omwe akuwonekera kumanzere pawindo lotseguka pambuyo pake, dinani pa chinthucho "Zosankha".
- Pambuyo poyambitsa zenera pazenera kudzera kumanzere ake akumanzere, pitani ku gawo Zowonjezera. Pali munda pansi pazanja lamanja la zenera. "Management". Yambitsaninso chosinthira mmalo mwake Zowonjezeretsa Zolembangati pulogalamu ina ikuwonetsedwa. Pambuyo pake timatsegula batani. "Pitani ..."kumanja kwa malo omwe atchulidwa.
- Fenje yaing'ono ikuyamba. Zowonjezera. Fufuzani bokosi pafupi ndi chizindikiro "Analysis Package". Kenaka mbali yeniyeni yawindo pindani pakani. "Chabwino".
Pambuyo pa phukusi lachitsulo chodziwika "Kusanthula Deta" idzatsegulidwa.
Gawo 2: Kuwerengera kokwanira
Tsopano mukhoza kupita molunjika ku chiwerengero cha coefficient multiple correlation. Tiyeni tigwiritse ntchito chitsanzo cha mndandanda wa zizindikiro za ntchito zolimbitsa thupi, chiŵerengero cha anthu ogwira ntchito ndi mphamvu zamagetsi ku mabungwe osiyanasiyana kuti awerengere kuchuluka kwa mgwirizano wa zinthu izi.
- Pitani ku tabu "Deta". Monga mukuonera, chida chatsopano chimapezeka pa tepi. "Kusanthula". Timasankha pa batani "Kusanthula Deta"yomwe ili mmenemo.
- Zenera likutsegula zomwe ziri ndi dzina. "Kusanthula Deta". Sankhani m'ndandanda wa zipangizo zomwe zili mmenemo, dzina "Mgwirizano". Pambuyo pake dinani pa batani "Chabwino" kumanja kwa mawonekedwe a mawindo.
- Chida chowonekera chimatsegulira. "Mgwirizano". Kumunda "Nthawi yolowera" Adilesi ya mapepala osiyanasiyana omwe deta yazinthu zitatu zomwe anaphunzirira ziyenera kukhazikitsidwa: chiŵerengero cha mphamvu-to-labor, chiŵerengero cha ogwira ntchito ndi chiwongoladzanja. Mungathe kulembetsa makonzedwe, koma ndi kosavuta kuti muyike mtolo mmunda ndipo, mutagwiritsa ntchito batani lamanzere, sankhani malo omwe ali pa tebulo. Pambuyo pake, adiresi yachitsulo idzawonetsedwa mubokosi la bokosi "Mgwirizano".
Popeza tili ndi zinthu zowonongeka ndi zipilala, osati mizere, muyeso "Kugawa" ikani kasinthasintha kuti muyime "Ndi ndondomeko". Komabe, yakhazikika kale pamtunda. Kotero, izo zimangokhala kuti zitsimikizire kulondola kwa malo ake.
Pafupi "Tags mu mzere woyamba" Chitsimikizo sichifunika. Choncho, tidzasuntha izi, chifukwa sizidzakhudza chikhalidwe chonse.
Mu bokosi lokhalamo "Chotsitsa Choyimira" Izi ziyenera kusonyezedwa kumene komwe matrix athu amgwirizano adzakhazikitsidwe, momwe zotsatira zake ziwonetsedwere. Zosankha zitatu zilipo:
- Buku latsopano (fayilo ina);
- Pepala latsopano (ngati mukufuna, mukhoza kulipatsa dzina m'munda wapadera);
- Mndandanda wa tsamba lomwe liri pano.
Tiyeni titenge njira yotsiriza. Sungani kusinthana ku "Kugawa Malo". Pachifukwa ichi, mu munda womwewo, muyenera kufotokozera adiresi ya matrix, kapena osachepera kumtunda. Ikani malonda mmunda ndipo dinani selo pa pepala, zomwe tikukonzekera kupanga chapamwamba chakutsala chazomwe zimatulutsidwa.
Mukatha kuchita zonsezi, zonse zotsalazo ndizochoka pa batani. "Chabwino" kumanja kwawindo "Mgwirizano".
- Pambuyo pachitsiriza chotsiriza, Excel imamanga matrix yolumikizana, ndikudzaza ndi deta muyeso yomwe umasankha.
Gawo 3: Kusanthula zotsatira
Tsopano tiyeni tiwone momwe tingamvetsetse zotsatira zomwe tapeza mu chipangizo chogwiritsa ntchito deta "Mgwirizano" mu Excel.
Monga momwe tikuonera kuchokera pa tebulo, chiwerengero cha mgwirizano wa chiwerengero cha ogwira ntchito (Column 2) ndi magetsi (Phunziro 1) ndi 0.92, zomwe zikugwirizana ndi mgwirizano wamphamvu kwambiri. Pakati pa ntchito yothandizira (Pulogalamu 3) ndi magetsi (Phunziro 1) Chizindikiro ichi ndi chofanana ndi 0.72, chomwe chiri chiwerengero cha kudalira kwambiri. Kugwirizana kwa mgwirizano pakati pa zokolola za ntchito (Pulogalamu 3) ndi chiŵerengero chachikulu cha anthu ogwira ntchito (Pulogalamu 2) ofanana ndi 0.88, zomwe zimagwirizananso ndi kuchuluka kwa kudalira. Motero, tinganene kuti kudalira pakati pa zinthu zonse zophunzira kungakhale kolimba ndithu.
Monga mukuonera, phukusi "Kusanthula Deta" mu Excel ndizosavuta kugwiritsa ntchito chida chogwiritsira ntchito chogwirizanitsa zinthu zambiri. Ndi chithandizo chake, mukhoza kupanga chiwerengero ndi chizoloŵezi chokhazikika pakati pa zifukwa ziwiri.