Pezani Average (Mafashoni) Ndi Ntchito ya Excel MODE

Mndandanda wa mndandanda wamtengo wapatali wa deta umatanthawuza kuti ndiwowonjezereka kowonjezeka pazandandanda.

Mwachitsanzo, mu mzere wachiwiri mu chithunzi pamwambapa, nambala 3 ndiyo njira chifukwa imapezeka kawiri mu deta ya A2 mpaka D2, pamene nambala zina zonse zimawoneka kamodzi kokha.

Mchitidwewo umaganiziranso, limodzi ndi tanthawuzo ndi zamkati, kukhala ndiyeso ya mtengo wapatali kapena chizoloŵezi chapakati cha deta.

Kuti mugawidwe bwino deta - yomwe imayimiliridwa ndi bello - pamtundu wa miyeso itatu ya chikhalidwe chachikulu ndi ofanana. Kuti pakhale kufotokozedwa kwa deta, mtengo wamtengo wapatali ukhoza kusiyana ndi miyeso itatu.

Kugwiritsira ntchito ntchito ya MODE ku Excel kumapangitsa kuti mupeze mosavuta mtengo umene umapezeka kawirikawiri m'ndandanda wa deta yosankhidwa.

01 a 03

Pezani Chidziwitso Chochuluka Kwambiri pa Zambiri Za Data

Kusintha kwa Ntchito ya MODE - Excel 2010

Mu Excel 2010 , Microsoft inayambitsa njira ziwiri zomwe zingagwiritsidwe ntchito pogwiritsa ntchito MODE cholinga chonse:

• MODE.SNGL Ntchito: yogwiritsidwa ntchito pa data ndi njira imodzi - yofanana ndi ntchito ya MOD yomwe ili pamwamba pano;
• MODE.MULT Ntchito: amagwiritsidwa ntchito ngati deta ili ndi njira zambiri - miyezo iwiri kapena iwiri yomwe imachitika mofanana.

Kuti mugwiritse ntchito MODE ntchito nthawi zonse mu Excel 2010 ndi maulendo matembenuzidwe, izo ziyenera kulowa mwamanja, popeza palibe bokosi bokosi yogwirizana ndi izo m'mawu a pulogalamu.

02 a 03

Syntax ndi Maganizo a Ntchito ya MODE

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.

Chidule cha ntchito ya MODE ndi:

= MODE (Number1, Number2, Number3, ... Namba2525)

Number1 - (yofunika) miyezo yomwe amagwiritsidwa ntchito powerengera. Mtsutso uwu ukhoza kukhala:

• nambala enieni - yolekanitsidwa ndi makasitomala - chitsanzo mu mzere 3 mu chithunzi pamwambapa;
• mtundu umodzi womwe uli ndi mafotokozedwe a selo kumalo a deta pamsewu wolemba - zitsanzo m'mizere 2, 5,6, ndi 7;
• kuphatikiza mafotokozedwe a selo ndi deta - chitsanzo mzere 4;
• dzina lotchuka;
• maofesi apadera omwe amasiyanitsidwa ndi makasitomala.

Number2, Number3, ... Namba255 - (zosankha) zowonjezera ziwerengero kapena mafotokozedwe a selo mpaka 255 omwe akugwiritsidwa ntchito kuti awerengere njira.

Mfundo

1. Ngati zosankha zadasankhidwa zilibe deta yochepa, ntchito ya MODE idzabweretsa # N / A mtengo wolakwika - monga momwe tawonedwera mzere 7 mu chithunzi pamwambapa.
2. Ngati miyezo yambiri yosankhidwayo ikuchitika ndi maulendo omwewo (mwazinthu zina, deta ili ndi mitundu yambiri) ntchitoyo imabwerera njira yoyamba yomwe ikukumana nayo monga momwe zakhalira zonsezi - monga momwe zasonyezedwera mzere 5 mu chithunzi pamwambapa . Dongosolo la A5 mpaka D5 liri ndi njira ziwiri - 1 ndi 3, koma 1 - zoyamba zomwe zinakumanapo - zimabweretsedwanso ngati njira yonseyo.
3. Ntchitoyi imanyalanyaza:
   • zida zolembera;
   • malingaliro abwino kapena a Boolean;
   • maselo opanda kanthu.

Ntchito ya MODE Chitsanzo

03 a 03

Ntchito ya MODE Chitsanzo

Mu chithunzi pamwambapa, ntchito ya MODE imagwiritsidwa ntchito kuwerengera njira zosiyanasiyana za deta. Monga tanenera, kuchokera mu Excel 2007 mulibe bokosi la zokambirana lomwe likupezeka kuti ligwire ntchito ndi zifukwa zake.

Ngakhale kuti ntchitoyi iyenera kulowa mwadongosolo, zosankha ziwiri zidakalipo pokalowa muzokambirana:

1. kulemba mu deta kapena zolemba za selo;
2. pogwiritsa ntchito mfundo ndikusindikiza kuti muzisankha mafotokozedwe a selo m'ndandanda.

Ubwino wa mfundo ndi kubwezeretsa - zomwe zimaphatikizapo kugwiritsa ntchito mbewa kuti ziwonetsere maselo - ndizomwe zimachepetsa mwayi wa zolakwika chifukwa cholemba zolakwika.

M'munsimu muli ndondomeko zomwe zimagwiritsidwa ntchito polemba MODE kugwira ntchito mu selo F2 mu chithunzi pamwambapa.

1. Dinani pa selo F2 - kuti mupange selo yogwira ntchito;
2. Lembani izi: = machitidwe (
3. Dinani ndi kukokera ndi mbewa kuti musonyeze maselo A2 mpaka D2 mu tsamba lothandizira kuti mulowe muyeso ili monga zokhudzana ndi ntchito;
4. Lembani mzere womaliza wobwereza kapena malemba " ) " kuti muphatikize kukangana kwa ntchito;
5. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo;
6. Yankho lachitatu liyenera kuoneka mu selo F2 chifukwa nambalayi ikuwonekera kwambiri (kawiri) mundandanda wa deta;
7. Mukasindikiza pa selo F2 ntchito yonse = MODE (A2: D2) ikuwoneka mu barra ya fomu pamwamba pa tsamba.