Ikhono lokwenza izibikezelo, ukubikezela (okungenani cishe!) Inkambo yezenzakalo zesikhathi esizayo iyingxenye ebalulekile futhi ebaluleke kakhulu yanoma yiliphi ibhizinisi lanamuhla. Yiqiniso, lena isayensi ehlukile, eyinkimbinkimbi kakhulu enenqwaba yezindlela nezindlela, kodwa ngokuvamile amasu alula anele ukuhlolwa kwansuku zonke kwesimo. Omunye wabo umsebenzi ISIBIKEZELO (ISIBEKELO), engabala isibikezelo kuthrendi yomugqa.
Umgomo wokusebenza kwalo msebenzi ulula: sicabanga ukuthi idatha yokuqala ingahunyushwa (ishelelezi) ngomugqa othile oqondile ngesibalo sakudala somugqa y=kx+b:
Ngokwakha lo mugqa oqondile futhi siwunwebe kwesokudla ngale kwebanga lesikhathi elaziwayo, sithola isibikezelo esifiswayo.
Ukwakha lo mugqa oqondile, i-Excel isebenzisa owaziwa kakhulu indlela encane eyisikwele. Ngamafuphi, ingqikithi yale ndlela iwukuthi ukuthambekela kanye nendawo yomugqa wethrendi kukhethwa ukuze isamba sokuchezuka okuyisikwele sedatha yomthombo kusuka kumugqa wethrendi owakhiwe sibe sincane, okungukuthi umugqa wethrendi wenze lula idatha yangempela indlela engcono kakhulu.
I-Excel yenza kube lula ukwakha umugqa wethrendi khona kanye eshadini ngokuchofoza kwesokudla kumugqa - Engeza i-Trendline (Engeza i-Trendline), kodwa ngokuvamile esibalweni asiwudingi umugqa, kodwa amanani ezinombolo esibikezelo ezihambisana nayo. Lapha, nje, zibalwa ngomsebenzi ISIBIKEZELO (ISIBEKELO).
I-syntax yomsebenzi imi kanje
=PREDICTION(X; Amanani_aziwayo_Y; Amanani aziwayo_X)
lapho
- Х – iphuzu ngesikhathi esenza ngalo isibikezelo
- Amanani_aziwayo_Y - eyaziwa kithi amanani okuhluka okuncikile (inzuzo)
- Amanani aziwayo_X - amanani okuguquguquka okuzimele esikwaziyo (izinsuku noma izinombolo zezikhathi)
- Ukuthuthukisa amamodeli ebhizinisi ngesengezo seSolver
- Ukukhethwa kwemigomo yokuthola inani elifunekayo