Yadda za a gina parabola a Excel

Ginin parabola yana ɗaya daga cikin sanannun ayyukan lissafi. Sau da yawa yana amfani da dalilan kimiyya, har ma a cikin zalla. Bari mu gano yadda ake yin amfani da kayan aikin Aikace-aikacen Excel.

Samar da parabola

Parabola zane ne na aikin quadratic na nau'in na gaba f (x) = ax ^ 2 + BX + c . Ofaya daga cikin abubuwan da ba'a sani ba ne cewa parabola yana da wani nau'i na adadi na misali wanda ya kunshi sa na maki maki daga Daraktan. Da girma, ginin parabolala a cikin yanayin mai fitarwa ba shi da bambanci sosai da gina kowane zane a cikin wannan shirin.

Kirkirar tebur

Da farko dai, kafin a ci gaba da gina parabola, ya kamata ku gina tebur a kan abin da za a ƙirƙira shi. Misali, ɗauki jadawalin aikin f (x) = 2x ^ 2 + 7 + 7 + 7.

1. Cika tebur tare da dabi'u x na -10 zuwa 10 a mataki 1. Ana iya yin wannan da hannu, amma sau da hannu ga waɗannan manufofin don amfani da kayan aikin ci gaba. Don yin wannan, a cikin tantanin farko na shafi "x" mun shigar da darajar "-10". Bayan haka, ba tare da cire zaɓi daga wannan sel ɗin ba, je zuwa shafin "gida". Muna danna maballin "ci gaba", wanda aka buga a cikin kungiyar gyara. A cikin jerin kunnun, zaɓi matsayin "ci gaba ...".



2. Kunna taga gyara abubuwan da aka kunna. A cikin "wuri" toshe, ya kamata a sake shirya maɓallin zuwa wurin "akan ginshiƙai", tun, an sanya shi a cikin shafi na "a wasu lokuta da zai iya zama dole don saita canjin" a kan layi " matsayi. A cikin "nau'in" toshe, bar sauyawa a cikin ilimin lissafi.

   A cikin filin "Mataki", mun shigar da lambar "1". A cikin "iyakance darajar" filin, nuna lamba "10", kamar yadda muke la'akari da X Rango daga -10 zuwa 10 hade. Sannan danna maballin "Ok".



3. Bayan wannan aikin, duk shafi na "X" za a cika shi da bayanan da muke buƙata, wato, lambobi a cikin kewayon daga -10 zuwa 10 a cikin kari na 1.



4. Yanzu dole ne mu cika shafi "f (x)". Don yin wannan, dangane da daidaituwa (f (x) = 2x ^ 2 + 7 + 7), muna buƙatar shigar da magana game da tsarin wannan shafi na gaba:

   = 2 * x ^ 2 + 7

   Kawai maimakon darajar X muka sauke adireshin sel na farko na shafi "x", wanda kawai muke cike. Saboda haka, a cikin batunmu, magana zata dauki fom ɗin:

   = 2 * A2 ^ 2 + 7



5. Yanzu muna buƙatar kwafa dabara da kuma duk ƙananan kewayon wannan shafi. Bayar da ainihin kaddarorin Excel, lokacin da aka fitar da dukkan dabi'un x xauki zuwa sel mai dacewa "F (x) ta atomatik. Don yin wannan, mun sanya siginan kwamfuta zuwa ƙananan kusurwar dama ta tantanin halitta, wanda aka riga aka sanya dabara, ɗan lokaci kaɗan da farko. Dole ne a canza siginan kwamfuta zuwa mai alama, da ke da wani irin karamin gicciye. Bayan an sami bututun linzamin hagu na hagu na hagu da jan siginan ƙasa zuwa ƙarshen tebur, to, bari maɓallin.



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

A kan wannan samuwar, za a iya la'akari da teburin ana iya kammalawa kuma motsa kai tsaye ga gina jadawalin.

Darasi: Yadda ake yin Autocomplete a cikin hijira

Gina zane-zane

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

1. Zaɓi tebur tare da siginan kwamfuta ta riƙe maɓallin linzamin kwamfuta na hagu. Matsa cikin shafin "Saka" shafin. A kan tef a cikin "ginshiƙi" danna kan "tabo", tunda wannan nau'in wannan zane ne wanda ya fi dacewa da gina parabola. Amma wannan ba duka bane. Bayan danna maɓallin maɓallin da ke sama, jerin abubuwan da aka buɗe zane-zane suna buɗewa. Zaɓi zane mai zane tare da alamomi.



2. Kamar yadda muke gani, bayan wadannan ayyukan, an gina parabola.

Darasi: Yadda ake yin ginshiƙi a cikin hijira

Gyara ginshiƙi

Yanzu zaku iya shirya jadawalin sakamakon.

1. Idan baku son parabola da za a nuna ta a cikin hanyar maki, kuma akwai mafi saba game da layin layi, danna kowane ɗayansu danna-dama. Menu na mahallin yana buɗewa. A ciki kana buƙatar zaɓar abun "Canza nau'in zane don jerawa ...".



2. Window ɗin taga yana buɗe. Zaɓi sunan "tabo tare da daskararre masu laushi da alamomi." Bayan an yi zaɓin, danna maɓallin "Ok".



3. Yanzu jadawalin parabola yana da cikakkiyar gani.

Bugu da kari, zaku iya yin wasu nau'ikan gyaran parabola da aka karɓi, gami da canjin sunan da sunayensa. Wadannan masu karɓar masu karɓar ba za su wuce iyakokin aiki don yin aiki a Forecels na wasu nau'in.

Darasi: Yadda za a sanya hannu a Axis na Capit

Kamar yadda kake gani, gina parabola cikin fifita ba ya bambanta da kayan aikin wani nau'in zane ko ginshiƙi a cikin wannan shirin. Dukkanin ayyuka an kafa bisa tebur da aka riga aka ƙaddara. Bugu da kari, ya zama dole a yi la'akari da cewa nau'in ginshiƙi ya fi dacewa don gina parabola.