Qhov laj kab qis hauv kev txheeb cais yog dab tsi?
Qhov laj kab qis hauv kev txheeb cais yog dab tsi?

Video: Qhov laj kab qis hauv kev txheeb cais yog dab tsi?

Video: Qhov laj kab qis hauv kev txheeb cais yog dab tsi?
Video: Ke hlub yog dab tsi? 2024, Plaub Hlis Ntuj
Anonim

Upper thiab qis laj kab cordon tawm outliers los ntawm qhov ntau ntawm cov ntaub ntawv hauv ib pawg. Laj kab feem ntau pom muaj cov qauv hauv qab no: Upper laj kab = Q3 + (1.5 * IQR) Qab laj laj = Q1 - (1.5 * IQR).

Yog li, koj yuav pom lub laj kab qis hauv Excel li cas?

Cov qis laj kab yog sib npaug rau 1st quartile - IQR * 1.5. Saum laj kab yog sib npaug rau 3rd quartile + IQR * 1.5. Raws li koj tuaj yeem pom, hlwb E7 thiab E8 xam zaum kawg thiab qis laj kab . Txhua tus nqi ntau dua qhov siab laj kab los yog tsawg dua cov qis laj kab yog suav tias yog qhov qub.

Ib yam li ntawd, koj yuav pom qhov txwv qis thiab qis dua li cas? Yuav nrhiav tau txwv tsis pub tshaj ntawm thawj chav kawm, rho ib qho los ntawm tus qis txwv ntawm chav kawm thib ob. Tom qab ntawd txuas ntxiv ntxiv cov chav kawm dav rau qhov no txwv tsis pub tshaj mus nrhiav tus so cov kev txwv siab tshaj . Nrhiav cov ciam teb los ntawm rho tawm 0.5 units los ntawm qis txwv thiab ntxiv 0.5 units los ntawm lub sab sauv txwv.

Los ntawm qhov ntawd, qhov laj kab qis tuaj yeem tsis zoo?

1 Teb. Yog, a qis dua sab hauv laj kab tau ua tsis zoo txawm tias tag nrho cov ntaub ntawv yog nruj me ntsis zoo. Yog tias cov ntaub ntawv txhua tus zoo, tom qab ntawd tus nplawm nws tus kheej yuav tsum yog qhov zoo (txij li tus nplawm tsuas yog ntawm cov ntaub ntawv muaj txiaj ntsig), tab sis sab hauv laj kab ncua dhau cov ntaub ntawv.

Dab tsi yog quartile?

Cov peb lub hlis twg ntsuas kev sib kis ntawm qhov tseem ceeb saum toj no thiab hauv qab txhais tau tias los ntawm kev faib kev faib ua plaub pawg. A peb lub hlis twg faib cov ntaub ntawv rau hauv peb lub ntsiab lus - qis dua quartile , nruab nrab, thiab sab saud peb lub hlis twg - los tsim plaub pawg ntawm cov ntaub ntawv teeb tsa.

Pom zoo: