Mmene Mungapezere Medie (Average) mu Excel

Kugwiritsa ntchito Ntchito ya MEDIAN mu Microsoft Excel

Mwa masamu, pali njira zingapo zowunikira chizoloŵezi chapakati kapena, monga momwe zimatchulira kawirikawiri, chiwerengero cha zikhalidwe zoyenera . Kawirikawiri kukhala pakati kapena pakati pa chiwerengero cha ziwerengero mu kufalitsa kwa ziwerengero.

Pankhani ya apakati, ndi nambala yapakati mu nambala ya manambala. Gawo la manambala ali ndi malingaliro aakulu kuposa apakati, ndipo theka la chiwerengero ali ndi chikhalidwe chomwe chiri chochepa kuposa chamkati. Mwachitsanzo, woyimira pakati pa "2, 3, 4, 5, 6" ndi 4.

Kuti zikhale zosavuta kuyeza chizoloŵezi chapakati, Excel ili ndi ntchito zingapo zomwe ziwerengere zomwe zimagwiritsidwa ntchito kwambiri:

• Ntchito ya MEDIAN: Imapeza mtengo wapakati kapena pakati pakati pa manambala
• Ntchito YOPHUNZITSIRA : Imafufuza masamu ake amatanthauza manambala a manambala
• Ntchito ya MODE : Imapeza njira kapena chowonekera chomwe chikupezeka mndandanda wa manambala

Momwe Ntchito ya MEDIAN Imachitira

Ntchito ya MEDIAN imayenda kudzera m'maganizo operekedwa pofuna kupeza mtengo umene umagwera pansi pakati pa gululo.

Ngati nthano yosamvetsetseka yaperekedwa, ntchitoyo imatchula mtengo wapakati pamtunduwu monga mtengo wamkati.

Ngati pali zifukwa zambiri zomwe zimaperekedwa, ntchitoyi imatenga masamu omwe amatanthawuza kapena kuwerengera pakati pa miyeso iwiri monga mtengo wamkati.

Zindikirani : Makhalidwe omwe amaperekedwa ngati zotsutsana sayenera kusankhidwa mwa dongosolo lililonse kuti ntchitoyo igwire ntchito. Mutha kuona kuti mukusewera mumzere wachinayi mu chithunzi chapafupi.

MALANGIZO Ogwira ntchito Syntax

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.

Ichi ndicho chiganizo cha ntchito ya MEDIAN:

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

• = ZOKHUDZA : Izi ndizo momwe mayina onse a MEDIAN ayenera kuyamba, kotero izi sizingasinthe.
• Nambala1: Deta yofunikila kuti ikhale ndi ntchito
• Nambala2 : Zowonjezera zowonjezera chiwerengero cha deta kuti zikhale pamodzi. Chiwerengero chazowonjezereka chomwe chimaloledwa ndi 255, chomwe chili chonse chiyenera kupatulidwa ndi comma.

Mtsutso uwu ukhoza kukhala:

• mndandanda wa manambala omwe angakhalepo
• mafotokozedwe a selo kumalo a deta mu worksheet
• malingaliro osiyanasiyana a selo
• dzina lotchuka

Zosankha zolowera ntchito ndi zifukwa zake:

• Kujambula ntchito yeniyeni, monga = MEDIAN (A2: F2) , kulowa mu selo lamasewera
• Kulowa ntchito ndi ndemanga pogwiritsa ntchito bokosi la zokambirana

Ntchito Yogwira Ntchito

Zitsatanetsatane za momwe mungalowerere ntchito ya MEDIAN ndi mfundo pogwiritsa ntchito bokosi la chitsanzo choyamba chowonetsedwa pachithunzi ichi:

1. Dinani pa selo G2. Apa ndi pamene zotsatira zidzawonetsedwa.
2. Yendetsani ku Mafomu> Ntchito Zowonjezera> Chizindikiro cha menyu yazithunzi kuti muzisankha MEDIAN kuchokera pa mndandanda.
3. Mu bokosi loyamba la bokosi la bokosi, onetsetsani maselo A2 mpaka F2 mu tsamba lothandizira kuti muikepo mzerewo.
4. Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito.
5. Yankho 20 liyenera kuoneka mu selo G2
6. Ngati inu mutsegula pa selo G2, ntchito yonse, = MEDIAN (A2: F2) , ikuwoneka mu barra ya fomu pamwamba pa tsamba.

Nchifukwa chiyani mawonekedwe apakati ali 20? Kwa chitsanzo choyamba mu fano, popeza pali nthano zosamvetsetseka (zisanu), mtengo wamkatiwu ukuwerengedwa mwa kupeza nambala yapakati. Ndili pano chifukwa pali ziwerengero ziwiri zazikulu (49 ndi 65) ndi nambala ziwiri zazing'ono (4 ndi 12).

Maselo osajambulidwa ndi Zero

Pokhudzana ndi kupeza pakati pa Excel, pali kusiyana pakati pa zosalemba kapena maselo opanda kanthu ndi omwe ali ndi chiwerengero cha zero.

Monga momwe zasonyezera mu zitsanzo pamwambapa, maselo opanda kanthu amanyalanyazidwa ndi ntchito ya MEDIAN koma osati iwo okhala ndi zero mtengo.

• Kusintha kwapakati pakati pa zitsanzo zoyamba ndi zachiwiri chifukwa zero zinawonjezedwa ku selo A3 pomwe selo A2 liribe kanthu.
• Kuwonjezera kwa zero ku selo A3 kusintha chiwerengero cha zifukwa zomwe zagwiritsidwa ntchito ku selo G3 kuyambira zisanu mpaka zisanu - ngakhale nambala. Zotsatira zake ndizo, kuwerengera pakati kumaphatikizapo kuwonjezera miyeso iwiri yapakati (12 ndi 20) palimodzi ndikugawaniza awiri kuti apeze pafupifupi (16).

Mwachidziwitso, Excel imawonetsa zero (0) m'maselo ndi chiwerengero cha zero - monga momwe zasonyezera mu chitsanzo chapamwamba. Njira iyi ikhoza kutsegulidwa ndipo, ngati zatheka, maselo oterewa amasiyidwa opanda kanthu, koma mtengo wa zero wa seloyo umaphatikizidwanso ngati kutsutsana kwa ntchitoyo powerengera wamkati.

Pano ndi momwe mungasinthire njirayi ndiyikani:

1. Yendetsani ku Faili> Zosankha zam'mbuyo (kapena Zolemba Zowonjezera muzolembedwa zakale za Excel).
2. Pitani ku Gawo lotchuka kuchokera kumanzere kumanzere kwa zosankhazo.
3. Kumanja, pendekera pansi mpaka mutapeza "Zosonyeza zosankha za gawoli".
4. Kubisa zero mu maselo, tsambulani Show zero m'maselo omwe ali ndi zero mtengo check box. Kuti muwonetse zeros, kani cheke mu bokosi.
5. Sungani kusintha kulikonse ndi botani OK .