Iko kukwanisa kuita mafungidziro, kufanotaura (zvinenge zvingangoita!) Chiitiko chenguva yemberi chezviitiko chikamu chakakosha uye chakakosha zvikuru chebhizinesi chero ripi zvaro remazuva ano. Zvechokwadi, iyi isayenzi yakasiyana, yakaoma zvikuru ine boka remitoo uye nzira, asi kazhinji maitiro akareruka anokwana kuongororwa kwezuva nezuva kwemamiriro ezvinhu. Chimwe chazvo ibasa ZVINOFANIRA (FORECIST), iyo inogona kuverenga fungidziro pane mutsara maitiro.
Nheyo yekushanda kweiyi basa iri nyore: isu tinofungidzira kuti yekutanga data inogona kupindirana (yakatsetseka) neimwe mutsara wakatwasuka neiyo classical linear equation y=kx+b:
Nekugadzira iyi mutsara wakatwasuka uye nekuipfuudza kurudyi kupfuura iyo inozivikanwa nguva yakatarwa, tinowana iyo inodiwa kufanotaura.
Kuvaka iyi mutsara wakatwasuka, Excel inoshandisa inozivikanwa diki square method. Muchidimbu, kukosha kweiyi nzira ndeyokuti kutsetseka uye chinzvimbo chemutsetse wemaitiro anosarudzwa kuitira kuti huwandu hwekutsauka kwakapetwa kweiyo sosi data kubva kune yakagadzirwa maitiro mutsetse ishoma, kureva kuti mutsara wemaitiro wakakwenenzvera data chairo mu. nzira yakanakisa.
Excel inoita kuti zvive nyore kuvaka mutsara wemaitiro pachati nekudzvanya-kurudyi pamutsetse - Wedzera Trendline (Wedzera Trendline), asi kazhinji pakuverenga hatidi mutsetse, asi nhamba dzehuwandu hwekufanotaura. zvinoenderana nazvo. Pano, chete, ivo vanoverengerwa nebasa ZVINOFANIRA (FORECIST).
Basa re syntax rakaita seinotevera
=PREDICTION(X; Zvinozivikanwa_tsika_Y; Zvinozivikanwa_X tsika)
apo
- Х - iyo nguva yenguva yatinoita fungidziro
- Zvinozivikanwa_tsika_Y - inozivikanwa kwatiri kukosha kweiyo inotsamira shanduko (purofiti)
- Zvinozivikanwa_X tsika - kukosha kweiyo yakazvimiririra shanduko inozivikanwa kwatiri (mazuva kana nhamba dzenguva)
- Kugadzirisa mabhizinesi emhando neSolver yekuwedzera-mukati
- Kusarudzwa kwematemu kuti uwane mari yaunoda