Open Office Calc Tutorial AVERAGE Basa

Mathematically, kune nzira dzakawanda dzekuyera kwemaitiro epakati kana, sezvinowanzonzi zvinowanzonzi, yevhareji yezvidimbu zvehutano. Iyi nzira dzinosanganisira aritemeni zvinoreva , mhizha, uye nzira . Chiyero chinonyanya kuverengwa chepakati chetsika ndechokuti aritemi inoreva - kana iri nyore. Kuita kuti zvive nyore kune arithmeti zvinorevei, Open Office Calc ine basa rakagadzirirwa, rakadanwa, hazvishamisi, AVERAGE basa.

01 ye 02

Kuti Ivhareji inoratidzwa sei

Ivhareji inoratidzirwa nokuwedzera boka re nhamba pamwe chete uye kugoverwa nhamba yezviyero izvozvo.

Sezvinoratidzwa mumuenzaniso uri mumufananidzo uri pamusoro apa, muvhareji wezvinhu zvinokosha: 11, 12, 13, 14, 15, uye 16 kana zvakakamurwa ne6, iyo 13.5 sezvinoratidzwa muchitokisi C7.

Panzvimbo pokutsvaga mavhareji evanhu, zvisinei, sero iri rine AVERAGE basa:

= CHIKAMU (C1: C6)

izvo zvisingawaniki chete kuti aritemi inoreva kureva mazano ezvino asi zvinozopawo mhinduro yakagadziriswa kana data iri muboka iri remasero richinje.

02 of 02

Iko Syntax yeAVERAGE

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo

Mutsara weAVERAGE basa ndewokuti:

= KUTANGA (nhamba 1; nhamba 2; ... nhamba30)

Kusvika kumakumi makumi matatu kunogona kuenzaniswa nemabasa.

IAVERAGE Function Arguments

nhamba 1 (inoshandiswa) - data inogona kuenzaniswa nemabasa

nhamba 2; ... nhamba30 (zvisarudzo) - mamwe mashoko anokwanisa kuwedzerwa kune avhareji kuverenga.

Nharo dzinogona kuva:

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

Muenzaniso: Tsvaga Ivhareji Yakaisvonaka yeKirasi yeNhamba

1. Isa data inotevera inhengo C1 kusvika C6: 11, 12, 13, 14, 15, 16;
2. Dzvanya pane cell C7 - nzvimbo iyo migumisiro icharatidzwa;
3. Dzvanya paMushandi Wemagetsi wechiratidzo - sezvinoratidzwa mumufananidzo uri pamusoro - kuti uzarure Bhokisi reSebenzi rebhokisi rebhokisi ;
4. Sarudza Statistical kubva pane Category list;
5. Sarudza Avhareji kubva pane Rwendo rweMabasa;
6. Dhinda Uchitevera;
7. Simbisai masero C1 kusvika kuC6 mune pepadheetti kuti uise huwandu huno mubhokisi rebhokisi munhamba 1 argument line;
8. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi;
9. Nhamba "13.5" inofanira kuonekwa muchitokisi C7, iyi inowanikwa kuti nhamba inopinda mumasero C1 kusvika kuC6.
10. Paunenge uchinyora pa cell C7 yakakwana basa = AVERAGE (C1: C6) inowanikwa mumutsara wokupinza uri pamusoro pebasa

Cherechedza: Kana data yaunoda kuenzanisa inopararira mumasero ega ega pane pepa rekushanda kwete pane imwe imwe korombo kana mumutsara, pinda rimwe nerimwe rekutsvaira mubhokisi rebhokisi pane imwe nharo yenyaya - yakadai senhamba 1, nhamba 2, nhamba 3.