Yadda za a gano Median (Tsarin) a Excel

Yin amfani da aikin MEDIAN a cikin Microsoft Excel

Harshen lissafi, akwai hanyoyi da yawa don gwada hali na tsakiya ko, kamar yadda ake kira shi, matsakaici don saitin dabi'u . Matsakaicin kasancewa cibiyar ko tsakiyar ƙungiyar lambobi a cikin rarrabaccen lissafi.

A cikin yanayin lamarin, yana da lambar tsakiya a cikin ƙungiyar lambobi. Rabin lambobin suna da dabi'un da suka fi girma daga tsakiya, kuma rabi lambobi suna da dabi'u waɗanda ba su da ƙasa da na tsakiya. Alal misali, tsakiyar tsakiyar ga "2, 3, 4, 5, 6" shine 4.

Don sauƙaƙe don auna ma'auni na tsakiya, Excel yana da ayyuka masu yawa waɗanda zasu lissafta dabi'un da aka fi yawan amfani dashi:

• Ayyukan MEDIAN: Bincika na tsakiya ko tsakiyar darajar cikin lissafin lambobi
• Ayyukan GABATARWA : Gano mahimmancin mahimmanci don lissafin lambobi
• Ayyukan MODE : Nemo yanayin ko mafi yawan lamarin da ke faruwa a jerin lambobi

Ta yaya aikin MEDIAN yake aiki?

Ayyukan MEDIAN yana samuwa ta hanyar jayayya da aka samo don gano darajar da ta fi dacewa a tsakiyar ƙungiyar.

Idan an ba da lambar ƙwararraki mai mahimmanci, aikin yana gano ƙimar tsakiyar a cikin iyakar azaman darajar tsakiyar.

Idan an kawo yawan mahimmancin muhawara, aikin yana ɗaukar mahimmanci na mahimmanci ko matsakaicin matsayi na biyu kamar matsakaicin adadi.

Lura : Abubuwan da aka kawo a matsayin muhawara bazai buƙaci a rarraba cikin kowane umurni domin aikin zai aiki ba. Zaka iya ganin wannan a wasa a jere na huɗu a cikin misalin hoton da ke ƙasa.

MEDIAN Daidaita aiki

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.

Wannan shi ne haɗin kan aikin MEDIAN:

= MEDIAN ( Number1 , Number2 , Number3 , ... )

• = MEDIAN : Wannan shi ne yadda dukkan matakan MEDIAN ya buƙaci farawa, saboda haka ba za'a iya canja wannan ba.
• Number1: Bayanan da ake buƙata don yin girmanta ta wurin aikin
• Number2 : Zaɓin ƙarin ƙarin bayanai don haɗa su cikin matsakaita. Matsakaicin adadin shigarwar da aka yarda shi ne 255, kowannensu yana buƙatar rabuwa ta waka.

Wannan hujja zata iya ƙunsar:

• jerin lambobin da za su kasance masu girma
• tantanin halitta sunyi bayanin wuri na bayanan a cikin takardun aiki
• wani kewayon tantancewar salula
• wani layi mai suna

Zaɓuɓɓuka don shigar da aikin da kuma muhawarar:

• Rubuta cikakken aikin, kamar = MEDIAN (A2: F2) , a cikin saitunan aikin aiki
• Shigar da aiki da muhawara ta amfani da akwatin maganganun aikin

MEDIAN Sakamakon Misali

Wadannan matakai na yadda za a shiga aikin MEDIAN da muhawara ta amfani da akwatin maganganun na farko misali da aka nuna a wannan hoton:

1. Danna kan salula G2. Wannan shine wurin da za a nuna sakamakon.
2. Gudura zuwa Formulas> Ƙari Ayyuka> Lissafin lissafi don zaɓi MEDIAN daga lissafin.
3. A cikin akwati na farko a cikin akwatin maganganu, haskaka salolin A2 zuwa F2 a cikin takardun aiki don shigar da wannan iyakar ta atomatik.
4. Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki.
5. Amsar 20 ya kamata ya bayyana a cell G2
6. Idan ka danna kan salula G2, aikin cikakke, = MEDIAN (A2: F2) , ya bayyana a cikin maɓallin tsari a sama da takardun aiki.

Me yasa darajar tazarar 20? Don samfurin farko a cikin hoton, tun da akwai ƙwararrun gardama (biyar), ana ƙidaya yawan adadin tsakiyar ta hanyar gano lambar tsakiyar. Yana da 20 a nan saboda akwai lambobi biyu (49 da 65) da lambobin lambobi biyu (4 da 12).

Tsararren Firayi vs Zero

Lokacin da ya zo ne don gano maɓallin kwakwalwa a cikin Excel, akwai bambanci tsakanin nau'in komai ko kullun da waɗanda suke dauke da nau'i maras nauyi.

Kamar yadda aka nuna a misalai da ke sama, Kwayoyin suturta suna watsi da aikin MEDIAN amma ba wadanda suke dauke da nau'i maras nauyi ba.

• Bambanci ya canza a tsakanin misalan farko da na biyu saboda an ƙara siffar wani abu a cell A3 yayin da cell A2 ya zama maras nauyi.
• Bugu da ƙari na sifilin zuwa cell A3 ya canza yawan ƙididdigar da aka wuce zuwa aikin a cikin salula G3 daga biyar zuwa shida - ko da lambar. A sakamakon haka, an ƙidaya maƙalar ta hanyar ƙara nau'ikan dabi'u biyu (12 da 20) tare sannan raba su biyu don gano matsakaicin (16).

Ta hanyar tsoho, Excel yana nuni da babu (0) a cikin sel da nauyin zabin - kamar yadda aka nuna a cikin misali a sama. Wannan zaɓin za a iya kashe kuma, idan aka aikata, waɗannan kwayoyin suna bar blank, amma nauyin zero na wannan tantanin halitta har yanzu an hada shi a matsayin hujja don aikin yayin da ake kirga tsakiyar tsakiyar.

Ga yadda za a kunna wannan zaɓi a kunne da kashewa:

1. Gudura zuwa Fayil> Zaɓuɓɓukan menu (ko Zabuka na Excel a cikin tsofaffi na Excel).
2. Jeka cikin Babbar fannin daga hagu na hagu na zaɓuɓɓuka.
3. A gefen dama, gungurawa har sai kun sami "Zaɓuɓɓukan nunawa don wannan aikin aiki".
4. Don ɓoye dabi'un siffofin a cikin sel, share Shafin nuna kyamaran da ba su da darajar ajiya. Don nuna siffofin, saka rajistan shiga cikin akwatin.
5. Ajiye kowane canje-canje tare da maɓallin OK .