Kawm txog Txoj Cai Siv Los Tshaj Tawm Google Spreadsheets MEDIAN

01 ntawm 05

Nrhiav Nruab Nrab Nruab Nrab nrog MEDIAN Function

Nws muaj ntau txoj kev los ntsuas, los yog nws tau nquag hu ua, qhov nruab nrab, rau ib qho ntawm qhov tseem ceeb.

Yuav ua kom yooj yim los ntsuas cov cwj pwm txawv, Google Spreadsheets muaj ntau yam haujlwm uas yuav suav qhov nruab nrab siv feem ntau siv. Cov no suav nrog:

• MEDIAN muaj nuj nqi - pom cov nqi nruab nrab los nruab nrab ntawm cov naj npawb;
• Qhov kev ua haujlwm AVERAGE - pom cov ntsiab lus ntawm cov zauv rau cov zauv;
• Cov kev ua MODE - pom qhov hom lossis feem ntau tshwm sim muaj nqis nyob rau hauv ib daim ntawv teev cov naj npawb.

02 ntawm 05

Nrhiav cov Neeg Zej Zog

Tus zauv nruab nrab yog tau yooj yim tshaj plaws rau ib qho xov tooj ntawm qhov tseem ceeb. Rau cov lej 2,3,4, tus nqi nruab nrab, lossis qhov nruab nrab, yog tus naj npawb 3.

Nrog rau ib qho tseem ceeb ntawm qhov tseem ceeb, tus zauv nruab nrab yog xam los ntawm kev nrhiav qhov txhais nruab nrab lossis qhov nruab nrab ntawm ob qhov txiaj ntsig.

Piv txwv, tus zauv nruab nrab rau cov lej 2,3,4,5, yog xam los ntawm nruab nrab ntawm ob tus lej 3 thiab 4:

(3 + 4) / 2

uas tshwm sim hauv nruab nrab ntawm 3.5.

03 ntawm 05

MEDIAN muaj nuj nqi lub Syntax thiab kev sib ceg

Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav cov kev ua haujlwm lub npe, cov ntsiab lus, cov cim cais, thiab cov lus sib tham .

Tus syntax rau MEDIAN muaj nuj nqi yog:

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

naj npawb_1 - (yuav tsum tau) cov ntaub ntawv yuav tsum muaj nyob hauv xam cov neeg nruab nrab

naj npawb_2: number_30 - (optional) ntxiv cov ntaub ntawv tseem ceeb kom muab tso rau hauv cov lus teb nruab nrab. Qhov tsawg tshaj plaws ntawm nkag tau tso cai yog 30

Cov lus sib cav muaj peev xwm:

• ib daim ntawv teev cov naj npawb;
• xov tooj ntawm tes rau qhov chaw nyob ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm;
• ib chav ntawm cov xov tooj ntawm tes;
• ib lub npe hu ua .

04 ntawm 05

Piv txwv siv cov kev cai MEDIAN

Cov kauj ruam nram qab no raug siv los nkag rau MEDIAN kev ua haujlwm hauv xovtooj ntawm D2.

1. Sau qhov sib npaug sib npaug (=) tom qab los ntawm lub npe ntawm cov haujlwm nruab nrab;
2. Raws li koj ntaus ntawv, nws pib lub thawv tshwm nrog cov npe thiab syntax ntawm cov haujlwm uas pib ntawm tsab ntawv M;
3. Thaum twg lub npe nruab nrab hauv lub thawv, nias lub khawm nkag rau ntawm cov keyboard kom nkag mus rau lub npe thiab qhov qhib parenthesis rau hauv D2 cell;
4. Highlight hlwb A2 rau C2 kom muaj lawv li kev ua haujlwm cov lus;
5. Nias tus yuam sij nkag mus ntxiv rau pawg niam txiv kaw thiab ua tiav qhov haujlwm;
6. Tus lej 6 yuav tsum tshwm sim hauv cell A8 ua tus zauv nruab nrab rau peb tus lej;
7. Thaum koj nias ntawm tes D2 qhov ua tiav tiav = MEDIAN (A2C2) tshwm nyob rau ntawm qhov formula formula saum toj ntawv .

05 ntawm 05

Cov Kab Xev Plaub Hlis vs. Zero

Thaum nws los mus nrhiav tus neeg nruab nrab ntawm Google Spreadsheets, muaj qhov sib txawv ntawm cov voj voos khoob los dawb thiab cov uas muaj pes tsawg tus nqi.

Raws li pom hauv cov qauv saum toj no, dawb paug tsis pom los ntawm MEDIAN muaj nuj nqi tab sis tsis yog cov uas muaj pes tsawg tus nqi.

Qhov hloov pauv nrab ntawm cov piv txwv ntawm kab plaub thiab tsib vim tias xoom tau ntxiv rau cell B5 whereas ntawm tes B4 yog qhov seem.

Yog li ntawd ,:

• tus neeg nruab nrab rau kab plaub yog xam los ntawm kev ntxiv (6 + 4) / 2 = 5
• tus zauv nruab nrab ntawm kab tsib yog tsuas yog nruab nrab ntawm peb qhov tseem ceeb: 4