Qhov wikiHow qhia koj yuav ua li cas T-Test hauv Microsoft Excel los sib piv qhov nruab nrab ntawm ob pawg ntawm cov ntaub ntawv.
Cov kauj ruam
Kauj Ruam 1. Qhib koj phau ntawv ua haujlwm hauv Microsoft Excel
Ob-nias cov ntawv hauv koj lub computer kom qhib tam sim no.
Txhawm rau tsim phau ntawv ua haujlwm tshiab, qhib Microsoft Excel (hauv Start menu hauv Windows, lossis Cov ntawv thov nplaub tshev hauv macOS), tom qab ntawd nyem Phau ntawv dawb paug.
Kauj Ruam 2. Nyem rau ntawm tes tsis muaj dab tsi
Nov yog qhov uas koj yuav nkag mus rau cov ntaub ntawv formula.
Kauj Ruam 3. Nyem rau Formulas tab
Nws nyob rau sab saum toj ntawm Excel, mus rau qhov chaw.
Kauj Ruam 4. Nyem Ntau Cov Haujlwm
Nws yog lub cim phau ntawv liab nyob ze qhov chaw ntawm kab ntawv kab. Cov ntawv qhia zaub mov yuav nthuav dav.
Kauj Ruam 5. Nyem Txheeb cais
Ib daim ntawv teev cov haujlwm tseem ceeb yuav tshwm sim.
Kauj Ruam 6. Scroll down thiab nyem T. TEST
Lub qhov rooj sib cav ua haujlwm yuav tshwm sim qhov twg koj tuaj yeem nkag mus rau cov ntaub ntawv.
Kauj Ruam 7. Sau thawj txheej ntawm cov ntaub ntawv
Nov yog li cas:
- Nyem rau qhov xub xub nyob ib sab ntawm "Array1" lub thawv kom txo lub qhov rais.
- Nyem-thiab-luag koj tus cursor nas hla thawj cov ntaub ntawv.
- Nias ↵ Enter lossis ⏎ Return. Tam sim no qhov ntau tau tshwm sim nyob rau hauv qhov tsawg.
- Nyem rau xub ntawm ib sab ntawm "Array1" lub thawv kom nthuav lub qhov rai dua.
Kauj Ruam 8. Nkag mus rau txheej txheej thib ob ntawm cov ntaub ntawv
- Nyem rau qhov xub xub nyob ib sab ntawm "Array2" lub thawv kom txo lub qhov rais.
- Nyem-thiab-luag koj tus cursor nas hla thawj cov ntaub ntawv.
- Nias ↵ Enter lossis ⏎ Return. Tam sim no qhov ntau tau tshwm sim nyob rau hauv qhov tsawg.
- Nyem rau xub ntawm lub npov "Array2" txhawm rau nthuav lub qhov rai ntxiv.
Kauj Ruam 9. Ntaus tus Tails tus nqi
Qhov no qhia meej tus naj npawb ntawm kev faib tails. Hom
Kauj ruam 1. yog tias nws yog kev faib ib leeg-tailed, ntaus ntawv
Kauj ruam 2. yog tias nws yog ob leeg
Kauj Ruam 10. Sau Hom
Nov yog hom T-Test los ua. Nkag mus
Kauj ruam 1.
Kauj ruam 2., ua
Kauj ruam 3. ntawm no raws li qhov tsim nyog.
-
1:
Ua khub
-
2:
Ob-sampled sib npaug sib txawv
-
3:
Ob-samped tsis sib xws sib txawv
Kauj ruam 11. Nyem OK
Qhov no khiav T-Test thiab nthuav tawm cov txiaj ntsig hauv cov cell xaiv.