Uma ubheka ishadi elisanda kwakhiwa ku-Excel, akulula ngaso sonke isikhathi ukuqonda ngokushesha ukuthambekela kwedatha. Amanye amashadi enziwe izinkulungwane zamaphoyinti edatha. Kwesinye isikhathi ungasho ngeso ukuthi idatha ishintsha ngakuphi ngokuhamba kwesikhathi, ngezinye izikhathi uzodinga ukusebenzisa amathuluzi e-Excel ukuze uthole ukuthi kwenzekani. Lokhu kungenziwa kusetshenziswa umugqa wethrendi kanye nomugqa omaphakathi onyakazayo. Ngokuvamile, ukuze kunqunywe ukuthi idatha ithuthukela ngakuphi, umugqa wethrendi usetshenziswa eshadini. Ukuze ubale ngokuzenzakalelayo umugqa onjalo futhi uwungeze eshadini le-Excel, udinga ukuthatha izinyathelo ezilandelayo:
- Ku-Excel 2013, chofoza noma yikuphi eshadini bese uchofoza isithonjana sophawu more (+) eduze komdwebo ukuze uvule imenyu Izakhi zeshadi (Izici zeshadi). Enye inketho: chofoza inkinobho Engeza isici Seshadi (Engeza Izinto Zeshadi), elitholakala esigabeni Izakhiwo zeshadi (Izakhiwo Zeshadi) ithebhu umakhi (Umklamo).
- Bheka ibhokisi Umugqa wethrendi (I-Trendline).
- Ukuze usethe uhlobo lomugqa wethrendi, chofoza umcibisholo okhomba kwesokudla bese ukhetha enye yezinketho (umugqa, umchazi, isibikezelo somugqa, isilinganiso esinyakazayo, njll.).
Okuvame ukusetshenziswa kakhulu ithrendi yomugqa evamile kanye nomugqa omaphakathi onyakazayo. Ithrendi yomugqa - lena umugqa oqondile otholakala ngendlela yokuthi ibanga ukusuka kuwo kuya kunoma yimaphi amaphuzu kugrafu lincane. Lo mugqa uwusizo uma kunokuthenjwa ukuthi idatha elandelayo izolandela iphethini efanayo.
Iwusizo kakhulu umugqa omaphakathi ohambayo ngamaphuzu amaningana. Ulayini onjalo, ngokungafani nethrendi yomugqa, ubonisa ithrendi emaphakathi enani elinikeziwe lamaphoyinti eshadini, elingashintshwa. Umugqa omaphakathi onyakazayo usetshenziswa uma ifomula ehlinzeka ngedatha yokuhlela ishintsha ngokuhamba kwesikhathi futhi ithrendi idinga ukuhlelwa ngaphezu kwamaphoyinti ambalwa wangaphambilini. Ukudweba umugqa onjalo, landela izinyathelo 1 no-2 ukusuka phezulu, bese wenza lokhu:
- Chofoza umcibisholo wesokudla kumugqa Umugqa wethrendi (I-Trendline) bese ukhetha inketho isilinganiso esihambayo (Isilinganiso esihambayo).
- Yenza izinyathelo 1 no-2 kusukela esibonelweni sangaphambilini futhi bese ucindezela Izinketho eziningi (Okunye ongakhetha kukho).
- Kuphaneli evuliwe Ifomethi yomugqa wethrendi (Fometha i-Trendline) qiniseka ukuthi ibhokisi likaqhwishi lithikhiwe Ukuhlunga komugqa (Isilinganiso sokuhambisa).
- Kwesokudla sepharamitha Ukuhlunga komugqa (Moving Average) yinkambu amaphuzu (Isikhathi). Lokhu kusetha inombolo yamaphoyinti azosetshenziswa ukubala amanani amaphakathi ukuze kuhlelwe umugqa wethrendi. Setha inani lamaphuzu, okuzothi, ngokombono wakho, libe lilungile. Isibonelo, uma ucabanga ukuthi ukuthambekela okuthile kudatha kuhlala kungashintshile kuphela kumaphoyinti okugcina angu-4, bese ufaka inombolo engu-4 kulo mkhakha.
Imigqa yethrendi ku-Excel iyindlela enhle yokuthola ulwazi olwengeziwe mayelana nedathasethi onayo nokuthi ishintsha kanjani ngokuhamba kwesikhathi. Ithrendi ewumugqa kanye nesilinganiso esinyakazayo yizinhlobo ezimbili zemigqa ethrendayo evame kakhulu futhi ewusizo ebhizinisini.