Funda indlela efanelekileyo yokusebenzisa i-Google Spreadsheets I-MEDIAN Function

01 ngo 05

Ukufumanisa Ixabiso Lobumbano kunye nomsebenzi weMEDIAN

Kukho iindlela ezininzi zokulinganisa okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge, kwisethi yexabiso.

Ukwenza kube lula ukulinganisa ukutyekela okuphambili, i-Google Spreadsheets inomsebenzi omninzi oya kubala ixabiso eliqhelekileyo elisetyenziswa ngokuqhelekileyo. Ezi ziquka:

• Umsebenzi weMEDIAN - ufumana ixabiso eliphakathi okanye eliphakathi kwimihlu yamanani;
• Umsebenzi we- AVERAGE - ufumana i- arithmetic ithetha ukuba uluhlu lwamanani;
• Umsebenzi we- MODE - ufumana imo okanye ubuninzi bexabiso eliqhelekileyo kwiluhlu lwamanani.

02 we 05

Ukufumana iMathematika yeMedian

I-median ibalwa ngokulula kwixabiso elingaqhelekanga. Kuba inani 2,3,4, ixabiso eliphakathi, okanye eliphakathi, linani le-3.

Ngamaxabiso amanani, i-median ibalwa ngokufumana i- arithmetic ithetha okanye umyinge wexabiso ezimbini eziphakathi.

Ngokomzekelo, umlambo wamanani 2.3,4,5, ubalwa ngokulinganisa phakathi kwamanani amabini 3 no-4:

(3 + 4) / 2

eziphumela kumlamandla we-3.5.

03 we 05

I-Syntax yeMisebenzi kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .

I-syntax yomsebenzi we-MEDIAN yile:

= UMEDIAN (inombolo_1, inombolo_2, ... inombolo_30)

inombolo_1 - (efunekayo) idatha ukuba ifakiwe ekubaleni umlambo

inombolo_2: inombolo_30 - (okukhethwa kukho) ixabiso leenkcukacha ezongezelelweyo ukuba zifakwe kwizibalo zamanani. Inani eliphezulu lokungena elivunyelwe li-30

Inombolo yeziphakamiso zingabandakanya:

• uluhlu lwamanani;
• izikhokelo zeseli kwindawo yendawo kwiphepha lokusebenzela;
• uluhlu lweenkcukacha zeeseli;
• uluhlu olukhethiweyo .

04 we 05

Umzekelo usebenzisa umsebenzi weMEDIAN

Amanyathelo alandelayo asetyenziswa ukufaka umsebenzi we-MEDIAN kwiseli D2.

1. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi ophakathi;
2. Njengoko uthayipha, ibhokisi ephakamisa ukuzenzekelayo ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta M;
3. Xa igama eliphakathi livela kwibhokisi, cofa iqhosha lokungena kwikhibhodi ukufaka igama lomsebenzi kunye nabazali abavulekile kwi-cell D2;
4. Phakamisa iiseli ezi-A2 ukuya ku-C2 ukuze uzibandakanye njengeengxoxo zomsebenzi;
5. Cinezela ukhiye wokungena ukongeza abazali bokuvala kunye nokugqiba umsebenzi;
6. Inombolo 6 kufuneka ibonakale kwiseli ye-A8 njengemida yeenombolo ezintathu;
7. Xa ucofa kwiseli D2 umsebenzi opheleleyo = I-MEDIAN (A2C2) ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela .

05 we 05

Amaseli angenanto ngokubhekiselele kwiZero

Xa kuziwa ekufumaneni i-median kwi-Google Spreadsheets, kukho umehluko phakathi kwengubo engenanto okanye engenanto kunye nalabo abanokuxabiswa kwexabiso.

Njengoko kuboniswe kwimimiselo engentla, iiseli ezingenanto zingagcinwa ngumsebenzi weMEDIAN kodwa kungekhona ezo zinto ezinexabiso lexabiso.

Utshintsho lwangaphakathi phakathi kwemizekelo kwimigangatho emine neyesihlanu kuba i-zero yongezwa kwiseli B5 ngelixa i-cell B4 ingenanto.

Nje ngeziphumo,:

• umlambo womqolo wesine ubalwa ngokungongeza (6 + 4) / 2 = 5
• umlambo kwinqanaba elithandathu liphakathi kwamanani amathathu: 4