Phunzirani Njira Yoyenera Yogwiritsa Ntchito Google Spreadsheets Function Fun

01 ya 05

Kupeza Mtengo Wapakati ndi Ntchito ya MEDIA

Pali njira zingapo zoyezera kapena, monga momwe zimatchulira kawirikawiri, zowonjezera, chifukwa cha chikhalidwe.

Kuti zikhale zosavuta kuyeza chizoloŵezi chapakati, Google Spreadsheets ili ndi ntchito zambiri zomwe zikhoza kuwerengera zomwe zimagwiritsidwa ntchito kwambiri. Izi zikuphatikizapo:

• Ntchito ya MEDIAN - imapeza mtengo wapakati kapena pakati pakati pa manambala;
• Ntchito YOPHUNZITSIRA - imapeza chilembo chikutanthawuza kwa manambala a manambala;
• Ntchito ya MODE - imapeza njira kapena zochitika zomwe zimachitika kawirikawiri pamndandanda wa manambala.

02 ya 05

Kupeza Masamu Achi Median

Werenganinso amawerengedwa mosavuta kwa chiwerengero chosamvetseka cha miyezo. Kwa chiwerengero 2,3,4, mtengo wapakati, kapena pakati, ndi nambala 3.

Pokhala ndi chiwerengero cha chiwerengero, munthu wamkati amalingalira popeza chiwerengerocho chikutanthawuza kapena kuwerengera zoyenera ziwiri zapakati.

Mwachitsanzo, woyimira pakati pa chiwerengero cha 2,3,4,5, amawerengedwa poyerekeza pakati pa nambala ziwiri ndi 4:

(3 + 4) / 2

zomwe zimayambitsa pafupifupi 3,5.

03 a 05

Syntax ndi Mapangano a Ntchito ya MEDIAN

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

Chidule cha ntchito ya MEDIAN ndi:

= MADZI (nambala_1, nambala_2, ... nambala_30)

nambala_1 - (yofunika) deta yoti ikhale yowerengera muyeso

nambala_2: nambala_30 - (zosankha) zina zowonjezera chiwerengero cha deta ziyenera kuphatikizidwa muzowerengera zam'kati. Chiwerengero chazowonjezera chololedwa ndi 30

Chiwerengero cha nambala chingakhale nacho:

• mndandanda wa manambala;
• mafotokozedwe a selo kumalo a deta mu worksheet;
• malingaliro osiyanasiyana a selo;
• dzina lotchuka .

04 ya 05

Chitsanzo pogwiritsa ntchito ntchito ya MEDIAN

Njira zotsatirazi zinagwiritsidwa ntchito kulowa ntchito ya MEDIAN mu selo D2.

1. Lembani chizindikiro chofanana (=) chotsatira dzina la ntchito yoyimira;
2. Pamene mukuyimira, bokosi lopangira galimoto likuwoneka ndi maina ndi maina a ntchito zomwe zimayamba ndi kalata M;
3. Pamene dzina lofikira limapezeka m'bokosi, lowetsani mu Enter key pa khididiyi kuti mulowetse dzina la ntchito ndi mazira oyamba mu selo D2;
4. Onetsetsani maselo A2 mpaka C2 kuti awagwiritse ntchito monga zifukwa za ntchito;
5. Lembani fungulo lolowamo lolowera kuti muwonjezere zolemba za kutseka ndi kumaliza ntchitoyo;
6. Nambala 6 iyenera kuoneka mu selo A8 ngati yeniyeni kwa nambala zitatu;
7. Mukasindikiza pa selo D2 ntchito yonse = MEDIYA (A2C2) ikuwoneka mu barra yazenera pamwamba pa tsamba .

05 ya 05

Maselo osajambulidwa ndi Zero

Pokhudzana ndi kupeza zamkati mwa Google Spreadsheets, 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 m'mizere inayi ndi isanu chifukwa zero inawonjezeredwa ku selo B5 pomwe selo B4 liribe kanthu.

Zotsatira zake,:

• Werenganinso wa mzere wachinayi akuwerengedwa powonjezera (6 + 4) / 2 = 5
• Werenganinso wa mzere wachisanu ndi chimodzi mwazigawo zitatu: 4