Kupanga parabola mu Microsoft Excel

Kupanga parabola ndi imodzi mwazolemba zodziwika bwino zamasamu. Nthawi zambiri, imagwiritsidwa ntchito osati zongogwiritsa ntchito zasayansi, komanso zothandiza chabe. Tiyeni tiwone momwe mungagwiritsire ntchito njirayi pogwiritsa ntchito zida za Excel.

Kupanga parabola

Parabola ndi chithunzi cha mitundu inayi yamtundu wotsatira f (x) = ax ^ 2 + bx + c. Chimodzi mwazinthu zake zodabwitsa ndizakuti parabola ili ndi mawonekedwe ofanana, opangidwa ndi mfundo zofanana kuchokera ku Directrix. Mokulira, kupanga parabola m'malo a Excel sikusiyana kwambiri ndi kapangidwe kazinthu zina pulogalamuyi.

Kulenga kwa tebulo

Choyamba, musanayambe kupanga parabola, muyenera kupanga tebulo pamaziko omwe apangidwire. Mwachitsanzo, tengani chithunzi cha ntchitoyo f (x) = 2x ^ 2 + 7.

1. Dzazani tebulo ndi mfundo x kuchokera -10 kale 10 zowonjezera 1. Izi zitha kuchitika pamanja, koma ndizosavuta kugwiritsa ntchito zida zotsogola pazolinga izi. Kuti muchite izi, mu foni yoyamba ya mzati "X" lowetsani tanthauzo "-10". Kenako, osachotsa kusankhidwa mu cell, pitani ku tabu "Pofikira". Pamenepo timadina batani "Kupita patsogolo"lomwe limayikidwa mgulu "Kusintha". Pamndandanda wokhazikitsa, sankhani malo "Kupita patsogolo ...".



2. Zenera losintha mosinthika limayatsidwa. Mu block "Malo" sunthani batani pamalo Column ndi safukuyambira mzere "X" kuyikidwa mu mzati, ngakhale nthawi zina, mungafunike kukhazikitsa Mzere ndi mzere. Mu block "Mtundu" siyani kusintha kosinthika "Arithmetic".

   M'munda "Khwerero" lowetsani nambala "1". M'munda "Mtengo wochepera" onetsani nambala "10"popeza tikuganizira zamtundu x kuchokera -10 kale 10 kuphatikiza. Kenako dinani batani "Zabwino".



3. Pambuyo pa izi, mzere wonse "X" idzadzazidwa ndi zomwe tikufuna, monga manambala kuyambira -10 kale 10 zowonjezera 1.



4. Tsopano tikuyenera kudziwa zambiri "f (x)". Kwa izi, kutengera ndi equation (f (x) = 2x ^ 2 + 7), tikuyenera kuyika mawuwa mu foni lotsatira mu foni yoyamba yamtunduwu:

   = 2 * x ^ 2 + 7

   M'malo mopindulitsa x sinthani adilesi ya selo loyamba la chipilalacho "X"kuti tangodzaza. Chifukwa chake, kwa ife, mawuwo akutenga mawonekedwe:

   = 2 * A2 ^ 2 + 7



5. Tsopano tikuyenera kukopera chilinganizo kumigawo yonse yotsika iyi. Poganizira zofunikira za Excel, mukamakopera mfundo zonse x Idzayikidwa mu khungu lolingana ndi chipilalacho "f (x)" basi. Kuti muchite izi, ikani cholozera cha ngodya kumunsi kwa chipindacho, chomwe chili ndi chida chomwe tidalemba kale. Choperekera chizisinthidwa kukhala chikhomo chodzaza chomwe chimawoneka ngati mtanda yaying'ono. Kutembenuka kukachitika, gwerani pansi batani lakumanzere ndikokera kounikira mpaka kumapeto kwa tebulo, kenako tumizani batani.



6. Monga mukuwonera, mutatha izi, mzati "f (x)" adzakhuta nawonso.

Pamenepa, mapangidwe a tebulo amatha kuonedwa kuti ndi athunthu ndikupita molunjika kumangidwe kwa dongosolo.

Phunziro: Momwe mungapangire kuti zitheke mu Excel

Kupanga mapulani

Monga tafotokozera pamwambapa, tsopano tiyenera kupanga dongosolo lokha.

1. Sankhani tebulo ndi cholozera pomwe muli ndi batani lakumanzere. Pitani ku tabu Ikani. Pa tepi pachipika Ma chart dinani batani "Spot", popeza mtundu wamtunduwu ndi woyenera kwambiri pomanga parabola. Koma si zokhazo. Mukadina batani pamwambapa, mndandanda wamitundu yamatundu obalalika umatsegulidwa. Sankhani tchati chomwaza ndi chikhomo.



2. Monga mukuwonera, zitatha izi, parabola imamangidwa.

Phunziro: Momwe mungapangire chithunzi mu Excel

Kusintha kwa tchati

Tsopano mutha kusintha tchati chotsatira pang'ono.

1. Ngati simukufuna kuti parabola iwonetsedwe ngati mfundo, koma kuti mukhale ndi mawonekedwe odziwika bwino a mzere wolumikizidwa womwe umalumikiza mfundozi, dinani kumanja kwa aliyense wa iwo. Zosankha zam'mawu zimatsegulidwa. Mmenemo muyenera kusankha chinthucho "Sinthani mtundu wa tchati mzere ...".



2. Tsamba losankha tchati limatsegulidwa. Sankhani dzina "Spot yokhala ndi ma curve osalala ndi zimpawu". Pambuyo kusankha kwapangidwa, dinani batani. "Zabwino".



3. Tsopano tchati cha parabola chikuwoneka bwino kwambiri.

Kuphatikiza apo, mutha kupanga mitundu yina yosinthira ya parabola yomwe ikupezeka, kuphatikiza kusintha mayina ake ndi ma axis. Njira zamakonzedwe izi sizidutsa malire a zochita pakugwira ntchito ku Excel ndi zojambula zamitundu ina.

Phunziro: Momwe mungasainire tchati cha axis ku Excel

Monga mukuwonera, kupanga parabola ku Excel sikusiyana ndikumanga mtundu wina kapena chithunzi mu pulogalamu imodzimodzi. Zochita zonse zimachitika pamaziko a tebulo lomwe linapangidwa kale. Kuphatikiza apo, ziyenera kukumbukiridwanso kuti gawo lowonera bwino lajambuloli ndilabwino kwambiri popanga parabola.