Wannan misalin zai koya muku yadda ake ƙara layin da ake yi zuwa ginshiƙi na Excel.
- Dama danna kan jerin bayanai kuma a cikin mahallin menu danna Ƙara layi mai tasowa (Ƙara Trendline).
- Danna shafin Zaɓuɓɓukan Trendline (Trend/Regression Type) kuma zaɓi Linear (Linear).
- Ƙayyade adadin lokuta don haɗawa a cikin hasashen - shigar da lambar "3" a cikin filin Gaba zuwa (Gaba).
- Duba zaɓuɓɓukan Nuna ma'auni akan ginshiƙi (Nuna Equation akan ginshiƙi) и Saka ma'anar ƙimar amincewar kusantar (Nuna ƙimar R-squared akan ginshiƙi).
- latsa Close (Kusa).
Sakamako:
Ƙarin bayani:
- Excel yana amfani da mafi ƙarancin hanyar murabba'i don nemo layin da ya fi dacewa da tudu.
- Ƙimar R-squared ita ce 0,9295 wanda ke da kyau sosai. Makusancinsa zuwa 1, mafi kyawun layin ya dace da bayanan.
- Layin Trend yana ba da ra'ayi na jagorancin da tallace-tallace ke tafiya. A lokacin lokaci 13 tallace-tallace na iya kaiwa 120 (wannan hasashe ne). Ana iya tabbatar da wannan ta amfani da ma'auni mai zuwa:
y = 7,7515*13 + 18,267 = 119,0365