Harshen lissafi, akwai hanyoyi da yawa na auna yawan al'amuran tsakiya ko, kamar yadda ake kira da yawa, matsakaicin matsayi na dabi'u. Matsakaicin kasancewa cibiyar ko tsakiyar ƙungiyar lambobi a cikin rarrabaccen lissafi.
A yanayin yanayin, tsakiyar yana nufin mafi yawan lokuta da ke faruwa a cikin lissafin lambobi. Alal misali, yanayin 2, 3, 3, 5, 7, da 10 shine lamba 3.
Don yin sauki don auna ma'auni na tsakiya, Excel yana da ayyuka masu yawa waɗanda zasu lissafta dabi'un da aka fi amfani dasu da yawa . Wadannan sun haɗa da:
- Ayyukan MODE.SNGL - ya sami yanayin ko mafi yawan lokuta da ke faruwa a jerin lambobi.
- Ayyukan MODE.MULT - ana amfani dasu idan bayanan ya ƙunshi hanyoyi masu yawa - fiye da ɗaya darajar da ke faruwa sau da yawa a jerin lambobi
- Ayyukan MEDIAN - sami adadi na tsakiya ko tsakiyar cikin lissafin lambobi
- Ayyukan aikin AVERAGE - sami alamar lissafi don lissafin lambobi
01 na 05
Ta yaya MODE.MULT Function Works
A Excel 2010, an gabatar da aikin MODE.MULT don fadada akan amfanin aikin MODE da aka samo a cikin sassan Excel.
A waɗancan sifofin da suka gabata, an yi amfani da aikin MODE don nemo darajar abin da ke faruwa sau da yawa - ko yanayin - a lissafin lambobi.
MODE.MULT, a gefe guda, zai gaya maka idan akwai dabi'u mai yawa - ko hanyoyi masu yawa - wanda ke faruwa a mafi yawancin bayanai.
Lura: aikin kawai ya dawo da hanyoyi masu yawa idan lambobi biyu ko fiye suna faruwa tare da daidaitattun mita a cikin zaɓin bayanan da aka zaɓa. Ayyukan ba su ƙayyade bayanan ba.
02 na 05
Array ko CSE Formulas
Domin sake dawo da sakamako mai yawa, MODE.MULT dole ne a shigar dashi azaman tsari - wannan yana cikin sel guda daya a lokaci guda, tun da tsarin na Excel na yau da kullum zai iya dawo da sakamakon daya ta tantanin halitta.
Ana shigar da takaddun tsari ta latsa Ctrl , Shift , kuma Shigar da maɓallai akan keyboard a lokaci guda da zarar an halicci ma'anar.
Saboda maballin maballin don shigar da maɓallin lissafi, ana kira su a matsayin lokuta CSE .
03 na 05
Hanyoyin MODE.MULT da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin na MODE.MULT shine:
= MODE.MULT (Number1, Number2, ... Number255)
Lambar - (da ake buƙata) dabi'u (zuwa iyakar 255) don abin da kake son ƙididdige hanyoyin. Wannan hujja na iya ƙunsar lambobi na ainihi - rabu da ƙira - ko kuma zai iya zama ƙirar salula zuwa wuri na bayanan a cikin takardun aiki.
Misali Amfani da aikin MODE.MULT na Excel:
Misalin da aka nuna a cikin hoto a sama yana da hanyoyi guda biyu - lambobin 2 da 3 - wanda ya faru sau da yawa a cikin bayanan da aka zaɓa.
Ko da yake akwai lambobi biyu da ke faruwa tare da daidai lokacin, an shigar da aikin zuwa cikin kwayoyin guda uku.
Saboda an zaɓi wasu ƙwayoyin fiye da yadda akwai hanyoyi, ƙira ta uku - D4 - dawo da kuskuren N / A.
04 na 05
Shigar da aikin MODE.MULT
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: = MODE.MULT (A2: C4) a cikin sashin layi na aiki
- Zaɓi aikin da muhawara ta amfani da maganganun aikin
Ga dukkan hanyoyi biyu, mataki na karshe shi ne shigar da aikin a matsayin aikin tsararraki ta amfani da Ctrl , Alt , da kuma maɓallin Shift kamar yadda aka bayyana a kasa.
MODE.MULT Ayyukan maganganu
Matakan da ke ƙasa dalla-dalla yadda zaka zaɓa aikin MODE.MULT da kuma muhawara ta amfani da akwatin maganganu.
- Sanya sassa D2 zuwa D4 a cikin takardun aiki don zaɓar su - wadannan kwayoyin sune wurin da za'a nuna sakamakon aikin
- Danna kan shafukan Formulas
- Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin
- Danna MODE.MULT a jerin don kawo akwatin maganganun aikin
- Sanya siffofin A2 zuwa C4 a cikin takardun aiki don shigar da kewayon cikin akwatin maganganu
05 na 05
Ƙirƙirar takarda
- Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
- Latsa maɓallin shigarwa a kan keyboard don ƙirƙirar lissafin tsari kuma rufe akwatin maganganu
Sakamakon tsari
Sakamakon wadannan ya kamata ya kasance:
- lambar 2 a cell D2;
- lambar 3 a cell D3;
- da kuma # N / A a cell D4.
- Wadannan sakamakon yana faruwa saboda lambobi biyu - 2 da 3 - suna bayyana mafi sau da yawa kuma daidai daidai a samfurin bayanai
- Ko da yake lambar 1 tana faruwa fiye da sau daya - a cikin sassan A2 da A3 - ba daidai da mita na lambobi 2 da 3 don haka ba'a haɗa shi a matsayin ɗayan hanyoyin don samfurin samfurin
- Lokacin da ka danna kan tantanin halitta D2, D3, ko D4 cikakkiyar tsari
{= MODE.MULT (A2: C4)}
za a iya gani a cikin maɓallin tsari a sama da takardun aiki
Bayanan kula:
- Idan babu wani yanayi - ko, a wasu kalmomi, ƙididdigar bayanai ba ta ƙunshi bayanan dallafi ba - aikin MODE.MULT zai dawo da kuskuren N / A a kowace tantanin da aka zaɓa domin nuna aikin fitar da aikin
- Tsarin sel da aka zaɓa don nuna sakamakon aikin MODE.MULT dole ne a gudanar da shi tsaye. Ayyukan ba zai fitar da sakamakon zuwa jeri na kwance na kwance ba.
- Idan ana buƙatar ana buƙatar samfurin fitarwa, aikin MODE.MULT zai iya aiki a cikin aikin TRANSPOSE
- Nauyin ƙaddamar zai kasance: {= TRANSPOSE (MODE.MULT (A2: C4)}