Njira ziwiri zakuwunikira komwe kukuchitika mu Microsoft Excel

Kusanthula kwa ubale ndi njira yotchuka pakufufuza, komwe kumagwiritsidwa ntchito pozindikira kuchuluka kwa kudalirika kwa chisonyezo chimodzi pa chimzake. Microsoft Excel ili ndi chida chapadera chopangidwira kusanthula kwamtunduwu. Tiyeni tiwone momwe angagwiritsire ntchito izi.

Chinsinsi cha kusanthula kwina

Cholinga cha kusanthula kophatikizana ndikuwonetsa kukhalapo kwa kudalirika pakati pa zinthu zosiyanasiyana. Ndiye kuti, zimatsimikiziridwa ngati kuchepa kapena kuwonjezeka kwa chisonyezo chimodzi kumakhudza kusintha kwina.

Ngati kudalirika kwakhazikitsidwa, ndiye kuti cholinganizidwa chikutsimikizika. Mosiyana ndi kusanthula kwakanthawi, ichi ndiye chisonyezo chokha chomwe njira iyi yowerengera imawerengera. Kuphatikiza kwofananira kumasiyana kuchokera ku +1 mpaka -1. Pamaso pa kuphatikiza kwabwino, kuwonjezereka kwa chisonyezo chimodzi kumathandizira kuwonjezeka kwachiwiri. Ndi kulumikizana kopanda pake, kuwonjezereka kwa chisonyezo chimodzi kumaphatikizapo kuchepa kwina. Kuchulukitsitsa kwa modulus kwamakanidwe oyenerana, chowonekera kwambiri ndikusintha kwa chisonyezo chimodzi kumakhudza kusintha kwachiwiri. Ngati cholowa ndi 0, kudalirika pakati pawo kulibe kwathunthu.

Kuwerengera kwa kuphatikizika kwa kuphatikizika

Tsopano tiyeni tiyese kuwerengera momwe mulumikizidwe wogwiritsira ntchito mwachitsanzo. Tili ndi tebulo momwe ndalama zotsatsira pamwezi komanso kuchuluka kwa malonda zimalembedwa m'mitundu yosiyana. Tiyenera kudziwa kuchuluka kwa kudalira kuchuluka kwa malonda pa kuchuluka kwa ndalama zomwe zimagwiritsidwa ntchito kutsatsa.

Njira 1: onani kulumikizana kudzera pa Wizard wa Ntchito

Njira imodzi yomwe kuwunika kosakanikirana kumathandizira ndikugwiritsa ntchito ntchito ya CRREL. Ntchitoyi payokha ili ndi mawonedwe wamba KORREL (gulu1; gulu2).

1. Sankhani khungu lomwe mawerengero akuyenera kuwonetsedwa. Dinani batani "Ikani ntchito"lomwe lili kumanzere kwa baramu yamu formula.



2. Pamndandanda womwe umawonetsedwa pazenera la Function Wizard, timasaka ndi kusankha ntchito KORREL. Dinani batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imatsegulidwa. M'munda "Pantan1" lowetsani zolumikizana za maselo am'munsi mwa chimodzi mwazofunikira, kudalirika komwe kuyenera kutsimikiziridwa. M'malo mwathu, awa adzakhala omwe ali mgulu la "Zogulitsa kuchuluka". Kuti mulowe ma adilesi omwe ali mumundamu, timangosankha maselo onse omwe ali ndi deta yomwe ili pamwambapa.

   M'munda Array2 muyenera kuyika zolumikizira za gawo lachiwiri. Tili ndi ndalama zotsatsa. Momwemonso monga momwe zinalili m'mbuyomu, timayika zidziwitso m'munda.

   Dinani batani "Zabwino".

Monga mukuwonera, cholumikizira cholingana ndi manambala chimawonekera mu foni yomwe idasankhidwa kale. Pankhaniyi, ndi 0.97, chomwe ndi chizindikiro chokwera kwambiri chodalira kuchuluka kwina kwina.

Njira 2: kuwerengera malumikizidwe akugwiritsa ntchito phukusi la kusanthula

Kuphatikiza apo, malumikizowo amatha kuwerengera pogwiritsa ntchito imodzi mwazida, zomwe zimaperekedwa mu phukusi lowunikira. Koma choyamba tiyenera kuyambitsa chida ichi.

1. Pitani ku tabu Fayilo.



2. Pa zenera lomwe limatseguka, sinthani ku gawo "Zosankha".



3. Kenako, pitani "Zowonjezera".



4. Pansi pazenera lotsatira m'gawolo "Management" sinthani kusintha kwa malo Wonjezerani-Exngati ali ndi vuto lina. Dinani batani "Zabwino".



5. Pa zenera lowonjezera, onani bokosi pafupi Mapaketi Osanthula. Dinani batani "Zabwino".



6. Pambuyo pake, phukusi la kusanthula limayendetsedwa. Pitani ku tabu "Zambiri". Monga mukuwonera, apa patepi pakhala zida zatsopano - "Kusanthula". Dinani batani "Kusanthula Kwambiri"yomwe ili mkati mwake.



7. Mndandanda umayamba ndi zosankha zingapo zosanthula deta. Sankhani chinthu Chiyanjano. Dinani batani "Zabwino".



8. Windo limatseguka ndi magawo a kuwunika kwa kuphatikiza. Mosiyana ndi njira yapita, m'munda Kulowetsa Kuyimitsa timalowa pakadutsa kalikonse payekhapayekha, koma pazigawo zonse zomwe zimatenga nawo mbali pakuwunikira. M'malo mwathu, iyi ndi data yomwe ili mgulu "Zotsatsa Zotsatsa" ndi "mtengo Wogulitsa".

   Parameti "Gulu" Siyani zosasinthika - Column ndi safu, popeza magulu athu a data agawidwa m'mizere iwiri. Ngati adasweka ndi mzere ndi mzere, ndiye kuti kusinthaku kuyenera kupita kumalo Mzere ndi mzere.

   Pazosankha, zomwe zimakhazikitsidwa zimakhala "Worksheet yatsopano", ndiye kuti, zomwe zikuwonetsedwa ziziwonetsedwa patsamba lina. Mutha kusintha malowa posuntha kusintha. Ili ndiye pepala la panopo (ndiye kuti muyenera kufotokozera magwirizanidwe a maselo otulutsa zidziwitso) kapena buku laling'ono (fayilo).

   Zosintha zonse zikakhazikitsidwa, dinani batani "Zabwino".

Popeza malo omwe zotsatira zakusanthula zimatsalira ndikusintha, timapita ku pepala latsopano. Monga mukuwonera, cholumikizira cholumikizidwa chikuwonetsedwa apa. Mwachilengedwe, zimakhala chimodzimodzi ngati mugwiritsa ntchito njira yoyamba - 0.97. Izi ndichifukwa choti njira zonse ziwiri zimawerengera zomwezo, zitha kuchitidwa m'njira zosiyanasiyana.

Monga mukuwonera, ntchito ya Excel imapereka njira ziwiri zakuwongolera nthawi imodzi. Zotsatira za kuwerengera, ngati muchita chilichonse bwino, zikhala zofanana. Koma, aliyense wosankha akhoza kusankha njira ina yabwino kwambiri yowerengera.