Ukwakha umdwebo ku-Microsoft Excel

Ukwakhiwa kwesiphakamiso kungenye yezinto eziziwayo zezibalo. Ngokuvamile lisetshenziselwa izinjongo zesayensi kuphela, kepha futhi ngenxa yokusebenza okungokoqobo. Masifunde ukwenza le nqubo ngokusebenzisa i-Excel toolkit.

Ukudala i-Parabola

I-parabola igrafu yomsebenzi we-quadratic wohlobo olulandelayo f (x) = i-ax + 2 + bx + c. Esinye sezakhiwo zayo eziphawulekayo yiqiniso lokuthi leli phepha linokubonakala komlinganiso olinganiselwe oqukethe isethi yamaphuzu equidistant avela kumqondisi. Ngokuvamile, ukwakhiwa kwesigameko ku-Excel akufani neze nokwakhiwa kwanoma iyiphi enye igrafu kulolu hlelo.

Indalo yethebula

Okokuqala, ngaphambi kokuba uqale ukwakha umdwebo, kufanele wakhe ithebula ngesisekelo sayo. Isibonelo, ake sithathe umsebenzi wokuhlela f (x) = 2x ^ 2 + 7.

1. Gcwalisa ithebula ngamanani x kusuka -10 kuze kube 10 ezinyathelweni 1. Lokhu kungenziwa ngesandla, kodwa kulula ngalezi zinhloso ukusebenzisa amathuluzi okuqhubekayo. Ukuze wenze lokhu, kuseli lokuqala lekholomu "X" faka inani "-10". Khona-ke, ngaphandle kokukhipha ukhetho kusuka kule seli, iya kuthebhu "Ikhaya". Lapho sikhofoza inkinobho "Ukuqhubeka"okubanjwe eqenjini Ukuhlela. Kuluhlu olusebenziwe, khetha isikhundla "Ukuqhubeka ...".



2. Ivuselela iwindi lokulungiswa kwewindi. Ku-block "Indawo" kufanele uhambise inkinobho endaweni "Ngamakholomu"njengomugqa "X" Itholakala kukholomu, nakuba kwezinye izimo kungase kudingekile ukusetha ushintsho endaweni "Emigqa". Ku-block "Thayipha" shiya inkinobho endaweni "I-Arithmetic".

   Ensimini "Isinyathelo" faka inombolo "1". Ensimini "Inani elilinganiselwe" ucacise inombolo "10"njengoba sibheka ububanzi x kusuka -10 kuze kube 10 kubandakanya. Bese uchofoza inkinobho. "Kulungile".



3. Ngemuva kwalesi senzo, lonke ikholomu "X" uzogcwala idatha esiyidingayo, okungukuthi izinombolo ebangeni -10 kuze kube 10 ezinyathelweni 1.



4. Manje kufanele sigcwalise ikholomu yedatha "f (x)". Ukwenza lokhu, ngokusekelwe ku-equation (f (x) = 2x ^ 2 + 7), sidinga ukufaka inkulumo esitokisini sokuqala sale kholomu ngokuya kwesakhiwo esilandelayo:

   = 2 * x ^ 2 + 7

   Kuphela esikhundleni senani x faka ikheli le-cell yokuqala yekholomu "X"esisanda kugcwalisa. Ngakho-ke, kithi, inkulumo ithatha ifomu:

   = 2 * A2 ^ 2 + 7



5. Manje sidinga ukukopisha ifomula nawo wonke ububanzi obuphansi bale kholomu. Unikezwe izakhiwo eziyisisekelo ze-Excel, uma ukopisha wonke amanani x izobekwa emangqamuzaneni afanele ekholomu "f (x)" ngokuzenzakalelayo. Ukuze wenze lokhu, faka isikhombisi ekhoneni elingaphansi lesokudla leseli, lapho ifomula esiyilobele khona ngaphambili ifakiwe. I-cursor kufanele iguqulwe kumaka wokugcwalisa obukeka njengesiphambano esincane. Ngemuva kokuguqulwa okwenzekile, sibamba inkinobho yesinxele segundane bese uhudula isikhombisi kuze kube sekupheleni kwetafula, bese ukhulula inkinobho.



6. Njengoba ungabona, emva kwalesi sinyathelo ikholomu "f (x)" uzogcwala futhi.

Ukwakheka kwetafula kungacatshangwa ukuthi kuphelele futhi kuqhubeke ngqo ekwakhiweni kwesimiso.

Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel

I-Plotting

Njengoba kushiwo ngenhla, manje kufanele sakha isimiso ngokwayo.

1. Khetha ithebula nge-cursor ngokubamba inkinobho yegundane lesokunxele. Hambisa kuthebhu "Faka". On the tape block "Amashadi" chofoza inkinobho "Indawo", ngoba yilolu hlobo lwegrafu olufanele kakhulu ukwakha isithombe. Kodwa akusikho konke. Ngemuva kokuchofoza inkinobho engenhla, uhlu lwezinhlobo zama-diskhatshaza avuleka. Khetha ishadi lokuhlakaza elinamakaki.



2. Njengoba ubona, ngemuva kwalezi zenzo, i-parabola yakhiwe.

Isifundo: Indlela yokwenza umdwebo ku-Excel

Ukuhlela Ishadi

Manje ungakwazi ukuhlela kancane igrafu eliholele.

1. Uma ungafuni ukuthi i-parabola iboniswe njengamaphoyinti, kodwa ukuze uhlolwe ngokwengeziwe komugqa wendonga ohlanganisa lezi amaphuzu, chofoza kunoma iyiphi yazo inkinobho yegundane efanele. Imenyu yomongo ivulwa. Kulo, udinga ukukhetha into "Shintsha uhlobo lweshadi lomugqa ...".



2. Iwindi lokukhethwa kwehlobo leshadi livulwa. Khetha igama "I-Dot ene-curves ebushelelezi namaka". Emva kokukhethwa kukwenziwa, chofoza inkinobho. "Kulungile".



3. Manje ishadi le-parabola linokubukeka okujwayelekile.

Ukwengeza, ungenza noma yiziphi ezinye izinhlobo zokuhlela i-parabola elandelayo, kuhlanganise nokushintsha igama layo namagama axis. Lezi zindlela zokuhlela azihambanga ngaphezu kwemingcele yezenzo zokusebenza ku-Excel ngemidwebo yezinye izinhlobo.

Isifundo: Indlela yokusayina i-axis eshadi ku-Excel

Njengoba ubona, ukwakhiwa kwesigcawu ku-Excel akufani neze nokwakhiwa kolunye uhlobo lwegrafu noma umdwebo ohlelweni olufanayo. Zonke izenzo zenziwe ngesisekelo setafula elenziwe ngaphambili. Ngaphezu kwalokho, kufanele kuqashelwe ukuthi iphuzu lokubuka umdwebo lifaneleka kakhulu ekwakhiweni kwesakhiwo.