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

01 ka 05

Ukuthola i-Value Middle nge-MEDIAN Function

Kunezindlela eziningi zokulinganisa noma, njengoba kubizwa ngokujwayelekile, isilinganiso, ngesethi yamanani.

Ukwenza kube lula ukukala ukuthambekela okuphakathi, ama-Google Spreadsheets anemisebenzi eminingi ezobala amanani ajwayelekile asetshenziswe kakhulu. Lokhu kufaka:

• Umsebenzi we-MEDIAN - uthola inani eliphakathi noma eliphakathi ohlwini lwezinombolo;
• Umsebenzi we- AVERAGE - uthola incazelo ye- arithmetic ohlwini lwamanani;
• Umsebenzi we- MODE - uthola imodi noma i-value evame kakhulu eyenzeka ohlwini lwamanani.

02 ka 05

Ukuthola i-Median Mathematically

I-median ibalwa kalula ngenani elingavamile lamanani. Ngokuba izinombolo 2,3,4, inani eliphakathi, noma eliphakathi, yinombolo 3.

Ngenani elilinganayo lamanani, umlingani ubalwa ngokuthola incazelo ye- arithmetic noma isilinganiso samanani amabili aphakathi.

Isibonelo, i-median yezinombolo 2,3,4,5, ibalwa ngokulinganisela phakathi kwezinombolo ezimbili no-4:

(3 + 4) / 2

okuholela kumuntu ophakathi kuka-3.5.

03 ka 05

I-syntax ye-MEDIA ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax yomsebenzi we-MEDIAN yile:

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

inombolo_1 - (edingekayo) idatha okumele ifakwe ekubaleni okuphakathi

inombolo_2: inombolo_30 - (okukhethwa kukho) amanani wedatha eyengeziwe ukuze afakwe ekubaleni okuphakathi. Inombolo ephezulu yokufakwayo evunyelwe i-30

Izinombolo zezinombolo zingaqukatha:

• uhlu lwezinombolo;
• izingqikithi zeseli endaweni yedatha kushidi lokusebenzela;
• ububanzi bezinkomba ezisele;
• ibanga elibizwe .

04 ka 05

Isibonelo usebenzisa umsebenzi we-MEDIAN

Izinyathelo ezilandelayo zisetshenziselwa ukungena emsebenzini we-MEDIAN kuseli D2.

1. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi ophakathi;
2. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi M;
3. Uma igama eliphakathi livela ebhokisini, cindezela ukhiye we- Enter ekhibhodi ukuze ufaka igama lomsebenzi kanye nabazali abavuliwe ku-cell D2;
4. Gqamisa amaseli A2 kuya ku-C2 ukuze uwafake njengezingqinamba zomsebenzi;
5. Cindezela ukhiye wokungena ukuze ungeze ama-parenthesis wokuvala futhi uqedele umsebenzi;
6. Inombolo 6 kufanele ibonakale esitokisini A8 njengomlingani wezinombolo ezintathu;
7. Uma uchofoza ku-cell D2 umsebenzi ophelele = I-MEDIAN (A2C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela .

05 ka 05

Amaseli angenalutho ahambisana ne-Zero

Uma kuziwa ekutholeni ama-median ku-Google Spreadsheets, kukhona umehluko phakathi kwamangqamuzana angenalutho noma angenalutho nalabo abanesilinganiso senani.

Njengoba kuboniswe kulezi zibonelo ezingenhla, amangqamuzana angenalutho ayenganakwa umsebenzi we-MEDIAN kodwa hhayi lawo anesilinganiso senani.

Izinguquko eziphakathi phakathi kwezibonelo emigqeni ezine nezinhlanu ngoba i-zero yanezelwa kwiseli B5 kuyilapho iseli B4 lingenalutho.

Ngenxa yalokho,:

• ophakathi komugqa we-4 ubalwa ngokungeza (6 + 4) / 2 = 5
• ophakathi komugqa wesihlanu uphakathi kwamanani amathathu: 4