Uburyo bwo gukora imbonerahamwe mu buhungiro

Microsoft Excel yemerera gukora gusa gukorana gusa namakuru yumubare, ariko kandi atanga ibikoresho byo kubaka ibipimo bishingiye kuri ibipimo byinjiye. Iyerekanwa ryabo rirashobora gutandukana rwose kandi biterwa nibisubizo byabakoresha. Reka tumenye uburyo bwo gushushanya ubwoko butandukanye bwibishushanyo ukoresheje iyi gahunda.

Imbonerahamwe yo kubaka muri excel

Kuberako binyuze muri Excel urashobora gutunganya amakuru yubarera hamwe nandi makuru, igikoresho cyo kubaka ibizamini hano bikora muburyo butandukanye. Muri uyu muhinduzi, hari ubwoko busanzwe bwibishushanyo bishingiye ku makuru asanzwe n'ubushobozi bwo gukora ikintu cyo kwerekana ko igipimo cy'inyungu cyangwa no kwerekana neza amategeko ya Pareto. Ibikurikira, tuzavuga uburyo butandukanye bwo gukora ibi bintu.

Ihitamo 1: Kubaka imbonerahamwe kumeza

Kubaka ubwoko butandukanye bwibishushanyo ntaho bitandukaniye, gusa kurwego runaka ugomba guhitamo ubwoko bukwiye bwo kwiyumvirwa.

1. Mbere yuko utangira gukora imbonerahamwe iyo ari yo yose, birakenewe kubaka imbonerahamwe hamwe namakuru ashingiyeho azubakwa. Noneho jya kuri tab "shyiramo" hanyuma ugabanye agace k'ameza, bizagaragarira mu gishushanyo.



2. Kuri kaseti kuri progaramu yo kubitsa, duhitamo bumwe muburyo butandatu bwingenzi:
   • Igishushanyo;
   • Ingengabihe;
   • Umuzenguruko;
   • Umurongo;
   • N'uturere;
   • Ingingo.



3. Byongeye kandi, ukanze kuri buto ya "Ibindi", urashobora guhagarara kuri bumwe muburyo buke busanzwe: ububiko, ubuso, impeta, igituba, pote.



4. Nyuma yibyo, ukanze kubwoko bumwe bwimbonerahamwe, ubushobozi bwo guhitamo ubwoko bwihariye. Kurugero, kuri estogramu cyangwa akanwa hitomo cyangwa akabari, nkiyi ni ibintu bikurikira: Ibisanzwe bya hestogramu, igice kinini, silindrical, piramidal.



5. Nyuma yo guhitamo igice runaka, igishushanyo gihita gishiraho. Kurugero, New Histogramu izareba yerekanwe mumashusho hepfo:



6. Imbonerahamwe muburyo bw'igishushanyo bizaba nkibi bikurikira:



7. Ihitamo hamwe nuturere bizatwara ubu bwoko:

Gukorana n'ibishushanyo

Iyo ikintu cyakozwe, ibikoresho byinyongera kugirango uhindure kandi impinduka ziboneka muri tab nshya "Gukorana nimbonerahamwe".

1. Ubwoko bwo Guhindura Ubwoko, Imiterere nibindi bipimo byinshi.



2. "Akazi hamwe n'imbonerahamwe" hagira hantu hatatu ku bisobanuro bitarenze: "Imiterere", "imiterere" na "imiterere", urashobora guhindura ikarita yayo nkuko bibaye ngombwa. Kurugero, kuvuga igishushanyo, fungura tab "imiterere" hanyuma uhitemo imwe mumazina yizina: hagati cyangwa kuva hejuru.



3. Nyuma yo gukorwa, izina risanzwe "risanzwe" izina "rigaragara. Turabihindura ku nyandiko iyo ari yo yose ibereye mu rwego rw'iyi mbonerahamwe.



4. Izina ry'ishoka ryashyizweho ryashyizweho umukono nihame rimwe, ariko kubwibyo ukeneye gukanda buto "AXIS".

Ihitamo rya 2: Kwerekana imbonerahamwe ijanisha

Kugaragaza ijanisha ryibipimo bitandukanye, nibyiza kubaka igishushanyo kizengurutse.

1. Mu buryo nk'ubwo, uko twabwiwe, twubaka ameza, hanyuma duhitemo amakuru. Ibikurikira, jya kuri tab "shyiramo", vuga igishushanyo kizengurutse kuri kaseti no gukanda urutonde rugaragara muburyo ubwo aribwo bwose.



2. Gahunda yigenga iraduhindura muri kimwe muri tabs gukorana niki kintu - "umushushanya". Hitamo mumiterere muri lente ya buri wese, aho hari ikimenyetso cyijana.



3. Igishushanyo cyuruziga hamwe namakuru yerekanwe kuri ijana yiteguye.

Ihitamo rya 3: Kubaka imbonerahamwe pareto

Dukurikije ibitekerezo bya Wilfredo Pareto, 20% byibikorwa byiza cyane bizana 80% byabisubizo muri rusange. Kubwibyo, 80% isigaye yibikorwa byose byibikorwa bidakora, 20% gusa byibisubizo byazanye. Imbonerahamwe yo kubaka Pareto ikubiyemo gusa kubara ibikorwa byiza cyane bitanga inyungu ntarengwa. Bikore ukoresheje Microsoft Excel.

1. Nibyiza cyane kubaka iki kintu muburyo bwa histogramu, ibyo tumaze kuvuga haruguru.
2. Reka dutanga urugero: ameza arimo urutonde rwibiryo. Mu nkingi imwe, agaciro ko gutanga amasoko yubunini bwubwoko bwihariye bwibicuruzwa byibicuruzwa byinshi byanditswe, no mu bya kabiri - inyungu mu ishyirwa mu bikorwa ryayo. Tugomba kumenya ibicuruzwa bitanga "kugaruka" mugihe ugurisha.

   Mbere ya byose, twubakira muri Histogramu: Tujya kuri tab "shyiramo", tugenera akantu kose k'imyanda, kanda buto ya "Histogramu" hanyuma uhitemo ubwoko bwifuzwa.



3. Nkuko mubibona, imbonerahamwe ifite ubwoko bubiri bwinkingi yakozwe nkigisubizo: ubururu n'umutuku. Noneho dukwiye guhindura inkingi zitukura kuri gahunda - hitamo inkingi hamwe na indanga no kuri "uwashushanyije" ukanze kuri "guhindura ubwoko bwimbonerahamwe".



4. Idirishya rihindura idirishya rifungura. Jya kuri "Gahunda" hanyuma ugaragaze ubwoko bubereye intego zacu.



5. Rero, igishushanyo cya pareto cyubatswe. Noneho urashobora guhindura ibintu (izina ryikintu na chaes, imiterere, nibindi) nkuko byasobanuwe kurugero rwimbonerahamwe yimyuma.

Nkuko mubibona, Excel itanga imirimo myinshi yo kubaka no guhindura ubwoko butandukanye bwibishushanyo - umukoresha agumaho guhitamo ubwoko kandi bukenewe kugirango imyumvire igaragara.