Nzira Yokuwana nayo Median (Average) muExpcel

Kushandisa Basa reMEDIAN mu Microsoft Excel

Mathematically, kune nzira dzinoverengeka dzekuyera chimiro chepakati kana, sezvinowanzonzi kazhinji, chiyero chetsika yehutsika . Ivhareji kuva pakati kana pakati pakati peboka rezviverengero mune kugoverwa kwenhamba.

Munyaya yemukati, ndiyo nhamba yepakati muboka remazana. Hafu iyo nhamba ine zvido zvakakura kudarika midzi, uye hafu yenhamba ine zvido zvisingasviki zvemukati. Semuenzaniso, muteereri wezera "2, 3, 4, 5, 6" ndeye 4.

Kuita kuti zvive nyore kuongorora hutano hwepakati, Excel ine mabasa akawanda anozoverenga maitiro anowanzoshandiswa pachiyero:

• Basa reMEDIAN: Rinowana huwandu hwepakati kana hwepakati mumutsetse wehuwandu
• IAVERAGE basa : Inoona aritemu inoreva kureva mazita emhando
• Iyo MODE inoshanda : Inoona iyo nzira kana kuti inowanzoitika inowanikwa munhamba ye nhamba

Basa reMedhia Rinoshanda Sei?

Basa reMEDIAN rinotarisana nemafungiro akapiwa kuti awane kukosha kunowira arithmetically pakati peboka.

Kana nhamba isinganzwisisiki yepikisheni inopiwa, basa racho rinoratidza hutengo hwepakati mukati mehupamhi sehuwandu hwemukati.

Kana imwe nhamba yemakakatanwa inopiwa, basa rinotora aritemu rinoreva kana kuenzanisa kwepakati mairi nheyo sehuwandu hunokosha.

Cherechedza : Maitiro anopiwa semafungiro asingatsvaki kurongedzerwa pane imwe nzira kuitira kuti basa rishande. Iwe unogona kuona kuti mukutamba mumutsara wechina mumufananidzo wemuzasi.

Basa reMedhiya Syntax

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo.

Ichi ndicho chirevo chebasa reMEDIAN:

= MUTA ( Nhamba1 , Nhamba2 , Nhamba3 , ... )

• = MASHUNGA : Ndiwo maitiro ayo maMedIAN ose aifanira kutanga, saka izvi hazvigone kuchinjwa.
• Nhamba1: Dhairiro inoda kuti ienzaniswe nebasa racho
• Nhamba2 : Zvimwe zvekuwedzerwa kwehuwandu hwehuwandu hwemashoko hunogona kuiswa mumusangano. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndei 255, chimwe nechimwe chazvo chinoda kuparadzaniswa nekomma.

Iyi nharo inogona kuva:

• urongwa hwehuwandu hunogona kuenzaniswa
• sero rinotaura nezve nzvimbo ye data mune pepa rekushanda
• ruzhinji rwemasero zvinyorwa
• a name named

Zvisarudzo zvekupinda mubasa uye nharo dzayo:

• Kunyora basa rakakwana, se = MEDIA (A2: F2) , mupepeti yekushanda
• Kupinda basa uye nharo dzinoshandisa bhokisi rebasa rebasa

Basa reMedhiya Muenzaniso

Aya matanho anokwanisa kuisa sei basa reMEDIAN uye nharo dzinoshandisa bhokisi rebhokisi yekutanga kuratidzwa mumufananidzo uyu:

1. Dzvanya pane cell G2. Iyi ndiyo nzvimbo iyo migumisiro icharatidzwa.
2. Dzokera kune maMafomu> Zvimwe Mamwe mabasa> Statistical menu item kuti uwane MEDIAN kubva pakurongwa.
3. Mutsamba yekutanga yebhokisi mubhokisi rebhokisi, sarudza masero A2 kusvika kuF2 mubhidhiro rekushandisa kuti uise huwandu iyo.
4. Dzvanya OK kuti upedze basa uye dzokera kushizha rekushanda.
5. Mhinduro 20 inofanira kuonekwa muchitokisi G2
6. Kana iwe ukanyora pane sejeri G2, basa rakakwana, = = MEDIA (A2: F2) , rinowanikwa mubhairi yepamusoro pane pepa pepaji.

Nei chiyero chemukati chichikosha makumi maviri? Nokuda kwemuenzaniso wokutanga mumufananidzo, sezvo pane nhamba dzisinganzwisisiki dzemakakatanwa (mashanu), kukosha kwemukati kunotarirwa nekuwana nhamba yapakati. Ndiko pano nokuti kune nhamba mbiri mbiri (49 ne65) uye nhamba mbiri mbiri (4 ne12).

Mabhendi asina kuchena vs Zero

Kana zvasvika pakutsvaga mutevedzeri muEexcel, pane musiyano pakati pekusavhara kana masero asina chinhu neavo vane zero kukosha.

Sezvinoratidzwa mumienzaniso iri pamusoro, pasina masero mashoma haatauri nebasa reMEDIAN asi kwete avo vane zero kukosha.

• Kuchinja kwemukati pakati pemuenzaniso wekutanga uye wechipiri nokuti zero yakawedzerwa kune cell A3 asi chekisi A2 haina chinhu.
• Kuwedzerwa kwe zero kumusana weA3 kunoshandura nhamba yezvakaitika zvakapedzisira kune basa muchitokisi G3 kubva pa5 kusvika kune matanhatu - kunyange nhamba. Somugumisiro, mutevedzeri anoverengerwa nekuwedzera mairi maviri epakati (12 ne20) pamwe chete ndokuzoparadzanisa neveviri kuti awane mavhareji (16).

Nenguva dzose, Excel inoratidza zero (0) mumasero ane kukosha kwezero - sezvinoratidzwa mumuenzaniso uri pamusoro. Iyi sarudzo inogona kuvharwa uye, kana ikaitwa, masero akadaro akasiiwa asina chinhu, asi kukosha kwezero kwechiremba ichocho kuchiri kusanganiswa sepikisheni yebasa kana kuverenga mutevedzeri.

Heino nzira yekugadzirisa iyi sarudzo uye yega:

1. Nzira kuFilisi > Options menu (kana Excel Options mumakore ekare eExcel).
2. Enda muZvikwata zvakadzama kubva kumucheto uri kuruboshwe rwezvaunogona.
3. Kurutivi rworudyi, pfugama pasi kusvikira uwana "Ratidza zvisarudzo zvechikamu chebasa iri" chikamu.
4. Kuti uvanze hutano hwemasero mumasekese, sarudza Ratidza zero mumasero ane zero kukosha cheki bhokisi. Kuti uone zeros, isa cheki mubhokisi.
5. Chengetedza chero shanduko nechocho OK .