Momwe mungawonjezere mzere wamayendedwe kapena mzere wosuntha wapakati pa tchati mu Excel

Kuyang'ana tchati chomwe changopangidwa kumene mu Excel, sikophweka nthawi zonse kumvetsetsa momwe deta ikuyendera. Ma chart ena amapangidwa ndi masauzande a mfundo za data. Nthawi zina mutha kudziwa ndi maso komwe deta ikusintha pakapita nthawi, nthawi zina mungafunike kugwiritsa ntchito zida za Excel kuti muwone zomwe zikuchitika. Izi zitha kuchitika pogwiritsa ntchito mzere wamayendedwe komanso mzere wosuntha wapakati. Nthawi zambiri, kuti mudziwe komwe deta ikupita, mzere wazomwe zimagwiritsidwa ntchito pa tchati. Kuti muwerengere mzere woterewu ndikuwuwonjezera pa tchati cha Excel, muyenera kuchita izi:

1. Mu Excel 2013, dinani kulikonse pa tchati ndikudina chizindikiro cha chizindikiro more (+) pafupi ndi chithunzi kuti mutsegule menyu Ma chart a zinthu (Zinthu zama chart). Njira ina: dinani batani Onjezani Chart Element (Add Chart Elements), yomwe ili mgawoli Masanjidwe a ma chart (Mapangidwe a Tchati) tabu Constructor (Kupanga).
2. Chongani bokosi Mzere wamayendedwe (Trendline).
3. Kuti muyike mtundu wa mayendedwe, dinani muvi womwe ukulozera kumanja ndikusankha chimodzi mwazosankha (mzere, tsatanetsatane, zolosera zam'mbali, kuchuluka kwakuyenda, ndi zina).

Zomwe zimagwiritsidwa ntchito kwambiri ndi mzere wanthawi zonse komanso mzere wosuntha. Linear trend - uwu ndi mzere wowongoka womwe uli m'njira yoti mtunda kuchokera ku izo kupita ku mfundo iliyonse pa graph ndi yochepa. Mzerewu ndi wothandiza ngati pali chidaliro kuti deta yotsatira idzatsatira ndondomeko yomweyo.

Zothandiza kwambiri kusuntha mzere wapakati pa mfundo zingapo. Mzere woterewu, mosiyana ndi mzere wa mzere, umasonyeza chiwerengero cha chiwerengero cha mfundo zomwe zili pa tchati, zomwe zingasinthidwe. Mzere wapakati wosuntha umagwiritsidwa ntchito pamene chilinganizo chopereka deta yokonzera chiwembu chimasintha pakapita nthawi ndipo zomwe zikuchitika zikuyenera kusinthidwa pa mfundo zingapo zam'mbuyomo. Kuti mujambule mzere wotere, tsatirani masitepe 1 ndi 2 kuchokera pamwamba, kenako chitani izi:

1. Dinani muvi wakumanja pamzerewu Mzere wamayendedwe (Trendline) ndikusankha njira chiwerengero chosuntha (Kusuntha kwapakati).
2. Chitani masitepe 1 ndi 2 kuchokera ku chitsanzo chapitachi kachiwiri ndikusindikiza Zosankha zina (Zosankha zina).
3. Mu gulu lotsegulidwa Mtundu wa Trendline (Format Trendline) onetsetsani kuti bokosi loyang'anira lafufuzidwa Zosefera liniya (Moving Average).
4. Kumanja kwa parameter Zosefera liniya (Moving Average) ndi munda mfundo (Nthawi). Izi zimakhazikitsa kuchuluka kwa mfundo zomwe zingagwiritsidwe ntchito kuwerengera mitengo yapakati kuti ikonzekere mzere wamayendedwe. Khazikitsani chiwerengero cha mfundo, zomwe, m'malingaliro anu, zidzakhala zabwino kwambiri. Mwachitsanzo, ngati mukuganiza kuti chikhalidwe china mu deta sichinasinthidwe pa mfundo 4 zomaliza, ndiye lowetsani nambala 4 m'munda uno.

Trendline mu Excel ndi njira yabwino yodziwira zambiri za dataset yomwe muli nayo komanso momwe imasinthira pakapita nthawi. Linear trend and move average ndi mitundu iwiri ya mizere yomwe imakhala yofala kwambiri komanso yothandiza pabizinesi.