Maitiro ekuvaka parabola muExcel

Kuvakwa kweparabola ndiyo imwe yemabasa anozivikanwa emasvomhu. Kazhinji kazhinji zvinoshanda kwete chete nekuda kwesainzi zvinangwa, asiwo mune zvakasarudzika. Ngatitsvagei kuti ungaita sei maitiro aya uchishandisa Excel application application.

Kusikwa kweparabola

Parabola girafu yeiyo quadratic basa remhando inotevera f (x) = ax ^ 2 + bx + c . Chimwe chezvivakwa zvinosarudzwa ndezvekuti iyo parabola ine fomu yeiyo symmetric nhamba inosanganisira seti yemapepa anoyevedza kubva kumutungamiriri. Ne uye yakakura, kuvakwa kweparable munzvimbo yekuwedzera haina kunyanya kusiyana nekuvaka chero imwe imwe girafu muchirongwa ichi.

Kugadzira tafura

Chekutanga pane zvese, usati waenderera nekuvaka parabola, iwe unofanirwa kuvaka tafura pane iyo iyo ichagadzirwa. Semuenzaniso, tora girafu yebasa rebasa f (x) = 2x ^ 2 + 7.

1. Zadza tafura ne x kukosha kweX kubva -10 kusvika ku10 mudanho 1. Izvi zvinogona kuitwa pamunhu, asi zviri nyore kune izvi zvinangwa zvekushandisa zviridzwa zvinofambira mberi. Kuti uite izvi, muchitokisi chekutanga chekamuri "x" tinopinda kukosha "-10". Zvadaro, pasina kubvisa kusarudzwa kubva muchitokisi ichi, enda ku "imba" tab. Isu tinodzvanya pane "kufambira mberi" bhatani, iyo inotumirwa muboka rekugadzirisa. Mune iyo yakagadziriswa rondedzero, sarudza chinzvimbo "kufambira mberi ...".



2. Activation yeiyo inoenderera mberi yekugadzirisa hwindo inoitwa. Mu "nzvimbo" block, bhatani rinofanira kugadzirwazve pachinzvimbo "pamhuru", sezvo nhevedzano "X" inoiswa muzvimwe zviitiko, kunyangwe mune zvimwe zviitiko zvingangodaro zvichidikanwa kuisa iyo 'pamitsetse " chinzvimbo. Mu "mhando" block, siya switch mune arithmetic chinzvimbo.

   Mu "nhanho" munda, tinopinda nhamba "1". Mu "Limit kukosha" munda, ratidza nhamba "10", sezvatinofunga nezve X renji kubva -10 kusvika ku11 kusvika 10 kubatanidzwa. Wobva wadzvanya pane "OK" bhatani.



3. Mushure mekuita uku, iyo column yese "X" ichazadzwa nedata yatinoda, iyo, nhamba dziri muzvikamu kubva pagumi kusvika gumi mukuwedzera kwe1.



4. Ikozvino isu tichafanira kuzadza iyo column "f (x)". Kuti uite izvi, zvichienderana neiyo equation (f (x) = 2x ^ 2 + 7), tinoda kupinda chirevo pane chinotevera muenzaniso weiyi chikamu kune chinotevera chimiro:

   = 2 * x ^ 2 + 7

   Asi chete pane kukosha kwe x isu tinotsiva kero yesero rekutanga reColumn "x" isu takango zadzwa kunze. Naizvozvo, kwatiri, kutaura kwedu kuchatora fomu.

   = 2 * A2 ^ 2 + 7



5. Zvino isu tinofanirwa kutevedzera formula uye yeiyo yakazara yakadzika chikamu cheiyi ikholamu. Kupiwa izvo zvakakosha zvivakwa zveExcel, kana uchitevedzera zvese X tsika zvichaunzwa kune inoenderana column masero "f (x) otomatiki. Kuti tiite izvi, tinoisa chikwama kune zasi kurudyi kona yechitokisi, umo iyo formula yatoiswa, yakanyorwa nesu zvishoma pakutanga. Iyo inotsaurwa inofanira kushandurwa kusvika pakuzadza mucherechedzo, kutarisa muchinjiro chidiki. Mushure mekunge kushandurwa kwakaitika, clamp iyo yekuruboshwe mbeva bhatani uye kudhonza iyo inotuka pasi kusvika kumagumo etafura, wobva watendera kuenda kwebhatani.



6. Sezvauri kuona, mushure mekuita uku, iyo column "f (x)" ichazadzwa.

Pane kuumbwa uku, tafura inogona kutariswa yakapera uye kufambisa zvakananga pakuvakwa kwehurongwa.

Chidzidzo: Maitiro ekuita autocomlete muutapwa

Kuvaka Graphics

Sezvatotaurwa pamusoro apa, ikozvino tinofanirwa kuvaka chirongwa.

1. Sarudza tafura neiyo yerotor nekubata iyo yekuruboshwe mbeva bhatani. Famba mu "Insert" tab. Pamutepi mu "chart block" tinya pane iyo "nzvimbo" bhatani, sezvo iri rudzi rweGirafu iyo yakakodzera kwazvo kuvakwa kweparabola. Asi hazvisi zvese. Mushure mekudzvanya pane bhatani riri pamusoro apa, rondedzero yemakona enzvimbo dzinoverengeka dzinovhura. Sarudza dhizaini yemitambo ine mamaki.



2. Sezvatinoona, mushure meizvi zviito, parabola yakavakwa.

Chidzidzo: Maitiro Ekuita Chati Muhutapwa

Editing Chart

Iye zvino unogona kugadzirisa hurongwa hwakakonzerwa.

1. Kana iwe usingade parabola kuti uratidzwe muchimiro chemapepa, uye pakanga paine maonero akajairika emutsetse wemutsetse, uyo unobatanidza idzi pfungwa, tinya pane chero chipi zvacho kurudyi-tinya. Mamino menyu anovhura. Mairi iwe unofanirwa kusarudza chinhu "chinja mhando yedhirowa yemutsara ...".



2. Iyo Windows Section Window inovhura. Sarudza zita rekuti "nzvimbo ine zvisizvo curves uye mamaki." Mushure mekusarudza kuitwa, tinya pane "OK" bhatani.



3. Zvino chati ye paraabola ine hanya zvakanyanya.

Mukuwedzera, iwe unogona kuita mamwe marudzi ekugadzirisa iyo paraitha parabola, kusanganisira shanduko muzita raro nemazita emazita. Aya ekurongedza anogamuchira haafambi kupfuura miganhu yekuita kuti ishande mukuratidzira nedzimwe mhando dzemamwe marudzi.

Chidzidzo: Maitiro ekusaina iyo axis ye chati yekubuda

Sezvauri kuona, kuvaka parabola muExcel haina kunyanya kusiyana nekuvaka imwe mhando yegirafu kana chati muchirongwa chimwe chete. Zvese zviito zvinogadzirwa zvichienderana netafura yakatemerwa. Uye zvakare, zvinodikanwa kuti ufunge kuti iyo pfungwa yeiyo chati yakanyanya kukodzera kuvaka parabola.