Thola Isilinganiso (Imodi) Ngomsebenzi we-MODE we-Excel

Imodi yokwahlula kwamanani wedatha ichazwa njengenani elivame ukwenzeka kakhulu ohlwini.

Isibonelo, emgqeni wesibili esithombeni esingenhla, inombolo engu-3 iyimodi njengoba ivela kabili ebangeni lobubanzi A2 kuya ku-D2, kanti zonke ezinye izinombolo zivela kanye kuphela.

Imodi iphindwe iphindwe, kanye nencazelo nesikhombisa, ukuba isilinganiso senani elijwayelekile noma ukuthambekela okuphakathi kwedatha.

Ukuze kube nokusabalalisa okujwayelekile kwedatha - okufanekiselwa imidwebo nge-curve ye-bell - isilinganiso sezinyathelo ezintathu zokuthambekela okuphakathi kukhona inani elifanayo. Ukuze kusatshalaliswe idatha, inani elilinganiselwe lingahluka ngezinyathelo ezintathu.

Ukusebenzisa umsebenzi we-MODE ku-Excel kwenza kube lula ukuthola inani elithatha kakhulu kwiqoqo lemininingwane ekhethiwe.

01 ka-03

Thola I-Value Frequently Acurring Value ku-Range Data

Izinguquko kumsebenzi we-MODE - Excel 2010

Ku- Excel 2010 , iMicrosoft yazisa izindlela ezimbili zokusebenzisa umsebenzi wonke we-MODE:

• Umsebenzi we-MODE.SNGL: usetshenziselwa idatha ngemodi eyodwa - efana kakhulu nomsebenzi we-MODE ohlanganiswe lapha;
• I-MODE.MULT Umsebenzi: isetshenzisiwe uma idatha ingase ibe namamodi amaningi - amanani amabili noma ngaphezulu atholakala ngezimvamisa ezifanayo.

Ukuze usebenzise umsebenzi we-MODE ovamile ku-Excel 2010 nezinguqulo zamuva, kufanele kufakwe ngesandla, njengoba kungekho bhokisi lengxoxo ehlotshaniswa nalo kulezi zinguqulo zohlelo.

02 ka-03

I-syntax yeMisebenzi ye-MODE ne-Arguments

I-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.

I-syntax yomsebenzi we-MODE yile:

= I-MODE (Inombolo1, Inombolo2, Inombolo3, ... Inombolo255)

Inombolo1 - (edingekayo) amanani asetshenziselwa ukubala imodi. Le mpikiswano ingaqukatha:

• izinombolo zangempela - ezahlukana nama-commas - isibonelo kulayini 3 esithombeni ngenhla;
• ibanga elilodwa eliqukethe izingqikithi zamangqamuzana endaweni yedatha ekhasini lokusebenzela - izibonelo emigqeni 2, 5,6, no-7;
• inhlanganisela yezingcingo zesitoreji nedatha - isibonelo kulayini 4;
• ububanzi obuqanjwe;
• izinkomba zomuntu ngabanye ezihlukaniswe ngama-commas.

Number2, Number3, ... Inani255 - (okukhethwa kukho) amanani engeziwe noma izinkomba zeseli kuze kufike ku-255 esetshenziselwe ukubala imodi.

Amanothi

1. Uma ibanga lemininingwane ekhethiwe lingenalo idatha yedatha, umsebenzi we-MODE uzobuyisa inani lephutha le- # N / A - njengoba kuboniswe kulayini 7 esithombeni ngenhla.
2. Uma amanani amaningi ku-data akhethiwe ayenzeka ngemvamisa efanayo (ngamanye amagama, idatha iqukethe izindlela eziningi) umsebenzi ubuyisela imodi yokuqala ehlangana nayo njengemodi yonke isethi yedatha - njengoba kuboniswe emgqeni 5 esithombeni ngenhla . Ibanga ledatha le-A5 kuya ku-D5 linamamodi angu-2 - 1 no-3, kepha i-1 - imodi yokuqala ehlangene - ibuyiselwa njengemodi ebangeni lonke.
3. Umsebenzi awuzinaki:
   • izintambo zombhalo;
   • amanani anengqondo noma ama-Boolean;
   • amaseli angenalutho.

Isibonelo somsebenzi weMODE

03 ka 03

Isibonelo somsebenzi weMODE

Emfanekisweni ngenhla, umsebenzi we-MODE usetshenziselwa ukubala imodi yezinamba ezimbalwa zedatha. Njengoba kukhonjisiwe, kusukela i- Excel 2007 ayikho ibhokisi lengxoxo elitholakalayo lokufaka umsebenzi kanye nezimpikiswano zalo.

Noma ngabe umsebenzi kumele ungene ngesandla, izinketho ezimbili zikhona ngokufaka ingxabano yomsebenzi:

1. ukuthayipha idatha noma izingqikithi zeseli;
2. usebenzisa iphuzu bese uchofoza ukuze ukhethe izingqikithi zeseli ekhasini lokusebenzela.

Inzuzo yephoyinti nokuchofoza - okubandakanya ukusebenzisa igundane ukugqamisa amaseli wedatha - ukuthi ukunciphisa amathuba amaphutha abangelwa ukuthayipha amaphutha.

Ngezansi kubalwe izinyathelo ezisetshenziselwa ukufaka ngesandla umsebenzi we-MODE esitokisini F2 esithombeni ngenhla.

1. Chofoza kuseli F2 - ukwenza kube iseli elisebenzayo;
2. Thayipha okulandelayo: = imodi (
3. Chofoza bese uhudula ngegundane ukuze ugcizelele amaseli A2 kuya ku-D2 ekhasini lokusebenzela ukuze ungene kulolu hlu njengempikiswano yomsebenzi;
4. Thayipha ibhakha lokuvala nxazonke noma abazali " ) " ukufakazela ukuphikisana komsebenzi;
5. Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi;
6. Impendulo yesi-3 kufanele ivele kuseli F2 kusukela le namba ivela kakhulu (kabili) ohlwini lwedatha;
7. Uma uchofoza ku-cell F2 umsebenzi ophelele = I-MODE (A2: D2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.