Lesi sibonelo sizokufundisa ukuthi ungangeza kanjani umugqa wethrendi eshadini le-Excel.
- Chofoza kwesokudla ochungechungeni lwedatha bese uchofoza kumenyu yokuqukethwe Engeza umugqa wethrendi (Engeza i-Trendline).
- Chofoza ithebhu Izinketho zomugqa wethrendi (I-Trend/Regression Type) bese ukhetha Linear (Liyini).
- Cacisa inani lezikhathi ezizofakwa esibikezelweni - faka inombolo "3" ensimini Dlulisela ku (Phambili).
- Thikha izinketho Bonisa isibalo eshadini (Khombisa i-Equation eshadini) и Faka kumdwebo inani lokuqiniseka okulinganiselwe (Bonisa inani eliphindwe kabili lika-R eshadini).
- Cindezela Close (Vala).
Umphumela:
Incazelo:
- I-Excel isebenzisa indlela yezikwele ezincane kakhulu ukuze ithole umugqa ofaneleka kakhulu ukuphakama.
- Ivelu eyisikwele esingu-R ngu-0,9295 okuyinani elihle kakhulu. Lapho isondela ku-1, umugqa ulingana kangcono nedatha.
- Umugqa wethrendi unikeza umbono wendlela okuthengiswa ngayo. Phakathi nenkathi 13 ukuthengisa kungase kufinyelele 120 (lesi isibikezelo). Lokhu kungaqinisekiswa kusetshenziswa isibalo esilandelayo:
y = 7,7515*13 + 18,267 = 119,0365