T-Test in Excel (NEW VERSION IN DESCRIPTION)

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

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

  • @juded14
    @juded14 7 ปีที่แล้ว +8

    For people like myself, your explanation of each argument, the meaning and the examples help the viewers follow what you're doing. So thank you for the thorough explanation.

    • @VivoPhys
      @VivoPhys  7 ปีที่แล้ว

      +Jude Diegue I'm happy the video was helpful to you!

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

      @@VivoPhys Your Null Hypothesis is Mu1 = Mu2. Your Alternate Hypothesis is Mu1 is not equal to Mu2. After calculating your t-test which for me came out to be 0.003735, using all the exact parameters you used (In any event, let's not dwell on the t-test calculation), you then need to compare your t-test to your t-Critical. Looking up your t-Critical for the 5% significant level (0.05) you will have gotten a t-Critical of 2.074 which, in any event, is still higher than the calculated t-test. As the mnemonic goes: If the p-value is high, the Null must fly, if the p-value is low, the Null must go. Both of our p-value, i.e., t-Critical is high which means the Null must fly, i.e., you must fail to reject the Null Hypothesis: Mu1 = Mu2 at the 95% Confidence Level, meaning there is NO STATISTICAL SIGNIFICANT difference between the Population Means: Mu1 = Mu2. You don't compare your t-test to 0.05. 0.05 (5%) is simply the level of significance you chose. You compare your t-test to your t-Critical value which takes the additional step of finding you degrees of freedom (df) which in this case turns out to be 22 (n1+n2-2) and looking up the t-Critical either on an APP or in a stat table.

    • @VivoPhys
      @VivoPhys  4 ปีที่แล้ว

      Thanks for posting this more in depth method.

  • @mariahenriquez2468
    @mariahenriquez2468 6 ปีที่แล้ว +6

    Thank you so much! Your video explained to me exactly what I needed to understand for my physiology class! My professors didn't cover this and I was soooooooo lost. Thank you!

    • @VivoPhys
      @VivoPhys  4 ปีที่แล้ว

      You're welcome Maria Henriquez!

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

    This was so helpful, thank you!

    • @VivoPhys
      @VivoPhys  3 ปีที่แล้ว

      I'm happy it helped.

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

    Thank you. I like the way that you put yourself in front of the excel spreadsheet.
    I was taught that if you had a clear and justified hypothesis (in this case that people in a supine position would have a lower heart rate due to their increased relaxation and less of a requirement to pump blood against the force of gravity) then it is justifiable to use a one tailed test, which gives half the p value, AFAIK and makes twice as easy to reach statistical significance. If the test could go either way then one should use a two tail test. But I may well be wrong.
    And I did not even know about "type 3"! I just used type two when the subjects are different. I wonder if one should check the variance or standard deviation (=stdev(array)) of the two groups of subjects, and how much the standard deviation would need to deviate for the two groups to be considered to have different variance or, all other things (other than the independent variable) being equal, one can assume that the variance is the same.

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

    This helped a lot. Cheers.

    • @VivoPhys
      @VivoPhys  4 ปีที่แล้ว

      Jake Marshall I'm happy it helped!

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

    Thank you so much!!!

    • @VivoPhys
      @VivoPhys  4 ปีที่แล้ว

      You're welcome Lucas Delmonico!

  • @lulu-og1ho
    @lulu-og1ho 5 ปีที่แล้ว +3

    thanks you saved me from 10 minutes opening of MATLAB

    • @VivoPhys
      @VivoPhys  5 ปีที่แล้ว

      I'm glad it helped.

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

    Thanks so much!

    • @VivoPhys
      @VivoPhys  4 ปีที่แล้ว

      I'm glad it helped.