I-Excel MODE.MULT Function

Isibalo seMathematika, kukho iindlela ezininzi zokulinganisa ukutyekela okuqhelekileyo okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge weesethi zexabiso. Umyinge ophakathi kwinqanaba okanye emkhatsini weqela lamanani kwinani lokusabalalisa.

Kwimeko yemodi, emkhatsini ubhekisela kwixabiso eliqhelekileyo elivela rhoqo kwiluhlu lwamanani. Ngokomzekelo, imodeli ye-2, 3, 3, 5, 7, ne-10 yinombolo 3.

Ukwenza kube lula ukulinganisa ukutyekela kwe-central, i-Excel inemisebenzi embalwa eya kubala inani eliqhelekileyo elisetyenziswayo. Ezi ziquka:

• Umsebenzi weMODE.SNGL - uyifumana imo okanye ixabiso eliqhelekileyo elivela rhoqo kwiluhlu lwamanani.
• Umsebenzi weMODE.MULT - usetyenziswe ukuchonga ukuba idatha iqulethe iimodem ezininzi - ngaphezu kwexabiso elilodwa elivela rhoqo kwiluhlu lwamanani
• Umsebenzi weMEDIAN - ufumana ixabiso eliphakathi okanye elingaphakathi kwimihlu yamanani
• Umsebenzi we- AVERAGE - ufumana i- arithmetic ithetha ukuba uluhlu lwamanani

01 ngo 05

Indlela iMODE.MULT Function Works

Ku-Excel 2010, umsebenzi weMODE.MULT waziswa ukuba wandise ekusebenzeni komsebenzi weMODE ofumaneka kwiinguqu zangaphambili ze-Excel.

Kule nguqulelo yangaphambili, umsebenzi we-MODE wasetyenziselwa ukufumana ixabiso eliqhelekileyo elivela rhoqo - okanye imodi - kwiphepha lamanani.

I-MODE.MULT, ngakolunye uhlangothi, iya kukuxelela ukuba kukho iimilinganiselo ezininzi - okanye iimodeli ezininzi - ezenzeka rhoqo kwiinkalo zolwazi.

Qaphela: umsebenzi ubuyisela iimodem ezininzi xa kubalwa amaninzi amabini okanye amaninzi ngamaxesha afanayo kwi-data ekhethiweyo. Umsebenzi awululathisi idatha.

02 we 05

I-Array okanye i-CSE ifomu

Ukuze ubuyisele iziphumo ezininzi, i-MODE.MULT kufuneka ifakwe njengefomula yoluhlu - ekhoyo kwiiseli ezininzi ngexesha elifanayo, kuba iifomula rhoqo ze-Excel zingabuyisela kuphela umphumo omnye ngeseli.

Iifomula zefayile zifakwe ngokucinezela i Ctrl , Shift , kunye neefayile zokungenisa kwikhibhodi ngexesha elinye xa ifomula idalwe.

Ngenxa yezitshixo ezixinzelelweyo ukuba zingene kwifom yefomathi, ngamanye amaxesha zibizwa ngokuba yi- CSE ifomu.

03 we 05

I-MODE.MULT ye-Syntax yeMisebenzi kunye neengxoxo

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi weMODE.MULT ngu:

= MODE.MULT (Number1, Number2, ... Inani255)

Inani - (elifunekayo) ixabiso (ukuya kuma-255) apho ufuna ukubala iimodesi. Le ngxabano ingaba neenombolo zangempela-ezahlukana ngama-commas - okanye ingaba yereferensi yeseli kwendawo yedatha kwiphepha lokusebenzela.

Umzekelo Ukusebenzisa iMODE ye-Excel.Usebenza:

Umzekelo oboniswe kumfanekiso ongentla unamathomo amabini - amanani 2 no-3-ayenzeka rhoqo kwi-data ekhethiweyo.

Nangona kukho ixabiso elimbini kuphela elivela ngexesha elilinganayo, umsebenzi sele ungeniswe kwiiseli ezintathu.

Ngenxa yokuba ezinye iiseli zikhethiweyo kunokuba kukho iimodesi, isithandathu sesithathu - i-D4 - ubuyisela impazamo ye- # N / A.

04 we 05

Ukufaka iMODE.MULT Function

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi opheleleyo: = MODE.MULT (A2: C4) kwifayile yeshidi
2. Ukukhetha umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi

Kuzo zombini iindlela, isinyathelo sokugqibela ukufaka umsebenzi njengomsebenzi woluhlu usebenzisa iifayile ze- Ctrl , Alt , kunye neShift njengoko zichaziwe ngezantsi.

I-MODE.MULT yeBhokisi yokuSebenza yeM function

Amanyathelo angezantsi iinkcukacha ngokukhetha indlela ye-MODE.MULT kunye neengxabano usebenzisa ibhokisi yencoko.

1. Gqamisa iiseli zeD2 ukuya kwi-D4 kwiphepha lokusebenzela ukuze uzikhethele - ezi iiseli indawo apho iziphumo zomsebenzi ziza kuboniswa
2. Cofa kwiThebhu yefomula
3. Khetha Imisebenzi Engakumbi> Isitatisti kwibhebhoni ukuvula uluhlu lokuhla kwehla
4. Cofa kwi MODE.MULT kwoluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
5. Phakamisa iiseli ezi-A2 ukuya ku-C4 kwiphepha lokusebenzela ukuze ufake ibhola kwibhokisi yencoko

05 we 05

Ukudala iFomula yeFom

1. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
2. Cinezela ukhiye wokungena kwibhodibhodi ukudala ifom yefayile kwaye uvale ibhokisi yencoko

I-Formula Results

Ezi zilandelayo ziphumo mazibe khona:

• Inombolo 2 kwiseli D2;
• inani 3 kwi-D3 yeseli;
• kunye # N / A kwiseli D4.

1. Ezi ziphumo zivela kuba kubalwa amanani amabini - 2 kunye no-3 - abonakala rhoqo kwaye anamaxesha alinganayo kwisampuli yedatha
2. Nangona inombolo 1 ivela ngaphezu kweyodwa - kwiiseli A2 kunye ne-A3 - ayilingani imvama yeenombolo 2 ne-3 ngoko kungabandakanywa njengenye yemodyuli yesampuli yedatha
3. Xa ucofa kwiseli D2, D3, okanye i-D4 iqulunqo lenkqubo epheleleyo

   {= MODE.MULT (A2: C4)}

   inokubonwa kwifom yefomula ngaphezu kwephepha lokusebenzela

Amanqaku:

• Ukuba akukho mimoya - okanye, ngamanye amagama, uluhlu lweedatha aluququzekanga nedatha yedatha - umsebenzi we-MODE.MULT uza kubuya impazamo ye-# N / A kwiseli nganye ekhethiweyo ukubonisa imveliso yomsebenzi
• Uluhlu lweeseli ezikhethiweyo ukubonisa iziphumo zeMODE.MULT umsebenzi kufuneka usebenze ngokuzenzekelayo. Umsebenzi awuyi kuvelisa iziphumo kwiqela elincinci leeseli.
• Ukuba kukho uluhlu olungenanto olufunekayo, umsebenzi weMODE.MULT ungasondla ngaphakathi kwintsebenzo.
• Ifom ye-equation iya kuba: {= UKUTHUTHUKISWA (MODE.MULT (A2: C4)}