Ungayisebenzisa kanjani i-Excel yezibalo

Isibuyekezo sokugcina: I-17 March ka-2026
Author: I-TecnoDigital
  • I-Excel iyithuluzi elidumile lokucubungula nokuhlaziya idatha, elinezici eziningi ezakhelwe ngaphakathi namathuluzi ezibalo eziyisisekelo kanye nokubona ngeso lengqondo.
  • Imisebenzi evamile: I-AVERAGE, MEDIAN, STDEV, COUNTIF, SUMIF, CORREL kanye neminye ekuvumela ukuthi ubale izilinganiso, ukubalwa kanye nobudlelwano phakathi kweziguquguquko.
  • Amashadi ahlukahlukene (ibha, umugqa, iphayi, i-scatter, i-histogram) kanye ne-add-ins kuvumela ukuhlaziywa okuthuthukisiwe; noma kunjalo, i-Excel ayithathi indawo yesofthiwe yezibalo ekhethekile.
I-Excel yezibalo

Kulesi sihloko sizochaza ukuthi i-Excel isetshenziswa kanjani ku-Statistics, ngenxa yenani elikhulu lemisebenzi eyakhelwe ngaphakathi kanye neqoqo layo elibanzi lokuklanywa kwezithombe.

I-Excel iyithuluzi elidumile kakhulu elisetshenziselwa ukucubungula nokuhlaziya idatha. Nakuba ingeyona isofthiwe yezibalo ngqo, i-Excel inemisebenzi eminingi namathuluzi angasetshenziswa ukwenza ukuhlaziywa kwezibalo.

Ukusetshenziswa okujwayelekile kwe-Excel

Okunye okuvamile ukusetshenziswa kwe-Excel kwezibalo ukuhlela nokuhlanza idatha. I-Excel ivumela umsebenzisi ukuthi akhe amatafula futhi asebenzise imisebenzi efana “nokuhlunga” kanye “nokuhlunga” ukuze ahlele idatha kahle.

I-Excel futhi inemisebenzi eyisisekelo yezibalo okufanele ibale: ama-avareji, i-median, ukuchezuka okujwayelekile, njll. Le misebenzi ingasetshenziswa ukubala izibalo eziyisisekelo kudatha.

Ukwengeza, i-Excel inohlu olubanzi lweshadi namathuluzi ethebula, angasetshenziswa ukubona idatha ngeso lengqondo nokwenza kube lula ukuyiqonda. Lawa mathuluzi ahlanganisa ulayini, ibha, amashadi ophayi, njll.

Ukuze wenze ukuhlaziywa kwezibalo okuthuthukisiwe kakhulu ku-Excel, ungasebenzisa izengezo ezifana nesengezo sezibalo se-Excel noma isengezo se -Excel Data Analysis . Lezi zengezo zengeza imisebenzi eyengeziwe yezibalo ohlelweni, njengekhono lokwenza ukuhlaziywa kokuhlehla kanye nokuhlaziywa kokwehluka.

  Indlela yokuguqula ithebhulethi yakho ibe yi-monitor futhi uthole okuningi kuyo

Imisebenzi evame kakhulu ye-Excel yezibalo

Ku-Excel, ungasebenzisa amafomula ukuthuthukisa izinkulumo zezibalo ezenziwe ngokwezifiso noma usebenzise imisebenzi eyakhelwe ngaphakathi. Ngezansi uhlu lweminye yemisebenzi ye-Excel evame kakhulu esetshenziselwa ukuhlaziya izibalo, kanye nencazelo emfushane yokusetshenziswa kwayo:

  • I-AVERAGE: Ibala isilinganiso sochungechunge lwezinombolo.
  • UMEDIYA: Ibuyisela inani elimaphakathi lochungechunge lwezinombolo.
  • IMFASHINI: Ibuyisela inani elivame ukwenzeka ochungechungeni lwezinombolo.
  • I-STDEV: Ibala ukuchezuka okujwayelekile kochungechunge lwezinombolo.
  • COUNT YEBO: Ibala inani lamaseli ahlangabezana nesimo esithile ebangeni ledatha.
  • I-SUM.IF: Ihlanganisa amaseli ahlangabezana nesimo esithile ebangeni ledatha.
  • MAX: Ibuyisela inani eliphezulu lochungechunge lwezinombolo.
  • -MIN: Ibuyisela inani eliphansi lochungechunge lwezinombolo.
  • MAX.IF: Ibuyisela inani eliphezulu ochungechungeni lwezinombolo ezihlangabezana nombandela othile ebangeni ledatha.
  • MIN.YEBO: Ibuyisela inani eliyisisekelo ochungechungeni lwezinombolo ezihlangabezana nombandela othile kububanzi bedatha.
  • PERCENTAGE: Iguqula inani libe iphesenti.
  • BREAK: Ibuyisela ububanzi bochungechunge lwezinombolo.
  • I-COUNT: Ibala inani lamaseli angenalutho kububanzi bedatha.
  • I-SUMA: Ihlanganisa amanani ebangeni ledatha.
  • COUNTIF: Ibala inani lamaseli ahlangabezana nesimo esithile ebangeni ledatha.
  • I-SUMIF: Ihlanganisa amaseli ahlangabezana nesimo esithile ebangeni ledatha.
  • I-CORREL: Ibuyisela i-coefficient yokuhlobanisa yamasethi edatha amabili.
  • UKUBUYEKA: Ibuyisela imiphumela yokuhlehla komugqa.
  • ANOVA: Yenza ukuhlaziya okuhlukile.
  • I-CHI-SQUARE: Yenza ukuhlolwa kwe-chi-square.
  • KURT: Ibuyisela i-kurtosis yochungechunge lwezinombolo.
  • SKEW: Ibuyisela i-symmetry yochungechunge lwezinombolo.
  • PERCENTILE.EXC: Ibuyisela iphesenti yochungechunge lwezinombolo.
  • I-QUARTILE.EXC: Ibuyisela i-quartile yochungechunge lwezinombolo.
  Abaphathi Befayela Abahle Kakhulu beLinux: Umhlahlandlela Ophelele

Izinhlobo zamashadi ku-Excel Yezibalo

Kulesi sihloko, sihlose ukuchaza indlela yokusebenzisa i-Excel yezibalo, sichaza eminye yemisebenzi eyakhelwe ngaphakathi yesofthiwe.

I-Excel inikeza izinhlobo ezahlukene zeshadi ezingasetshenziswa ukumela nokuhlaziya idatha yezibalo. Ezinye zezinhlobo ezivame kakhulu zamagrafu ku-Excel ngezibalo yilezi:

  • Igrafu yebha: Ibonisa ukuqhathanisa phakathi kwamanani ezigabeni ezahlukene. Ingasetshenziselwa ukukhombisa ukuqhathanisa phakathi kwamaqembu ahlukene noma ukukhombisa izinguquko ngokuhamba kwesikhathi.
  • Igrafu yomugqa: Ibonisa izinguquko ochungechungeni lwedatha eyodwa ngokuhamba kwesikhathi. Ingasetshenziselwa ukukhombisa amathrendi noma amaphethini kudatha.
  • Ishadi likaphayi: Ibonisa ingxenye yezigaba ezihlukene kusethi yedatha. Ingasetshenziselwa ukukhombisa ukuthi idatha isatshalaliswa kanjani ezigabeni ezahlukahlukene.
  • Isakhiwo sokuhlakaza: Ibonisa ubudlelwano phakathi kwamasethi amabili edatha. Ingasetshenziswa ukukhombisa ubudlelwano phakathi kweziguquko ezimbili.
  • Ishadi Lekholomu Ye-3D: Ibonisa ukuqhathanisa phakathi kwamanani ezigabeni ezihlukene kusetshenziswa amakholomu endaweni enezinhlangothi ezintathu. Ingasetshenziselwa ukukhombisa ukuqhathanisa phakathi kwamaqembu ahlukene noma ukukhombisa izinguquko ngokuhamba kwesikhathi.
  • Ishadi le-Gantt: Ibonisa ukuqhubeka kwephrojekthi kumugqa wesikhathi. Ingasetshenziswa ukukhombisa ukuqhubeka kwephrojekthi noma ukuhlela amaphrojekthi.
  • Ishadi leradar: Ibonisa ubudlelwano phakathi kwamasethi edatha amaningi kuma-eksisi amaningi. Ingasetshenziswa ukukhombisa ubudlelwano phakathi kokuguquguquka okuningana.
  • ishadi lebhamuza: Ibonisa ubudlelwano phakathi kwamasethi amathathu edatha. Ingasetshenziswa ukukhombisa ubudlelwano phakathi kweziguquko ezintathu.
  • Ishadi le-Pareto: Isetshenziselwa ukukhombisa ukusatshalaliswa kwe-a okuguquguqukayo maqondana nomunye.
  • I-Histogram: Isetshenziselwa ukumela ukusatshalaliswa kwesethi yedatha. Ibonisa imvamisa amanani ahlukene avela ngayo kusethi yedatha.
  Umhlahlandlela ophelele wezinqamuleli zokuthayipha ze-HyperOS namaqhinga

Ngamafuphi, i-Excel yezibalo iyithuluzi eliwusizo kakhulu lokucubungula nokuhlaziya idatha yezibalo futhi ingasetshenziswa emisebenzini esukela kweyisisekelo kakhulu kuya kwethuthuke kakhulu. Kodwa-ke, kubalulekile ukukhumbula ukuthi i-Excel akuyona isofthiwe yezibalo ezinikele futhi ingaba nemikhawulo uma iqhathaniswa nesofthiwe eyenzelwe ngqo izibalo zebhizinisi.

Sishicilele ingxenye yesibili yalesi sihloko.