E aʻo i ke ala kūpono e hoʻohana ai i nā pā'ālua o Google MEDIAN

01 o 05

Ke Huli 'ana i ka Wahi Kūpono me ka Hana MEDIAN

Nui nāʻano o ke anaʻana a, paha e like me ka mea i kapaʻia he nui,ʻo ka awelika, no ka hoʻonohonohoʻana i nā koina.

I mea e maʻalahi ai ke anaʻana i ka maʻalahi o ka pūnaewele, loaʻa i nā Google spreadsheets kekahi mauʻoihana e koho ai i nā kumukūʻai maʻamau iʻoi aku ka hoʻohanaʻia. Eia kēia mau mea:

• ʻO ka hana MEDIAN - loaʻa i ka helu waena a waena paha ma ka papa inoa o nā helu;
• ʻO ka hana AVERAGE - loaʻa i ka huahelu helu no kahi papa inoa o nā helu;
• Ka lawelawe MODE - loaʻa i ke kūlana a iʻole ka hopena maʻamau i loaʻa ma ka papa inoa o nā helu.

02 o 05

Ke Huliʻana i ka Makemakika Median

Ua maʻalahi ka helu waena ma kahi helu maʻamau. No nā helu 2,3,4, ke kiko waena, a me ka helu waena,ʻo ia ka helu 3.

Me nā helu waiwai he nui, ua heluʻia ka helu waena ma kaʻikeʻana i ka mean mean or average for the two values ​​middle.

Eia kekahi laʻana,ʻo ka helu waena no nā helu 2,3,4,5, ke heluʻia ma ka heluʻana i nā helu helu waena 3 a me 4:

(3 + 4) / 2

i ka hopena o ka 3.5.

03 o 05

ʻO ka Syntax Hana a me nā Hoʻopilikia

ʻO ka'ōkuhi o kahi hana e pili ana i ka hoʻolālā o ka hana a me ka inoa o ka hana, nā pale, nā huiwaena wili, a me nā pane .

ʻO ka syntax no ka hana MEDIAN:

= MEDIAN (number_1, number_2, ... number_30)

helu_1 - (i makemakeʻia) e hoʻokomo i nāʻikepili i ka heluʻana i ka helu waena

helu_2: number_30 - (kohoʻia) nā hōʻailonaʻikepili'ē aʻe e hoʻokomoʻia i ka helu helu waena. ʻO ka helu nui o nā kiʻina i'āponoʻia he 30

Hiki i nā hua'ōlelo helu ke komo:

• he papa inoa o nā helu;
• nāʻikepili pūnaewele i kahi o kaʻikepili ma ka pepa haʻawina;
• i keʻano o nā haha'ōlelo pūnaewele;
• he inoa i kapaʻia .

04 o 05

Ke hōʻailona e hoʻohana ana i ka Hana MEDIAN

Ua hoʻohanaʻia nā kuhi i lalo no ka hoʻokomoʻana i ka hana MEDIAN ma ke kelepona D2.

1. E kākau i ka hōʻailona like (=) a me ka inoa o ka median hana ;
2. I koʻoe pehiʻana, ʻikeʻia kahi pahu hōʻikeʻike manawa me nā inoa a me ka hui pūʻana o nā hana e hoʻomaka me ka leka M;
3. Keʻikeʻia ka inoa median ma ka pahu, e kaomi i ka pihi komo ma ka papa keyboard e komo i ka inoa o ka hana a me ke kuhikuhiʻana ma ka pūnaewele D2;
4. ʻO nā kinolima maʻamauʻo A2 i C2 e hoʻokomo iā lākou e like me nā pane o ka hana;
5. E kaomi i ke kī komo no ka hoʻomoʻiʻana i ka pani pani a me ka hoʻopau i ka hana;
6. Eʻike ka helu 6 i ke kelepona A8 e like me ka median no nā heluʻekolu;
7. Ke pāʻaniʻoe i ke kelepona D2 i ka hana piha = MEDIAN (A2C2) i loko o ka formula bar ma luna aʻe o ka pepa haʻawina .

05 o 05

Pūnaewele Nalu vs. Zero

I ka loaʻaʻana o ka median ma nā Pūlewele Google, hiki keʻokoʻa ma waena o nā pūnaewele blank a iʻole nā ​​kīnā liʻiliʻi a me nā mea i loaʻa ka waiwai zero.

E like me ia i hōʻikeʻia i nā hiʻohiʻona i luna, ua mālamaʻia nā pūnaewele blank e ka hana MEDIAN akāʻaʻole nā ​​mea i loaʻa ka waiwai zero.

ʻO ka pākēna waena ma waena o nā hiʻohiʻona i nā lālaniʻehā a me kaʻelima no ka mea ua hoʻokomoʻia kekahi zero i ke cell B5 akāʻo ka waihona B4 pūnaewele.

Ma ka hopena,:

• ʻO ka helu waena o ka paeʻehā ke heluʻia (6 + 4) / 2 = 5
• ʻO ka median no ka pae elima ka mea wale nō i waena o nā kumukūʻaiʻekolu: 4