Kusanthula kwagwirizano - njira yodziŵika bwino yofufuza, zomwe zimagwiritsidwa ntchito pozindikira kuchuluka kwa kudalira kwa chizindikiro chimodzi kuchokera ku chimzake. Microsoft Excel ili ndi chida chapadera chomwe chinapangidwa kuti chiyesedwe mtundu uwu. Tiyeni tione momwe tingagwiritsire ntchito mbali iyi.
Chofunika cha kusintha kwa mgwirizano
Cholinga cha kuwunika kwa mgwirizano ndiko kuzindikira kukhalapo pakati pa zinthu zosiyanasiyana. Izi zikutanthauza ngati kuchepa kapena kuwonjezeka kwa chizindikiro chimodzi kumakhudza kusintha kwa wina.
Ngati kudalira kwakhazikitsidwa, ndiye kuti chokhazikika cha mgwirizanowo chadziwika. Mosiyana ndi kusanthula zovuta, ichi ndi chokhacho chimene chiwerengerochi choyesa kufufuza chiwerengera. Zowonjezera zokhala pamodzi kuyambira +1 mpaka -1. Pamaso pa mgwirizano wabwino, kuwonjezeka kwa chizindikiro chimodzi kumapangitsa kuwonjezeka kwachiwiri. Ndi mgwirizano wolakwika, kuwonjezeka kwa chizindikiro chimodzi kumaphatikizapo kuchepa kwa wina. Powonjezerapo kayendedwe kogwirizanitsa, podziwika kwambiri kusintha kwa chizindikiro chimodzi chikuwonekera pa kusintha kwachiwiri. Pamene coefficient ndi 0, chiyanjano pakati pawo palibe.
Kuwerengera kokwanira kokwanira
Tsopano tiyeni tiyesere kuwerengera coefficient yolumikizana pa chitsanzo chapadera. Tili ndi tebulo yomwe ndalama zowonetsera mwezi ndizolembedwa muzitsulo zosiyana zotsatsa malonda ndi malonda. Tiyenera kudziwa kuchuluka kwa chiwerengero cha malonda pa kuchuluka kwa ndalama zomwe tinagwiritsa ntchito pa malonda.
Njira 1: Tsimikizani mgwirizano Pogwiritsira ntchito Wopanga Ntchito
Imodzi mwa njira zomwe mungagwiritsire ntchito ndondomeko yolumikizana ndi kugwiritsa ntchito ntchito ya CORREL. Ntchitoyo imakhala ndi malingaliro onse. CORREL (array1; array2).
- Sankhani selo momwe zotsatira za mawerengedwe ziyenera kuwonetsedwa. Dinani pa batani "Ikani ntchito"yomwe ili kumanzere kwa bar.
- M'ndandanda, yomwe ikuwonekera pazenera la Function Wizard, tikuyang'ana ndikusankha ntchitoyi CORREL. Timakanikiza batani "Chabwino".
- Ntchito yotsutsana yenera ikutsegula. Kumunda "Massive1" lowetsani makonzedwe a maselo osiyanasiyana a imodzi yamtengo wapatali, kudalira kumene kumayenera kudziwika. Kwa ife, izi zidzakhala zoyenera mukhomo "Zofunika". Kuti mulowe mu adiresi yazomwe muli kumunda, mungosankha maselo onse ndi deta muzamulo pamwambapa.
Kumunda "Massiv2" muyenera kulowa m'zigawo zachiwiri. Tili ndi ndalama zogulitsa. Mofananamo monga momwe zinalili kale, timalowa mu deta.
Timakanikiza batani "Chabwino".
Monga momwe mukuonera, coefficient chiyanjano amawoneka ngati nambala mu selo osankhidwa. Pankhani iyi, ndi ofanana ndi 0.97, omwe ndi chizindikiro chachikulu cha kudalira kwa mtengo umodzi pa wina.
Njira 2: Yerengani Chiyanjano Pogwiritsa Ntchito Analysis Package
Kuphatikizanso, mgwirizanowu ukhoza kuwerengedwa pogwiritsira ntchito chimodzi mwa zida zomwe zafotokozedwa mu phukusi lofufuza. Koma choyamba tiyenera kuyika chida ichi.
- Pitani ku tabu "Foni".
- Pawindo lomwe limatsegulira, pita ku gawolo "Zosankha".
- Kenako, pitani ku mfundo Zowonjezera.
- Pansi pazenera lotsatira m'gawoli "Management" Sinthani kusintha kwa malo Zowonjezeretsa Zolembangati ziri zosiyana. Timakanikiza batani "Chabwino".
- Mu bokosi lowonjezera, yang'anani bokosi pafupi ndi chinthucho. "Analysis Package". Timakanikiza batani "Chabwino".
- Pambuyo pake, phukusi lofufuzira likuyambidwa. Pitani ku tabu "Deta". Monga tikuonera, chida chatsopano chimapezeka pa tepi - "Kusanthula". Timakanikiza batani "Kusanthula Deta"yomwe ili mmenemo.
- Mndandanda umayamba ndi zosankha zosiyanasiyana zosanthula deta. Sankhani chinthu "Mgwirizano". Dinani pa batani "Chabwino".
- Zenera likuyamba ndi kulingalira kwazowonjezera. Mosiyana ndi njira yapitayi, m'munda "Nthawi yolowera" timalowa mugawo osati ndime iliyonse padera, koma mitu yonse yomwe ikukhudzidwa. Kwa ife, iyi ndi deta mu "Zotsatsa Zamalonda" ndi "Ma mtengo Wogulitsa".
Parameter "Kugawa" siyani osasintha - "Ndi ndondomeko", popeza tili ndi magulu a deta anagawa ndendende muzitsulo ziwiri. Ngati iwo anali osweka mzere ndi mzere, ndiye kuti nkofunikira kukonzanso kusintha kwa malo "M'mizere".
Chotsalira chosinthidwa chosankhidwa chasankhidwa "New Worksheet", ndiko kuti, deta idzawonetsedwa pa pepala lina. Mukhoza kusintha malo mwa kusuntha makina. Izi zikhoza kukhala pepala lamakono (ndiye inu muyenera kufotokoza zochitika za maselo omwe amapanga zidziwitso) kapena bukhu latsopano la ntchito (fayilo).
Pamene zonse zakhazikitsidwa, dinani pa batani. "Chabwino".
Popeza malo a zotsatira za zotsatira zowonongeka zinasiyidwa chosasintha, timasamukira ku pepala latsopano. Monga mukuonera, apa pali coefficient yolumikizana. Mwachibadwa, zimakhala zofanana ndi kugwiritsa ntchito njira yoyamba - 0.97. Izi zikufotokozedwa ndi mfundo yakuti zonsezi zikhoza kuchita zowerengera zomwezo, mungathe kuzipanga m'njira zosiyanasiyana.
Monga mukuonera, ntchito ya Excel imapereka nthawi yomweyo njira ziwiri zoyanthana. Zotsatira za mawerengero, ngati mutachita zonse molondola, zidzakhala chimodzimodzi. Koma, aliyense wogwiritsa ntchito akhoza kusankha njira yabwino kwambiri yokwaniritsira mawerengedwe.
