Tusaalahani wuxuu ku bari doonaa sida loogu daro khadadka isbeddelka shaxda Excel.
- Midig ku dhufo taxanaha xogta iyo gudaha macnaha guud guji Ku dar khadka isbeddelka (Ku dar Trendline).
- Guji tab Ikhtiyaarada Trendline (Trend/Regression Type) oo dooro toosan (Linear).
- Sheeg tirada xilliyada lagu daro saadaasha - geli lambarka "3" ee goobta U sii gudbi (Hore).
- Sax doorarka Muuji isla'egta shaxda (Muujinta isla'egta shaxda) и Ku dheji jaantuska qiimaha kalsoonida qiyaasta (Muuji qiimaha R-squared ee shaxanka).
- Press Close (Xirran).
Natiijo:
Sharaxaada:
- Excel waxay isticmaashaa habka ugu yar ee afar geesoodka ah si loo helo xariiqda ku habboon meelaha sare.
- Qiimaha R-squared waa 0,9295 taas oo ah qiimo aad u wanaagsan. Marka ay u dhowdahay 1, ayaa si fiican u xariiqda ku habboon xogta.
- Khadka isbeddelku wuxuu bixiyaa fikradda jihada uu iibku ku socdo. Inta lagu jiro muddada 13 iibku wuu gaadhi karaa 120 (tani waa saadaal). Tan waxaa lagu xaqiijin karaa iyadoo la isticmaalayo isla'egta soo socota:
y = 7,7515*13 + 18,267 = 119,0365