Yuav Ua Li Cas Siv T Kev faib tawm hauv Excel: 8 Kauj Ruam

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:25

Phau ntawv qhia no piav qhia yooj yim thiab ua txhaum ntawm kev siv T Kev faib tawm hauv Excel. Phau ntawv qhia piav qhia yuav ua li cas txhawm rau txhim kho cov ntaub ntawv tsom xam cov cuab yeej thiab muab cov txheej txheem ua tau zoo rau rau hom T Kev faib tawm, xws li: Tis Tsiaj Tis T-Tis, Tis Tsov T-T Tis, Ib-Tail T Faib, Ob-Tail T Faib, Sab laug -tau Kev Pauv Ntawm Cov Tub-ntxhais kawm ntawv t-faib khoom thiab Ob-tailed Pauv ntawm Cov Tub-ntxhais kawm ntawv t-faib khoom

Kauj ruam 1: Taw qhia

T-Kev faib tawm yog ib qho ntawm cov hauv paus ntsiab lus thiab cov ntsiab lus tseem ceeb ntawm kev pib txheeb cais thiab qhov tshwm sim nrog rau kev faib khoom ib txwm thiab Z Table. Thaum cov tub ntxhais kawm pib kawm T-Kev faib tawm, lawv tau muab ua ntej T suav T Table uas lawv yuav tsum saib mus, txhawm rau daws cov lus nug thiab teeb meem nqe lus uas yog qhov zoo rau cov neeg tshiab tab sis raws li ib tus tuaj yeem pom, cov tub ntxhais kawm raug txwv rau qhov tseem ceeb muab rau hauv lub rooj thiab tej zaum kuj yuav tsis nkag siab qhov twg qhov txiaj ntsig tshwm sim los ntawm. Yog li thaum nws los txog rau kev thov lub neej tiag tiag thiab yog qhov teeb meem nqe lus suav nrog qhov tseem ceeb sab nraum lub rooj, cov tub ntxhais kawm pom lawv tus kheej hauv kev khi. Kev daws teeb meem yooj yim heev kom kov yeej qhov no yog siv Excel. Excel los ua ntej teeb tsa nrog ntau lub luag haujlwm uas pab cov tub ntxhais kawm suav T T Kev faib tawm rau ntau hom kev faib khoom thiab ntau yam txiaj ntsig txawm tias sab nraum lub rooj ua ntej.

Kauj Ruam 2: T-faib ua haujlwm hauv Excel

Excel muab nrog rau sib txawv T-Faib faib ua haujlwm. Thaum twg los xij koj tus qauv me me yog qis dua 30 txog 40, ua kom siv cov haujlwm no dhau ntawm Z Table kev ua haujlwm tau pom zoo. Ib tus tuaj yeem xaiv nruab nrab ntawm tus tis sab laug lossis txoj cai-t t tis, ib tus tis lossis ob-tis t faib thiab ib qho thim rov qab lossis ob-tis faib

Kauj Ruam 3: Cov Ntaub Ntawv Txheeb Xyuas Cov Ntaub Ntawv

Qee qhov qauv ntawm Excel tuaj nruab nrog Kev Txheeb Xyuas Cov Ntaub Ntawv qhov rau qee qhov hloov kho Cov ntaub ntawv tshuaj xyuas lub cuab yeej yuav tsum tau teeb tsa thiaj li ua tau t-xeem. Txhawm rau teeb tsa qhov no mus rau Cov Ntaub Ntawv hauv excel cov ntawv qhia zaub mov, thiab xaiv Cov Kev Tshawb Fawb Cov Ntaub Ntawv hauv ntu tshawb xyuas. Thiab txoj hauv kev zoo los txheeb xyuas yog tias koj tau ntim cov ntaub ntawv pob tsuas yog ntaus thiab nias nkag mus rau ib qho ntawm t t faib ua haujlwm hauv qab no thiab yog tias koj tau txais cov lus teb raug nws txhais tau tias cov ntaub ntawv tshuaj xyuas toolpak twb tau teeb tsa.

Kauj Ruam 4: Sab laug-tus Tub Kawm T-kev faib khoom

Peb yuav siv T. DIST txoj haujlwm muab los ntawm excel kom rov qab tis t-tis faib rov qab. Cov syntax rau tib yam yog muab raws li

= T. DIST (x, deg_freedom, sib sau ua ke)

qhov twg x yog t-tus nqi thiab deg_freedom yog qib ntawm kev ywj pheej. Cia peb ua piv txwv, uas koj xav suav t faib rau sab laug tailed faib qhov twg x = 2.011036 thiab deg_freedom = 20

= TDIST (2.011036, 20, 0)

uas rov qab tus nqi 0.056974121

Kauj Ruam 5: Txoj Cai Tis Tub Ntxhais Kawm T-faib

Peb yuav siv T. DIST. RT ua haujlwm los ntawm excel kom xa rov qab txoj cai-tailed t-tis. Cov syntax rau tib yam yog muab raws li

= T. DIST. RT (x, deg_freedom)

ib yam li cov mis dhau los ntawm no ib yam x sib npaug t-tus nqi thiab deg_freedom sib npaug qib ntawm kev ywj pheej tshwj tsis yog tsis muaj qhov sib ntxiv ntawm no. Tsuas yog hloov tus nqi ntawm x thiab qib ntawm kev ywj pheej hauv cov txheej txheem saum toj no thiab koj yuav tau txais koj tus nqi

Kauj Ruam 6: Ob-tw Tub Ntxhais Kawm T-kev faib khoom

Peb yuav siv T. DIST.2T ua haujlwm los ntawm excel kom xa rov qab ob-tis t-tis. Cov syntax rau tib yam yog muab raws li

= T. DIST.2T (x, deg_freedom)

Yuav luag zoo ib yam li cov kab lus yav dhau los tshwj tsis yog RT hloov los ntawm 2T

Kauj Ruam 7: T. INV: Sab laug-thim rov qab ntawm Cov Tub Ntxhais Kawm T-faib

Peb yuav siv T. INV txoj haujlwm muab los ntawm excel kom rov qab sab laug-tailed rov qab ntawm t-tis. Cov syntax rau tib yam yog muab raws li

= T. INV (qhov tshwm sim, deg_freedom)

nyob rau sab laug-tailed thim rov qab, tsis txhob x peb hloov tus nqi ntawm qhov yuav tshwm sim feem pua qhia tias yuav tshwm sim hauv cov syntax.

Piv txwv hais tias peb hais tias peb muaj qhov feem yuav tshwm sim ntawm 7-feem pua thiab qib ntawm kev ywj pheej yog 20. Los laij t-tus nqi syntax yuav zoo li

= TINV (0.07, 20)

uas rov t -tus nqi li -1.536852112

Kauj Ruam 8: T. INV.2T: Ob-thim rov qab ntawm Cov Tub Ntxhais Kawm T-faib

Peb yuav siv T. DIST txoj haujlwm muab los ntawm excel kom rov qab tis t-tis faib rov qab. Cov syntax rau tib yam kuv muab rau

= T. INV.2T (qhov yuav tshwm sim, deg_freedom)

yuav luag zoo ib yam li cov qauv yav dhau los tshwj tsis yog kev ntxiv 2T ua ntej ntawm INV kev ua haujlwm hauv kab lus