Kev sib txheeb ze yog hu ua kev sib nrig sib ntawm ob qho kev hloov pauv (ntau zaus - ob pawg ntawm qhov muaj nuj nqis), qhov kev hloov pauv ntawm ib qho ntawm lawv ua rau kev hloov pauv ntawm lwm tus. Txoj kev sib txheeb ntawm coefficient qhia tau hais tias qhov yuav hloov ntawm qhov khoom thib ob yog thaum qhov txiaj ntsig ntawm thawj qhov kev hloov pauv, i.e. degree ntawm nws dependence Txoj kev yooj yim los laij cov nqi no yog kev siv cov haujlwm ua tau tsim los rau hauv Microsoft Office Excel spreadsheet editor.
Tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Pib Excel thiab qhib daim ntawv uas muaj cov pab pawg rau cov ntaub ntawv uas koj xav tau los laij cov correlation coefficient. Yog tias cov ntaub ntawv zoo li no tseem tsis tau tsim, tom qab ntawd nkag mus rau cov ntaub ntawv nkag mus rau hauv lub rooj khoob - cov kws sau ntawv hloov nws tus kheej cia thaum qhov kev pab cuam pib. Nkag mus rau txhua qhov ntawm cov pab pawg ntawm qhov muaj nuj nqis, qhov sib txheeb ze uas koj nyiam rau, hauv kem cais. Cov no tsis tas yuav tsum nyob ib sab, koj yog dawb tsim lub rooj hauv kev yooj yim tshaj plaws - ntxiv cov kem ntxiv nrog cov lus piav qhia rau cov ntaub ntawv, kab npe kab ntawv, tag nrho cov hlwb nrog tag nrho lossis nruab nrab cov nuj nqis, thiab lwm yam Koj tuaj yeem npaj cov ntaub ntawv tsis yog ntsug (hauv kab), tab sis horizontally (hauv kab). Qhov tsuas yog ib qho yuav tsum tau ua kom pom yog tias cov cell nrog cov ntaub ntawv ntawm txhua pawg yuav tsum muab tso ua ntu zus ib qho dhau ib qho, yog li ntawd qhov txuas nruam raug tsim nyob hauv txoj kev no.
Kauj ruam 2
Mus rau ntawm lub xovtooj uas yuav muaj qhov sib txheeb ntawm tus nqi ntawm cov ntaub ntawv ntawm ob kab, thiab nyem rau "Formulas" tab hauv Excel cov zaub mov. Hauv pab pawg ntawm cov lus txib "Cov Tsev Qiv Ntawv ntawm lub luag haujlwm" nyem rau ntawm cov duab tam sim no - "Lwm yam haujlwm". Daim ntawv teev npe poob qis yuav qhib, uas koj yuav tsum mus rau seem "Xov Xwm" thiab xaiv CORREL qhov haujlwm. Qhov no yuav qhib lub qhov rai wizard muaj nuj nqi nrog ib daim ntawv sau. Tib lub qhov rais tuaj yeem hu tau yam tsis muaj Daim Ntawv Qhia tab los ntawm kev nias lub lag luam ntxig icon uas nyob rau sab laug ntawm daim ntawv qhia mis.
Kauj ruam 3
Qhia kom meej thawj pawg ntawm cov ntaub ntawv sib txheeb nyob rau hauv Array1 teb ntawm Formula Wizard. Txhawm rau nkag mus rau ntau qhov ntawm lub xov tooj ntawm tes, ntaus qhov chaw nyob ntawm thawj tus thiab thawj theem ntawm lub hlwb, cais lawv nrog lub nyuv (tsis muaj chaw seem). Lwm qhov kev xaiv yog tsuas yog xaiv cov kab uas yuav tsum tau muaj nrog tus nas, thiab Excel yuav muab cov ntaub ntawv xav tau hauv daim teb no ntawm daim foos los ntawm nws tus kheej. Kev ua haujlwm zoo ib yam yuav tsum tau ua nrog pab pawg thib ob ntawm cov ntaub ntawv hauv "Array2".
Kauj ruam 4
Nyem OK. Lub khoos phis tawm ntawv yuav suav laij thiab ntsuas qhov cuam tshuam rau hauv tus qauv ntawm tes. Yog tias tsim nyog, koj tuaj yeem khaws cov ntawv no rau yav tom ntej siv (keyboard shortcut Ctrl + S).
