Extrapolation ku-Excel

Kunamacala lapho kudingeka ukwazi imiphumela yokubala ukusebenza ngaphandle kwendawo eyaziwayo. Le ndaba ihambelana ikakhulukazi nenqubo yokubikezela. Kunezindlela eziningana zokuba nezindlela eziningi zokusebenza okungenziwa ngazo. Ake sibabuke ezibonelweni ezithile.

Kusetshenziswa i-extrapolation

Ngokungafani nokuhunyushwa, umsebenzi wawuwumsebenzi wawusemsebenzini phakathi kwezimpikiswano ezimbili ezaziwayo, ukukhishwa kwemvelo kusho ukusesha izixazululo ngaphandle kwendawo eyaziwayo. Kungakho le ndlela ifuneka ukubikezela.

I-Excel ingasebenzisa i-extrapolation, zombili amanani ethebula namagrafu.

Indlela 1: Ukukhishwa kwedatha ye-tabular

Okokuqala, indlela yokungezelela kokuqukethwe uhla lwetafula kuyasebenza. Isibonelo, thatha itafula lapho kunenqwaba yezimpikiswano (X) kusuka ku-5 kuye ku-50 kanye namanani amaningi ahambisanayo (F (X)). Sidinga ukuthola inani lomsebenzi wengxabano 55, elisemuva komkhawulo we-array yedatha ebekiwe. Ngalezi zinhloso, sebenzisa umsebenzi obikezelwe.

1. Khetha iseli lapho umphumela wezibalo owenziwe kuzovezwa. Chofoza isithonjana se- "Insert Funct", esithunyelwa entanjeni yefomula.



2. Iwindows Wizard Wisard iqala. Sifeza inguquko esigabeni "sezibalo" noma "uhlu olugcwele lwezinhlamvu". Uhlu oluvula, sikhiqiza ukusesha igama elithi "Predecz". Njengoba usuthole, wabelela, bese uqhafaza inkinobho ethi "Kulungile" ezansi kwewindi.



3. Sithuthela efasiteleni lezimpikiswano zomsebenzi ongenhla. Inezimpikiswano ezintathu kuphela kanye nenani elihambisanayo lezinkambu zokwethula kwabo.

   In the "X" field, chaza inani lengxabano, umsebenzi okufanele siwabala. Ungavele ushayele inombolo oyifunayo kusuka kukhibhodi, futhi ungacacisa izixhumanisi zeseli uma ingxabano iqoshwe ephepheni. Inketho yesibili iyathandeka. Uma senza isingeniso ngale ndlela, ukuze sibheke inani lomsebenzi kwenye impikiswano, akudingeki ukuthi sishintshe ifomula, kodwa sizokwanele ukushintsha isingeniso esitokisini esihambisanayo. Ukuze ucacise izixhumanisi zalesi seli, uma ngabe usakhethelwa inketho yesibili, kwanele ukufaka isikhombisi enkombeni efanelekile bese ukhetha leli ngqa. Ikheli lakhe lizovela ngokushesha efasiteleni lengxabano.

   Ensimini "eyaziwayo ye-R", kufanele ucacise lonke uhla lwemisebenzi. Kuboniswa kukholamu "F (x)". Ngakho-ke, sibeka isikhombisi emkhakheni ofanele futhi sabela yonke ikholomu ngaphandle kwegama laso.

   Ensimini "eyaziwayo X", kufanele uchaze wonke amanani wengxabano yokuthi umsebenzi wokusebenza uhambelana nalokhu okungenhla. Le mininingwane ikukholomu "X". Ngendlela efanayo njengasesikhathini esedlule, sabela ikholamu oyidingayo, ngemuva kokubeka isikhombisi efasiteleni lewindi lengxabano.

   Ngemuva kwayo yonke imininingwane yenziwe, chofoza inkinobho ethi "Kulungile".



4. Ngemuva kwalezi zenzo, umphumela wokubala ngokukhishwa kuzovezwa esitokisini, esaqokonyiswa esigabeni sokuqala salo myalelo ngaphambi kokuqala iwizadi yemisebenzi. Kulokhu, umsebenzi wengxabano 55 uneminyaka engama-338.



5. Uma ngemuva kwayo yonke inketho kukhethwe ngokufakwa kwesixhumanisi esiya esitokisini, esiqukethe impikiswano oyifunayo, khona-ke singakushintsha kalula bese sibuka inani lomsebenzi nganoma iyiphi enye inombolo. Isibonelo, inani elifunekayo lengxabano 85 lizoba ngu-518.

Isifundo: Imisebenzi yeWizard ku-Excel

Indlela 2: Ukukhishwa kwesheduli

Yenza inqubo yokungenisa i-igrafu ngokwakha umugqa wethrendi.

1. Okokuqala, sakha uhlelo ngokwakho. Kulokhu, isikhombisi esinenkinobho yegundane kwesobunxele siqokonyiswa yindawo yonke yetafula, kufaka phakathi izimpikiswano kanye namanani womsebenzi ahambisanayo. Ngemuva kwalokho, ungene kuthebhu ethi "Insert", chofoza inkinobho ethi "Sheduli". Lesi sithonjana sitholakala ebhuthini "eshadini" kwiribhoni yetheyipu. Uhlu lwamasheduli atholakalayo luyavela. Sikhetha okufanele kakhulu ngokubona kwabo.



2. Ngemuva kokuthi isheduli yakhelwe, susa umugqa wokuphikisana owengeziwe kulo, uqokomise bese ucindezela inkinobho yokususa kwikhibhodi yekhompyutha.



3. Okulandelayo, kudingeka siguqule ukwahlukana kwesilinganiso esivundlile, ngoba sibonisa hhayi amanani ezimpikiswano, njengoba sidinga. Ukuze wenze lokhu, chofoza inkinobho yegundane efanelekile emjovo naloluhlu oluvelayo, umisa kumanani athi "Khetha idatha".



4. Efasiteleni lokuqala lewindi lokukhetha umthombo wedatha, chofoza inkinobho ethi "Hlela" esigxotsheni sokuhlela esiqondisayo.



5. Iwindi lokufaka le-Axis Signature livula. Sibeka isikhombisi emkhakheni waleli windi, bese ukhetha yonke imininingwane yekholomu ye- "X" ngaphandle kwegama layo. Bese uchofoza inkinobho ethi "KULUNGILE".



6. Ngemuva kokubuyela ewindini lokukhetha umthombo wedatha, siphinda inqubo efanayo, okungukuthi, sichofoza inkinobho ethi "Kulungile".



7. Manje uhlelo lwethu lulungiselelwe futhi lungaqhubeka ngqo nokwakhiwa komugqa wethrendi. Chofoza ku-schedule, ngemuva kwalokho amathebhu angeziwe we-Tabs asebenza ethekeni - "Sebenza namashadi". Sithuthela kuthebhu "Izakhiwo" bese uchofoza inkinobho ethi "Trend Line" kubhlokhi "yokuhlaziya". Chofoza ku- "Linear applimation" noma "ukuzungeza okusondele".



8. Kunezelwa umugqa wethrendi, kepha ungaphansi komugqa wegrafu uqobo, ngoba asikhombisi inani lengxabano okufanele lilwele kulo. Ukuze wenze lokhu bese ulandelana ngokulandelana kwenkinobho ethi "Trend Line", kepha manje khetha "Into Ethuthukile Yokulahla Ipharamitha".



9. Iwindi lefomethi yeTrend Line seliqaliwe. Esigabeni se- "Trend Line izilungiselelo" Kukhona i-Presecast "Block Block. Njengasendleleni edlule, ake sithathe impikiswano 55 ngokungenisa imali. Njengoba ukwazi ukubona, manje igrafu inobude ekuphikisana nokufaka phakathi kwe-RVOPTEP. Kuyavela, sizodinga ukuwelula amanye amayunithi ayi-5. E-axis evundlile kungabonakala ukuthi amayunithi ama-5 alingana nesigaba esisodwa. Ngakho-ke lesi sikhathi esisodwa. Ensimini "phambili" endle "faka inani" 1 ". Chofoza inkinobho ethi "Vala" ekhoneni elingezansi kwesokudla sewindi.



10. Njengoba sikwazi ukubona, uhlelo lwanwetshwa ngobude obucacisiwe besebenzisa umugqa wethrele.

Isifundo: Ungawakha kanjani umugqa wethrekhi ku-Excel

Ngakho-ke, sabuyekeza izibonelo ezilula kakhulu zokukhishwa kwamatafula namagrafu. Esimweni sokuqala, umsebenzi obikezelwe usetshenziswa, kanti owesibili - umugqa wethrendi. Kepha ngesisekelo salezi zibonelo, imisebenzi enzima kakhulu yokubikezela ingaxazululwa.