Muaj qhov teeb meem no thaum nyob hauv qhov kev paub txog qhov tseem ceeb uas koj xav tau kom nrhiav tau cov qhab nia nruab nrab. Hauv kev ua lej, qhov no hu ua interpolation. Nyob hauv Excel, hom no siv tau rau ob qho tib si cov ntaub ntawv thiab cov graphing. Cia peb kuaj xyuas txhua txoj hau kev no.
Siv interpolation
Qhov loj tshaj nyob rau hauv uas sib nkag tau thov yog tias qhov nqi yam yuav tsum yog hauv cov ntaub ntawv array, thiab tsis mus tshaj nws txoj kev txwv. Piv txwv li, yog tias peb muaj ib qho ntawm cov lus sib cav 15, 21, thiab 29, ces thaum nrhiav kev ua haujlwm rau kev sib cav 25 peb tuaj yeem siv sijhawm. Thiab mus nrhiav qhov nqi coj los sib cav 30 - tsis ntev lawm. Qhov no yog qhov sib txawv ntawm qhov kev ua no ntawm kev sib luag.
Txoj kev 1: Interpolation rau tabular cov ntaub ntawv
Ua ntej tshaj plaws, xav txog kev siv interpolation rau cov ntaub ntawv uas nyob hauv lub rooj. Piv txwv, siv ib qho kev sib ceg ntawm cov lus sib cav thiab qhov tseem ceeb ua piv txwv, qhov sib piv uas tau piav qhia los ntawm ib txoj kab zauv. Cov ntaub ntawv no yog nyob rau hauv qab rooj. Peb yuav tsum tau nrhiav qhov haujlwm coj los sib cav. 28. Qhov yooj yim tshaj los ua qhov no yog nrog tus neeg teb xov tooj. FORECAST.
- Xaiv yam npliag hlwb ntawm daim ntawv uas tus neeg siv khoom siv los tso saib qhov tshwm sim los ntawm kev nqis tes ua. Tom ntej no, nias lub khawm. "Ntxig rau kev ua haujlwm"uas yog nyob rau sab laug ntawm lub mis bar.
- Kaw lub qhov rais Muaj nuj nqi masters. Nyob hauv qeb "Lej" los yog "Daim ntawv teev npe tag nrho" saib lub npe "TXHAIS". Tom qab sib piv, nrhiav nws thiab nyem rau ntawm lub pob "OK".
- Qhov kev ua lag luam muaj nuj nqi pib tshwm. FORECAST. Nws muaj peb daim teb:
- X;
- Paub Y Zoo;
- Paub x qhov tseem ceeb.
Hauv thawj lub tshav, peb tsuas xav tau manually sau qhov tseem ceeb ntawm qhov sib cav los ntawm cov keyboard, qhov kev ua haujlwm ntawm qhov yuav tsum tau nrhiav tau. Nyob rau hauv peb cov ntaub ntawv nws yog 28.
Hauv teb "Paub Y Qhov Tseeb" koj yuav tsum qhia lub zog ntawm qhov ntau ntawm lub rooj, uas muaj qhov tseem ceeb ntawm txoj haujlwm. Qhov no yuav ua tau manually, tab sis nws yooj yim dua thiab yooj yim dua los tso tus cursor hauv lub tshav pob thiab xaiv thaj tsam thaj tsam ntawm daim ntawv.
Zoo sib xws, teev nyob rau hauv thaj av "Paub x" ntau lub koom haum nrog cov lus sib tham.
Tom qab tag nrho cov ntaub ntawv tsim nyog nkag, nias ntawm lub pob "OK".
- Cov nuj nqis ntawm cov nuj nqis yuav pom tshwm hauv xov tooj ntawm tes uas peb tau xaiv hauv thawj kauj ruam ntawm hom no. Qhov tshwm sim yog tus naj npawb 176. Nws yuav yog qhov tshwm sim ntawm kev sib nkag siab.
Tshooj: Excel ua haujlwm wizard
Method 2: Interpolate graph siv nws cov chaw
Tus txheej txheem interpolation kuj tuaj yeem siv thaum ua kev teeb tsa ntawm kev ua haujlwm. Nws yog qhov tseem ceeb yog tias qhov sib piv ntawm qhov kev ua haujlwm tsis raug pom hauv ib qho ntawm cov lus sib cav nyob rau hauv lub hauv paus uas lub teeb tsa los ua, raws li hauv daim duab hauv qab no.
- Ua tus tsim ntawm daim duab hauv txoj kev niaj zaus. Ntawd yog, nyob hauv tab "Ntxig", peb xaiv lub rooj sib thooj raws li qhov kev tsim kho yuav raug muab coj los ua. Ndliv qhov icon "Teem caij"muab tso rau hauv ib lub block ntawm cov cuab yeej "Kab Cim". Hauv daim duab cov duab tshwm, xaiv ib qho uas peb pom zoo tsim nyog rau qhov teeb meem no.
- Raws li koj tuaj yeem pom, daim duab teeb tsa los ua, tab sis tsis heev hauv daim ntawv peb xav tau. Ua ntej, nws yog tawg, vim hais tias qhov coj ua piv txwv tsis pom muaj rau ib qho kev sib cav. Secondly, muaj ib qho kab ntxiv rau nws. X, uas nyob rau hauv cov ntaub ntawv no tsis tsim nyog, thiab cov ntsiab lus ntawm kab rov tav axis yog cov khoom xwb, tsis yog qhov tseem ceeb ntawm qhov kev sib cav. Cia peb sim kho txhua yam.
Ua ntej, xaiv cov khoom xiav uas koj xav tawm thiab nyem rau ntawm lub pob Rho tawm ntawm cov keyboard.
- Xaiv lub dav hlau dav uas tso rau hauv daim duab. Hauv cov ntawv qhia zaub mov uas tshwm sim, nias ntawm khawm "Xaiv cov ntaub ntawv ...".
- Cov ntaub ntawv qhov chaw xaiv qhov rais pib. Nyob hauv txoj cai thaiv "Kos npe ntawm kab rov tav" nias lub khawm "Hloov".
- Lub qhov rais qhib me me qhib qhov chaw koj yuav tsum qhia lub zog ntawm qhov ntau, qhov tseem ceeb ntawm qhov yuav tshwm rau lub teev ntawm kab rov tav. Teem tus cursor hauv lub tshav pob "Axis kos npe ntau" thiab tsuas yog xaiv qhov cheeb tsam sib luag ntawm daim ntawv, uas muaj cov lus sib txuas lus. Peb nias lub khawm "OK".
- Tam sim no peb tau ua lub ntsiab haujlwm tseem ceeb: siv qhov sib nkag siab kom tshem tawm qhov sib txawv. Rov qab mus rau cov ntaub ntawv xaiv ntau qhov rai nias ntawm khawm. "Cov hlwb thiab cov kab mob"nyob rau sab qis sab laug.
- Lub qhov chaw qhib rau lub hlwb zais thiab npliag. Nyob rau hauv lub parameter "Qhia cov hlwb hauv hlwb" teem caij mus rau txoj haujlwm "Kab". Peb nias lub khawm "OK".
- Tom qab rov mus rau ntawm qhov chaw xaiv qhov rais, peb paub meej tias tag nrho cov kev hloov tau los ntawm txhaj khawm "OK".
Raws li koj tau pom, daim duab raug kho, thiab sib txawv ntawm qhov sib txawv los ntawm kev sib nkag siab.
Tshooj: Yuav tsim ib lub teeb hauv Excel
Txoj kev 3: Inter Intervolation Siv qhov kev ua
Koj tuaj yeem interpolate lub graph siv cov kev ua tshwj xeeb ND. Nws rov thov qhov tseem ceeb hauv lub xov tooj ntawm tes.
- Tom qab lub sijhawm ua tiav thiab kho tiav, raws li koj xav tau, nrog rau qhov muab nkag rau ntawm qhov kos npe, nws tseem tshuav qhov tsuas yog kaw qhov txawv. Xaiv lub npliag cell nyob rau hauv lub rooj los ntawm cov ntaub ntawv uas tau rub tawm. Nias rau ntawm qhov twb paub lawm "Ntxig rau kev ua haujlwm".
- Qhib Function Wizard. Nyob hauv qeb "Xyuas cov khoom thiab qhov tseem ceeb" los yog "Daim ntawv teev npe tag nrho" nrhiav thiab teev cov ntaub ntawv "ND". Peb nias lub khawm "OK".
- Qhov kev ua no tsis muaj qhov sib cav, uas tau qhia los ntawm cov ntaub ntawv qhov rai tshwm. Mus kaw nws cia li nias ntawm khawm. "OK".
- Tom qab qhov kev txiav txim no, qhov yuam kev nqi tshwm hauv cov xov tooj ntawm tes xaiv. "# N / A", tab sis, ces, raws li koj tau pom, lub clipping twb tau tsau.
Koj tuaj yeem ua rau nws yooj yim txawm tias tsis khiav Function Wizard, tab sis cia li los ntawm cov keyboard tsav tus nqi rau hauv ib qho kev npliag ntawm tes "# N / A" tsis muaj quotes. Tab sis nws twb yog nyob ntawm seb nws yog qhov yooj yim dua rau tus neeg siv khoom.
Raws li koj tau pom, hauv Excel qhov kev pab cuam koj tuaj yeem ua interpolation li tabular cov ntaub ntawv uas siv cov kev ua FORECASTthiab cov duab kos. Nyob rau tom kawg rooj plaub, qhov no yuav ua tau los siv cov sijhawm teem sijhawm lossis siv qhov haujlwm NDua qhov yuam kev "# N / A". Cov kev xaiv uas txoj hauv kev siv yog nyob ntawm cov qauv ntawm qhov teeb meem, nrog rau tus neeg siv tus kheej nyiam.
