Na kēia hiʻohiʻona e aʻo iā ʻoe pehea e hoʻohui ai i kahi laina au i kahi pakuhi Excel.
- Kaomi ʻākau ma ka moʻo ʻikepili a kaomi ma ka papa kuhikuhi Hoʻohui i ka laina au (Hoʻohui Trendline).
- Kaomi i ka pā Nā Koho Trendline (Trend/Regression Type) a koho Ke laina (Linear).
- E wehewehe i ka helu o nā manawa e hoʻokomo i ka wānana - e hoʻokomo i ka helu "3" ma ke kahua Imua i (Imua).
- E koho i nā koho Hōʻike i ka hoohalike ma ka pakuhi (Hōʻike Equation ma ka pakuhi) и E kau ma ke kiʻikuhi i ka waiwai o ka hilinaʻi pili (E hōʻike i ka waiwai R-squared ma ka pakuhi).
- Press kokoke (Piki).
Hualoaʻa:
Hōʻike:
- Hoʻohana ʻo Excel i ke ala liʻiliʻi loa e ʻike i ka laina kūpono i nā kiʻekiʻe.
- ʻO ka waiwai R-squared he 0,9295 kahi waiwai maikaʻi loa. ʻO ka pili kokoke i ka 1, ʻoi aku ka maikaʻi o ka laina i kūpono i ka ʻikepili.
- Hāʻawi ka laina laina i kahi manaʻo o ke ala e hele ai nā kūʻai. I loko o ka manawa 13 hiki ke kuai 120 (he wānana kēia). Hiki ke hōʻoia ʻia kēia me ka hoʻohana ʻana i ka hoohalike penei:
y = 7,7515*13 + 18,267 = 119,0365