Kuwana Averageverage Value neExpcel's AVERAGE Function

Shandisa IAVERAGE basa kuti uwane aritemu inoreva kureva mazita emitemo

Mathematically, kune nzira dzakawanda dzekuyera kwemaitiro epakati kana, sezvinowanzonzi zvinowanzonzi, yevhareji yezvidimbu zvehutano. Iyi nzira dzinosanganisira aritemeni zvinoreva , mhizha, uye nzira .

Chiyero chinonyanya kuverengwa chechimiro chetsika ndechokuti aritemi inoreva - kana iri nyore-uye inoratidzirwa nekuwedzera boka re nhamba pamwe chete uye kugoverwa nhamba yezviyero izvozvo. Somuenzaniso, muvhareji we2, 3, 3, 5, 7, uye 10 ndiwo 30 akaparadzaniswa ne6, iyo 5.

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

• IAVERAGE basa - inowana arithmetic inoreva kureva mazita ehuwandu
• Basa reMEDIAN - rinowana huwandu hwepakati kana hwepakati pane urongwa hwemawanda
• Iyo MODE inoshanda - inowana maitiro kana kuti inowanzoitika inowanikwa muurongwa hwemawanda

Iko Syntax yeAVERAGE neMagariro

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

Mutsara weAVERAGE basa ndewokuti:

= CHIKAMU (Number1, Number2, ... Number255)

• Nhamba1 - (inodikanwa) data kuti ienzaniswe nebasa racho.
• Nhamba2 kusvika kuNhamba 255 - (zvisarudzo) mamwe mazano ezvinyorwa kuti aiswe mukati mega. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndei 255.

Iyi nharo inogona kuva:

• Runyora rwemajeri runotarwa;
• Sero rinotaura nezvekunzvimbo kwedata iri mubasa rekushanda;
• Mhando yezvikamu zvinyorwa;
• A zita rakarongwa.

Kutsvaga KUTAURWA Kushanda

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana , rakadai se = AVERAGE (C1: C7) muchengeti rekushanda;
2. Kupinda basa uye nharo kushandisa sarudzo yebhokisi rebasa;
3. Kupinda basa uye nharo dzakashandisa Excel's Average function shortcut.

AVERAGE Function Shortcut

Excel ine nzira shoma yekupinda muAVERAGE basa - dzimwe nguva inonzi AutoAverage nekuda kwekushamwaridzana nehutano hunozivikanwa hweAustSum - huri paImba yebhu yebhoni .

Chiratidzo pane chebarimi yezvi uye nemamwe mabasa akawanda anozivikanwa ndeyechiGiriki tsamba Sigma ( Σ ). Nokutadza, AutoSum basa inoratidzwa pedyo neikoni.

Chikamu cheAuto chezita chinoreva kureva kuti kana wapinda achishandisa nzira iyi, basa rinosarudza zvarinotenda kuti mararamiro emasero anotsanangurwa nebasa racho.

Kuwana Avhareji neAgaAga

1. Dzvanya pane cell C8 - nzvimbo iyo maitiro emabasa anoratidzwa;
2. Sezvinoratidzwa mumufananidzo uri pamusoro, chete cell C7 inofanira kusarudzwa nemabasa - nekuda kwekuti cell C6 haina chinhu;
3. Sarudza utera hwakakodzera hwebasa C1 kusvika C7 ;
4. Dhinda pikicha yoKuisa pane keyboard kuti ubvume basa;
5. Mhinduro 13.4 inofanira kuonekwa muchitokisi C8.

Excel AVERAGE Function Example

Matanho ari pasi apa anokwanisa kupinda muAVERAGE basa rinoratidzwa mumutsara wechina mumuenzaniso uri mumufananidzo pamusoro apa uchishandisa nzira yekutsvaga kuAVERAGE basa inotaurwa pamusoro apa.

Kupinda muAVERAGE Function

1. Dzvanya pachitokisi D4 - nzvimbo iyo migumisiro yefomu icharatidzwa;
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pamusara wepasi pedo neBootSum bhodhi paibhoni kuitira kuti uzarure pasi-rutsoka rwemabasa
4. Dzvanya pazwi Avhareji muzvero kupinda muAVERAGE basa muchikamu D4
5. Dzvanya paMabasa icon pane bharakiti pamusoro pekuzarura rondedzero yezvidzidzo;
6. Sarudza Avhareji kubva pane urongwa ugoisa kopi isina chinhu yebasa muchitokisi D4;
7. Nokutadza, basa rinosarudza nhamba muchitokisi D4;
8. Shandura izvi nekusimbisa masero A4 kusvika kuC4 kuti uise zvinyorwa izvi sezvikonzero zvebasa uye tapinza muIno yeKuisa pane keyboard;
9. Nhamba yegumi inofanira kuonekwa muchikamu cheD4. Iyi ivhareji yenhamba nhatu - 4, 20, uye 6;
10. Paunenge uchitarisa pane cell A8 basa rakakwana = AVERAGE (A4: C4) inowanikwa mubhairi yepamusoro pane pepa pepaji.

Chengeta nyora idzi mupfungwa:

• Masero ega ega, panzvimbo peurongwa hunoramba huripo hunogona kuwedzerwa semafungiro asi sero rega rega rinofanirwa kuparadzana nekma.

• Nyora inopinda uye masero ane Bhoolean maonero (TRUE kana FALSE) uye masero asina chinhu haana hanya nebasa sezvinoratidzwa mumitsara 6, 8 ne9 pamusoro.

• Mushure mokupinda mubasa racho, kana kuchinja kunogadzirwa kune data mumasero akasarudzwa, basa racho, nekutadza, rinongoratidzira zvakare kuratidza kuchinja.

Nzira Yokuti AutoAverage Inosarudza Argument Range

• Nzira yakasara inosanganisira masero ane nhamba, uwandu hwenhamba dzakasarudzwa huvhiringidzika nesero iri rine zvinyorwa kana sevha isina chinhu.
• IAVERAGE basa yakagadzirirwa kuiswa pasi pekorodhe ye data kana kumucheto wakarurama wemutsara we data. Inotanga kutarisa nhamba yedhamba kumusoro uye kuruboshwe.
• Kubvira paAVERAGE basa, chaizvoizvo, kufungidzira pane iyo yakasarudzwa iyo inosarudza nharo yeNhamba, kusarudzwa uku kunofanira kuongororwa kuti ive yakarurama zvisati zvanyanya kuvhara kupinda mubhokisi kuti upedze basa.

Masero asina kuchena vs. Zero

Kana zvasvika pakutsvaga mavhareji muExpcel, kune musiyano pakati pevharivha kana masero asina chinhu uye avo vane zero kukosha.

Masero asina kujeka haatauri neAVERAGE basa, iyo inogona kuva yakasimba sezvo ichiita kuti pave nekuenzanisa kwemasero asina kubatana e data zvakanyanya nyore sezvinoratidzwa mumutsara 6 pamusoro.

Masero ane zero kukosha, zvisinei, akabatanidzwa mumwero wakatarwa sezvinoratidzwa mumutsara 7.

Kuratidza Zeros

Nenguva isipi, Excel inoratidza zero mumasero ane kukosha kwezero - yakadai semugumisiro wekuverenga, asi kana sarudzo iyi ikadzimwa, masero akadaro akasiiwa asina chinhu, asi achiri kuiswa mumavhareji kuverenga.

Kugadzirisa iyi sarudzo:

1. Dzvanya paDhiyabhorosi tab yebhoni kuitira kuti uratidze mifananidzo yezvinyorwa zvesarudzo;
2. Dzvanya Zvimwe zviri muurongwa kuti uzarure Excel Options dialog box.
3. Dzvanya paZvikwata zvakadzama muboshwe-kuruboshwe pane bhokisi rebhokisi kuti uone zvinoshandiswa.
4. Muruoko rworudyi-pane, pane Zvichasarudza zvarongwa zvechikamu chesebasa chebasa cheza bhokisi rekutarisa Ratidza zero mumasero ane zero value checkbox.
5. Kuti uratidze zero (0) maonero mumasero iva nechokwadi chekuti Kuratidza zero mumasero ane zero value checkbox anosarudzwa.