Enye yezinto ezibalulekile kwanoma yikuphi ukuhlaziya ukunqunywa komkhuba omkhulu wezehlakalo. Ukuba nale datha, ungenza isibikezelo sokuqhubeka kwesimo okuqhubekayo. Lokhu kubonakala ikakhulukazi esibonelweni somugqa wethenda eshadini. Ake sibheke ukuthi ingakhiwa kanjani kuMicrosoft Excel.
I-Excel Trendline
Uhlelo lokusebenza lwe-Excel luhlinzeka ngokwakha umugqa wethenda usebenzisa igrafu. Ngaphezu kwalokho, idatha yokuqala yokwakheka kwayo ithathwa etafuleni elilungiselelwe kwangaphambili.
Ukuhlela
Ukuze wakhe uhlelo, udinga ukuba netafula elenziwe ngomumo, ngokwesisekelo elizokwakhiwa ngalo. Njengesibonelo, sithatha idatha ngenani ledola kumarubhu isikhathi esithile.
- Sakha itafula lapho kuzobekwa khona izinkathi zesikhathi esisodwa kwikholamu (esimeni sethu, izinsuku), kwesinye - inani elizovezwa amandla alo kwigrafu.
- Khetha leli thebula. Iya kuthebhu Faka. Kukhona iribhoni kubhokisi lamathuluzi Amashadi chofoza inkinobho Ishadi. Ukusuka ohlwini olwethuliwe, khetha inketho yokuqala.
- Ngemuva kwalokho, uhlelo luzokwakhiwa, kepha lusadinga ukuqedwa. Senza isihloko eshadini. Ukuze wenze lokhu, chofoza kukho. Eqenjini elivelile lamathebhu "Ukusebenza namashadi" iya kuthebhu "Isakhiwo". Kuyo sichofoza inkinobho Ishadi Igama. Kuluhlu oluvulayo, khetha "Ngaphezulu kweshadi".
- Ensimini evela ngenhla kweshadi, faka igama esilibona lifanelekile.
- Ngemuva kwalokho sisayina i-axis. Kuthebhu efanayo "Isakhiwo" chofoza inkinobho kubambo Amagama we-Axis. Sihamba ngamaphuzu "Igama le-axis eyinhloko evundlile" futhi "Igama ngaphansi kwe-eksisi".
- Ensimini evelayo, faka igama le-eksizi elivundlile, ngokuya ngomongo wedatha etholakala kuyo.
- Ukuze unikeze igama le-eksisi emile sisebenzisa futhi ithebhu "Isakhiwo". Chofoza inkinobho Igama le-Axis. Hambisa ngokulandelana kwezinto zemenyu ezivelelayo "Igama le-eksisi esemile mpo" futhi Isihloko Esijikeleziwe. Yilolu hlobo lokuhlelwa kwegama le-eksisi elizolungela kakhulu uhlobo lwethu lwemidwebo.
- Emkhakheni wegama le-eksisi emile evelayo, faka igama olifunayo.
Isifundo: Ungayenza kanjani ishadi ku-Excel
Ukwakha umugqa wethremu
Manje udinga ukwengeza ngokuqondile umugqa wesitayela.
- Ukuba kuthebhu "Isakhiwo" chofoza inkinobho Umugqa Wendlelaetholakala kwibhulokhi yamathuluzi "Ukuhlaziywa". Ukusuka ohlwini oluvulayo, khetha "Ukucacisa okucacisiwe" noma "Ukuqagela kwe-Linear".
- Ngemuva kwalokho, umugqa wethenda ungezwa eshadini. Ngokuzenzakalelayo, kumnyama.
Ukubeka umugqa wethremu
Kukhona ithuba lezilungiselelo ezingeziwe zomugqa.
- Iya kuthebhu "Isakhiwo" ezintweni zemenyu "Ukuhlaziywa", Umugqa Wendlela futhi "Imingcele eyengeziwe yomugqa wokuhambisa ...".
- Iwindi lemingcele liyavuleka, kungenziwa izilungiselelo ezahlukahlukene. Isibonelo, ungashintsha uhlobo lokubusheleleza kanye nokukhetha ngokukhetha eyodwa yezinto eziyisithupha:
- I-Polynomial;
- Ulayini;
- Amandla;
- I-Logarithmic
- I-Exponential;
- Ukuhlunga komugqa.
Ukuze unqume ukuthembeka kwemodeli yethu, hlola ibhokisi eliseduze "Beka inani lokuqiniseka lokulinganisa kumdwebo". Ukuze ubone umphumela, chofoza inkinobho Vala.
Uma le nkomba ingu-1, khona-ke imodeli ithembekile ngangokunokwenzeka. Ibanga elikude lisuka kwelinye, eliphansi lithembekile.
Uma ungagculisekile ngezinga lokuzethemba, ungaphindela ngamapharamitha futhi ushintshe uhlobo lokubusheleleka nokulingana. Ngemuva kwaloko, kwakha lokulingene futhi.
Ukubikezela
Umsebenzi oyinhloko womugqa wethremu yikhono lokwenza isibikezelo sezinto ezenzeka kuso.
- Futhi, iya ngamapharamitha. Ebhuthini yezilungiselelo "Isimo sezulu" Ezindimeni ezifanele zibonisa ukuthi zingaki izikhathi eziya phambili noma emuva emuva okudingeka uqhubeke ngazo umugqa wethenda wokubikezela. Chofoza inkinobho Vala.
- Abuye siqhubekele ohlelweni futhi. Kuyakhombisa ukuthi ulayini uphezulu. Manje singasetshenziswa ukuthola ukuthi yisiphi isikhombi esilinganiselwayo esibikezelwayo ngosuku oluthile ngenkathi sigcina isimo samanje.
Njengoba ukwazi ukubona, ku-Excel akunzima ukwakha umugqa wethremu. Uhlelo luhlinzeka ngamathuluzi ukuze alungiselelwe ukubonisa izinkomba ngendlela efanele ngangokunokwenzeka. Ngokusekelwe kugrafu, ungenza isibikezelo sesikhathi esithile.
