Correlation thiab regression tsom xam thiab nws ntau daim ntawv thov nyob rau hauv kev khwv nyiaj txiag

Basic statistical txoj kev tau ntev tau siv nyob rau hauv tag nrho cov cheeb tsam ntawm kev tib neeg kev ua si. Txawm li cas los, qhov tseem ceeb luag hauj lwm ua si los ntawm kev txheeb cais rau lub kev khwv nyiaj txiag. Tom qab tag nrho, qhov no ceg ntawm science tswj socio-economic kev sib raug zoo ntawm ua lag ua luam chaw koom nyob rau hauv tus tsom xam thiab ua loj loj nqi ntawm cov ntaub ntawv.

Heev feem ntau nyob rau hauv nyiaj txiag cov kev tshawb fawb nrhiav tau ib tug daws ib qho teeb meem nyob rau hauv kev txheeb xyuas cov yam tseem ceeb uas txiav txim seb lub theem ntawm txoj kev muaj zog nyob rau hauv kev khwv nyiaj txiag. Xws li ib tug teeb meem feem ntau solves correlation thiab regression tsom. Mus cuag lub ntseeg ntawm tus tsom xam nws yog tsim nyog xwb tsis qhia hais tias yuav muaj tej yam kev sib raug zoo, tab sis kuj yuav yamntxwv li tej cim no.

Correlation thiab regression tsom xam daws qhov teeb meem no, raws li ib txoj kev kuaj ntawm statistical hypothesis txog hauv lub xub ntiag thiab lub zog ntawm correlation. Txaus tus naj npawb ntawm yam rau tus txheej txheem kev khwv nyiaj txiag, yog tsis random zog. Qhov tseeb ua hauj lwm pab raws li ib tug prerequisite rau tus tsom xam ntawm nyiaj txiag phenomena nyob rau hauv lub nam ntawm kev sib raug zoo ntawm random thiab uas tsis yog-random qhov tseem ceeb. Cov kev sib txuas lus no yog hu ua regression thiab yog li ntawd lub statistical txoj kev, uas kawm lawv - regression tsom.

Vim tus nruam kev loj hlob ntawm computer technology, kev siv cov computer technology yog nce siv nyob rau hauv statistical suav. Yog li, kev siv ntawm tej computer ntaub ntawv ua software tso cai rau koj kom sai daws teeb meem ntawm qhov kev sib raug zoo ntawm ntau yam tsis siv regression tsom.

Yog li ntawd, correlation thiab regression tsom xam (piv txwv yog ib tug) sufficiently qha nws siv nrog rau Microsoft Excel kev pab cuam thaum khiav ntaub ntawv pauv cov nqi.

Microsoft Excel Lub vam tso cai rau koj los daws kom tau txoj statistical thiab engineering teeb meem siv ib tug tshwj xeeb cov teeb ntawm cov ntaub ntawv tsom xam cov cuab yeej. Correlation thiab regression tsom xam nyob rau hauv Excel yog ua nrog cov obligatory hais txog ntawm lub tswv yim ntaub ntawv thiab cov kev xaiv ntawm thawj zaug tsis. Analysis nws tus kheej yog ua siv statistical macro (kuj muaj nyob engineering muaj nuj nqi), qhov tshwm sim yog muab tso rau hauv lub qhov zis ntau uas yuav tau teev tseg los ntawm tus neeg siv. Yog hais tias koj siv lwm yam txhais tau tias ntawm cov kev pab cuam, peb yuav tau txais cov kev tshwm sim nyob rau hauv graphical daim ntawv.

Nrog kev pab los ntawm ib tug duab duab analyst yuav pom ib tug sawv cev nrig ntawm tej ntaub ntawv. Qhov no hom heev tswj cov xaav thiab nkag siab txog cov kev tshwm sim.

Piv txwv li, thaum nws txheeb cais rooj yog tej thaum nyuaj rau ntes uas tsis yog inaccuracies. Sawv cev raws li ib tug cov ntaub ntawv teeb tso cai rau koj kom sai thiab yooj yim ntes hloov thiab anomalies, ib tug ntse nce los yog nco cov ntaub ntawv, txawm hais tias lub rooj tsis portend zoo li no tsis sib nrauj.

Correlation yog ib tug Microsoft Excel cuab tam pob. Nws yuav siv tau los yamntxwv lub kev sib raug zoo ntawm ob peb cov ntaub ntawv poob lawm. Correlation tsom xam yuav tsim kom muaj kev sib raug nyob rau hauv qhov ntau ntawm cov ntaub ntawv poob lawm. Yog li, muaj tswv yim "zoo" correlation (siab qhov tseem ceeb ntawm cov ntaub ntawv array yog txuas mus rau cov tib loj qhov tseem ceeb ntawm lwm array), cov "tsis zoo" correlation (me me nqi ntawm ib tug cov ntaub ntawv cov ntaub ntawv txuam nrog tib qhov tseem ceeb ntawm cov lwm array) thiab cov correlation sib npaug zero (cov ntaub ntawv lub ob arrays tsis cob cog rua). Regression tsom xam nyob rau hauv Microsoft Excel yog npaj siv ib tug statistical txoj kev xws li kawg squares.

Yog li, correlation thiab regression tsom xam yog yooj yim npaum li mus nqa tawm nrog rau kev siv niaj hnub lub computer technology, uas muab tau cov kev kawm tau nyob rau hauv lub sij hawm shortest.