Cov txheej txheem:

Yuav ua li cas koj xam cov laj kab qis?
Yuav ua li cas koj xam cov laj kab qis?

Video: Yuav ua li cas koj xam cov laj kab qis?

Video: Yuav ua li cas koj xam cov laj kab qis?
Video: npauj​ kub​ xyooj​ ua​ nkauj​ xwb​ nyob​ 2024, Plaub Hlis Ntuj
Anonim

Cov laj kab feem ntau pom muaj cov qauv hauv qab no:

  1. Saum toj laj kab = Q3 + (1.5 * IQR)
  2. Qab laj laj = Q1 – (1.5 * IQR).

Tsis tas li ntawd, koj yuav nrhiav tau lub laj kab qis ntawm cov ntaub ntawv li cas?

Rau txheeb xyuas outliers, Upper thiab qis laj kab siv tau rau teeb txwv ntawm cov ntaub ntawv cov qhab nias. Rau nrhiav tus laj kab , cov quartiles cov ntaub ntawv teev yuav tsum tau pom, ua rau IQR ntawm lub teeb . Cov mis rau sab sauv laj kab yog Q3 + 1.5 IQR thiab cov qauv rau cov qis laj kab yog Q1-1.5 IQR.

Tsis tas li ntawd, qhov laj kab qis hauv kev txheeb cais yog dab tsi? Cov Qab laj laj yog " qis limit" thiab Upper laj kab yog qhov "sab sauv txwv" ntawm cov ntaub ntawv, thiab txhua cov ntaub ntawv dag sab nraum qhov kev cia siab no tuaj yeem suav tias yog qhov outlier. qhov twg Q1 thiab Q3 yog qhov qis thiab sab sauv quartile thiab IQR yog interquartile ntau.

Ib sab saum toj no, koj yuav pom qhov laj kab qis hauv Excel li cas?

Cov qis laj kab yog sib npaug rau 1st quartile – IQR * 1.5. Lub sab sauv laj kab yog sib npaug rau 3rd quartile + IQR * 1.5. Raws li koj tuaj yeem pom, hlwb E7 thiab E8 xam kawg sab sauv 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 ib qho outlier.

Lub laj kab qis puas tuaj yeem tsis zoo?

1 Teb. Yog, a qis sab hauv laj kab ua tsis zoo txawm tias tag nrho cov ntaub ntawv yog nruj me ntsis zoo. Yog hais tias cov ntaub ntawv yog tag nrho cov zoo, ces tus whisker nws tus kheej yuav tsum zoo (vim hais tias whiskers tsuas yog nyob rau hauv cov ntaub ntawv tseem ceeb), tab sis lub puab. laj kab ncua dhau cov ntaub ntawv.

Pom zoo: