Kodi kumanga histogram mu kupambana ndi Mawu

Palibe angatsutse mfundo yakuti histogram - chida chabwino zowoneka kusonyeza deta. Kungoyang'ana pa tchati, n'zotheka mu nthawi yaifupi kuti aone zinthu popanda kuwaika kusanthula mfundo n'zosangalatsa kumva tebulo. N'chifukwa chake dziko wotchuka spreadsheet mkonzi "kupambana" anatenga chida manja.

M'nkhani ino mudzaphunzila mmene kumanga bala Zithunzi mu kupambana. Pali njira zinayi yomanga mfutizo, omwe ndi mokwanira osiyana pakati pawo. Choncho ndikofunikira kuti nditsirize kuwerenga nkhaniyi mpaka kumapeto, kusankha njira okha. Kumapeto kwa nkhaniyi kudzakhala chitsanzo cha histogram mu "Mawu."

histogram

Mu kupambana, n'zotheka kuti amange histogram njira zitatu:

• ntchito chida chapadera;
• Kugwiritsa masanjidwe makonzedwe;
• ndi pokha-mvu.

Tsopano ife tiyang'ana pa njira zonse kumanga histogram mu kupambana. Mwa njira, izo zikhoza kupangidwa m'njira zosiyanasiyana - kukhala mbali ya foni kapena ngati chinthu osiyana.

Yoyamba njira: kumangira histogram ochiritsira

Ntchito yomanga inayambika ndi Kugawilidwa kwanthaka tebulo dera, phindu limene lidzakhala chaonetsedwera mu histogram m'tsogolo. Kamodzi kusankha yakhala ikuchitidwa upite kwa tsamba "Ikani". M'pofunika alemba pa "Histogram" batani, limene lili mu "Zithunzi".

Pomaliza, kutsogolo kwa inu ndi mndandanda mwatsatanetsatane za komwe muyenera kusankha imodzi zotchuka. Mwa njira, histogram mwachizolowezi limapezeka koyamba mu mndandanda.

Pambuyo kusankha mu kupambana adzakhala njira anakhumba, ndi mu chipinda chino tinganene kuti monga kulembedwa. Komabe, mutha kusintha histogram pogwiritsa ntchito zida kuti ali m'gulu la totsegulira lotchedwa "Kugwira ntchito ndi Charts".

Njira yachiwiri: yomanga kudzikundikira ndi

Monga mwa njira woyamba, tiyenera tebulo wodzipereka. The histogram Pankhaniyi wamangidwa pang'ono mosiyana. Chinthu choyamba muyenera tcheru - ili ndi dzina mu chamutu wa iwo sayenera. Apo ayi, palibe chimachitika.

Pambuyo kusankha muyenera kupita ku tsamba "Ikani", dinani "Charts" mu dontho pansi menyu "Histogram" kusankha zimakusangalatsani. Dziwani kuti histogram kudzikundikira ali mu gawo lamanja la mndandanda.

Ndi kusankha mmodzi wa zinthu, onani ndandanda pa pepala. The histogram, monga mu ndondomeko m'mbuyomu zikhoza kusintha pa nzeru zanu, ichinso ntchito zipangizo zomwe zili mu gulu la totsegulira "Kugwira ntchito ndi Charts".

Njira yachitatu: yomanga ntchito kuwonjezera-mvu

Tsopano ife kupita mu Njira ya chitatu momwe amange histogram. Amakhala mu ntchito ya kusanthula phukusi wapadera.

Sitepe yoyamba ndi kuti yambitsa phukusi. Kuti tichite zimenezi, mufunika pulogalamu poyamba alemba pa "Buku" batani. Kenako sidebar kupita "Zikhazikiko" gawo. Tsopano, kupeza katunduyo "Add-ins" menyu dontho-pansi "Control" kusankha "kupambana Add-ins." Kenako dinani "Pita" batani.

Mudzakhala pokha-ins bokosi limene muyenera kuika bango pafupi "Analysis ToolPak" ndi kudina "Chabwino" batani.

Choncho, phukusi kusanthula ndi adamulowetsa. Tsopano histogram ikuchitika mu "Data" - kupita kumeneko.

Pa Toolbar, muyenera akanikizire "Data Analysis", lili kumanja mu "Analysis". zenera A limapezeka imene mukufuna kuunikila "Histogram" ndiyeno akanikizire "Chabwino" batani.

Izi windo lina kumene mukufuna anapereka magawo a tsogolo la taperekachi. Mu "Lowetsani osiyanasiyana" muyenera mwachindunji malo pa tebulo, kumene deta adzakhala ntchito yomanga. Pambuyo pake, onani bokosi lotsatira kuti "Sonyezani zithunzi". Tsopano inu mukhoza mwachindunji kumene tchati adzakhala kuwonetsedwa. Pali zinthu zitatu - buku lolembamo latsopano, fomu latsopano kapena pa pepala la. Pambuyo zoikamo zakonzedwa, tilimbikire "Chabwino" batani.

Malinga ndi zotsatira zanu mwachindunji malo histogram Zithunzi ikusonyezedwa.

The njira yachinayi: kumanga ndi masanjidwe makonzedwe

The njira yachinayi ndi kumanga histogram, ndi mwapadera kwa onse anapereka pamwamba. Kumapeto kwa kusanthula wake, mudzaona nokha zimenezi.

Poyamba, monga mwa nthawi, muyenera kusankha malo pa tebulo, kumene deta adzakhala ntchito yomanga. Kamodzi zimenezi, kupita "Home" pa Toolbar, kutsegula dontho-pansi mndandanda wa "MAKONZEDWE Zokongoletsa". Mu inu muyenera kupeza chinthu "Histograms" ndi zenera chifukwa, kusankha mtundu wa histogram lapansi. Pali yachiwiriyo: a masinthidwe amtundu mudzaze ndi olimba. Kusiyana iwo pafupifupi palibe ayi, kotero kuti inu mukhoza kuganizira kukoma anu posankha.

Mukakhala kusankha mtundu wa histogram, uwoneka maselo apadera mawonekedwe a kudzazidwa mzere.

Histogram mu "Mawu"

Tsopano tiyeni tiwone momwe kupanga histogram mu "Mawu." Pakati pake penipeni, ndondomeko ya chilengedwe chake si wosiyana kwambiri kuchokera "kupambana", koma zinthu oyamba.

Poyamba, kusankha ndi kukanikiza mbewa batani kumanzere, malo mukufuna kumanga ndi histogram. Pambuyo pake, kupita ku tsamba "Ikani" ndi "Zithunzi", dinani "Ikani Tchati" batani - zenera lolingana adzaoneka.

Mu sidebar bokosi, sankhani gulu "Histogram," ndipo kumanja, mwachindunji mtundu wa histogram lapansi. Monga mukuonera, pali onse wamba ndi ndalama - kusankha yoyenera akanikizire "Chabwino" batani.

Pa pepala la "Ward" histogram wanu akuoneka. Onani kuti pa iwo adzakhala yaing'ono "ekselevskaya" tebulo kulowa deta. Ikani chofunika zosintha, ndi kusangalala chifukwa.

Tsopano inu mukudziwa momwe kupanga histogram mu "Mawu." Tikumbukenso, si ovuta kwambiri kuposa "Eksele".