Qonda umsebenzi weMODE kwi-Google AmaSpredishithi

01 ngo 01

Fumana Ixabiso Eliqhelekileyo Ngokuqhelekileyo Ngomsebenzi weMODE

Iipredishithi zeGoogle zeMODE. © Ted French

I-Google AmaSpredishithi ispredishithi esekelwe kwiwebhsayithi edunyiswayo ngenxa yokulula. Ngenxa yokuba ingaboshwa kumashini omnye, unokufikelela kuyo naphi na kuyo nayiphi na ifowuni. Ukuba untsha kwiiSpredishithi zeGoogle, uzakufuna ukwenza imisebenzi emininzi ukuze uqalise. Eli nqaku lijongene nomsebenzi weMODE, ofumana ixabiso eliqhelekileyo elivela rhoqo kwiqela leenombolo.

Umzekelo, ukwenzela inombolo:

1,2,3,1,4

imodeli yile nombolo 1 kuba iyenzeka kabini kwoluhlu kwaye enye inamba ibonakala kanye kuphela.

Ukuba ngaba amabini amabini okanye amaninzi avela kwiluhlu inani elifanayo lamaxesha, bobabini banokucingwa ukuba yimo.

Inombolo efakwe:

1,2,3,1,2

zombini iinombolo 1 no-2 zibhekwa njengemodi kuba zombini zivela kabini kwoluhlu kwaye inombolo 3 ibonakala kanye kuphela. Kwimizekelo yesibini, isethi yenani kuthiwa yi-bimodal.

Ukufumana imodeli yesethi yamanani xa usebenzisa i-Google AmaSpredishithi, sebenzisa umsebenzi weMODE.

Indlela yokusebenzisa umsebenzi weMODE kwi-Google AmaSpredishithi

Vula idokhumenti entsha ye-Google yeSpredishithi kwaye ulandele le nyathelo ufunde indlela yokusebenzisa umsebenzi we-MODE.

  1. Faka idatha elandelayo kwiiseli A1 ukuya ku-A5: igama "enye," kunye neenombolo 2, 3, 1 no-4 njengoko kuboniswe kumzobo ohambisana nale nqaku.
  2. Cofa kwi- cell A6, indawo apho iziphumo ziza kuboniswa khona.
  3. Thayipha uphawu olulinganayo = landelwa ligama elithi "imo ."
  4. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta M.
  5. Xa igama "imodi" livela phezulu kwibhokisi, cinezela ukhiye wokungena kwikhibhodi ukufaka igama lomsebenzi kwaye uvule ibhondi ejikelezayo ( kwi-cell A6.
  6. Gqamisa iiseli ezi-A1 ukuya ku-A5 ukuba zibandakanye njengemibono yomsebenzi.
  7. Thayipha ibhondi yokuvala ejikelezayo ) ukufaka iingqinamba zomsebenzi.
  8. Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi.
  9. Iphutha le-# N / A kufuneka livele kwiseli ye-A6 kuba akukho namba kwi-intlobo ekhethiweyo yeeseli ivela ngaphezu kweyodwa.
  10. Cofa kwiseli A1 uze uthayiphe inamba 1 ukutshintsha igama "elinye."
  11. Cinezela ukhiye wokungena kwikhibhodi
  12. Iziphumo zomsebenzi we-MODE kwiseli ye-A6 kufuneka ziguqulwe kwi-1. Ngenxa yokuba kukho iiseli ezimbini kwimiba equle inombolo 1, yindlela yokuseta inombolo ekhethiweyo.
  13. Xa ucofa kwi-cell A6, umsebenzi opheleleyo = MODE (A1: A5) ibonakala kwifom yefomula ngaphezu kwiphepha lokusebenzela

I-Syntax yeeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakaki, abahluli be-comma kunye neengxabano .

I-syntax yomsebenzi weMODE yi: = MODE (inombolo_1, inombolo_2, ... inombolo_30)

Inombolo yeziphakamiso zingabandakanya:

Amanqaku