Kuti mudziwe kuchuluka kwa kudalirika pakati pa zizindikiro zingapo, ma coefficients angapo amagwiritsidwa ntchito. Amawonetsedwa mwachidule pagome lina, lomwe lili ndi dzina la matrix a malumikizidwe. Mayina mizere ndi mizati ya matrix amenewo ndi mayina a magawo omwe kudalirana kwawo kumakhazikitsidwa. Panjira yolumikizana mizere ndi mizere yolumikizana ikugwirizana. Tiyeni tiwone momwe mungachitire izi kuwerengera pogwiritsa ntchito zida za Excel.
Onaninso: Kusanthula kwa Excel Correlation
Kuwerengera kwa kuphatikiza kochulukirapo
Imalandiridwa motere kudziwa mulingo wa ubale pakati pa zizindikiro zosiyana, kutengera cholumikizana:
- 0 - 0,3 - palibe kulumikizana;
- 0,3 - 0,5 - kulumikizana ndikofowoka;
- 0,5 - 0,7 - pakati yolumikizira;
- 0,7 - 0,9 - mkulu;
- 0,9 - 1 wamphamvu kwambiri.
Ngati cholumikizira cholakwika sichili bwino, ndiye kuti izi zikutanthauza kuti ubale wa magawowo ndi wosagwirizana.
Pofuna kupanga matrix a malumikizanidwe mu Excel, chida chimodzi chimagwiritsidwa ntchito, chomwe chimaphatikizidwa mu phukusi "Kusanthula Kwambiri". Amatchedwa kuti - Chiyanjano. Tiyeni tiwone momwe mungazigwiritsire ntchito kuwerengetsa ma metriki angapo ophatikizika.
Gawo 1: kuyambitsa kwa kusanthula phukusi
Nthawi yomweyo muyenera kunena kuti phukusi lokhazikika "Kusanthula Kwambiri" kusakanizidwa. Chifukwa chake, musanapitirize ndi njira yowerengera ma coefficients mwachindunji, muyenera kuyiyambitsa. Tsoka ilo, siwogwiritsa ntchito aliyense amadziwa momwe angachitire izi. Chifukwa chake, tikambirana pankhaniyi.
- Pitani ku tabu Fayilo. Pazenera lakumanzere la zenera lomwe limatseguka pambuyo pake, dinani chinthucho "Zosankha".
- Mutakhazikitsa zenera la paramente, kudzera menyu ake ofukula kumanzere, pitani pagawo "Zowonjezera". Pali munda kumunsi komwe kumanja kwa zenera "Management". Timasinthana kusinthaku kukhala pamalo Wonjezerani-Exngati chizindikiro china chikuwonetsedwa. Pambuyo pake, dinani batani "Pita ..."ili kumanja kwa gawo lotchulidwa.
- Windo laling'ono limayamba. "Zowonjezera". Ikani bokosi loyang'ana pafupi ndi paramayo Mapaketi Osanthula. Kenako mu gawo loyenera la zenera, dinani batani "Zabwino".
Pambuyo pazochitikazo, phukusi la chida "Kusanthula Kwambiri" zidzakonzedwa.
Gawo lachiwiri: kuwerengera koyenera
Tsopano titha kupita mwachindunji kuwerengera kogwirizira kokwanira ka malumikizidwe angapo. Tiyeni, pogwiritsa ntchito chitsanzo cha mndandanda wazizindikiro za zokolola za anthu ogwira ntchito, kuchuluka kwa ogwira ntchito komanso kuwerengera mphamvu kwa ogwira ntchito m'mabizinesi osiyanasiyana pansipa, kuwerengera zolingana zingapo pazinthu izi.
- Pitani ku tabu "Zambiri". Monga mukuwonera, bokosi la zida zatsopano lawonekera pa tepi "Kusanthula". Dinani batani "Kusanthula Kwambiri", yomwe ili mkati mwake.
- Zenera lomwe limadziwika ndi dzinali limatsegulidwa "Kusanthula Kwambiri". Sankhani m'ndandanda wazida zomwe zili mmenemo, dzinalo Chiyanjano. Pambuyo pake, dinani batani "Zabwino" kumanja kwa mawonekedwe a zenera.
- Windo la chida limatseguka Chiyanjano. M'munda Kulowetsa Kuyimitsa adilesi yamtundu wa tebulo momwe zidziwikiratu zinthu zomwe zaphunziridwamo: kuchuluka kwa mphamvu, kuchuluka kwa ndalama, ndi zokolola ziyenera kuyikidwa. Mutha kuyika pamanja maulalo, koma ndizosavuta kungoyika chikwangwani m'munda ndikugwira batani lakumanzere, ndikusankha gawo lolingana ndi tebulo. Pambuyo pake, adilesi yamtunduwu iwonetsedwa pazenera Chiyanjano.
Popeza zinthu zathu zimagawidwa m'mizere m'malo mwa mizere, parilamu "Gulu" ikani kusintha Column ndi safu. Komabe, idakhazikitsidwa kale pamenepo. Chifukwa chake, zimangotsimikizira kuti malowo ndi olondola.
Pafupifupi mfundo "Tizilombo pamzere woyamba" kuyesa sikofunikira. Chifukwa chake, talumpha izi, chifukwa sizikhudza chiwerengero chonse.
Mu makatani "Linanena bungwe" ziyenera kuwonetsedwa komwe makatiriji athu ogwirizanira adzakhalire, momwe amawerengera akuwonetsedwa. Zinthu zitatu zomwe zilipo:
- Buku latsopano (fayilo ina);
- Pepala latsopano (ngati mukufuna, mutha kulipatsa dzina mundawo wapadera);
- Zosintha patsamba lakale.
Tiyeni tisankhe njira yotsiriza. Timasinthanso "Patuluka Pakatikati". Poterepa, m'munda wolingana muyenera kutchulanso adilesi yamtundu wa matrix, kapena maselo ake apamwamba kumanzere. Timayika cholozera m'munda ndikuyika pa cholembera papepala, chomwe timakonzekera kupanga gawo lamanzere pamndandanda wazotsatira.
Pambuyo pochita zonse zowonetsedwa, zimangokhala kungodina batani "Zabwino" kumanja kwa zenera Chiyanjano.
- Pambuyo pazochita zomaliza, Excel imanga malumikizidwe, ndikuidzaza ndi data mumtundu wosankhidwa ndi wogwiritsa ntchito.
Gawo 3: kusanthula zotsatira
Tsopano tiyeni tiwone momwe tingamvetsetse zotsatira zomwe tidakwanitsa kukonza deta ndi chida Chiyanjano mu Excel.
Monga mukuwonera patebulopo, kuchuluka kwa magwiridwe antchito a capital-task (Columu 2) ndi kuchuluka kwamphamvu (Kholamu 1) ndi 0.92, yomwe imagwirizana ndi ubale wolimba kwambiri. Pakati pa zokolola zantchito (Column 3) ndi kuchuluka kwamphamvu (Kholamu 1) chizindikiro ichi ndi 0.72, komwe ndi kudalira kwakukulu. Kuyanjana kwa mgwirizano pakati pakubala kwa ntchito (Column 3) ndi kuchuluka kwa ogwira ntchito (Column 2) ilingana ndi 0.88, yomwe imagwirizananso ndi kudalira kambiri. Chifukwa chake, titha kunena kuti kudalirika pakati pazinthu zonse zomwe zaphunziridwa ndikulimba.
Monga mukuwonera, phukusi "Kusanthula Kwambiri" Excel ndi chida chothandiza kwambiri komanso chosavuta kugwiritsa ntchito chida chofufuzira maphatikizidwe angapo. Kugwiritsa ntchito, munthu amathanso kuwerengera kugwirizana komwe kulipo pakati pa zinthu ziwiri.
