Kunzwisisa Basa reMODE muGoogle Sheets

01 ye 01

Tsvaga Chinhu Chinowanzoitika Zvikuru Kwazvo NeMODE Basa

MaSpredishiti eGoogle ispredishiti yewebhu-yakarumbidzwa nekuda kwekusununguka kwekushandisa. Nemhaka yokuti haisi kusungirirwa kumushini mumwe chete, inogona kusvika kune imwe nzvimbo uye pane chero rudzi rwechigadzirwa. Kana iwe uri mutsva kuGoogle Sheetsiti, iwe unoda kuziva mabasa akawanda kuti utange. Ichi chinyorwa chinotarisa basa reMODE, iro rinowana kukosha kunowanzoitika pane imwe yenhamba.

Somuenzaniso, nokuti nhamba yakatarwa:

1,2,3,1,4

iyo ndiyo inhamba nhamba 1 sezvo ichiitika kaviri mubhuku uye imwe neimwe nhamba inowanikwa kamwe chete.

Kana nhamba mbiri kana kupfuura dzikaitika munyore nhamba imwe chete yezviitiko, ivo vose vari vaviri vanofunga kuti ndiyo nzira.

Nokuti nhamba yakatarwa:

1,2,3,1,2

zvose nhamba 1 ne2 dzinofungidzirwa kuti ndiyo nzira sezvo zvose zviri zviviri zvinowanikwa kaviri mumutsara uye nhamba 3 inowanikwa kamwe chete. Muenzaniso wechipiri, nhamba yakatarwa inonzi iine bimodal.

Kuti uwane nzira yekugadzirisa nhamba paunenge uchishandisa Google Sheets, shandisa MODE basa.

Nzira Yokushandisa Nayo Basa reMODE muGoogle Sheets

Vhura gwaro idzva risina mahwendefa eGoogle uye tevera matanho aya kudzidza kuti ungashandisa sei MODE basa.

1. Isa data inotevera inomutsetse A1 kusvika kuA5: shoko rokuti "one," uye nhamba 2, 3, 1 uye 4 sezvinoratidzwa mufananidzo unoenderana nenyaya ino.
2. Dzvanya pane cell A6, iyo ndiyo nzvimbo iyo migumisiro icharatidzwa.
3. Tora chiyero chechipiri = chinotevera nezwi "mode ."
4. Sezvaunonyora, bhokisi rinotsanangura-bhokisi rinowanikwa nemazita uye maitiro ezvinyorwa zvinotanga netsamba M.
5. Apo shoko rokuti "mode" rinowanikwa mukati mebhokisi, shandisai muIki yeKuisa pabhobhoyo kuti uise zita rebasa uye uzarure bhandi rakapoteredza ( mune cell A6.
6. Simbisai masero A1 kusvika kune A5 kuti muvaise sezvinoitwa nharo.
7. Tora chivharo chekuvhara mabhirikiti ) kuti uvhare mhinduro dzebasa.
8. Dhinda pikicha inopinda mubhokisi kuti upedze basa.
9. I # N / A kukanganisa kunofanira kuonekwa muchitokisi A6 sezvo hapana nhamba mumakamuri akasarudzwa emasero anowanikwa kanopfuura kamwechete.
10. Dzvanya pane sero A1 uye nyora nhamba 1 kuti utore shoko rokuti "one."
11. Dhinda pikicha inopinda mubhokisi
12. Migumisiro yeMODE inoshanda muchitsauko A6 inofanira kuchinja kusvika 1. Nokuti pane ikozvino masero maviri ari muzera rine nhamba 1, iyo ndiyo nzira yeiyo yakasarudzwa nenhamba.
13. Paunenge uchitarisa pane cell A6, basa rakakwana = MODE (A1: A5) inowanikwa mubhairi yepamusoro pane pepa rekushanda

Iko Syntax yeMagetsi uye Arguments

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

Izwi rechiito cheMODE ndere: = MODE (number_1, number_2, ... number_30)

• nhamba_1 - (inoshandiswa) iyo data inogona kuiswa pakuverenga mamiriro acho
• nhamba_2: nhamba_30 - (kusarudza) mamwe mazano emitemo kuti aiswe mumamiriro ekuverenga. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndeye 30.

Nhamba dzemibvunzo dzinogona kuva:

• rondedzero yenhamba
• sero rinotaura nezve nzvimbo ye data mune pepa rekushanda
• ruzhinji rwemasero zvinyorwa
• a name named

Notes

• Nyore yekunyoreswa yakabatanidzwa muhutano hwemaferensi esero hauna hanya nebasa racho. Kana masero ane magwaro akazogadziriswa kuti awane nhamba, iyo nzira inodzokorora, kana zvichidikanwa, kuti igone kuchinja.
• Kana pasina kukosha kunowanikwa kanopfuura kamwe mumutsetse wakasarudzwa wedata, nhamba ye # N / A inowanikwa mune sero iyo basa iri.