Isesengura rifitanye isano muri Excel: amahitamo yakazi

Isesengura rifitanye isano nuburyo bukunzwe nubushakashatsi bwibarurishamibare, bukoreshwa mukumenya urwego rwo kwishingikiriza kumurongo umwe. Microsoft Excel ifite igikoresho kidasanzwe cyagenewe gukora ubu bwoko bwisesengura. Reka tumenye uburyo bwo gukoresha iki gikorwa.

Ishingiro ryo gusesengura guhuza

Intego yo gusesengura igabanijwe kugirango igaragaze ko yishingikiriza ibintu bitandukanye. Ni ukuvuga, igenwa niba kugabanuka kwatewe cyangwa kwiyongera mubimenyetso bimwe byimpinduka kurundi.

Niba kwishingikiriza byashyizweho, bigenwa hamwe. Isesengura ridahuye, iyi niyo kimenyetso cyonyine kibara ubu buryo bwo ubushakashatsi bwibarurishamibare. Coeeffic ihumure iratandukanye murwego kuva +1 kugeza -1. Niba hari ihumura neza, kwiyongera mubipimo kimwe bigira uruhare mu kwiyongera kwa kabiri. Hamwe no guhuza nabi, kwiyongera mubipimo kimwe bikubiyemo kugabanuka kurundi. Module ikora neza ihumure, impinduka zigaragara mu cyerekezo kimwe kigaragarira ku mpinduka mubya kabiri. Hamwe na coefficient ingana na 0, kwishingikiriza hagati yabo ntibishoboka rwose.

Kubara Coerefer Coeffice

Noneho reka tugerageze kubara amafaranga yimari kurugero runaka. Dufite ameza aho ari irangi rya buri kwezi kubavuga batandukanye mugutanga ibicuruzwa no kugurisha. Tugomba kumenya urwego rwo kwishingikiriza ku mubare wo kugurisha ku bijyanye n'amafaranga, yakoreshejwe mu kwamamaza.

Uburyo 1: Kugena isano binyuze muri Master of Imikorere

Bumwe mu buryo isesengura rifitanye isano rishobora gukorwa ni ugukoresha imikorere ihumure. Imikorere ubwayo ifite icyerekezo rusange cya Corneal (Array1; Array2).

1. Hitamo selile aho ibisubizo byo kubara bigomba kuba bivuzwe. Kanda kuri buto "Shyiramo Imikorere", ishyirwa ibumoso bwumugozi wa formula.



2. Ku rutonde, rutangwa muri wizard wizard, dushakisha no gutanga imikorere ya cornel. Kanda kuri buto ya "OK".



3. Imikorere irafungura. Mu murima wa "masuve1", tumenyekanisha imirongo ya selile imwe yimwe mu ndangagaciro, kwishingikiriza bigomba kugenwa. Ku bitureba, izi zizaba indangagaciro muri "Igurishwa". Kugirango wongere aderesi ya array mumurima, gusa bigabanya selile zose zifite amakuru mumikino yavuzwe haruguru.

   Mu murima "massive2" Ugomba gukora imirongo yinkingi ya kabiri. Dufite ibiciro byo kwamamaza. Nkuko byavuzwe haruguru, twinjije amakuru mumurima.

   Kanda kuri buto ya "OK".

Nkuko tubibona, guhuza imiterere muburyo bwinshi bugaragara muri selire twahisemo. Muri iki gihe, bingana na 0.97, nikintu kinini cyane cyo kwishingikiriza ku gaciro kamwe uhereye kurundi.

Uburyo 2: Kubara isano ukoresheje paki yisesengura

Byongeye kandi, ihuriro rishobora kubarwa rikoresheje kimwe mubikoresho, bigereranywa mubipaki. Ariko mbere yuko dukeneye iki gikoresho cyo gukora.

1. Jya kuri tab "dosiye".



2. Mu idirishya rifungura, wimuke mu gice cya "Parameter".



3. Ibikurikira, jya kuri "ongeraho".



4. Mu idirishya rikurikira mu gice cya "Gucunga", twongera kuri gahunda kuri "Excel Ongeraho-" mu mwanya, niba ari mu bundi buryo. Kanda kuri buto ya "OK".



5. Mu idirishya rya on-ons, dushiraho amatiku hafi ya "isesengura". Kanda kuri buto ya "OK".



6. Nyuma yibyo, paki isesengura irakora. Jya kuri tab "data". Nkuko mubibona, guhagarika ibikoresho bishya bigaragara kuri lente - "gusesengura". Kanda kuri buto "Gusesengura amakuru", birimo muri yo.



7. Urutonde hamwe namahitamo atandukanye yo gusesengura amakuru. Hitamo ingingo "Ifitanye isano". Kanda kuri buto ya "OK".



8. Idirishya rifungura hamwe no gusesengura ibipimo bifitanye isano. Bitandukanye nuburyo bwambere, mumurima "intera" tumenyekanisha intera ya buri nkingi zitandukanye, ariko inkingi zose zigira uruhare musesengura. Ku bitureba, aya ni amakuru mu nkingi "ibiciro byo kwamamaza" na "agaciro kagurishwa".

   Igipimo cya "Gusya" gisigaye kidahindutse - "ku nkingi", kubera ko dufite itsinda ryamakuru ryacitsemo ibice bibiri. Niba baravunitse umurongo, noneho rero bagomba gutondekanya kumwanya "kumurongo".

   Mubisanzwe bisohoka Ibipimo, "Urutonde rushya rwakazi" Ingingo rwashyizweho, ni ukuvuga amakuru azerekanwa kurundi rupapuro. Urashobora guhindura ikibanza uhuza switch. Irashobora kuba urupapuro (noneho uzakenera kwerekana imirongo yo gusohoka amakuru) cyangwa igitabo gishya cyakazi (dosiye).

   Iyo igenamiterere ryose ryashyizweho, kanda kuri buto "OK".

Kubera ko isesengura ryibisubizo byisesengura ryasizwe na decial, twimukira kurupapuro rushya. Nkuko mubibona, ububiko buhuza. Mubisanzwe, ni kimwe no mugihe ukoresheje uburyo bwa mbere - 0.97. Ibi birasobanurwa nukuri ko amahitamo yombi akora kubara rimwe, ababyara muburyo butandukanye.

Nkuko mubibona, porogaramu ya Excel itanga uburyo bubiri bwo gusesengura icyarimwe. Igisubizo cyibarirwa, niba ukora byose neza, bizaba bimwe rwose. Ariko, buri mukoresha arashobora guhitamo amoko yoroshye kuri yo.