Kev tsim kho ntawm ib qho chaw ua haujlwm yog ib qho ntawm kev paub ua zauv. Ntau zaus nws tsuas yog siv tsis yog rau kev tshawb nrhiav xwb, tab sis kuj yog rau cov neeg tsis muaj tswv yim. Cia peb kawm kom paub ua cov txheej txheem no siv cov cuab yeej Excel.
Tsim ib qho Parabola
Parabola yog ib daim duab ntawm lub cim plaub ntawm cov nram qab no f (x) = taus ^ 2 + bx + c. Ib qho ntawm nws cov txiaj ntsim zoo tshaj plaws yog qhov tseeb tias cov nyiaj parabola muaj cov tsos ntawm ib yam kab uas muaj cov ntsiab lus sib npaug ntawm tus thawj coj. Los thiab loj, kev tsim kho ntawm ib qho chaw hauv Excel tsis txawv ntawm qhov kev tsim kho ntawm lwm cov teeb hauv qhov kev kawm no.
Cov lus tsim
Ua ntej tshaj plaws, ua ntej koj pib tsim ib qho chaw ua noj haus, koj yuav tsum tsim ib lub rooj rau lub hauv paus uas tsim muaj. Piv txwv li, cia tus nqis ua tus ua haujlwm f (x) = 2x ^ 2 + 7.
- Sau lub rooj nrog qhov tseem ceeb x ntawm -10 mus txog 10 hauv cov kauj ruam 1. Qhov no yuav ua tau manually, tab sis nws yooj yim rau cov laj thawj no siv cov cuab yeej ntawm kev mob. Ua li no, hauv thawj lub xovtooj ntawm kem "X" sau tus nqi "-10". Tom qab ntawd, yam uas tsis tau tshem qhov xaiv los ntawm no cell, mus rau tab "Tsev". Muaj peb nyem rau ntawm lub pob "Kev mob"uas yog hosted nyob rau hauv ib pawg Editing. Hauv daim ntawv teev npe, xaiv qhov chaw "Kev mob ...".
- Qhib qhov kev hloov kho qhov rais. Hauv kev thaiv "Qhov chaw" yuav tsum txav mus rau txoj haujlwm "Los ntawm kab"raws li ib tug uake "X" Nws nyob rau hauv kem, tab sis nyob rau hauv lwm cov ntawv nws kuj yuav tsum tau teem caij mus rau txoj haujlwm "Hauv kab". Hauv kev thaiv "Hom" tawm qhov hloov hauv txoj haujlwm "Sibtham".
Hauv teb "Kauj Ruam" sau tus naj npawb "1". Hauv teb "Txwv cov nqi" qhia tus naj npawb "10"vim peb xav txog qhov ntau x ntawm -10 mus txog 10 suav txhua tus. Ces nyem rau ntawm lub pob. "OK".
- Tom qab qhov kev txiav txim, tag nrho sab "X" yuav tsum tau sau nrog cov ntaub ntawv peb xav tau, namely tus lej nyob rau hauv cov ntau ntawm -10 mus txog 10 hauv cov kauj ruam 1.
- Tam sim no peb tau ua kom tiav cov lus qhia "f (x)". Ua li no, raws li qhov kev ua zauv (f (x) = 2 x ^ 2 + 7), peb yuav tsum tau muab cov lus qhia hauv thawj lub xovtooj ntawm cov kab no raws li cov nram qab no:
= 2 * x ^ 2 + 7Tsuas yog siv tus nqi x hloov qhov chaw nyob ntawm thawj lub xovtooj ntawm kem "X"uas peb tau cia li ua tiav. Yog li ntawd, nyob rau hauv peb cov ntaub ntawv, qhov kev qhia siv daim ntawv:
= 2 * A2 ^ 2 + 7 - Tam sim no peb yuav tsum luam cov mis thiab tag nrho qis dua ntawm kem no. Muab cov khoom pib ntawm Excel, thaum luam tag nrho cov kev tsim txiaj x yuav muab tso rau hauv lub hlwb uas tsim nyog ntawm kem "f (x)" txiav. Ua li no, muab tus cursor tso rau hauv qab ces kaum ntawm tus xovtooj ntawm tes, uas yog qhov formula uas peb tau sau yav dhau los twb raug muab tso lawm. Tus cursor yuav tsum hloov dua siab tshiab rau tus cim kos npe uas zoo li tus ntoo khaub lig me me. Tom qab qhov pom muaj tshwm sim lawm, peb tuav khawm nas khawm thiab cab tus cursor nqes mus rau qhov kawg ntawm lub rooj, ces tso khawm.
- Raws li koj tau pom, tom qab kab ntawv no "f (x)" yuav raug puv dhau.
Nyob rau ntawm daim ntawv no yuav suav tau tias ua tiav thiab pib ncaj qha mus rau kev tsim kho ntawm lub sijhawm.
Tshooj: Yuav ua li cas kom autocomplete hauv Excel
Plotting
Raws li tau hais los saum no, tam sim no peb yuav tsum tsim kho lub sij hawm xwb.
- Xaiv lub rooj nrog tus cursor los tuav lub pob nyem khawm. Txav mus rau tab "Ntxig". Hauv kab xev hauv kev thaiv "Kab Cim" nyem rau ntawm lub pob "Chaw", vim nws yog hom teeb uas yog qhov zoo tshaj plaws rau kev tsim ib qho chaw ua si. Tab sis qhov no tsis yog txhua yam. Tom qab txhaj rau saum toj khawm, ib daim ntawv teev hom scatter kab kos opens. Xaiv ib daim duab nrauv nrog cov cim.
- Raws li koj tuaj yeem pom, tom qab cov kev ua no, lub chaw ua haujlwm tau tsim tsa.
Tshooj: Yuav ua li cas ua ib daim duab hauv Excel
Daim Ntawv Sau
Tam sim no koj tau me ntsis hloov lub teeb duab.
- Yog hais tias koj tsis xav kom qhov chaw ua si yuav tsum tau tso tawm kom pom li cov ntsiab lus, tab sis kom muaj kev paub zoo dua ntawm txoj kab ntawm txoj kab uas txuas cov ntsiab lus, nyem rau ntawm ib qho ntawm lawv tus nas khawm. Lub ntsiab lus teb ntsiab lus opens. Hauv nws, koj yuav tsum xaiv qhov khoom "Hloov cov hom ntawv qhia rau ib tug uake ...".
- Daim ntawv xaiv xaiv lub qhov rooj opens. Xaiv lub npe "Dot nrog cov curves thiab cov cim". Tom qab xaiv ua, nyem rau ntawm lub pob. "OK".
- Tam sim no daim ntawv qhia ntawm parabola muaj kev paub zoo dua.
Tsis tas li ntawd, koj tuaj yeem ua lwm hom kev kho kom haum lub cev ua ke, nrog rau kev hloov lub npe thiab lub npe ntawm cov axis. Cov kev kho cov tswv yim no tsis dhau mus rau thaj tsam ntawm kev ua haujlwm rau Excel nrog cov duab kos ntawm lwm hom.
Tshooj: Yuav ua li cas kos npe rau daim ntawv qhia nyob hauv Excel
Raws li koj tau pom, kev tsim kho ntawm qhov chaw parabola hauv Excel nws tsis txawv txav ntawm kev tsim kho ntawm lwm hom teeb lossis daim duab hauv tib qho kev pabcuam. Txhua yam kev ua yog ua raws li cov txheej txheem ua ntej. Ntxiv mus, nws yuav tsum tau muab sau tseg tias qhov taw tes pom ntawm daim duab yog qhov zoo tshaj plaws rau kev tsim kho ntawm ib qho chaw ua si.
