Kanjani ukwakha i-parabola ku-Excel

Ukwakhiwa kwe-parabola kungenye yemisebenzi eyaziwayo yezibalo. Imvamisa akusebenzi kuphela ngezinhloso zesayensi, kodwa futhi nasekusebenzeni. Ake sibheke ukuthi ukwenza kanjani le nqubo usebenzisa ithuluzi lesicelo se-Excel.

Ukudalwa kweParabola

I-Parabola iyigrafu yomsebenzi we-quadratic wohlobo oluzayo F (x) = AX ^ 2 + BX + C . Enye yezakhiwo eziphawuleka yiqiniso ukuthi i-parabola inendlela yokulinganisa okuqukethe iqoqo lamaphoyinti alingana nomqondisi. Ngobukhulu, ukwakhiwa kwe-parabola endaweni ye-Excel akufani nokwakha noma iyiphi enye igrafu kulolu hlelo.

Ukudala itafula

Okokuqala, ngaphambi kokuqhubeka nokwakha i-parabola, kufanele wakhe itafula ngesisekelo sokuthi kuzokwakhiwa ngalo. Isibonelo, thatha igrafu yokusebenza komsebenzi f (x) = 2x ^ 2 + 7.

1. Gcwalisa itafula ngamanani we-X ukusuka ku-10 kuye ku-10 ngesinyathelo 1. Lokhu kungenziwa ngesandla, kepha kulula lezi zinhloso ukusebenzisa izinsimbi zokuqhubekela phambili. Ukuze wenze lokhu, esitokisini sokuqala sekholomu "x" Sifaka inani "-10". Ngemuva kwalokho, ngaphandle kokukhipha ukukhethwa kuleli ngqaya, iya kuthebhu ethi "Home". Sichofoza inkinobho ethi "Qotha", okuthunyelwe eqenjini lokuhlela. Uhlu olusebenze, khetha isikhundla "Ukuqhubekela phambili ...".



2. Ukwenza kusebenze kwewindows sokulungiswa kokuthuthukiswa kwenziwa kusebenze. Evikini "lendawo", inkinobho kufanele ihlelwe kabusha esikhundleni "kumakholomu", ngoba uchungechunge oluthi "X" lubekwe kwikholamu, yize lusezingeni eliphezulu kungadingeka ukusetha ukushintshela ku-"emigqeni" isikhundla. Evikini le- "hlobo", shiya inkinobho esesimweni se-arithmetic.

   Ensimini "yesinyathelo", sifaka inombolo "1". Ensimini ethi "Inani Lomkhawulo", khombisa inombolo "10", njengoba sibheka ububanzi be-X ukusuka ku-10 kuya ku-10 kufakiwe. Bese uchofoza inkinobho ethi "KULUNGILE".



3. Ngemuva kwalesi senzo, lonke ikholomu "x" lizogcwaliswa ngemininingwane esiyidingayo, okungukuthi, izinombolo ezisezingeni ukusuka ku--10 kuye ku-10 ezikhuphukeni ze-1.



4. Manje kuzofanela sigcwalise ikholomu "F (x)". Ukuze wenze lokhu, kususelwa ku-equation (f (x) = 2x ^ 2 + 7 + 7), sidinga ukufaka inkulumo kumodeli elandelayo yale kholout:

   = 2 * x ^ 2 + 7

   Kuphela esikhundleni senani le-X sifaka ikheli leseli lokuqala lekholomu "X", esisanda kugcwalisa. Ngakho-ke, esimweni sethu, inkulumo izothatha lelo fomu:

   = 2 * A2 ^ 2 + 7



5. Manje sidinga ukukopisha ifomula nalo lonke uhla oluphansi lwale kholamu. Njengoba kunikezwe izakhiwo eziyisisekelo ze-Excel, lapho ukopisha wonke amanani we-X kuzothunyelwa kumaseli wekholamu ahambisanayo "F (x)" ngokuzenzakalelayo. Ukuze senze lokhu, sibeka isikhombisi ekhoneni elingezansi kwesokudla seseli, lapho ifomula isivele ibekwe khona, yaqoshwa ngathi phambilini. Isikhombisi kufanele siguqulwe sibe uphawu lokugcwalisa, ukubukeka kwesiphambano esincane. Ngemuva kokuthi ukuguqulwa kwenzeka, bopha inkinobho yegundane kwesobunxele bese udonsa isikhombisi phansi kuze kube sekupheleni kwetafula, bese uyeka inkinobho.



6. Njengoba ubona, ngemuva kwalesi senzo, ikholomu "F (x)" nayo izogcwaliswa.

Kulobumba, itafula lingabhekwa njengeligcwalisiwe futhi lithuthele ngqo ekwakhiweni kwesheduli.

Isifundo: Kanjani ukwenza i-autocomplete ekudingisweni

Ihluzo zokwakha

Njengoba sekushiwo ngenhla, manje kufanele sakhe uhlelo.

1. Khetha itafula nesikhombisi ngokubamba inkinobho yegundane kwesobunxele. Hambisa kuthebhu ethi "Faka". Ethepheni ku- "Block Chart" chofoza inkinobho ethi "Spot", ngoba lolu hlobo lwegrafu olufanele kakhulu ukwakhiwa kwe-parabola. Kepha akupheleli lokho. Ngemuva kokuchofoza inkinobho engenhla, kuvulwa uhlu lwamaphuzu wamaphuzu wephuzu. Khetha umdwebo wephuzu nabamaka.



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

Isifundo: Ungayenza kanjani ishadi lokudingiswa

Ukuhlela Ishadi

Manje usungahlela uhlelo oluholelwayo.

1. Uma ungafuni ukuthi uParabola uboniswe ngendlela yamaphoyinti, futhi kunombono ojwayelekile we-Line Curve, exhuma lawa maphuzu, chofoza kunoma yimuphi omunye wabo ngokuchofoza kwesokudla. Imenyu yomongo iyavula. Kuyo udinga ukukhetha into ethi "shintsha uhlobo lomdwebo ukuze uthole umugqa ...".



2. Iwindi lokukhetha iwindi livuleka. Khetha igama elithi "indawo enama-curves abushelelezi kanye namamaki." Ngemuva kokukhethwa kwenziwa, chofoza inkinobho ethi "Kulungile".



3. Manje ishadi leParabola linokubukeka okujwayelekile.

Ngaphezu kwalokho, ungenza ezinye izinhlobo zokuhlela i-parabola etholakele, kufaka phakathi ushintsho egameni layo namagama ezimbazo. Lamamukeli wokuhlela awadluleli ngaphesheya kwemikhawulo yesenzo ukuze asebenze ku-Excel ngemidwebo yezinye izinhlobo zezilwane.

Isifundo: Ungasayina kanjani i-axis yeshadi ku-Excel

Njengoba ukwazi ukubona, ukwakha i-parabola ku-Excel akufani ngokuyisisekelo ekwakheni olunye uhlobo lwegrafu noma ishadi kuhlelo olufanayo. Zonke izenzo zenziwa ngokususelwa etafuleni elinqunyelwe kusengaphambili. Ngaphezu kwalokho, kuyadingeka ukubheka ukuthi uhlobo lwephuzu eshadi lulungele kakhulu ukwakha i-parabola.