Тёмный

How to perform t-test in Excel 

Innovative Learner (innovative_learning)
Подписаться 3 тыс.
Просмотров 148 тыс.
50% 1

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 37   
@sr.peter-paulnakitende5124
@sr.peter-paulnakitende5124 Год назад
I am very impressed on how you are able to explain a complicated matter and simplified it for me. I have managed to compute my assignment that was so hard for me following your explanation. Be blessed.
@FFMvideos2
@FFMvideos2 11 месяцев назад
Thank you so much 😢😢😢, I'm about to fail the subject that using excel😢😢, but thank you for your brilliant explanation and tutorial❤
@innovative_learner
@innovative_learner 10 месяцев назад
Thank you so much for the beautiful words and appreciation.
@issamelidrissi6279
@issamelidrissi6279 2 дня назад
Hello would u plz help me to calculate p value for the work of my thesis I really watched your video several times but i couldn't manage to calculate it at my own
@Miss_smiling_brunette
@Miss_smiling_brunette 2 года назад
Turned out very helpful to analyse my data 😁 god bless you ☺️
@waynegreaves9070
@waynegreaves9070 Год назад
Clarifications please: On both the Paired and Unpaired t-test, we are doing a 95% Confidence Level which leaves us with 0.05 to be divided by two and distributed in the two tails as our Critical Value and Rejection Region to the right of the Critical Value. First t-test, the paired t-test yields a P-Value of Positive (+) 0.029 in the Right Tail, and Negative (-) 0.029 in the Left Tail. This gives us a comparison of Alpha < P-Value or 0.025 < 0.029. Because this P-Value falls to the right of the Critical Value (into the Rejection Region), it is considered significant and we must reject the Null (Mu1 = Mu2). Second t-test, the Unpaired t-test yields a P-Value = +0.024 in the Right Tail and -0.024 in the Left Tail. In this second t-test we have the following: Alpha > P-Value: Right Tail: 0.025 > 0.024. This P-Value is NOT Significant. It does NOT fall in the Rejection Region. Therefore, we FAIL TO REJECT THE NULL at the 95% Confidence Level. Left Tail: -0.05 > -0.024. The P-Value is NOT significant. It does NOT fall in the Rejection Region. We, therefore, FAIL TO REJECT THE NULL. CLARIFICATION: As it relates to the second Unpaired t-test, I heard you said it is significant, meaning that we must reject the NULLL. Please update.
@rebeccaapayor8062
@rebeccaapayor8062 Год назад
@farahqureshi864
@farahqureshi864 7 месяцев назад
Thsnk u today is my viva in excel 😢 thsnk u for guiding
@theanalyst1728
@theanalyst1728 7 месяцев назад
Goodluck !
@princetakyitabiri8225
@princetakyitabiri8225 Месяц назад
For the unpaired is the option you choose going to have an effect on the p-value ?
@mazam6762
@mazam6762 3 года назад
Display is a slightly small in view, can it becom enlarge
@Frank-te7tl
@Frank-te7tl Год назад
Do you have to click with sound?
@innovative_learner
@innovative_learner Год назад
Sorry about that. I have noted down your comment. Thanks for the feedback.
@alicjamoodynska4813
@alicjamoodynska4813 Год назад
brilliant explanation, you explained a difficult topic in a simple way, thank you!
@asmaashbat4519
@asmaashbat4519 2 года назад
Thank you so much for this video. and I am looking for a video to test the validity for each question. Could you please make this video.
@letodavid5026
@letodavid5026 Год назад
Thank you very much for the simplified lecture
@innovative_learner
@innovative_learner Год назад
Thanks
@sujittilak5697
@sujittilak5697 2 года назад
Very nice and informative 🙏
@adriancorreces7636
@adriancorreces7636 Год назад
Nice, this helped me a lot... Thank you
@barbararapaport5214
@barbararapaport5214 2 года назад
Can anyone please tell how to do a t-test when you have 50 rows and 50 columns in excel spreadsheet?
@rahul4413
@rahul4413 2 года назад
You cannot use t test in that case , t test is use to compare only two group , first of all you have to make your data into two group and then you can use t test according to the requirement.
@daveang7678
@daveang7678 6 месяцев назад
the video is great but would prefer if you can speak louder.
@idehngozi1110
@idehngozi1110 2 года назад
Please can I use it for effect of cashless policy in an economy
@innovative_learner
@innovative_learner 2 года назад
You can use it for comparing means of two different groups so if that's the case then it's fine. Thanks.
@julia10092000
@julia10092000 7 месяцев назад
Спасибо большое! Вы на не родном мне языке объясняете понятнее, чем русские "знатоки"
@nadinetaylor2449
@nadinetaylor2449 Год назад
Great video, but please turn the volume down on your clicking
@innovative_learner
@innovative_learner Год назад
Thank you very much. OK I have got the point.
@caecbhilai5332
@caecbhilai5332 2 года назад
Thanks, very useful
@emmanuelhyerobanabala
@emmanuelhyerobanabala 3 месяца назад
Perfect!
@no4869
@no4869 Год назад
legend
@firstnamenotimportant1818
@firstnamenotimportant1818 5 месяцев назад
the voice is low, adjust it
@kannadasansellaiyan2551
@kannadasansellaiyan2551 5 месяцев назад
Use earphones or Bluetooth
@MichelleParksAmes
@MichelleParksAmes 4 месяца назад
Please turn off the clicking noise. It is very distracting to try to listen to you with that loud clicking.
@arnoldchukwudi5342
@arnoldchukwudi5342 Год назад
I can't see your video clearly
@innovative_learner
@innovative_learner Год назад
Please try on PC/laptop and select higher resolution like 1080p. Thanks.
@Souvik-g3g
@Souvik-g3g 2 месяца назад
Helpful video but irritating clicker sound. Can you please turn off the clicker sound in future videos. Distracting, irritating and unprofessional!
@appakochori
@appakochori Год назад
Voice nahi ahtahey.. thora jorsey. Nahi tho doctor dekhw...go
Далее
How to Do a T-Test for Beginners
19:51
Просмотров 715 тыс.
КТО БОИТСЯ КЛОУНОВ?? #shorts
00:20
Просмотров 460 тыс.
GENIUS FOOD HACKS 🍰 #shorts
00:36
Просмотров 17 млн
Independent-Samples t-test in Excel
18:28
Просмотров 23 тыс.
Performing an independent samples t test in Excel
4:26
Hypothesis Testing correlation (Excel)
7:37
Просмотров 97 тыс.
Paired and unpaired T test in Excel
18:49
Просмотров 8 тыс.
Matched or Paired Samples T-Test - Hypothesis Testing
12:56
How To Perform A One-Way ANOVA Test In Excel
8:31
Просмотров 755 тыс.
Column graphs and T tests using Excel
13:57
Просмотров 56 тыс.
How to perform paired t-test in Excel
6:47
Просмотров 140 тыс.