Nigute wubaka parabola muri excel

Kubaka parabola nimwe mubikorwa bizwi byimibare. Kenshi na kenshi ntabwo bireba intego za siyansi gusa, ahubwo no muri siyanse ifatika. Reka tumenye uburyo bwo gukora ubu buryo dukoresheje ibikoresho bya Excel.

Kurema Parabola

Parabola ni igishushanyo cyibikorwa bya quadratic yubwoko butaha f (x) = ax ^ 2 + bx + c . Imwe mu mitungo yoroshye ni ukuri ko parabola ifite uburyo bwo guhuza igishushanyo bigizwe ningingo zihwanye numuyobozi. Muri rusange, kubaka parabola mu bidukikije bidasanzwe ntabwo bitandukanye cyane no kubaka ikindi gishushanyo icyo ari cyo cyose muri iyi gahunda.

Gukora imbonerahamwe

Mbere ya byose, mbere yo gukomeza kubaka parabola, ugomba kubaka imbonerahamwe hashingiwe kuriyo. Kurugero, fata igishushanyo cyimikorere yimikorere f (x) = 2x ^ 2 + 7.

1. Uzuza imbonerahamwe ya x indangagaciro kuva -10 kugeza 10 ku ntambwe 1. Ibi birashobora gukorwa intoki, ariko byoroshye kuriya ntego yo gukoresha ibikoresho byiterambere. Kugira ngo ubigereho, mu kagari ka mbere k'inkingi "x" twinjije agaciro "-10". Noneho, utakuyeho guhitamo kuri iyi selile, jya kuri tab "urugo". Twakanze kuri buto "Iterambere", ishyirwa mumatsinda yo guhindura. Murutonde rukora, hitamo umwanya "Iterambere ...".



2. Gukora idirishya ryiterambere rikora. Muri "Ahantu", buto igomba gutondekwa kumwanya "ku nkingi", kuva murukurikirane, nubwo mubindi bibazo bishobora kuba ngombwa kugirango ushireho ibintu "kumurongo" umwanya. Muri "ubwoko", va kuri switch muburyo bw'imibare.

   Mu murima "intambwe", twinjije umubare "1". Muri "imipaka ntarengwa", erekana umubare "10", nkuko dusuzuma X kuva -10 kugeza 10 birimo. Hanyuma ukande kuri buto "OK".



3. Nyuma yibi bikorwa, inkingi yose "X" izaba yuzuyemo amakuru dukeneye, aribo, kugeza 10 kugeza 10 mu kwiyongera kwa 1.



4. Noneho tugomba kuzuza inkingi "f (x)". Kugirango ukore ibi, ukurikije ikigereranyo (f (x) = 2x ^ 2 + 7), dukeneye kwinjiza imvugo ikurikira yiyi nkingi kumiterere ikurikira:

   = 2 * x 2 + 7

   Gusa aho kuba agaciro ka x dusimbuza aderesi ya selile yambere yinkingi "X", twaruzuyemo. Kubwibyo, kuri twe, imvugo izafata ifishi:

   = 2 * A2 ^ 2 + 7



5. Noneho dukeneye kwigana formula kandi kurwego rwo hasi rwinkingi. Urebye imitungo yibanze ya Excel, mugihe ukwirakwiza indangagaciro zose za X zizashyikirizwa selile zijyanye na complen "f (x)" mu buryo bwikora. Kugirango dukore ibi, dushyira indanga kuruhande rwiburyo bwiburyo bwa selire, aho formula yamaze gushyirwamo, yanditswe natwe mbere natwe kare. Indanga igomba guhindurwa ikimenyetso cyuzuza, arebye umusaraba muto. Nyuma yo guhinduka kwabaye, clamp ibumoso buto hanyuma ukure indanga kumanuka kugeza kumpera yimeza, hanyuma ureke buto.



6. Nkuko mubibona, nyuma yibi bikorwa, inkingi "f (x)" nayo izuzura.

Kuri iyi mishinga, ameza arashobora gufatwa nkaho yarangiye kandi akagenda mubwoyubakwa kuri gahunda.

Isomo: Nigute ushobora gukora Autoplete mu buhungiro

Gushushanya

Nkuko byavuzwe haruguru, ubu tugomba kubaka gahunda.

1. Hitamo imbonerahamwe hamwe na indanga ufashe buto yimbeba yibumoso. Kwimuka muri tab "shyiramo". Kuri kaseti muri "imbonerahamwe" kanda kuri buto "Ikibanza", kubera ko ari ubwoko bwibishushanyo bikwiranye no kubaka parabola. Ariko ibyo sibyo byose. Nyuma yo gukanda kuri buto yavuzwe haruguru, urutonde rwibisobanuro bya point. Hitamo igishushanyo nigishushanyo hamwe nibimenyetso.



2. Nkuko tubibona, nyuma yibi bikorwa, iyi parabola yubatswe.

Isomo: Uburyo bwo gukora imbonerahamwe mu buhungiro

Imbonerahamwe

Noneho urashobora guhindura gahunda bivamo.

1. Niba udashaka parabola yerekanwe muburyo bwingingo, kandi habaye uburyo bumenyerewe kumurongo wumurongo, uhuza izi ngingo, kanda kuri buri wese muri bo kanda iburyo. Ibikubiyemo bifungura. Muri yo ukeneye guhitamo ikintu "Hindura ubwoko bwigishushanyo cyumurongo ...".



2. Idirishya ryo gutoragura idirishya rifungura. Hitamo izina "ahantu hamwe n'imirongo yoroshye n'ibimenyetso." Nyuma yo guhitamo byakozwe, kanda kuri buto "OK".



3. Noneho imbonerahamwe ya parabola ifite isura imenyerewe.

Byongeye kandi, urashobora gukora ubundi buryo ubwo aribwo bwose bwo guhindura parabola, harimo impinduka mwizina ryayo n'amazina yishoka. Aba bakira bandika ntibarenze imipaka y'ibikorwa kugirango bakore bakemuye ibishushanyo mbonera byubundi bwoko.

Isomo: Nigute wasinya umurongo wimbonerahamwe muri excel

Nkuko mubibona, kubaka parabola muri excel ntabwo bitandukanye cyane no kubaka ubundi bwoko bwibishushanyo cyangwa imbonerahamwe muri gahunda imwe. Ibikorwa byose byakozwe bishingiye kumeza yagenwe. Byongeye kandi, birakenewe gusuzuma ko ingingo Ubwoko bw'imbonerahamwe bukwiriye kurushaho kubaka parabola.