Ukwakha i-parabola eMicrosoft Excel

Ukwakha i-parabola kungenye yemisebenzi eyaziwayo yezibalo. Imvamisa, ayisetshenziselwa izinjongo zesayensi kuphela, kepha futhi nezisebenzayo. Ake sithole ukuthi ungayiqedela kanjani le nqubo usebenzisa i-Excel toolkit.

Ukwenza i-parabola

I-parabola igrafu yomsebenzi we-quadratic wohlobo olulandelayo f (x) = i-ax ^ 2 + bx + c. Enye yezimpawu zayo eziphawulekile iqiniso lokuthi i-parabola inesimo sesibalo esimile, esihlanganisa iqoqo lamaphuzu alinganayo avela ku-Directrix. Ngokuvamile, ukwakhiwa kwe-parabola kwimvelo ye-Excel akuhlukile kakhulu ekwakhiweni kwanoma yiluphi olunye uhlelo kulolu hlelo.

Ukudalwa kwetafula

Okokuqala, ngaphambi kokuthi uqale ukwakha i-parabola, kufanele wakhe itafula ngesisekelo elizokwakhiwa ngalo. Isibonelo, thatha igrafu yomsebenzi f (x) = 2x ^ 2 + 7.

1. Gcwalisa ithebula ngamanani x kusuka -10 ngaphambili 10 ekukhuphukeni 1. Lokhu kungenziwa ngesandla, kepha kulula ukusebenzisa amathuluzi wokuthuthuka ngalezi zinhloso. Ukuze wenze lokhu, kuseli lokuqala lekholamu "X" faka incazelo "-10". Ngemuva kwalokho, ngaphandle kokususa ukukhetha kule seli, iya kuthebhu "Ikhaya". Lapho, sichofoza inkinobho "Ukuqhubeka"elibekwe eqenjini "Ukuhlela". Uhlu olusetshenzisiwe, khetha isikhundla "Ukuqhubeka ...".



2. Iwindi lokulungiswa kokuqhubekela phambili lisebenza. Ebhlokini "Indawo" inkinobho yokuhambisa esimeni Ikholomu ngekholamuselokhu umugqa "X" ibekwe kwikholamu, yize kwezinye izimo, kungadinga ukusetha ukushintshela kuyo Umugqa ngomugqa. Ebhlokini "Thayipha" shiya inkinobho isesimweni "I-Arithmetic".

   Ensimini "Isinyathelo" faka inombolo "1". Ensimini "Umkhawulo wenani" khombisa inombolo "10"ngoba sibheka uhla x kusuka -10 ngaphambili 10 kuhlangene. Bese uchofoza inkinobho "Kulungile".



3. Ngemuva kwalesi senzo, ikholamu yonke "X" izogcwala imininingwane esiyidingayo, okungukuthi izinombolo ezisukela -10 ngaphambili 10 ekukhuphukeni 1.



4. Manje kufanele sigcwalise imininingwane yekholamu "f (x)". Lokhu, kususelwa ku-equation (f (x) = 2x ^ 2 + 7), sidinga ukufaka izinkulumo esitokisini esilandelayo esitokisini sokuqala sale kholamu:

   = 2 * x ^ 2 + 7

   Kuphela esikhundleni senani x faka ikheli lekheli lokuqala lekholamu "X"esisanda kugcwalisa. Ngakho-ke, kithi, le nkulumo izothatha isimo:

   = 2 * A2 ^ 2 + 7



5. Manje sidinga ukukopisha ifomula kulo lonke uhla olungaphansi lwale kholamu. Unikezwe izakhiwo eziyisisekelo ze-Excel, lapho ukopisha wonke amanani x izofakwa kumaseli ahambelana nekholomu "f (x)" ngokuzenzakalelayo. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingezansi kweseli, esivele liqukethe ifomula esilibhale ngaphambili. Isikhombisi kufanele siguqulwe sibe ngumaka wokugcwalisa obukeka njengesiphambano esincane. Ngemuva kokuthi ukuguqulwa sekwenzekile, bamba inkinobho yegundane kwesobunxele bese uhudula isikhombisi phansi ekugcineni kwetafula, bese ukhipha inkinobho.



6. Njengoba ukwazi ukubona, ngemuva kwalesi senzo, ikholamu "f (x)" ligcwaliswe futhi.

Kulokhu, ukwakheka kwetafula kungabhekwa njengokuphelele futhi kuya ngqo ekwakhiweni kwesheduli.

Isifundo: Ungayenza kanjani i-autocomplete ku-Excel

Ukuhlela

Njengoba kushiwo ngenhla, manje kufanele sakhe uhlelo uqobo.

1. Khetha itafula nesikhombisi ngenkathi ubamba phansi inkinobho yegundane kwesobunxele. Hambisa kuthebhu Faka. Eteyipini ebhlokini Amashadi chofoza inkinobho "Spot", ngoba lolu hlobo oluthile lwegrafu lufanele kakhulu ekwakheni i-parabola. Kepha akupheleli lapho. Ngemuva kokuchofoza inkinobho engenhla, uhlu lwezinhlobo zamashadi okusabalalisa luyavula. Khetha ishadi lokusakaza elinomaka.



2. Njengoba ubona, ngemuva kwalezi zenzo, kwakhiwa i-parabola.

Isifundo: Ungawenza kanjani umdwebo e-Excel

Ukuhlelwa kweshadi

Manje usungahlela ishadi eliphumela kancane.

1. Uma ungafuni ukuthi i-parabola iboniswe njengamaphoyinti, kepha ukuze ube nefomu elijwayeleke ngokwengeziwe lomugqa oqondile oxhumanisa la maphuzu, chofoza kwesokudla kunoma yiluphi kuwo. Imenyu yokuqukethwe iyavula. Kuyo udinga ukukhetha into "Shintsha uhlobo lweshadi lomugqa ...".



2. Ifasitela lokukhethwa kweshadi liyavula. Khetha igama "Spot ngamajika abushelelezi kanye nemaki". Ngemuva kokuthi ukwenziwa kwenziwe, chofoza inkinobho. "Kulungile".



3. Manje ishadi le-parabola linokubukeka okujwayelekile.

Ngaphezu kwalokho, ungenza ezinye izinhlobo zokuhlela kwe-parabola eholelwayo, kufaka phakathi ukuguqula amagama namagama e-axis. Lezi zinhlelo zokuhlela azihambi ngaphezu kwemingcele yezenzo zokusebenza e-Excel ngemidwebo yezinye izinhlobo.

Isifundo: Ungasayina kanjani ishadi le-axis ku-Excel

Njengoba ubona, ukwakha i-parabola e-Excel akufani nokwakha uhlobo oluhlukile lwegrafu noma ishadi ohlelweni olufanayo. Zonke izenzo zenziwa ngesisekelo setafula elakhelwe ngaphambili. Ngaphezu kwalokho, kufanele kubhekwe ukuthi umbono wephuzu lomdwebo ulungele kakhulu ekwakheni i-parabola.