How to perform t-test in Excel
HTML-код
- Опубликовано: 6 июл 2024
- The Student's t-test or simply t-test tells you how significant the differences between groups are. It can either be paired or unpaired t-test depending on whether the data is paired or unpaired. The ultimate goal for you is to find the p value and if it is less than 0.05 then there is significant difference between the two groups. If it is more than 0.05 then there is no significant difference between the two groups.
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.
Turned out very helpful to analyse my data 😁 god bless you ☺️
brilliant explanation, you explained a difficult topic in a simple way, thank you!
Thank you so much 😢😢😢, I'm about to fail the subject that using excel😢😢, but thank you for your brilliant explanation and tutorial❤
Thank you so much for the beautiful words and appreciation.
Very nice and informative 🙏
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.
Nice, this helped me a lot... Thank you
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.
❤
Thank you very much for the simplified lecture
Thanks
Thanks, very useful
Thsnk u today is my viva in excel 😢 thsnk u for guiding
Goodluck !
Display is a slightly small in view, can it becom enlarge
Спасибо большое! Вы на не родном мне языке объясняете понятнее, чем русские "знатоки"
Can anyone please tell how to do a t-test when you have 50 rows and 50 columns in excel spreadsheet?
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.
Please can I use it for effect of cashless policy in an economy
You can use it for comparing means of two different groups so if that's the case then it's fine. Thanks.
legend
Do you have to click with sound?
Sorry about that. I have noted down your comment. Thanks for the feedback.
the video is great but would prefer if you can speak louder.
Great video, but please turn the volume down on your clicking
Thank you very much. OK I have got the point.
I can't see your video clearly
Please try on PC/laptop and select higher resolution like 1080p. Thanks.
Voice nahi ahtahey.. thora jorsey.
Nahi tho doctor dekhw...go
the voice is low, adjust it
Use earphones or Bluetooth
Please turn off the clicking noise. It is very distracting to try to listen to you with that loud clicking.