How to perform t-test in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024

ความคิดเห็น • 35

  • @sr.peter-paulnakitende5124
    @sr.peter-paulnakitende5124 ปีที่แล้ว +9

    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.

  • @smiling_crumbles6409
    @smiling_crumbles6409 2 ปีที่แล้ว +5

    Turned out very helpful to analyse my data 😁 god bless you ☺️

  • @FFMvideos2
    @FFMvideos2 9 หลายเดือนก่อน +3

    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  9 หลายเดือนก่อน +1

      Thank you so much for the beautiful words and appreciation.

  • @waynegreaves9070
    @waynegreaves9070 ปีที่แล้ว +4

    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.

  • @alicjamoodynska4813
    @alicjamoodynska4813 ปีที่แล้ว

    brilliant explanation, you explained a difficult topic in a simple way, thank you!

  • @farahqureshi864
    @farahqureshi864 5 หลายเดือนก่อน +1

    Thsnk u today is my viva in excel 😢 thsnk u for guiding

  • @sujittilak5697
    @sujittilak5697 2 ปีที่แล้ว +3

    Very nice and informative 🙏

  • @letodavid5026
    @letodavid5026 ปีที่แล้ว +1

    Thank you very much for the simplified lecture

  • @mazam6762
    @mazam6762 3 ปีที่แล้ว +3

    Display is a slightly small in view, can it becom enlarge

  • @asmaashbat4519
    @asmaashbat4519 2 ปีที่แล้ว +1

    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.

  • @adriancorreces7636
    @adriancorreces7636 10 หลายเดือนก่อน

    Nice, this helped me a lot... Thank you

  • @emmanuelhyerobanabala
    @emmanuelhyerobanabala หลายเดือนก่อน

    Perfect!

  • @caecbhilai5332
    @caecbhilai5332 2 ปีที่แล้ว +1

    Thanks, very useful

  • @daveang7678
    @daveang7678 5 หลายเดือนก่อน +1

    the video is great but would prefer if you can speak louder.

  • @Frank-te7tl
    @Frank-te7tl ปีที่แล้ว +4

    Do you have to click with sound?

    • @innovative_learner
      @innovative_learner  ปีที่แล้ว

      Sorry about that. I have noted down your comment. Thanks for the feedback.

  • @julia10092000
    @julia10092000 6 หลายเดือนก่อน

    Спасибо большое! Вы на не родном мне языке объясняете понятнее, чем русские "знатоки"

  • @barbararapaport5214
    @barbararapaport5214 2 ปีที่แล้ว +3

    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.

  • @nadinetaylor2449
    @nadinetaylor2449 ปีที่แล้ว +2

    Great video, but please turn the volume down on your clicking

  • @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.

  • @no4869
    @no4869 11 หลายเดือนก่อน

    legend

  • @MichelleParksAmes
    @MichelleParksAmes 2 หลายเดือนก่อน

    Please turn off the clicking noise. It is very distracting to try to listen to you with that loud clicking.

  • @Souvik-g3g
    @Souvik-g3g 19 วันที่ผ่านมา

    Helpful video but irritating clicker sound. Can you please turn off the clicker sound in future videos. Distracting, irritating and unprofessional!

  • @firstnamenotimportant1818
    @firstnamenotimportant1818 3 หลายเดือนก่อน

    the voice is low, adjust it

  • @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.

  • @appakochori
    @appakochori ปีที่แล้ว

    Voice nahi ahtahey.. thora jorsey.
    Nahi tho doctor dekhw...go