01 ya 01
Pezani Mtengo Wowonjezeka Kwambiri Nthawi Zonse Ndi Ntchito ya MODE
Mapepala a Google ndi spreadsheet yovomerezeka pa intaneti yomwe imatamandidwa chifukwa chosavuta kugwiritsa ntchito. Chifukwa sichikumangirizidwa ndi makina amodzi, akhoza kupezeka kuchokera kulikonse ndi pa mtundu uliwonse wa chipangizo. Ngati mwatsopano ku Google Mapepala, muyenera kudziwa ntchito zingapo kuti muyambe. Nkhaniyi ikuyang'ana ntchito ya MODE, yomwe imapeza kufunika kowonjezeka kawirikawiri pa chiwerengero cha nambala.
Mwachitsanzo, kuti chiwerengero chiyike:
1,2,3,1,4njira ndi nambala 1 chifukwa imapezeka kawiri mndandanda ndipo nambala iliyonse imapezeka kamodzi kokha.
Ngati ziwerengero ziwiri kapena zingapo zikupezeka pa mndandanda nthawi yomweyo, onsewo amaonedwa kuti ndiwo machitidwe.
Kwa chiwerengero chayikidwa:
1,2,3,1,2ma nambala 1 ndi 2 akuonedwa kuti ndizofanana chifukwa zonsezi zimachitika kawiri pa mndandanda ndipo nambala 3 ikuwonekera kamodzi kokha. Mu chitsanzo chachiwiri, chiwerengero chayikidwa kuti ndi bimodal.
Kuti mupeze momwe mungagwiritsire ntchito nambala ya manambala pogwiritsa ntchito Google Mapepala, gwiritsani ntchito MODE ntchito.
Mmene Mungagwiritsire ntchito Ntchito ya MODE mu Google Mapepala
Tsegulani chikalata chatsopano cha Google Maps ndipo tsatirani izi kuti mudziwe momwe mungagwiritsire ntchito MODE ntchito.
- Lowetsani deta zotsatirazi mu maselo A1 mpaka A5: mawu akuti "amodzi," ndi nambala 2, 3, 1 ndi 4 monga momwe zikuwonetseratu zotsatizana ndi nkhaniyi.
- Dinani pa selo A6, komwe kuli malo omwe zotsatira zidzawonetsedwa.
- Lembani chizindikiro chofanana = kutsatiridwa ndi mawu "mawonekedwe ."
- Pamene mukuyimira, bokosi lopangira galimoto likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata M.
- Pamene mawu akuti "mawonekedwe" amapezeka pamwamba pa bokosi, pindikizani fungulo lolowamo lolowamo kuti mulowetse dzina la ntchito ndikutsegula mzere wozungulira ( mu selo A6.
- Onetsetsani maselo A1 ku A5 kuti awaphatikize ngati zifukwa za ntchito.
- Lembani mzere womaliza wazitsulo ) kuti mutsimikize mfundo za ntchitoyo.
- Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo.
- Cholakwika cha # N / A chiyenera kuoneka mu selo A6 chifukwa nambala iliyonse mu maselo ambiri osankhidwa amawonekera kangapo.
- Dinani pa selo A1 ndipo lembani nambala 1 kuti mutengere mawu akuti "chimodzi."
- Dinani ku key lolowamo pa khibhodi
- Zotsatira za MODE zimagwira ntchito mu selo A6 ziyenera kusintha ku 1. Chifukwa tsopano pali maselo awiri m'magulu omwe muli nambala 1, ndiyo njira yosankhidwa nambala.
- Mukasindikiza pa selo A6, ntchito yonse = MODE (A1: A5) ikuwoneka mu barra ya fomu pamwamba pa tsamba
Syntax ndi Maganizo a Ntchito ya MODE
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakia, olekanitsa okometsa ndi otsutsana .
Chidule cha ntchito ya MODE ndi: = MODE (nambala_1, nambala_2, ... nambala_30)
- nambala_1 - (yofunikira) deta yoti ikhalepo pakuwerengera njira
- nambala_2: nambala_30 - (zosankha) zina zamtengo wapatali za deta ziyenera kuphatikizidwa muzowerengera. Chiwerengero chazowonjezera chololedwa ndi 30.
Chiwerengero cha nambala chingakhale nacho:
- mndandanda wa nambala
- mafotokozedwe a selo kumalo a deta mu worksheet
- malingaliro osiyanasiyana a selo
- dzina lotchuka
Mfundo
- Kulembera malemba kumaphatikizapo mafotokozedwe angapo omwe sakusamalidwa ndi ntchitoyi. Ngati maselo omwe ali ndi malemba adasinthidwa kuti apeze manambala, machitidwewo amawongolera, ngati kuli koyenera, kuti akwaniritse kusintha.
- Ngati palibe phindu likuwonekera kangapo kamphindi, data # N / A ikuwoneka mu selo komwe ntchitoyi ili.