Mohlala ona o tla u ruta mokhoa oa ho kenyelletsa mohala oa feshene ho chate ea Excel.
- Tobetsa ka ho le letona lethathamong la data ebe u tobetsa ho menyu ea litaba Eketsa mokhoa oa mokhoa (Eketsa Trendline).
- Tobetsa tab ya Likhetho tsa Trendline (Mofuta oa Tloaelo / Regression) ebe u khetha Linear (Mohala).
- Hlalosa palo ea linako tse lokelang ho kenyelletsa bolepi - kenya nomoro "3" tšimong Fetisetsa pele ho (Tsapele).
- Tšoaea likhetho Hlahisa equation chate (Bontša Equation chate) и Beha setšoantšong boleng ba kholiseho ea ho atamela (Bontša boleng ba R-squared chate).
- Press Close (Koala).
sephetho:
tlhaloso:
- Excel e sebelisa mokhoa o fokolang oa lisekoere ho fumana mohala o lekanang hantle le libaka tse phahameng.
- Theko ea R-squared ke 0,9295 e leng boleng bo botle haholo. Ha e le haufi le 1, mohala o lumellana hantle le data.
- Mohala oa mokhoa o fana ka mohopolo oa hore na thekiso e ea kae. Nakong ea nako 13 thekiso e ka fihla 120 (ena ke ponelopele). Sena se ka netefatsoa ho sebelisoa equation e latelang:
y = 7,7515*13 + 18,267 = 119,0365