Kunezimo lapho ufuna ukwazi imiphumela yokubala umsebenzi ngaphandle kwendawo eyaziwayo. Le nkinga ibaluleke ngokukhethekile ngenqubo yokubikezela. E-Eksele kunezindlela eziningana ezisiza ukuthi kwenzeke umsebenzi owenziwe. Ake sibabheke ngezibonelo ezithile.
Sebenzisa i-extrapolation
Ngokungafani nokubhaliwe, umsebenzi okuzowuthola ukubaluleka komsebenzi phakathi kwezimpikiswano ezimbili ezaziwayo, ukukhishwa kwe-extrapolation kuhilela ukuthola isisombululo ngaphandle kwesifunda esaziwayo. Yingakho le ndlela idume kakhulu ngokubikezela.
Esikhathini se-Excel, i-extrapolation ingasetshenziswa kokubili amanani wethebula namagrafu.
Indlela 1: i-extrapolation yedatha ye-tabular
Okokuqala, sisebenzisa indlela ye-extrapolation kokuqukethwe kwebanga letafula. Isibonelo, thatha itafula ngezimpikiswano eziningi. (X) kusuka 5 kuze kube 50 futhi uchungechunge lwamanani asebenzayo ahambisanayo (f (x)). Sidinga ukuthola inani lomsebenzi wempikiswano 55okungaphezulu kwe-data ecacisiwe. Ngale njongo, sisebenzisa lo msebenzi UKUPHILA.
- Khetha iseli lapho umphumela wezibalo ezenziwe kuzoboniswa. Chofoza kusithonjana "Faka umsebenzi"okuyinto itholakala kubha yefomula.
- Iwindi iqala Amakhosi omsebenzi. Yenza ushintsho esigabeni "Isitatimende" noma "Uhlu oluphelele lwe-alfabhethi". Kulolu hlu oluvula, sifuna igama. "UKUQALA". Ukuthola, ukhethe, bese uchofoza inkinobho. "Kulungile" phansi kwefasitela.
- Sithuthela ewindini lempikiswano yomsebenzi ongenhla. Inemibono emithathu kuphela kanye nenombolo ehambelana yamasimu ekusungulweni kwayo.
Ensimini "X" kufanele kubonise ukubaluleka kwempikiswano, umsebenzi okufanele sibale kuwo. Ungamane uhambise inombolo oyifunayo kusuka kukhibhodi, noma ungacacisa izixhumanisi zeseli uma ngabe ukuphikisana kubhaliwe kushidi. Ukhetho lwesibili lungcono nakakhulu. Uma senza idiphozi ngale ndlela, ukuze sibuke inani lenkonzo yenye ingxabano, ngeke kudingeke sishintshe ifomula, kodwa kuyokwanela ukushintsha okokufaka esitokisini esilandelayo. Ukuze ucacise izixhumanisi zale seli, uma ukhetho lwesibili lukhethiwe, kwanele ukubeka isikhombisi ensimini ehambelanayo bese ukhetha le seli. Ikheli lakhe liboniswa masinyane ewindini lezimangalo.
Ensimini "Izimpawu Zama-Y" kufanele ikhombise lonke uhla lwamanani omsebenzi esinalo. Kuboniswa kukholomu "f (x)". Ngakho-ke, setha isikhombisi ensimini ehambelanayo bese ukhetha yonke ikholomu ngaphandle kwegama layo.
Ensimini "Eyaziwa x" kufanele ikhombise zonke izindinganiso zempikiswano, ezihambisana namanani omsebenzi wethulwa kithi. Le datha ikukholomu "x". Ngendlela efanayo, njengasesikhathini esidlule, sikhetha ikholomu esiyidingayo ngokubeka kuqala isikhombisi emkhakheni wewindi lezingxoxo.
Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".
- Ngemva kwalezi zenzo, umphumela wokubala nge-extrapolation izoboniswa esitokisini okhethiwe esigabeni sokuqala sale myalelo ngaphambi kokusebenza. Amakhosi omsebenzi. Kulesi simo, ukubaluleka komsebenzi wempikiswano 55 kufana 338.
- Uma, noma kunjalo, ukhetho lukhethiwe ngokungeziwe kokubhekisela kweseli equkethe impikiswano edingekayo, ngakho-ke singayishintsha kalula futhi sibheke inani lomsebenzi kunoma iyiphi enye inombolo. Isibonelo, inani elidingekayo lempikiswano 85 izolingana 518.
Isifundo: I-Excel Function Wizard
Indlela 2: extrapolation yegrafu
Ungenza inqubo ye-extrapolation yegrafu ngokwakha umugqa wendabuko.
- Okokuqala, sakha isimiso ngokwayo. Ukuze wenze lokhu, sebenzisa isikhombisi ngenkathi ubambe inkinobho yegundane lesokunxele ukuze ukhethe yonke indawo yetafula, kufaka phakathi izingxabano kanye namanani okusebenza ahambelanayo. Bese, ukuthuthela kuthebhu "Faka", chofoza inkinobho "Hlela". Lesi sithonjana sisendaweni. "Amashadi" kuthebhu ye-tape. Uhlu lwezinketho zeshadi elikhona livela. Sikhetha ukufaneleka kakhulu kubo ngokuqonda kwethu.
- Ngemuva kokuthi igrafu isungulwe, susa umugqa wempikiswano eyengeziwe kusuka kuso, ukhethe futhi ucindezele inkinobho. Susa kwikhibhodi yekhompyutha.
- Okulandelayo, kudingeka sishintshe ukuhlukana okulinganiselwe kwesilinganiso, ngoba akubonisi amanani wezingxabano, njengoba sidinga. Ukwenza lokhu, chofoza ngakwesokudla emdwebeni nakulolu hlu olubonakala silumisa ngenani "Khetha idatha".
- Ewindini lokuqala lokukhetha umthombo wedatha, chofoza inkinobho "Shintsha" ebhodini lokuhlela isignesha ye-axis enezingqimba.
- Iwindi yokusetha isignesha i-axis ivuleka. Faka isikhombisi emkhakheni wale window, bese ukhetha yonke ikholomu yedatha "X" ngaphandle kwegama lakhe. Bese uchofoza inkinobho "Kulungile".
- Ngemva kokubuyela ewindini lokukhetha umthombo wedatha, siphinda inqubo efanayo, okungukuthi, chofoza inkinobho "Kulungile".
- Manje isimiso sethu sikulungele futhi ungakwazi, ngokuqondile, uqale ukwakha umugqa wendabuko. Chofoza eshadini, emva kwalokho isethi eyengeziwe yamathebhu ivuliwe ku-ribbon - "Ukusebenza ngamashadi". Hambisa kuthebhu "Ukuhlelwa" bese uchofoza inkinobho "Umugqa wethenda" ku-block "Ukuhlaziywa". Chofoza entweni "Ukulinganisa okulinganiselwe" noma "Ukulinganisa kwe-Exponential".
- Umzila wendabuko wengeziwe, kodwa ngokuphelele ngaphansi kwegrafu ngokwayo, ngoba asizange sibonise ukubaluleka kwempikiswano okufanele ibenze ngayo. Ukwenza lokhu futhi chofoza inkinobho "Umugqa wethenda"kodwa manje khetha into "Okukhethwa kukho Okukhethwa Kwamathrekhi Ethrekhi.
- Iwindi yefomethi yefomethi yokuqala iqala. Esigabeni "I-Trend Line Parameters" kukhona ibhokisi lezilungiselelo "Isibikezelo". Njengendlela yangaphambilini, ake sithathe ingxabano ye-extrapolation 55. Njengoba ubona, ngoba manje igrafu inebude kuze kube ngxabano 50 kubandakanya. Ngakho-ke, kuzodingeka sikwandise ngokuthi 5 amayunithi. E-axis enezingqimba kungabonakala ukuthi amayunithi angu-5 afana nokuhlukana okulodwa. Ngakho lena yisikhathi esisodwa. Ensimini "Dlulisela phambili" faka inani "1". Sicindezela inkinobho "Vala" ekhoneni elingaphansi kwesokudla lewindi.
- Njengoba ubona, igrafu yenezelwa ebude obucacisiwe besebenzisa umugqa wendabuko.
Isifundo: Indlela yokwakha umugqa wendabuko ku-Excel
Ngakho-ke, sibheke izibonelo ezilula ze-extrapolation yamatafula namagrafu. Esikhathini sokuqala, umsebenzi usetshenziselwa UKUPHILA, futhi okwesibili - umzila wesitayela. Kodwa ngesisekelo salezi zibonelo, kungenzeka ukuxazulula izinkinga eziningi ezibikezelayo ezibikezelayo.
