Google Sheets yog daim ntawv tshaj tawm hauv lub vev xaib uas yooj yim siv thiab ua rau koj cov ntaub ntawv muaj nyob txhua qhov chaw koj tuaj yeem nkag mus hauv is taws nem. Vim tias nws tsis khi rau ib lub tshuab, nws tuaj yeem nkag tau los ntawm txhua qhov chaw thiab ntawm txhua hom khoom siv. Yog tias koj yog tus tshiab rau Google Sheets, koj yuav tsum kawm ntau lub luag haujlwm kom pib. Ntawm no, peb saib ntawm MODE muaj nuj nqi, uas pom cov nqi tshwm sim ntau tshaj plaws hauv cov lej.
Nrhiav tus nqi tshwm sim feem ntau nrog rau hom kev ua haujlwm
Rau tus lej teeb:
1, 2, 3, 1, 4
hom yog tus naj npawb 1 vim nws tshwm sim ob zaug hauv daim ntawv thiab txhua tus lej tshwm sim ib zaug xwb.
Yog ob lossis ntau tus lej tshwm sim hauv ib daim ntawv teev npe tib lub sijhawm, lawv yog, sib sau ua ke, hom.
Rau tus lej teeb:
1, 2, 3, 1, 2
ob tus lej 1 thiab 2 yog hom vim lawv ob leeg tshwm sim ob zaug hauv daim ntawv, thiab tus lej 3 tshwm ib zaug xwb. Hauv qhov piv txwv thib ob, tus lej teeb tsa yog "bimodal."
txhawm rau nrhiav hom rau cov lej txheej thaum siv Google Sheets, siv MODE muaj nuj nqi.
MODE Function's Syntax and Arguments
A muaj nuj nqi syntax yog hais txog kev teeb tsa ntawm txoj haujlwm thiab suav nrog cov haujlwm lub npe, cov hlua khi, cov cim cais thiab cov lus sib cav.
Tus syntax rau MODE muaj nuj nqi yog: =MODE (number_1, number_2, …number_30)
- number_1 – (yuav tsum tau) cov ntaub ntawv suav nrog hauv kev suav cov hom
- number_2: number_30 – (yeem) cov ntaub ntawv ntxiv qhov tseem ceeb suav nrog hauv kev suav hom. Qhov siab tshaj plaws ntawm cov ntawv tso cai yog 30.
Cov lus sib cav tuaj yeem muaj:
- ib daim ntawv teev tus lej
- xovtooj xa mus rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm
- ntau yam ntawm cov ntaub ntawv xovtooj
- a npe range
Yuav ua li cas siv MODE muaj nuj nqi hauv Google Sheets
Qhib cov ntaub ntawv Google Sheets tshiab thiab ua raws cov kauj ruam no kom paub siv MODE muaj nuj nqi.
MODE muaj nuj nqi tsuas yog ua haujlwm nrog cov ntaub ntawv tus lej.
-
Tau koj cov ntaub ntawv rau hauv Google spreadsheet, thiab tom qab ntawd nyem lub xovtooj ntawm tes uas koj xav ntxig rau MODE muaj nuj nqi rau.
Image -
Type, " =MODE(" los pib tus qauv.
Image -
Xaiv cov hlwb nrog cov ntaub ntawv koj xav txheeb xyuas.
Koj tuaj yeem xaiv ntau lub hlwb los ntawm txhaj rau txhua tus lossis nyem thiab rub. Txhawm rau siv tag nrho kem tag nrho, yog nyem rau ntawm kab ntawv kab lus lossis ntaus "[kem npe]: [kem daim ntawv lo]."
Image -
Kaw cov kab lus thaum koj ua tiav cov kab ke, thiab tom qab ntawd nias Enter. Hom ntawm cov ntaub ntawv uas koj tau hais tseg yuav hloov cov qauv hauv lub cell.
Yog tias tsis muaj nqi tshwm ntau dua ib zaug hauv cov ntaub ntawv xaiv ntau, qhov N / A yuam kev tshwm sim hauv lub xov tooj ntawm tes.
Image - Cov mis yuav hloov pauv yog tias koj hloov cov ntaub ntawv qub thiab nws hloov hom.
Yuav Ua Li Cas Pom Ntau Hom
Cov ntaub ntawv koj tab tom txheeb xyuas yuav yog polymodal - ntau tus lej "kuav" rau qhov tshwm sim feem ntau. Yog tias koj siv MODE muaj nuj nqi, nws tsuas yog xa rov qab ib qho ntawm cov lej no: qhov ze tshaj plaws rau sab saum toj ntawm daim ntawv nthuav qhia. Google Sheets muaj lwm cov qauv uas yuav xaiv tawm txhua hom. Nov yog yuav siv li cas.
-
Siv "=MODE(, " type, " =MODE. MULT(" los pib koj cov qauv.
Koj tuaj yeem hloov kho cov qauv los ntawm nyem rau ntawm lub xovtooj thiab hloov nws hauv qhov nkag nkag ntawm qhov screen saum toj kawg nkaus.
Image -
Xaiv cov hlwb li qub, thiab tom qab ntawd kaw cov kab lus kom ua tiav txoj haujlwm.
Image -
Tam sim no, thaum koj nias Enter, tag nrho cov qauv hauv cov teeb yuav tshwm sim ntawm ib kab sib cais pib nrog ib qho uas koj nkag mus rau cov qauv.
Image - Google Sheets yuav tsis cia koj rho tawm cov ntawv nkag hauv hlwb uas tsis muaj cov qauv. Tab sis yog tias koj tshem lub xovtooj nrog lub luag haujlwm, nws yuav tshem tawm tag nrho lwm hom.
