Extrapolation muri Excel

Hariho ibibazo mugihe bisabwa kumenya ibisubizo byo kubara imikorere hanze yuburyo buzwi. Iki kibazo gifite akamaro cyane cyane kubikorwa byubuteganijwe. Hariho inzira nyinshi zo kugira inzira nyinshi niki gikorwa gishobora gukorwa. Reka tubarebe ku ngero zihariye.

Ukoresheje extleolation

Bitandukanye na interpolation, umurimo wacyo nikikorwa cyimikorere hagati yimpaka ebyiri zizwi, extration bisobanura gushakisha ibisubizo hanze yuburyo buzwi. Niyo mpamvu ubu buryo bukenewe cyane.

Excel irashobora gukoresha extleolation, haba kumurika indangagaciro nibishushanyo.

Uburyo 1: Extrapolation kumakuru ya pular

Mbere ya byose, uburyo bworoshye muburyo bwibiri mumeza birakurikizwa. Kurugero, fata imbonerahamwe aho hari impaka zitari nke (x) kuva kuri 5 kugeza kuri 50 na numero nyinshi zihuye (f (x)). Tugomba kubona agaciro k'imikorere y'impaka 55, iri inyuma yimipaka ya Data wanditse. Kuri izo ntego, koresha imikorere yahanuwe.

1. Hitamo akagari aho ibisubizo byirabu byakozwe bizerekanwa. Kanda kuri "Shyiramo imikorere", yashyizwe kumurongo wa formula.



2. Ikirangantego Wizard Idirishya ritangira. Turakora inzibacyuho kugeza kuri icyiciro "ibarurishamibare" cyangwa "Urutonde rwuzuye". Kurutonde rufungura, tubyara gushakisha izina "fedenz". Umaze kuyibona, kugenera, hanyuma ukande kuri buto "OK" hepfo yidirishya.



3. Twimukira mu idirishya ryibikorwa byavuzwe haruguru. Ifite impaka eshatu gusa nimibare ijyanye nintangiriro yintangiriro.

   Muri "X", kwerekana agaciro k'impaka, imikorere tugomba kubara. Urashobora gutwara gusa numero wifuza kuri clavier, kandi urashobora kwerekana imirongo ya selile niba impaka zanditswe kurupapuro. Ihitamo rya kabiri riracyafite akamaro. Niba dukora intangiriro muri ubu buryo, kugirango turebe agaciro k'imikorere indi mpaka, ntitugomba guhindura formula, ariko bizaba bihagije kugirango uhindure intangiriro mu kaga kajyanye. Kugirango ugaragaze guhuza iyi selile, niba bimaze guhitamo inzira ya kabiri, birahagije gushiraho indanga kumurima ukwiye hanyuma uhitemo iyi selile. Aderesi ye izahita igaragara mu idirishya ryimpaka.

   Muri "indangagaciro zizwi", ugomba kwerekana imikorere yose yimikorere. Yerekanwa mu nkingi "f (x)". Kubwibyo, twashizeho indanga kumurima ukwiye kandi tugatanga inkingi yose idafite izina ryayo.

   Muri "indangagaciro zizwi X", ugomba kwerekana indangagaciro zose zimpaka zivuga ko imikorere yimikorere ihuye haruguru. Aya makuru ari muri "X". Muri ubwo buryo bumwe nkuko bimeze, tugenera inkingi ukeneye, nyuma yo gushiraho indanga mumadirishya yidirishya.

   Nyuma yamakuru yose akorwa, kanda kuri buto "OK".



4. Nyuma yibi bikorwa, kubara biva mu mahanga bizerekanwa mu Kagari, byagaragaye mu gika cya mbere cya aya mabwiriza mbere yo gutangira umupfumu w'imikorere. Muri uru rubanza, imikorere yimpaka 55 ni 338.



5. Niba nyuma yamahitamo yose yatoranijwe hamwe ninyongera kumurongo, urimo impaka zifuzwa, noneho dushobora kuyihindura byoroshye tukareba akazi kandi mibare. Kurugero, agaciro kashukiwe kubwimpaka 85 zizaba 518.

Isomo: Umukozi wa Wizard muri Excel

Uburyo 2: Extcolation kuri gahunda

Kora uburyo bwo kwanga igishushanyo mukubaka umurongo.

1. Mbere ya byose, twubaka ingengu wenyine. Kubwibi, indanga hamwe na buto yimbeba yibumoso igaragara n'ahantu hose h'imbonerahamwe, harimo impaka n'indangagaciro zijyanye. Noneho, kwimukira muri tab "shyiramo", kanda buto "Gahunda". Iki gishushanyo kiherereye muri "imbonerahamwe" kuri kaseti ya kaseti. Urutonde rwibikorwa bihari biragaragara. Duhitamo ibyiza cyane kubushake bwabo.



2. Nyuma ya gahunda yubatswe, ikureho umurongo winyongera kuriyo, kubigaragaza hanyuma ukande buto yo gusiba kuri clavier ya mudasobwa.



3. Ibikurikira, dukeneye guhindura amacakubiri yurugero rutambitse, kuko rugaragaza indangagaciro zimpaka, nkuko dukeneye. Kugirango ukore ibi, kanda kuri buto yimbeba iburyo kuri diagram no kurutonde rugaragara, uhagarara kuri indangagaciro "Hitamo amakuru".



4. Mugihe cyo gutangira idirishya ryamakuru yo gutoranya amakuru, kanda kuri buto "Guhindura" muburyo butambitse bwo guhinduranya umurongo wa montantal.



5. Idirishya rya Axis Umukono wo Kwinjiza. Dushyira indanga mu murima w'iyi idirishya, hanyuma duhitemo amakuru yose ya "X" idafite izina ryayo. Hanyuma ukande kuri buto "OK".



6. Nyuma yo gusubira mumadirishya yo gutoranya amakuru, dusubiramo inzira imwe, ni ukuvuga, tukanda kuri buto "OK".



7. Noneho gahunda yacu irateguwe kandi irashobora gukomeza mubyubaka kumurongo. Kanda kuri gahunda, nyuma yinyongera ya tabs ikora kuri kaseti - "Kora hamwe nimbonerahamwe". Twimukiye muri tab "imiterere" hanyuma tukande kuri buto "umurongo wa Trend" mumodoka "Isesengura". Kanda kuri "umurongo ugereranya" cyangwa "kwerekana exponetion".



8. Umurongo wimpande wongeyeho, ariko rwose munsi yumurongo wibishushanyo ubwabyo, kubera ko tutagaragaje agaciro k'impaka igomba guharanira. Kugirango ukore ibi bikurikiranye kanda ahanditse "umurongo wumurongo", ariko noneho hitamo "Iterambere ryumurongo".



9. Idirishya ryumurongo widirishya riratangira. Muri "Igenamiterere ry'umurongo" Harahari "iteganyagihe" igenamiterere. Nko mu buryo bwabanje, reka dufate ingingo 55 kuri extrapolation. Nkuko mubibona, ni kuri ubu igishushanyo gifite uburebure bwo gutongana 50 urimo. Biragaragara, tuzakenera kubigeza kubindi bice 5. Kuri horizontal ya horizontal irashobora kuboneka ko ibice 5 bingana n'igabana rimwe. Iki gihe kimwe rero. Muri "imbere kuri", andika agaciro "1". Kanda kuri buto "gufunga" mugice cyo hepfo iburyo bwidirishya.



10. Nkuko tubibona, gahunda yageze muburebure bwagenwe ukoresheje umurongo.

Isomo: Uburyo bwo kubaka umurongo muri excel

Rero, twasuzumye ingero zoroshye zo kuvuka kumeza nibishushanyo. Mu rubanza rwa mbere, imikorere yahanuwe ikoreshwa, kandi mu isegonda - umurongo. Ariko hashingiwe kuri izi ngero, imirimo iteganya cyane irashobora gukemurwa.