Dzidza Nzira Yakarurama Yokushandisa Google Spreadsheets MedIAN Function

01 ye 05

Kuwana Iko Pakati Pakati neMusangano weMEDIAN

Kune nzira dzakawanda dzekuyera kana, sezvinowanzonzi dzinowanzonzi, yevhareji, kune imwe yehutsika.

Kuita kuti zvive nyore kuyera mutemo wepakati, Google Spreadsheets ine mabasa akawanda ayo achaverenga maitiro anowanzoshandiswa pachiyero. Izvi zvinosanganisira:

• Basa reMEDIAN - rinoona kukosha kwemukati kana pakati mukati mezita rehuwandu;
• IAVERAGE basa - inowana aritemeni inoreva kureva mazita ehamba;
• Iyo MODE inoshanda - inowana maitiro kana kuti inowanzoitika inowanikwa muurongwa hwemawanda.

02 of 05

Kuwana yeMedan Mathematically

Mutevedzeri unonyatsorondedzerwa kune nhamba dzisinganzwisisiki dzehutano. Nokuti nhamba 2, 3, 4, yemuviri, kana yepakati, iyo nhamba 3.

Nehuwandu hwehutano hwemitemo, inyanzvi inoratidzirwa nekuwana arithmetic inoreva kana kuenzanisa zviyero zviviri zvepakati.

Semuenzaniso, mutevedzeri wezviverengero 2,3,4,5, anoverengerwa nekuenzanisa pakati nepakati nhamba nhatu 3 ne4:

(3 + 4) / 2

izvo zvinoguma mune imwe mizana ye3,5.

03 of 05

Syntax Inoshanda yeMedIAN uye Arguments

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

Izwi rechirevo cheMEDIAN chinonzi:

= MUTA (nhamba_1, nhamba_2, ... namba_30)

nhamba_1 - (inotarisirwa) data kuti iverengwe pakuverenga mutevedzeri

nhamba_2: nhamba_30 - (kusarudza) mamwe mazano ehuwandu akaiswa mukati mekuverengwa kwemukati. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndeye 30

Nhamba dzemibvunzo dzinogona kuva:

• rondedzero yenhamba;
• sero zvinyorwa kune nzvimbo yedhesi iri mubhidhiro remabasa;
• ruzhinji rwemaferensi ezvinyorwa;
• a name named .

04 of 05

Muenzaniso uchishandisa basa reMEDIAN

Aya matanho anotevera akashandiswa kupinda muMEDIAN basa muchikamu cheD2.

1. Tora chikwangwani chakaenzana (=) chinotevera zita remushandi median;
2. Sezvaunonyora, bhokisi rinotaridzika rinowanikwa nemazita uye masikirwo emabasa anotanga netsamba M;
3. Apo zita rokuti median rinowanikwa mubhokisi, divha muIkiyo yeKuisa pabhobhoyo kuti uise zita rebasa uye mazera ekuvhura muchitokisi D2;
4. Simbisai masero A2 kusvika kuC2 kuti uvaise seanoshuva basa;
5. Dhinda pikicha inopinda kuwedzera mababa ekuvhara uye kugumisa basa;
6. Nhamba 6 inofanira kuonekwa muchitokisi A8 seyemukati kune nhamba nhatu;
7. Paunenge uchinyora pane cell D2 yakakwana basa = MEDIA (A2C2) inowanikwa mubhairi yepamusoro pane pepa pepaji .

05 of 05

Masero asina kuchena vs. Zero

Kana zvasvika pakutsvaga mutevedzeri muGoogle Spreadsheets, kune musiyano pakati pekusavhara kana masero asina chinhu uye avo vane zero kukosha.

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

Kuchinja kwemukati pakati pezvienzaniso mumitsara mana neyishanu nokuti zero yakawedzerwa kune cell B5 asi sero B4 harina chinhu.

Semagumo,:

• iyo miviri yemutsara wechina inoverengwa nekuwedzera (6 + 4) / 2 = 5
• iyo miviri yemutsara wechishanu inongova pakati pezvinhu zvitatu zvinokosha: 4