Enye yezingxenye ezibalulekile kwanoma yikuphi ukuhlaziywa ukucacisa umkhuba omkhulu wemicimbi. Ukuba nale datha, ungenza isibikezelo sokuthuthukiswa okuqhubekayo kwalesi simo. Lokhu kubonakala ngokukhethekile esibonelweni somugqa wendabuko eshadini. Ake sithole ukuthi singayakha kanjani ku-Microsoft Excel.
I-Trendline ku-Excel
Uhlelo lokusebenza lwe-Excel lunikeza ikhono ukwakha umugqa wendabuko usebenzisa igrafu. Ngesikhathi esifanayo, idatha yokuqala yokubunjwa kwayo ithathwe kuthebula elilungiselelwe ngaphambilini.
I-Plotting
Ukuze wakhe igrafu, udinga ukuba netafula elungile, ngesisekelo lapho kuzokwakhiwa khona. Isibonelo, thatha idatha ngokubaluleka kwedola ngo-ruble isikhathi esithile.
- Sakha itafula, lapho kukho ikholomu eyodwa kuyoba khona isikhathi (esimweni sethu, izinsuku), nakolunye - inani, ukuguqulwa kwalo okuzoboniswa kugrafu.
- Khetha letafula. Iya kuthebhu "Faka". Kule tape ku-block of amathuluzi "Amashadi" chofoza inkinobho "Hlela". Kusukela ohlwini olunikeziwe, khetha inketho yokuqala.
- Emva kwalokhu, isimiso sizokwakhiwa, kodwa sidinga ukuthuthukiswa. Yenza isihloko seshadi. Ukwenza lokhu, chofoza kuso. Kuqoqo lethebhu elivela "Ukusebenza ngamashadi" iya kuthebhu "Ukuhlelwa". Kulo, sithinta inkinobho. "Igama leshadi". Kulolu hlu oluvula, khetha into "Ngaphezulu kweshadi".
- Emkhakheni ovela ngenhla igrafu, faka igama esicabanga ukuthi kufanelekile.
- Bese sibhalisa izinkomba. Kuthebhu efanayo "Ukuhlelwa" chofoza inkinobho ebhethini "Ama-Axis amagama". Ngokulandelana kwethu siya phezu kwamaphoyinti "Igama le-axis eyinhloko" futhi "Isihloko ngaphansi kwe-axis".
- Emkhakheni ovelayo, faka igama le-axis enezingqimba, ngokusho komongo wedatha etholakala kuwo.
- Ukuze sinikeze igama le-axis eqondile sisebenzisa futhi ithebhu "Ukuhlelwa". Chofoza inkinobho "Igama le-Axis". I-sequentially uhamba ngezinyathelo zemenyu e-popup. "Igama le-axis eyinhloko" futhi "Yaguqulwe isihloko". Lolu hlobo lokubeka igama le-axis luzoba lula kakhulu ngohlobo lwethu lwemidwebo.
- Emkhakheni wegama le-axis elibonakalayo elivela, faka igama elifunayo.
Isifundo: Indlela yokwenza igrafu ku-Excel
Ukwakha umugqa wendabuko
Manje udinga ukufaka ngokuqondile umugqa wesitayela.
- Ukuba ngaphakathi kuthebhu "Ukuhlelwa" chofoza inkinobho "Umugqa wethenda"esitholakala kwibhulogi yamathuluzi "Ukuhlaziywa". Kusukela ohlwini oluvula, khetha into "Ukulinganisa kwe-Exponential" noma "Ukulinganisa okulinganiselwe".
- Emva kwalokho, umugqa wendabuko uyengezwa eshadini. Ngokuzenzakalelayo, kumnyama.
Ukusethwa komugqa wethenda
Kukhona amathuba okwenza izilungiselelo zedivayisi engeziwe.
- Phinda uhambe ngokuphumelelayo kuthebhu "Ukuhlelwa" kwimenyu yemenyu "Ukuhlaziywa", "Umugqa wethenda" futhi "Izinketho ezithuthukisiwe ze-Trend Line ...".
- Iwindi yemingcele ivula, ungenza izilungiselelo ezihlukahlukene. Isibonelo, ungashintsha uhlobo lokushelela nokulinganisa ngokukhetha elinye lamaphuzu ayisithupha:
- I-polynomial;
- Linear;
- Amandla;
- I-Logarithmic;
- I-Exponential;
- Ukuhlunga komugqa.
Ukuze unqume ukuthembeka kwesimodeli sethu, usethe uphawu eduze kwento "Beka eshadini ukubaluleka kokunemba kwesilinganiso". Ukuze ubone umphumela, chofoza inkinobho. "Vala".
Uma lesi sibonakaliso singu-1, imodeli inokwethenjelwa ngangokunokwenzeka. Ngaphezulu kwezinga kusuka eyunithi, ukwethemba kancane.
Uma ungenelisekile ngezinga lokuzethemba, ungabuyela emuva kwimingcele bese ushintsha uhlobo lokushelela nokulinganisa. Bese, faka i-coefficient futhi.
Ukubikezela
Umsebenzi oyinhloko wesitayela semikhuba yikhono lokwenza isibikezelo sokuthuthukiswa okuqhubekayo.
- Futhi, iya kwimingcele. Ebhokisini lesethingi "Isibikezelo" emasimini afanelekile, sibonisa ukuthi zingaki izinkathi eziseduze noma ezingemuva ezidingekayo ukuze siqhubeke nomzila wesimo sokubikezela. Sicindezela inkinobho "Vala".
- Futhi, iya esimisweni. Kubonisa ukuthi umugqa uhlukaniswe. Manje ingasetshenziselwa ukunquma ukuthi isiphi isibonisi esilinganiselwayo esabikezelwe usuku oluthile ngenkathi sigcina isimo samanje.
Njengoba ubona, ku-Excel akulona nzima ukwakha umugqa wendabuko. Lolu hlelo luhlinzeka ngamathuluzi ukuze alungiselelwe ukubonisa izinkomba ngokunembile ngangokunokwenzeka. Ngokusekelwe esimisweni, ungenza isibikezelo isikhathi esithile.
