Chitsanzo chakuchita kusanthula kolumikizana mu Excel

Imodzi mwa njira zomwe zimagwiritsidwa ntchito mu ziwerengero zowerengera deta ndi kusanthula kwa mgwirizano, komwe kungagwiritsidwe ntchito kuti mudziwe mphamvu ya kuchuluka kwa chiwerengero chimodzi pa china. Tiyeni tiwone momwe kusanthula uku kungachitidwe mu Excel.

Cholinga cha kusanthula mgwirizano

Kusanthula kwa mgwirizano kumakupatsani mwayi wopeza kudalira kwa chizindikiro chimodzi pa china, ndipo ngati chipezeka, werengerani coefficient yolumikizana (madigiri a ubale), omwe amatha kutenga mfundo kuchokera ku -1 mpaka +1:

• ngati coefficient ndi yolakwika, kudalira ndikosiyana, mwachitsanzo, kuwonjezeka kwa mtengo umodzi kumabweretsa kuchepa kwa wina ndi mosiyana.
• ngati coefficient ndi zabwino, kudalira mwachindunji, mwachitsanzo, kuwonjezeka chizindikiro chimodzi kumabweretsa kuwonjezeka chachiwiri ndi mosemphanitsa.

Mphamvu ya kudalira imatsimikiziridwa ndi modulus ya coefficient coefficient. Mtengo wokulirapo, kusintha kwakukulu kwa mtengo umodzi kumakhudzanso winayo. Malingana ndi izi, ndi zero coefficient, zikhoza kutsutsidwa kuti palibe chiyanjano.

Kuchita kusanthula kogwirizana

Kuti tiphunzire ndikumvetsetsa bwino kusanthula kwamalumikizidwe, tiyeni tiyese pa tebulo ili m'munsimu.

Nazi zambiri za kutentha kwa tsiku ndi tsiku ndi chinyezi cha miyezi ya chaka. Ntchito yathu ndikupeza ngati pali ubale pakati pa magawowa ndipo, ngati ndi choncho, ndi amphamvu bwanji.

Njira 1: Ikani Ntchito ya CORREL

Excel imapereka ntchito yapadera yomwe imakulolani kuti mupange kusanthula kogwirizana - CORREL. Syntax yake ikuwoneka motere:

КОРРЕЛ(массив1;массив2).

Njira yogwiritsira ntchito chida ichi ndi iyi:

1. Timadzuka mu selo laulere la tebulo momwe tikukonzekera kuwerengera coefficient yogwirizanitsa. Kenako dinani chizindikirocho "fx (Ikani ntchito)" kumanzere kwa formula bar.
2. Pa zenera lotsegula la ntchito, sankhani gulu "Statistical" (kapena “Mndandanda wa zilembo zonse”), pakati pa zomwe tasankha zomwe tikuwona "CORREL" ndipo dinani OK.
3. Zenera la mikangano yantchito liziwonetsedwa pazenera ndi cholozera m'munda woyamba motsutsana "Zotsatira 1". Apa tikuwonetsa kugwirizanitsa kwa maselo a gawo loyamba (popanda mutu wa tebulo), zomwe ziyenera kufufuzidwa (kwa ife, B2:b13). Mutha kuchita izi pamanja polemba zilembo zomwe mukufuna kugwiritsa ntchito kiyibodi. Mukhozanso kusankha mulingo wofunikira mwachindunji patebulo lenilenilo pogwira batani lakumanzere. Kenako timapita ku mkangano wachiwiri "Mzere 2", kungodinanso mkati mwa gawo loyenera kapena podina batani Tab. Apa tikuwonetsa kuphatikizika kwama cell amtundu wachiwiri wowunikiridwa (patebulo lathu, izi ndi c2: c13). Dinani mukakonzeka OK.
4. Timapeza coefficient coefficient mu selo ndi ntchito. Tanthauzo "-0,63" zikuwonetsa mgwirizano wamphamvu pakati pa zomwe zawunikidwa.

Njira 2: Gwiritsani ntchito "Analysis Toolkit"

Njira ina yochitira kusanthula kolumikizana ndiyo kugwiritsa ntchito "Package Analysis", zomwe ziyenera kuyambitsidwa. Za ichi:

1. Pitani ku menyu "Fayilo".
2. Sankhani chinthu kuchokera pamndandanda womwe uli kumanzere "Parameters".
3. Pazenera lomwe likuwoneka, dinani kachigawo "Zowonjezera". Ndiye kumanja kwa zenera pansi kwambiri kwa chizindikiro "Kuwongolera" Sankhani "Zowonjezera za Excel" ndipo dinani "Pitani".
4. Pazenera lomwe limatsegulidwa, dinani chizindikiro "Analysis Package" ndikutsimikizira zomwe zikuchitika ndikudina batani OK.

Zonse zakonzeka, "Analysis Package" adamulowetsa. Tsopano titha kupita ku ntchito yathu yayikulu:

1. Sakani batani "Data analysis", yomwe ili mu tabu "Zambiri".
2. Iwindo lidzawoneka ndi mndandanda wa zosankha zomwe zilipo. Timakondwerera "Kugwirizana" ndipo dinani OK.
3. Iwindo lidzawonekera pazenera momwe muyenera kufotokozera magawo otsatirawa:
   • "Input Interval". Timasankha mitundu yonse ya maselo owunikidwa (ndiko kuti, mizati yonse nthawi imodzi, osati imodzi panthawi, monga momwe zinalili mu njira yomwe tafotokozayi).
   • "Kupanga magulu". Pali njira ziwiri zomwe mungasankhe: ndi mizati ndi mizere. Kwa ife, njira yoyamba ndi yoyenera, chifukwa. umu ndi momwe deta yowunikiridwa ili patebulo. Ngati mitu ili m'gulu lomwe mwasankha, chongani bokosi lomwe lili pafupi ndi “Malemba pamzere woyamba”.
   • “Zotulutsa Zotulutsa”. Mukhoza kusankha njira "Exit Interval", pankhaniyi zotsatira za kusanthula zidzayikidwa pa pepala lamakono (muyenera kufotokoza adiresi ya selo yomwe zotsatira zake zidzasonyezedwe). Akufunanso kuwonetsa zotsatira pa pepala latsopano kapena m'buku latsopano (deta idzayikidwa pachiyambi, mwachitsanzo, kuyambira pa selo. (A1). Mwachitsanzo, timachoka "New Worksheet" (zosankhidwa mwachisawawa).
   • Zonse zikakonzeka, dinani OK.
4. Timapeza coefficient yofananira yofanana ndi njira yoyamba. Izi zikusonyeza kuti muzochitika zonsezi tinachita zonse bwino.

Kutsiliza

Chifukwa chake, kusanthula kwamalumikizidwe mu Excel ndi njira yodzichitira yokha komanso yosavuta kuphunzira. Zomwe muyenera kudziwa ndi komwe mungapeze komanso momwe mungakhazikitsire chida chofunikira, komanso pankhani ya "Solution Package", momwe mungayambitsire, ngati m'mbuyomo sichinayambitsidwe kale pamakonzedwe a pulogalamu.