Ƙarfin yin hasashe, tsinkaya (aƙalla kusan!) Yanayin gaba na abubuwan da suka faru na gaba shine mahimmanci da mahimmanci na kowane kasuwanci na zamani. Tabbas, wannan kimiyya ce dabam, mai sarƙaƙƙiya tare da gungun hanyoyi da hanyoyi, amma sau da yawa dabaru masu sauƙi sun isa don tantance yanayin yau da kullun. Ɗayan su shine aikin FASADI (HAUSA), wanda zai iya ƙididdige hasashe akan yanayin layi.
Ka'idar aiki na wannan aikin abu ne mai sauƙi: muna ɗauka cewa bayanan farko za a iya shiga tsakani (smoothed) ta wani madaidaiciyar layi tare da ma'auni na al'ada y = kx + b:
Ta hanyar gina wannan madaidaiciyar layi da kuma shimfiɗa shi zuwa dama fiye da lokacin da aka sani, muna samun hasashen da ake so.
Don gina wannan madaidaiciyar layi, Excel yana amfani da sanannun mafi ƙarancin murabba'in hanya. A takaice dai, jigon wannan hanyar ita ce, an zaɓi gangara da matsayi na layin Trend ta yadda jimillar ɓangarorin murabba'i na bayanan tushe daga layin da aka gina ba ya da yawa, watau Trend line ya smoothed ainihin bayanai a cikin hanya mafi kyau.
Excel yana sauƙaƙa don gina layin layi daidai akan ginshiƙi ta danna-dama akan jeri - Ƙara Trendline (Ƙara Trendline), amma sau da yawa don ƙididdiga ba mu buƙatar layi, amma ƙimar lambobi na tsinkaya. wanda yayi daidai da shi. Anan, kawai, ana ƙididdige su ta hanyar aikin FASADI (HAUSA).
Tsarin aikin shine kamar haka
= TSAKANIN (X; Sanin_darajar_Y; Sanann ƙimar_X)
inda
- Х - batu a lokacin da muke yin hasashen
- Sanin_darajar_Y - sananne a gare mu dabi'u na dogara m (riba)
- Sanann ƙimar_X - ƙimar madaidaicin mai zaman kanta da aka sani a gare mu (kwanaki ko lambobi na lokuta)
- Haɓaka samfuran kasuwanci tare da ƙarawar mai warwarewa
- Zaɓin sharuɗɗan don samun adadin da ake so