Kev ntsuas kev ntsuas yog ib qho ntawm cov neeg nrhiav tshaj plaws-tom qab kev tshawb fawb. Nrog nws, nws yog qhov ua tau los tsim kev cuam tshuam ntawm kev cuam tshuam ntawm kev ywj pheej tseem ceeb ntawm cov neeg uas vam khom. Lub Microsoft Excel kev ua haujlwm tau cov cuab yeej npaj rau ib hom kev txheeb xyuas zoo sib xws. Cia peb soj ntsuam tias lawv sawv cev lawv tus kheej thiab yuav siv lawv li cas.
Txuas ib pob ntawm kev txheeb xyuas
Tab sis, txhawm rau siv txoj haujlwm uas tso cai rau koj kom ua raws li kev ntsuas regressression, ua ntej txhua yam, koj yuav tsum ua kom pob khoom siv. Tsuas yog tom qab ntawd cov cuab yeej xav tau rau cov txheej txheem no yuav tshwm sim ntawm cov kab xev exile.
- Tsiv mus rau hauv "file" tab.
- Mus rau ntawm "txwv" ntu.
- Lub Excel tsis muaj qhov rais qhib. Mus rau ntu "addstructure".
- Nyob rau hauv qab ntawm lub qhov rais qhib, peb rov ua dua nyob rau hauv "tswj" thaiv rau "txoj haujlwm ntxiv-hauv" txoj haujlwm, yog tias nws nyob hauv lwm txoj haujlwm. Nyem rau "Mus khawm".
- Qhib lub qhov rais siv tau mus siv tau mus rau Excel qhov kev hloov pauv. Peb muab tus zuam txog qhov "kev tsom xam pob" khoom. Nyem rau ntawm "OK" khawm.
Tam sim no, thaum peb tsiv mus rau "cov ntaub ntawv" tab, peb yuav pom lub khawm tshiab hauv cov "Kev Ntsuam Xyuas" Toolbar "khawm.
Hom Kev Ntsuam Xyuas Kev Tshawb Fawb
Muaj ntau hom regressions:- parabolic;
- lub hwj chim;
- logarithmic;
- exponential;
- taw qhia;
- hyperbolic;
- Li cas regression.
Peb yuav tham ntau ntxiv txog kev siv ntawm hom kawg ntawm kev ntsuas regressionion hauv excele ntau.
Linear regression nyob rau hauv qhov kev pab cuam Excel
Hauv qab no, raws li ib qho piv txwv, ib lub rooj tau nthuav tawm nyob rau hauv uas nruab nrab cua huab cua kub ntawm txoj kev, thiab tus naj npawb ntawm cov neeg yuav khoom tsim nyog hnub ua haujlwm kom tsim nyog. Cia peb nrhiav tau nrog kev pab ntawm kev ntsuas kev txheeb xyuas, zoo meej li cas huab cua nyob rau hauv daim ntawv ntawm cov cua kub yuav cuam tshuam rau kev tuaj koom chaw lag luam.
Qhov dav dav ntawm regression ntawm txoj kab linear yog raws li hauv qab no: y = A0 + A1X1 + ... + AKK. Hauv cov mis no, y txhais tau hais tias ib qho sib txawv, cov cawv ntawm cov khoom uas peb tab tom sim tshawb. Hauv peb rooj plaub, qhov no yog tus naj npawb ntawm cov neeg yuav khoom. Tus nqi ntawm x yog ntau yam cuam tshuam rau kev sib txawv. Cov tsis muaj cov coefficients regression. Ntawd yog, nws yog lawv cov uas txiav txim siab qhov tseem ceeb ntawm ib qho tshwj xeeb. Qhov ntsuas K lees rau tag nrho cov naj npawb ntawm cov yam ntxwv.
- Nyem rau ntawm "Cov Ntaub Ntawv Ntsuas" khawm. Nws tau muab tso rau hauv lub tsev tab hauv "Kev Ntsuam Xyuas" toolbar.
- Ib lub qhov rai me me qhib. Hauv nws, peb xaiv cov khoom "regression". Nyem rau ntawm "OK" khawm.
- Retressression Chaw Qhov rai qhib. Nws yog qhov yuav tsum tau sau cov teb yog "Input Bast Y" thiab "Input Bast X". Tag nrho lwm cov chaw tuaj yeem tso tau los ntawm lub neej ntawd.
Nyob rau hauv "Input Interval Y" Field, teev qhov chaw nyob ntawm ntau ntawm cov xov ntawm cov xov ntawm qhov chaw uas peb tab tom sim tsim. Hauv peb kis, cov no yuav yog lub hlwb ntawm "tus naj npawb ntawm cov neeg yuav khoom" kem. Qhov chaw nyob tuaj yeem nkag mus rau manually los ntawm cov keyboard, thiab koj tuaj yeem tsuas yog xaiv cov kab lus uas xav tau. Kev xaiv kawg yog yooj yim dua thiab yooj yim dua.
Nyob rau hauv "Input Bastal X" teb, peb nkag mus rau qhov chaw nyob ntawm cov hlwb ntawm lub hlwb, qhov twg cov khoom siv tau nyob, uas muaj feem cuam tshuam peb xav tau los nruab. Raws li tau hais los saum no, peb yuav tsum tsim cov nyhuv ntawm cov neeg yuav khoom ntawm cov neeg yuav khoom, thiab yog li ntawd sau qhov chaw nyob ntawm lub hlwb hauv "KUB. Qhov no tuaj yeem ua rau tib txoj hauv kev hauv "tus naj npawb ntawm cov neeg yuav khoom" teb.
Siv lwm cov chaw, koj tuaj yeem tsim cov ntawv cim, qib ntawm kev ntseeg tau, tas li rau xoom, tso saib cov ntawv qhia txog ib txwm muaj, thiab ua lwm yam kev ua. Tab sis, feem ntau, cov chaw no tsis tas yuav hloov pauv. Qhov tsuas yog ua kom them tau tias yog rau cov txiaj ntsig tawm. Los ntawm lub neej ntawd, cov zis ntawm cov tshuaj xyuas tau yog nqa tawm ntawm lwm daim ntawv, koj tuaj yeem tsim cov khoom xa tawm ntawm tib phau ntawv yog nyob, lossis hauv phau ntawv cais, Uas yog, hauv cov ntaub ntawv tshiab.
Tom qab txhua qhov chaw tau teeb tsa, nyem rau ntawm "OK" khawm.
Kev tsom xam ntawm cov txiaj ntsig ntawm kev tsom xam
Cov txiaj ntsig ntawm kev ntsuas kev ntsuas tau muab tso rau hauv daim ntawv ntawm lub rooj hauv qhov chaw qhia hauv cov chaw.
Ib qho ntawm cov ntsuas tseem ceeb yog R-Square. Nws qhia qhov zoo ntawm cov qauv. Hauv peb qhov teeb meem, cov coefficent yog 0.705 lossis txog 70.5%. Nov yog qib uas siv tau ntawm qhov zoo. Vam khom tsawg dua 0.5 yog tsis zoo.
Qhov ntsuas qhov tseem ceeb dua yog nyob hauv lub cell ntawm kev sib tshuam ntawm "Y-sib tshuam" kab thiab "coefficients" kem. Nws qhia tias tus nqi twg yuav nyob hauv Y, thiab hauv peb kis, qhov no yog tus naj npawb ntawm cov neeg yuav khoom, nrog txhua yam sib npaug sib npaug. Cov lus no yog 58.04 hauv cov lus no.
Tus nqi ntawm kev sib tshuam ntawm cov suav "kuj sib txawv x1" thiab "coefficients ntawm y los ntawm cov neeg siv ntawm cov neeg siv khoom ntawm lub khw muag khoom kub. Cov coefficient ntawm 1.31 tau suav tias yog qhov taw qhia ntau dua ntawm kev cuam tshuam.
Raws li koj tuaj yeem pom, siv Microsoft Excel program nws yog qhov yooj yim heev los ua ib lub rooj ntawm kev ntsuas kev ntsuas. Tab sis, ua haujlwm nrog cov ntaub ntawv tau ntawm qhov tawm, thiab nkag siab lawv cov ntsiab lus, tsuas yog tus npaj npaj yuav muaj peev xwm.