Gina parabola a cikin Microsoft Excel

Gina parabola yana daya daga cikin sanannun ayyukan lissafi. Sau da yawa ana amfani dashi ba kawai don dalilai na kimiyya ba, har ma don kawai zartar da amfani. Bari mu gano yadda za a kammala wannan aikin ta amfani da kayan aikin kwalliya na Excel.

Yin parabola

Parabola jadawali ne na aikin quadratic na nau'in mai zuwa f (x) = ax ^ 2 + bx + c. Ofaya daga cikin kayansa na ban mamaki shine gaskiyar cewa parabola tana da siffa mai sifa, wacce ta ƙunshi jerin maƙasudan maki daga shugabanci. Gabaɗaya, gina parabola a cikin yankin Excel ba ya bambanta sosai da gina kowane jadawalin wannan shirin.

Tsarin tebur

Da farko dai, kafin ka fara gina parabola, yakamata ka gina tebur kan abin da za'a kirkireshi. Misali, dauki jadawalin aikin f (x) = 2x ^ 2 + 7.

1. Cika tebur da dabi'u x daga -10 a da 10 a kari 1. Ana iya yin wannan da hannu, amma yana da sauƙin amfani da kayan aikin ci gaba na waɗannan abubuwan. Don yin wannan, a cikin tantanin farko na shafi "X" shigar da ma'anar "-10". To, ba tare da cire zaɓi daga wannan tantanin ba, je zuwa shafin "Gida". A nan mun danna maballin "Ci gaba"wanda aka sanya a cikin rukuni "Gyara". A Jerin da aka kunna, zabi matsayin "Ci gaba ...".



2. Ana kunna taga daidaita ci gaba. A toshe "Wuri" Matsar da maɓallin zuwa wuri Harafi da shafitun jere "X" sanya a cikin shafi, kodayake a wasu lokuta, kuna iya buƙatar saita sauyawa zuwa Yayi layi-layi. A toshe "Nau'in" barin wurin canzawa a wuri "Ilmin lissafi".

   A fagen "Mataki" shigar da lamba "1". A fagen "Iyakataccen darajar" nuna lambarta "10"tunda muna la'akari da kewayon x daga -10 a da 10 gaba daya. Saika danna maballin "Ok".



3. Bayan wannan aikin, gaba ɗaya shafi "X" zai cika da bayanan da muke buƙata, watau lambobi jere daga -10 a da 10 a kari 1.



4. Yanzu dole ne mu cike bayanan shafi "f (x)". Don wannan, dangane da daidaituwa (f (x) = 2x ^ 2 + 7), muna buƙatar shigar da magana a cikin sel na gaba a cikin tantanin farko na wannan shafi:

   = 2 * x ^ 2 + 7

   Kawai maimakon darajar x canza adireshin sel na farko na shafi "X"cewa kawai mun cika. Saboda haka, a cikin yanayinmu, bayanin zai dauki hanyar:

   = 2 * A2 ^ 2 + 7



5. Yanzu muna buƙatar kwafa dabarar zuwa duka ƙananan keɓaɓɓun wannan shafin. Bayar da ainihin kayan aikin Excel, lokacin kwashe duk ƙimanta x za a sa a cikin m Kwayoyin na shafi "f (x)" ta atomatik. Don yin wannan, sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta, wanda ya riga ya ƙunshi tsarin da muka rubuta kaɗan a baya. Ya kamata a canza siginar alama zuwa abin cika mai kama da ƙaramin giciye. Bayan jujjuyawar ta faru, riƙe maɓallin linzamin kwamfuta na hagu ka ja siginar ƙasa zuwa ƙarshen teburin, sannan ka saki maɓallin.



6. Kamar yadda kake gani, bayan wannan matakin, shafi "f (x)" zai cika kuma.

A kan wannan, ana iya ɗaukar nauyin teburin cikakke kuma tafi kai tsaye zuwa ginin jadawalin.

Darasi: Yadda ake yin autocomplete a Excel

Shiryawa

Kamar yadda aka ambata a sama, yanzu dole mu gina jadawalin kanta.

1. Zaɓi tebur tare da siginan kwamfuta yayin riƙe maɓallin linzamin kwamfuta na hagu. Matsa zuwa shafin Saka bayanai. A kan tef a cikin toshe Charts danna maballin "Haske", tunda wannan nau'in jadawali na musamman ya fi dacewa don gina parabola. Amma wannan ba duka bane. Bayan danna maɓallin da ke sama, jerin jerin samfuran samfuran warwatsewa ke buɗe. Zaɓi ginshiƙi mai rarrabawa tare da alamomi.



2. Kamar yadda kake gani, bayan waɗannan ayyuka, an gina parabola.

Darasi: Yadda ake yin zane a Excel

Shirya zane

Yanzu zaku iya shirya sakamakon zane kaɗan.

1. Idan baku son parabola ta zama maki, amma don samun sabon tsari na layin da ya haɗu da waɗannan lamuran, danna-kan kowane ɗayan. Tushen mahallin yana buɗewa. A ciki akwai buƙatar zaɓi abu "Canza nau'in ginshiƙi akan layi ...".



2. Ana buɗe nau'in zaɓin nau'in ginshiƙi. Zaɓi suna "Spot tare da santsi masu lankwasa da alamomi". Bayan an yi zaɓi, danna maballin. "Ok".



3. Yanzu ginshiƙi na parabola yana da masaniya sosai.

Kari akan haka, zaku iya yin kowane nau'in gyara na parabola sakamakon, hade da canza sunanta da sunayen ta. Wadannan dabarun gyara ba su wuce iyakokin ayyuka don aiki a cikin Excel tare da zane-zanen wasu nau'ikan ba.

Darasi: Yadda za a sa hannu a ginshiƙi ginshiƙi a cikin Excel

Kamar yadda kake gani, gina parabola a cikin Excel bai bambanta da gina wani nau'in zane mai hoto ko zane a cikin shirin iri ɗaya ba. Dukkanin ayyuka ana yin su ne bisa tushen teburin da aka riga aka kafa. Bugu da kari, dole ne a yi la’akari da cewa isharar hoton hoton ta fi dacewa da kirkirar parabola.