Microsoft Excel muaj ntau lub luag haujlwm uas yuav suav cov nqi nruab nrab uas feem ntau siv. MEDIAN muaj nuj nqi pom tus nqi nruab nrab lossis nruab nrab hauv cov npe ntawm cov lej.
Cov lus qhia no siv rau Excel 2019, 2016, 2013, thiab 2010, nrog rau Excel 2019 rau Mac, Excel 2016 rau Mac, Excel rau Mac 2011, Excel rau Microsoft 365, thiab Excel Online.
How the MEDIAN Function Works
Lub MEDIAN muaj nuj nqi txheeb los ntawm cov lus sib cav los nrhiav tus nqi uas poob rau hauv nruab nrab ntawm pawg.
Yog tias muaj qhov sib txawv ntawm cov lus sib cav, MEDIAN muaj nuj nqi txheeb xyuas tus nqi nruab nrab hauv qhov ntau raws li tus nqi nruab nrab.
Yog tias muaj tus lej sib cav, qhov ua haujlwm yuav siv tus lej lej lossis qhov nruab nrab ntawm ob qhov tseem ceeb raws li tus nqi nruab nrab.
Cov khoom muaj nqis raws li kev sib cav tsis tas yuav tsum nyob rau hauv ib qho kev txiav txim tshwj xeeb rau kev ua haujlwm.
MEDIAN Function Syntax
A muaj nuj nqi syntax hais txog kev teeb tsa ntawm lub luag haujlwm thiab suav nrog cov haujlwm lub npe, cov hlua khi, cov cim cais, thiab cov lus sib cav.
Cov hauv qab no yog cov syntax rau MEDIAN muaj nuj nqi:
=MEDIAN(Number1, Number2, Number3, …)
=MEDIAN yog li cas tag nrho cov qauv MEDIAN pib. Number1 yog hais txog cov ntaub ntawv xav tau uas cov haujlwm yuav suav. Number2 thiab cov txiaj ntsig tom qab xa mus rau cov ntaub ntawv xaiv tau ntxiv qhov tseem ceeb uas yuav suav nrog qhov nruab nrab. Qhov siab tshaj plaws ntawm cov ntawv tso cai yog 255, txhua qhov yuav tsum tau muab cais los ntawm tus lej cim.
Cov lus sib cav no tuaj yeem muaj cov npe ntawm cov lej los nruab nrab, cov ntaub ntawv xov tooj ntawm tes rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm, ntau yam ntawm cov ntaub ntawv xov tooj ntawm tes, thiab cov npe muaj npe.
Hloov ua tiav rau hauv daim ntawv ua haujlwm lossis nkag mus rau cov haujlwm thiab cov lus sib cav siv lub thawv muaj nuj nqi.
MEDIAN Function Piv txwv
Cov kauj ruam no piav qhia yuav ua li cas nkag mus rau MEDIAN muaj nuj nqi thiab kev sib cav siv lub thawv sib tham. Peb tab tom siv cov ntaub ntawv piv txwv nkag mus rau hauv daim ntawv nthuav dav, raws li pom hauv qab no.
- Xaiv tes G2, uas yog qhov kev tshwm sim yuav tshwm sim.
- Xaiv lub Insert Function khawm qhib lub Insert Function dialog box.
- Xaiv Statistical hauv Qeb npe.
- Xaiv MEDIAN hauv daim ntawv teev cov haujlwm thiab tom qab ntawd xaiv OK.
- Highlight cells A2 rau F2 hauv daim ntawv ua haujlwm kom tau txais qhov ntau ntxiv.
- Nias Enter lossis Return kom ua tiav txoj haujlwm thiab rov qab mus rau daim ntawv ua haujlwm.
-
Rau peb cov ntaub ntawv piv txwv, cov lus teb 20 yuav tsum tshwm sim hauv cell G2.
Image Yog tias koj nyem rau ntawm tes G2, ua tiav txoj haujlwm, =MEDIAN(A2: F2), tshwm hauv cov qauv bar saum daim ntawv ua haujlwm.
Vim li cas tus nqi nruab nrab yog 20? Txij li thaum muaj tus lej khib ntawm cov lus sib cav hauv kab ntawm cov ntaub ntawv no (tsib), tus nqi nruab nrab yog xam los ntawm kev nrhiav tus lej nruab nrab. Nws yog 20 ntawm no vim tias muaj ob tus lej loj dua (49 thiab 65) thiab ob tus lej me dua (4 thiab 12).
Blank Cells vs. Zero Values
Thaum nrhiav qhov nruab nrab hauv Excel, nws muaj qhov sib txawv ntawm lub hlwb dawb lossis khoob thiab cov uas muaj tus nqi xoom. Lub luag haujlwm MEDIAN tsis quav ntsej cov hlwb dawb tab sis tsis yog cov uas muaj tus nqi xoom.
Los ntawm lub neej ntawd, Excel qhia qhov xoom hauv hlwb nrog tus nqi xoom. Qhov kev xaiv no tuaj yeem raug muab tua, yog li yog tias cov hlwb raug tso tseg, tus nqi xoom rau lub xovtooj ntawm tes tseem suav nrog kev sib cav rau kev ua haujlwm thaum xam qhov nruab nrab.
Ntawm no yog yuav ua li cas toggle qhov kev xaiv no rau thiab tawm:
In Excel 2019, Excel 2016, Excel 2013, thiab Excel 2010
- Mus rau File tab thiab xaiv Options.
- Nkag mus rau Advanced qeb los ntawm sab laug pane ntawm cov kev xaiv.
- Ntawm sab xis, nqes mus kom txog thaum koj pom Display Options for This Worksheet section.
- Txhawm rau zais xoom qhov tseem ceeb hauv cov hlwb, tshem tawm Qhia qhov xoom hauv cov hlwb uas muaj pes tsawg tus nqi checkbox. Txhawm rau tso saib zeros, muab kos rau hauv lub thawv.
-
Txuag txhua qhov kev hloov pauv nrog lub pob OK
Image
In Excel 2019 rau Mac, Excel 2016 rau Mac, thiab Excel rau Mac 2011
- mus rau Excel ntawv qhia.
- Xaiv Preferences.
- Under Authoring, xaiv View.
-
Ntawm qhov Qhia Zero Qhov Tseem Ceeb checkbox hauv qab Qhov Kev Xaiv Qhov rai.
Qhov kev xaiv no tsis tuaj yeem muab tua hauv Excel Online.
