Mvetserani Ntchito ya MODE mu Google Mapepala

01 ya 01

Pezani Mtengo Wowonjezeka Kwambiri Nthawi Zonse Ndi Ntchito ya MODE

Google Spreadsheets MODE Ntchito. © Ted French

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,4

njira 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,2

ma 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.

  1. Lowetsani deta zotsatirazi mu maselo A1 mpaka A5: mawu akuti "amodzi," ndi nambala 2, 3, 1 ndi 4 monga momwe zikuwonetseratu zotsatizana ndi nkhaniyi.
  2. Dinani pa selo A6, komwe kuli malo omwe zotsatira zidzawonetsedwa.
  3. Lembani chizindikiro chofanana = kutsatiridwa ndi mawu "mawonekedwe ."
  4. Pamene mukuyimira, bokosi lopangira galimoto likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata M.
  5. Pamene mawu akuti "mawonekedwe" amapezeka pamwamba pa bokosi, pindikizani fungulo lolowamo lolowamo kuti mulowetse dzina la ntchito ndikutsegula mzere wozungulira ( mu selo A6.
  6. Onetsetsani maselo A1 ku A5 kuti awaphatikize ngati zifukwa za ntchito.
  7. Lembani mzere womaliza wazitsulo ) kuti mutsimikize mfundo za ntchitoyo.
  8. Lembani fungulo lolowamo lolowamo mu khibhodi kuti mukwaniritse ntchitoyo.
  9. Cholakwika cha # N / A chiyenera kuoneka mu selo A6 chifukwa nambala iliyonse mu maselo ambiri osankhidwa amawonekera kangapo.
  10. Dinani pa selo A1 ndipo lembani nambala 1 kuti mutengere mawu akuti "chimodzi."
  11. Dinani ku key lolowamo pa khibhodi
  12. 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.
  13. 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)

Chiwerengero cha nambala chingakhale nacho:

Mfundo