Uyu muenzaniso unokudzidzisa maitiro ekuwedzera mutsara wemaitiro kune Excel chati.
- Kurudyi tinya pane data nhevedzano uye mune yemukati menyu tinya Wedzera mutsara wemaitiro (Wedzera Trendline).
- Dzvanya iyo tab Trendline Options (Trend/Regression Type) uye sarudza linearly (Linear).
- Rondedzera huwandu hwenguva dzinosanganisira mukufanotaura - isa nhamba "3" mumunda Pamberi ku (Pamberi).
- Tarisa pane zvingasarudzwa Ratidza equation pachati (Ratidza Equation pane chati) и Isa padhiyagiramu kukosha kwekuvimba kwekufungidzira (Ratidza R-squared value pane chati).
- dzvanya pedyo (Vhara).
Mhinduro:
Tsanangudzo:
- Excel inoshandisa idiki masikweya nzira yekutsvaga mutsara unonyatsoenderana neakakwirira.
- Iyo R-squared value ndeye 0,9295 inova yakanaka kwazvo kukosha. Iyo iri padyo ne1, zviri nani mutsara unokodzera iyo data.
- Mutsara wemutsetse unopa pfungwa yenzira iyo kutengesa kuri kuenda. Munguva iyi 13 kutengesa kunogona kusvika 120 (uku kufanotaura). Izvi zvinogona kusimbiswa uchishandisa inotevera equation:
y = 7,7515*13 + 18,267 = 119,0365