Paired samples T test using Excel

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • Paired samples T test using Excel
    اختبار تي لمقارنة متوسطي مجموعتين في ازراج غير مستقلتين
    TTEST, T.UNV. TDIST, T.DIST, VAR, STDEV Functions in excel 2007 2010 2013 2016 2019

Комментарии • 13

  • @elbouisfiiman9748
    @elbouisfiiman9748 Год назад +1

    The t stat is - value is normal to have a negative value

    • @DrMohamedKAbdelFattah
      @DrMohamedKAbdelFattah  Год назад +1

      A negative t-value indicates a reversal in the directionality of the effect, which has no bearing on the significance of the difference between groups. Analysis of a negative t-value requires examination of its absolute value in comparison to the value on a table of t-values and degrees of freedom, which quantifies the variability of the final estimated number. If the absolute value of the experimental t-value is smaller than the value found on the degrees of freedom chart, then the means of the two groups can be said to be significantly different.

  • @samehabdelnour5880
    @samehabdelnour5880 5 лет назад

    مجهود ممتاز استاذنا

  • @elbouisfiiman9748
    @elbouisfiiman9748 Год назад +1

    Ousaad please I want to know if it is normal to have a negative or minus value in my findings

    • @DrMohamedKAbdelFattah
      @DrMohamedKAbdelFattah  Год назад +1

      A negative t-value indicates a reversal in the directionality of the effect, which has no bearing on the significance of the difference between groups. Analysis of a negative t-value requires examination of its absolute value in comparison to the value on a table of t-values and degrees of freedom, which quantifies the variability of the final estimated number. If the absolute value of the experimental t-value is smaller than the value found on the degrees of freedom chart, then the means of the two groups can be said to be significantly different.

    • @elbouisfiiman9748
      @elbouisfiiman9748 Год назад

      Can you please tell me if my analysis are correct I followed what u have done here in this vd

    • @elbouisfiiman9748
      @elbouisfiiman9748 Год назад

      But I get two negative values in the Pearson correlation -0.111

    • @elbouisfiiman9748
      @elbouisfiiman9748 Год назад

      And in the t. Stat -3.429244

    • @elbouisfiiman9748
      @elbouisfiiman9748 Год назад

      But in the p value it is less than 0.05 and we can say that the alternative hypothesis can be adopted