I-Excel MODE.MULT Umsebenzi

Ngokwezibalo, kunezindlela eziningi zokulinganisa ukuthambekela okuphakathi noma, njengoba kuvame ukubizwa ngokuthi, isilinganiso sesethi yamanani. Isilinganiso sibe yisikhungo noma esiphakathi kweqembu lezinombolo ekusakazeni izibalo.

Endabeni yemodi, maphakathi ubhekisela kunani elivame ukwenzeka njalo ohlwini lwezinombolo. Isibonelo, imodi ye-2, 3, 3, 5, 7, no-10 iyinombolo 3.

Ukuze kube lula ukukala ukuthambekela okuphakathi, i-Excel inemisebenzi eminingi ezobala amanani ajwayelekile ajwayelekile asetshenziselwa. Lokhu kufaka:

• Umsebenzi we- MODE.SNGL - uthola imodi noma inani elivame ukwenzeka njalo ohlwini lwamanani.
• Umsebenzi we-MODE.MULT - usetshenziselwe ukubona ukuthi idatha iqukethe izindlela eziningi - inani elingaphezu kweyodwa elivela kaningi ohlwini lwamanani
• Umsebenzi we- MEDIAN - uthola inani eliphakathi noma eliphakathi ohlwini lwamanani
• Umsebenzi we- AVERAGE - uthola incazelo ye- arithmetic ohlwini lwamanani

01 ka 05

Indlela iMODE.MULT Function Works

Ku-Excel 2010, umsebenzi we-MODE.MULT wethulwa ukwandisa ekusebenzeni komsebenzi we-MOD otholakala ezihumulweni zangaphambilini ze-Excel.

Kulezo zinguqulo zangaphambilini, umsebenzi we-MODE wasetshenziselwa ukuthola inani elilodwa elivame ukuvela - noma imodi - kuhlu lwamanani.

I-MODE.MULT ngakolunye uhlangothi, izokutshela ukuthi kunezinamba eziningi - noma izindlela eziningi - ezenzeka kaningi emininingeni yolwazi.

Qaphela: umsebenzi ubuyisa kuphela izindlela eziningi uma izinombolo ezimbili noma ngaphezulu zenzeka ngezinga elilinganayo phakathi kwebanga elikhethiwe lwedatha. Umsebenzi awubeka idatha.

02 ka 05

I-Array noma i-CSE Formulas

Ukuze ubuyekeze imiphumela eminingi, i-MODE.MULT kumele ifakwe njengefomula yamalungu - engena amangqamuzana amaningi ngesikhathi esifanayo, ngoba amafomula avamile e-Excel angabuyisa kuphela umphumela owodwa ngeseli ngalinye.

Amafomu amafomu afakiwe ngokucindezela okhiye be- Ctrl , Shift , no- Enter ekhibhodi ngesikhathi esifanayo uma ifomula idalwe.

Ngenxa yezihluthulelo ezicindezelwe ukungena ifomula elandelanayo, ngezinye izikhathi zibizwa ngokuthi ama- CSE amafomula.

03 ka 05

I-Syntax ye-MODE.MULT Function and Arguments

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

I-syntax yomsebenzi we-MODE.MULT yile:

= MODE.MULT (Inombolo1, Inombolo2, ... Inamba255)

Inombolo - (edingekayo) amanani (kuze kufike ku-255) ofuna ukubala amamodi. Le mpikiswano ingaqukatha izinamba zangempela - ezahlukaniswa ngamakhompiyutha - noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.

Isibonelo Ukusebenzisa i-Excel MODE.MULT Umsebenzi:

Isibonelo esiboniswe esithombeni esingenhla sinamamodi amabili - izinombolo 2 no-3 - ezenzeka kaningi kwimininingwane ekhethiwe.

Ngisho noma kunezindinganiso ezimbili kuphela ezenzeka ngezimvamisa ezilinganayo, umsebenzi usungulwe amaseli amathathu.

Ngoba amaseli amaningi akhethiwe kunamamodi, iseli lesithathu - i-D4 - libuyisela iphutha le- # N / A.

04 ka 05

Ukufaka i-MODE.MULT Umsebenzi

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele: = MODE.MULT (A2: C4) kufinyelela kuseli lomsebenzi
2. Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi

Kuzo zombili izindlela, isinyathelo sokugcina ukufaka umsebenzi njengomsebenzi ohlangene usebenzisa izinkinobho ze- Ctrl , Alt , ne- Shift njengencazelo elandelayo ngezansi.

Ibhokisi le-MODE.MULT Function Box

Izinyathelo ezingezansi imininingwane yokukhetha umsebenzi we-MODE.MULT nezimpikiswano usebenzisa ibhokisi lengxoxo.

1. Gqamisa amaseli D2 kuya ku-D4 ekhasini lokusebenzela ukuze ukhethe - lawa maseli indawo lapho imiphumela yomsebenzi izoboniswa khona
2. Chofoza kuthebhu yefomula
3. Khetha Imisebenzi Engaphezulu> Isitatimende kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza phansi
4. Chofoza ku- MODE.MULT kuhlu ukuze ukhulise ibhokisi lengxoxo lomsebenzi
5. Gqamisa amaseli A2 kuya ku-C4 ekhasini lokusebenzela ukuze ufake ibanga ebhokisini lengxoxo

05 ka 05

Ukudala ifomu ye-Array

1. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi
2. Cindezela ukhiye wokungena kwikhibhodi ukuze udale ifomula yamagama bese uvala ibhokisi lengxoxo

Imiphumela ye-Formula

Imiphumela elandelayo kufanele ibe khona:

• inombolo 2 kuseli D2;
• inombolo 3 kuseli D3;
• futhi # N / A kwiseli D4.

1. Le miphumela ivela ngoba izinombolo ezimbili kuphela - 2 no-3 - zivela kaningi futhi zinezilinganiso ezilinganayo kwisampula yedatha
2. Ngisho noma inombolo engu-1 yenzeka kaningi - kuma-A2 no-A3 - ayilingani nemvamisa yezinombolo 2 no-3 ngakho ayihlanganisiwe njengenye yezimodemu zesampula yedatha
3. Uma uchofoza ku-cell D2, D3, noma i-D4 ifomula ephelele

   {= MODE.MULT (A2: C4)}

   kungabonakala kubha yefomula ngaphezulu kwephepha lokusebenzela

Amanothi:

• Uma kungekho modi - noma, ngamanye amazwi, ibanga lwedatha aliqukethe idatha ephindaphindiwe - umsebenzi we-MODE.MULT uzobuyisela iphutha le- # N / A kuseli ngalinye elikhethiwe ukuze libonise umkhiqizo womsebenzi
• Ububanzi bamaseli akhethiwe ukubonisa imiphumela yomsebenzi we-MODE.MULT kufanele ugijime ngokuqondile. Umsebenzi ngeke uphume imiphumela emkhakheni wezingqamuzana ezingqimba.
• Uma kudingekile ibanga elingenayo eliphumayo, umsebenzi we-MODE.MULT ungadliwa ngaphakathi kwe- TRANSPOSE function
• Ifomu le-equation kungaba: {= TRANSPOSE (MODE.MULT (A2: C4)}