Ib qho ntawm cov cuab yeej los daws cov teeb meem kev lag luam yog pawg kev ntsuam xyuas. Nrog nws, tej pawg thiab lwm yam khoom ntawm cov ntaub ntawv array raug cais ua pawg. Cov txheej txheem no siv tau hauv Excel. Cia peb kawm saib ua li cas thiaj ua tiav.
Siv cov qauv ntsuam
Nrog kev pab los ntawm cov kev ntsuam xyuas pawg tau tsim nyog los nqa cov qauv ntawm qhov kev tshawb nrhiav. Nws txoj hauj lwm tseem ceeb yog los faib cov lus sib txawv ntawm ntau hom neeg ua ke. Ua ib qho kev ntsuas rau kev sib koom, qhov khub sib xyaw coefficient los yog Euclidean nrug nruab nrab ntawm cov khoom los ntawm qhov muab cov parameter. Qhov tseem ceeb tshaj plaws yog pawg ua ke.
Txawm hais tias feem ntau hom kev tshuaj ntsuam no yog siv hauv kev lag luam, nws tuaj yeem siv tau biology (rau kev cais ntawm cov tsiaj txhu), psychology, tshuaj thiab lwm qhov chaw ntawm tib neeg kev ua ub no. Ib qho kev ntsuam xyuas pawg tuaj yeem raug siv los siv cov cuab yeej Excel rau qhov laj thawj no.
Pab piv txwv
Peb muaj tsib yam khoom, uas yog ob qho los ntawm ob yam kawm tsis tau - x thiab y.
- Thov rau cov txiaj ntsim ntawm Euclidean mis mis, uas yog xam ntawm tus qauv:
= KHO ((x2-x1) ^ 2 + (y2-y1) ^ 2) - Tus nqi no yog xam ntawm txhua ntawm tsib yam khoom. Cov kev sib tw tau muab tso rau hauv qhov kev ntsuas qhov siab.
- Peb saib, ntawm qhov tseem ceeb qhov kev ncua deb yog qhov tsawg tshaj plaws. Hauv peb tus qauv, cov no yog khoom. 1 thiab 2. Qhov kev ncua deb ntawm lawv yog 4,123106, uas yog tsawg tshaj ntawm lwm cov ntsiab lus ntawm cov neeg no.
- Peb muab cov ntaub ntawv no tso rau hauv ib pab pawg thiab tsim ib qho tshiab hauv qhov uas qhov tseem ceeb 1,2 sawv ntsug li cais lub hauv paus. Thaum sau cov cim tseg, tawm qhov tseem ceeb tshaj plaws ntawm lub rooj zaum dhau los ua ke. Rov zoo dua peb saib, ntawm txoj kev uas qhov kev sib nraus yog tsawg. Lub sijhawm no yog 4 thiab 5as Well as ib yam khoom 5 thiab pawg khoom 1,2. Qhov kev ncua deb yog 6,708204.
- Peb ntxiv cov ntsiab lus hais rau cov koom ua ke. Peb tsim ib qho qauv tshiab rau tib txoj cai li qub dhau los. Ntawd yog, peb saib qhov tseem ceeb tshaj plaws. Yog li, peb pom tias peb cov ntaub ntawv muab faib tau faib ua ob pawg. Nyob rau hauv thawj pawg yog cov ntsiab lus tshaj plaws - 1,2,4,5. Nyob rau hauv ob pawg nyob rau hauv peb cov ntaub ntawv muaj tsuas yog ib lub caij - 3. Nws yog nyob deb ntawm lwm yam khoom. Qhov kev ncua deb ntawm cov pawg yog 9.84.
Qhov no ua tiav cov txheej txheem kev faib cov pejxeem ua pab pawg.
Raws li koj tau pom, txawm hais tias nyob rau hauv dav dav tsom xam yuav zoo li nyuab, tab sis nyob rau hauv qhov tseeb nws tsis yog yooj yim to taub lub nuances ntawm no txoj kev. Qhov tseem ceeb tshaj plaws kom nkag siab txog qhov yooj yim qauv ntawm kev koom hauv pawg.
