Siv cov haujlwm MEDIAN hauv Microsoft Excel
Zauv, muaj ntau txoj hauv kev los ntsuas cov kev xav hauv nruab nrab los yog, vim nws tau hu ua ntau tshaj plaws, qhov nruab nrab rau ib qho ntawm qhov tseem ceeb . Qhov nruab nrab yog qhov chaw nruab nrab lossis nruab nrab ntawm ib pawg ntawm cov zauv nyob rau hauv ib qho kev faib tawm.
Nyob rau hauv cov ntaub ntawv ntawm tus zauv nruab nrab, nws yog nruab nrab tus naj npawb hauv ib pawg ntawm cov zauv. Ib nrab ntawm cov zauv muaj nqis ntau tshaj qhov nruab nrab, thiab ib nrab ntawm cov lej muaj qhov tseem ceeb tsawg dua tus neeg nruab nrab. Piv txwv, tus zauv nruab nrab rau qhov "2, 3, 4, 5, 6" yog 4.
Yuav ua kom yooj yim ntsuas ntawm txoj kev xav hauv nruab nrab, Excel muaj ntau yam haujlwm uas yuav suav qhov nruab nrab siv nruab nrab qhov tseem ceeb:
- MEDIAN muaj nuj nqi: Nrhiav tus nqi nruab nrab los nruab nrab ntawm cov npe
- Qhov muaj nuj nqi AVERAGE : Nrhiav cov ntsiab lus ntawm cov zauv
- Cov kev ua MODE : Nrhiav hom lossis feem ntau tshwm sim muaj nqis nyob rau hauv ib daim ntawv teev cov naj npawb
Yuav ua li cas MEDIAN Function Works
MEDIAN ua haujlwm xaiv los ntawm cov lus sib tham los nrhiav cov nqi uas poob hauv nruab nrab ntawm pawg.
Yog tias muaj cov lus sib ceg sib npaug, qhov kev ua haujlwm qhia qhov nruab nrab ntawm qhov nruab nrab ntawm tus nqi nrab nruab nrab.
Yog tias muaj cov lus sib cav sib npaug, qhov kev ua haujlwm yuav siv qhov nruab nrab ntawm qhov nruab nrab ntawm qhov nruab nrab ntawm qhov nruab nrab ntawm qhov nruab nrab ntawm qhov nruab nrab.
Lus Cim : Qhov tseem ceeb uas muab los ua kev sib ceg tsis tas yuav tau ua raws nraim hauv ib qho kev txiav txim tshwj xeeb rau kev ua haujlwm. Koj tuaj yeem pom tias hauv kev ua si nyob rau hauv plaub kab hauv tus duab hauv qab no.
MEDIAN muaj nuj nqi Syntax
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.
Qhov no yog qhov syntax rau MEDIAN muaj nuj nqi:
= MEDIAN ( Number1 , Number2 , Number3 , ... )- = MEDIAN : Qhov no yog li cas tag nrho MEDIAN cov qauv yuav tsum pib, yog li no tsis tuaj yeem hloov.
- Number 1: Yuav tsum tau muab cov ntaub ntawv yuav tsum raug kwv yees los ntawm txoj haujlwm
- Number2 : Cov ntaub ntawv tseem ceeb ntxiv rau qhov nruab nrab. Qhov tso cai ntau tshaj plaws nkag tau yog 255, txhua tus uas xav tau kev sib cais los ntawm ib qho kev sib yeem.
Qhov kev sib cav no muaj peev xwm:
- ib daim ntawv teev cov najnpawb yuav tsum tau ntaus nqi
- xov tooj ntawm tes rau qhov chaw nyob ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm
- ib txoj kab ntawm xov tooj ntawm cov xov tooj
- ib lub npe hu ua
Cov kev xaiv rau kev nkag mus rau qhov kev ua thiab nws cov lus:
- Sau cov kev ua tiav tiav, zoo li = MEDIAN (A2: F2) , mus rau hauv ib daim ntawv ntawm tes
- Nkag mus rau qhov kev ua thiab kev sib ceg uas siv qhov sib txawv ntawm lub thawv
MEDIAN Function Piv txwv
Cov kauj ruam no qhia meej txog yuav ua li cas nkag mus rau MEDIAN muaj nuj nqi thiab kev sib ceg uas siv lub thawv rau kev sib tham rau thawj tus qauv tshwm sim hauv daim duab no:
- Nyem ntawm tes G2. Qhov no yog qhov chaw uas cov ntsiab lus tau muab tso tawm.
- Next rau ntawm cov qauv> Ntau Cov Haujlwm> Tshaj Ntawv Xaiv Cov Ntawv Taw Qhia Xaiv MEDIAN los ntawm daim ntawv teev npe.
- Nyob rau ntawm thawj lub thawv ntawv hauv lub thawv ntawv, qhia txog lub hlwb A2 rau F2 hauv daim ntawv khij nyiab kom tau ntxig tias ntau yam.
- Nias OK mus ua kom tiav qhov ua haujlwm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
- Cov lus teb 20 yuav tsum tshwm sim hauv xov tooj ntawm tes G2
- Yog tias koj nias rau ntawm G2 tes, qhov ua tiav tiav, = MEDIAN (A2: F2) , tshwm nyob rau ntawm lub teeb mis saum toj sau nplooj ntawv.
Vim li cas cov nqi nrab 20? Rau thawj tus qauv hauv daim duab, vim muaj ib qho kev sib tw ntawm cov lus sib tham (tsib), tus nqi nrab nruab nrab yog xam los ntawm kev nrhiav tus nab npawb nruab nrab. Nws yog 20 qhov no vim hais tias muaj ob tus leb loj (49 thiab 65) thiab ob tug me dua (4 thiab 12).
Cov Kab Xev Plaub Hloov Pleev Xim
Thaum nws los mus nrhiav tus zais rau hauv Excel, nws muaj qhov sib txawv ntawm cov naj npawb dawb los yog tas nrho 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.
- Cov kev hloov hauv nruab nrab ntawm cov thawj thiab ob qho piv txwv vim tias xoom tau ntxiv rau qhov cell A3 whereas ntawm tes A2 yog qhov chaw.
- Qhov sib ntxiv ntawm ib qho xoom rau ntawm tes A3 hloov cov naj npawb ntawm cov lus sib kis mus rau txoj haujlwm hauv G3 ntawm tsib mus rau - ib qho xov tooj. Vim li ntawd, tus zauv nruab nrab yog muab xam los ntawm kev ntxiv ntawm ob qhov txiaj ntsig nruab nrab (12 thiab 20) ua ke thiab muab faib los ntawm ob los nrhiav lawv qhov nruab nrab (16).
Los ntawm lub neej ua ntej, Excel qhia xoom (0) hauv hlwb nrog pes tsawg tus nqi - raws li qhia hauv tus qauv saum toj no. Qhov kev xaiv no yuav raug tua thiab, yog tias ua tau tiav, cov hlwb zoo li cov seem, tab sis pes tsawg tus nqi rau cov xov tooj ntawm tes no tseem muaj kev sib cav rau qhov kev ua hauj lwm thaum xam xyuas cov neeg nruab nrab.
Ntawm no yog li cas toggle qhov kev xaiv no rau thiab tawm:
- Next rau cov ntaub ntawv> Cov ntawv xaiv zaub mov (los yog Excel Options nyob rau hauv cov laus versions of Excel).
- Nkag mus rau qhov Advanced category ntawm pane sab laug ntawm cov kev xaiv.
- Ntawm sab xis, khoov nqes mus txog ntua thaum koj pom tias "Cov duab xaiv rau daim ntawv no."
- Los zais xoom qhov tseem ceeb hauv cov hlwb, tshem qhov pom tus xoom hauv hlwb uas muaj pes tsawg tus nqi kos box. Kom tso saib daim duab tso zis, muab ib daim tshev rau hauv lub thawv.
- Tseg cov kev hloov nrog OK khawm.