Momwe Mungawonjezere Trendline ku Excel Chart

Chitsanzochi chidzakuphunzitsani momwe mungawonjezerere mzere wotsatira pa tchati cha Excel.

1. Dinani kumanja pamndandanda wa data ndikudina pazosankha Onjezani mzere wamayendedwe (Onjezani Trendline).
2. Dinani tabu Zosankha za Trendline (Trend/Regression Type) ndikusankha Linear (Linear).
3. Tchulani chiwerengero cha nthawi kuti muphatikizepo muzowonetseratu - lowetsani nambala "3" m'munda Pitani ku (Patsogolo).
4. Chongani zosankha Onetsani equation pa tchati (Kuwonetsa Equation pa tchati) ndi Ikani pa chithunzi mtengo wa kuyandikira kwa chidaliro (Sonyezani mtengo wa R-squared pa tchati).
5. Press Close (Tsekani).

Zotsatira:

Kufotokozera:

• Excel imagwiritsa ntchito njira ya masikweya ochepa kwambiri kuti ipeze mzere womwe umagwirizana bwino ndi malo okwera.
• Mtengo wa R-squared ndi 0,9295 womwe ndi mtengo wabwino kwambiri. Kuyandikira kwa 1, ndiye kuti mzerewo umagwirizana bwino ndi deta.
• Mzere wamayendedwe umapereka lingaliro la komwe malonda akupita. Panthawiyi 13 malonda angafikire 120 (uku ndi kulosera). Izi zitha kutsimikiziridwa pogwiritsa ntchito equation iyi:

  y = 7,7515*13 + 18,267 = 119,0365